SUMMARY

• More than eleven (11) years of experience as an Oracle and MySQL database administrator with hands on experience in ASM/RAC administration, Golden Gate replication, AWS migration, automation, SQL server administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, cloning and space management auditing
• Proficient in installation, configuration and cloning of Oracle 8i/9i/10g/11g/12c/11g RAC and standalone in UNIX/Linux and Windows environments
• Worked on Amazon AWS migration projects from on - premise datacenter to AWS
• Successfully migrated MySQL and Oracle databases to AWS EC2/RDS services
• Managed SQL server 2012 and 2014 installations and configuration on AWS EC2
• Knowledge of Google Cloud Platform for on premise application migration to GCP
• Scheduled backups using Commvault for AWS Oracle and SQL databases
• Scheduled native backups, jobs on SQL server and point in time recovery of SQL databases
• Skilled in performance tuning and monitoring production database alerts in SQL Server
• Monitored EC2 and report generation using Splunk monitoring tool
• Worked on master/slave replication for MySQL databases
• Used AWS data migration service and schema conversion tools to migrate on premise databases
• Familiar with SQL tuning advisor and SPA (SQL Performance Analyzer) for migrationsand upgrades
• Experienced in database migration across various platforms
• Configured unidirectional Goldengate replications between production databases and provided support
• Experience with Data Pump, Flash-Back Recovery, AWR, ASM, ADDM and grid monitoring
• Strong knowledge of performance tuning and AWR analysis
• Improved SQL query performance using explain plans and by SQL profiles and baselines
• Experience with automation tools such as Ansible and knowledge of docker microservices
• Configured active Data Guards and DG broker and converted to various modes
• Proficient with Oracle 12c Cloud Control: implemented auto patching
• Knowledge of Postgre SQL database administration

TECHNICAL SKILLS

Technologies: C, C++, JSON, Python, shell scripting Oracle 8i/9i/10g/11g/12c, MS SQL 2012/2014MySQL 5.x, DB2, OEM 12c/13c, Golden GateExadata, VMWare

Web/Application Servers: E Business Suite, 11i, R12

Operating Systems: Redhat, HP-UX, Solaris, AIX, Windows

Databases: Oracle 8i-12c, MySQL, MS SQL, DB2

Tools: TKPROF, Explain Plan, Statspack, SQL DeveloperTOAD, Oracle Client

Cloud Technologies: Amazon Web Services, Google Cloud Platform

PROFESSIONAL EXPERIENCE

Sr. Oracle/MySQL Database Administrator

Confidential, Bergenfield, NJ

Responsibilities:

• Applied regular quarterly CPU/PSU patches and keep the databases up to date with the Oracle security updates
• Managed SQL server 2012 and 2014 installation and configuration
• Worked on Amazon AWS migration from the on-premise datacenter
• Configured Goldengate replication between production databases
• Monitored EC2 and report generation using Splunk monitoring tool
• Created RDS instance for MySQL database and support
• Configured active Data Guard and DG broker and converted to various modes
• Successfully migrated MS SQL and Oracle databases to AWS EC2 instances
• Scheduled backups using Commvault for AWS Oracle and SQL databases
• Scheduled backups and jobs in SQL Server and point in time recovery of SQL databases
• Monitored and managed MySQL databases using MONYOG
• Automated PSU patching through Oracle 12c cloud control
• Managed performance tuning and AWR analysis
• Installation, configuration and maintenance of standby databases using Data Guard
• Interacted with the applications teams and resolved their connectivity issues
• Created users and assigning roles to them as per the requirements
• Performance issues for database slowness, CPU and memory high utilization issues
• Installed and configured MySQL 5.7 database software and upgrades
• Worked on Master Slave replication for MySQL databases

Environment: AIX, Linux, Windows, Oracle 9i/10g/11g, 12c, RAC, Goldengate, ASM, Cloud Control, Data Guard, MySQL, SQL, DB2

Sr. Oracle Database Administrator

Confidential, Atlanta, GA

Responsibilities:

