Pankaj S.

ABOUT ME

am sharing my profile summary below.

I have done post-graduation in MCA as well as past 9.4+ years as an Oracle /PostgreSQL/Cassandra/goldengate database Administrator experienced in the information technology. Hereby I provide you with a brief overview of my skill set:

· Experience in Oracle software installation, Migration, cloning, patching (CPU/PSU), and up gradation of database etc.
· Having the experience of Production Database administration and day-to-day Operations of different Database.
· Execution Plan Troubleshooting database related issue & server-side connectivity, space related issue.
· Generating Reports (AWR/TKPROF/Explain Plan/Auto Trace/Sql Advisor/ADDM).
· Performing active DR Drills Primary Database and Physical Standby Database/ Data guard.
· Backup & Recovery (RMAN/DATAPUMP/EXP/IMP).
· Monitoring ASM and database instance availability
· Monitoring the ASM disk group and adding the disk to the disk group when required.
· Monitoring RAC database & oracle golden gate.
· Having experience of Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases.
· Data Replication - Streaming replication.
· Expert in Backup & Recovery including Pg dump, setting up WAL archiving, Point in time recovery.
· 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 and Involved in cassandra Cluster prod environments that includes adding and removing cluster nodes, cluster capacity planning, Installation, Upgrading, performance tuning, cluster Monitoring, Troubleshooting.
· SQL Tuning
· Understanding of Unix environment with shell scripting.

SKILLS