Chandan S.

11.6+ years’ experience as Oracle Databases Administrator • Experience in Oracle software installation, cloning, patching (PSU/CPU) and up gradation of oracle database. • Design, Implementing and maintaining Backup policies using RMAN, Import/Export, hot/cold backup and data pump (EXPDP/IMPDP). • Expert in managing Oracle RAC and Non-RAC databases. • Monitoring space related issues of (data files, tablespaces, and Disk/Disk group). • Installation, Configuration and Implementation of Data guard/Standby/RAC. • Having experience on DR Drills (switchover/Failover) from Primary Database to Physical Standby Database. • Database Migration (expdb/impdp, database link, Transport tablespace & Full RMAN backup) and oracle Goldengate PostgreSQL Databases Administrator • Having experience of Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases. • Having experience on installed the multi-cluster postgreSQL database on same server with different port. • Experience in migrating oracle databases to PostgreSQL and upgrade from 9.x to 10.x,11.x,12.x PostgreSQL version • Experience in setup Data Replication – Warm standby /Streaming/hot-standby replication. • Expert in Backup & Recovery including Pg dump, Bart and Barman tool, setting up WAL archiving, Point in time recovery. • Creation & managing PostgreSQL database, schema, tables, tablespaces and users, roles & groups. • Having experience on Installation and configuration HA (EFM/Repmgr) and Monitoring tool (PEM). • Scheduled maintenance activities to vacuum, analyze to improve the query response time. • Daily log analysis using pgbadger tool and query tuning. • Installing and monitoring PostgreSQL database using the standard monitoring tools like PEM etc. Cassandra database Administrator • Experience in installing, configuring and monitoring DataStax Cluster (Enterprise Edition). • Experience on Installed and configured multi-nodes fully distributed Cassandra cluster. • Understanding of Cassandra cluster management by using datastax Opscenter, Devcenter and nodetool utility commands • Understanding Cassandra snapshotBackup & Recovery. • Knowledge in Cassandra read and write paths and internal architecture. • Installed and Configured DataStax OpsCenter for Cassandra Cluster maintenance and alerts. • Involved in data migrations, Incremental backups and data restores using ‘Snapshots’ and 'SStableloader' in Cassandra • Managing NoSQL distributed database Cluster that includes adding and removing cluster nodes, cluster capacity planning, performance tuning, cluster Monitoring, Troubleshooting. Oracle Goldengate Administrator • Having experience of Oracle Godengate Implementation/setup DDL and both unidirectional & bidirectional mode and able to Configure the Manager, extractor, replicator and data pump process, initial data load. • Monitoring Information of all Golden Gate processes running on a system (Source/Target). • Having experience on Oracle database SQLTuning.