• Managed the high availability (24/7) database in an onshore-offsite model
• Addressed performance issues at an application level and database level
• Applied regular quarterly CPU/PSU patches and kept the databases up to date with the Oracle security updates
• Facilitated SQL Server 2012 and 2014 installation and configuration
• Managed Amazon AWS migrations from the on-premise data center
• Successfully migrated SQL and Oracle databases to AWS EC2 instances
• Worked on the AWS post application migration issues
• Responsible for SQL Server 2012 and 2014 installation and configurations on AWS EC2
• Used the Google Cloud Platform for on premise application migrations to GCP
• Scheduled backups using commvault for AWS Oracle and SQL databases
• Scheduled backups and jobs on the SQL server and point in time recovery of SQL databases
• Managed Log Shipping, Replications and STLC
• Facilitated performance tuning and monitored production alerts on the SQL server
• Provided support for 10g, 11g, 12c and 11g RAC databases
• Automated the PSU patching through Oracle 12c Cloud Control
• Improved SQL query performance using explain and by passing hints
• Used RMAN for replication and OEM, TOAD and managed database migrations
• Managed installation, configuration and maintenance of standby databases using Data Guard
• Upgraded 11gR2 RAC database to the Oracle 12.1.0.2 RAC version
• Used SCP for data transfers and data domain for faster transfers
• Interacted with the applications teams and resolved their connectivity issues
• Created users and assigned roles to them as per the requirements
• Created Oracle 12c databases with containers and non CDB modes
• Converted non CDB databases to single container mode
• Corrected performance issues for slow databases, CPU and memory high utilization issues
• Conducted SQL tuning using Cloud Control and using Toad
• Contracted Oracle support for performance issues
• Installed and configured MySQL 5.7 database software
• Supported DB2 and MSSQL databases

Environment: AIX, Linux, Windows, Oracle 9i/10g/11g/12c, RAC, Golden Gate, ASM, AWS, Cloud Control, MySQL, DB2, MS SQL 2008/2012/2014

Lead Oracle/SQL DBA

Confidential, Webster, NY

Responsibilities:

• Managed a high availability (24/7) database in the onshore-offsite model (24/7)
• Addressed the performance issues at application levels and database levels
• Applied regular quarterly CPU/PSU patches and kept the databases up to date with the Oracle security updates
• Provided support for 10g, 11g, 12c and 11g RAC databases
• Managed data pumps using exports and imports
• Facilitated performance tuning and AWR analysis
• Scheduled backups and jobs on SQL Server and point in time recovery of SQL databases
• Responsible for log shipping, replications and STLC
• Monitored production alerts on the SQL server
• Improved SQL query performance using Explain and by passing hints
• Used RMAN for replication and OEM, TOAD and managed database migrations
• Upgraded the databases from 10g to 11g and 11g to 12c
• Managed installation, configuration and maintenance of standby databases using Data Guard
• Upgraded 11gR2 RAC database to the Oracle 12.1.0.2 RAC version
• Took necessary actions for improving database performance
• Used SCP for data transfers and data domain for faster transfers
• Interacted with the applications teams and resolved their connectivity issues
• Created users and assigned roles to them as per the requirements
• Created Oracle 12c databases with container and non CDB modes
• Converted non CDB database to single container mode
• Addressed performance issues for slow databases, CPU and memory high utilization issues
• Suggested Oracle 12c active Data Guard options for database upgrades
• Performed SQL tuning using Cloud Control and used Toad
• Contracted Oracle support for performance issues

Environment: Solaris, Linux, Windows, Oracle 9i/10g/11g/12c, RAC, Golden Gate, ASM, Cloud Control 12c, Exadata X2, MSSQL 2008/2012/2014

Lead Oracle Database Administrator

Confidential

Responsibilities:

• Managed high availability database in onshore-offsite models (24/7)
• Addressed performance issues at application levels and database levels
• Applied regular quarterly CPU/PSU patches and kept the databases up to date with the Oracle security updates
• Provided support for 10g, 11g, 12c and 11g RAC databases
• Supported the data warehouse jobs and tuning queries
• Upgraded the databases from 10g to 11g and 11g to 12c
• Installed, configured and maintained standby databases using Data Guard
• Installed and maintained Golden Gate and Oracle 12c Cloud Control
• Cloned the Oracle home and upgrades
• Created health monitoring Unix shell scripts
• Scheduled the health scripts using Cron tab and Mailx
• Trouble shot user access issues
• Created user profiles and roles
• Worked closely with the application teams on scheduling the patching windows
• Cloned the databases regularly for the reporting databases and stage environments
• Tuned the database level performance issues
• Analyzed the AWR reports periodically for better performance
• Participated in SOX audits and provided justifications for the business users
• Created SOX level auditing scripts and made the validations and changes as required
• Created backup schedules and took periodic backups for both offline and online using RMAN
• Participated in corporate DR Drills and ensured data protection
• Trouble shot the application server issues
• Defragmented the tables using exp/imp, reorg, and shrink
• Worked with Oracle on critical database bug/issues
• Created process documents for the DBA activities and made sure that the team adhered to the process outlined
• Supervised a team of five offshore members
• Created shift schedules
• Created RMAN and exported jobs through 12c Cloud Control and monitoring
• Managed materialized views and refreshes
• Created DB links to heterogeneous environments for the data warehouse
• Managed periodic index management and index rebuilding
• Trained junior DBAs on DBA activities

Environment: Solaris, Linux, Windows, Oracle 9i, 10g and 11g, 12c, RAC, ASM, 11g Grid Control