SUMMARY

• 18+ Years of experience in Oracle database administration managing large size databases. Production support DBA for Oracle, MongoDB, PostgreSQL, SQL Server, Oracle Real Application cluster databases with Oracle Data Guard and Recovery Manager on Exadata, Solaris, Linux, HP - U/X and Windows environments.
• Performed database migration from Aix to Exadata platform
• Deleted failed node and added node to oracle Cluster.
• Install and run MongoDB with multiple instances on servers.
• Configured table queries, columns and other administrative operations such as grouping, indexing and joining.
• Install, upgrade MongoDB standalone, replica set configurations in community and Enterprise versions.
• Setup MongoDB database backups using Mongo dump/restore, Ops Manager.
• Performed Mongo DB failover, switchover, troubleshooting and tuning MongoDB deployments.
• MongoDB user management and day to day operations support.
• Configured, optimized and supported high availability (Replication) MongoDB cluster.
• Optimized MongoDB CRUD Operations
• Monitored deployments for capacity, performance, and reliability.
• Identify, troubleshoot and resolved MongoDB issues.
• Installed and configured oracle 12c, 18c,19c databases and 12c/18c/19c RAC on Exadata platform.
• Installed and configured Golden gate 11g/12c on Linux.
• Experience on oracle Golden Gate for uni/Bi-directional replication.
• Installed and configured 13c OEM agents and added targets
• Involved in upgrading databases from Oracle 9i/10g to Oracle 11g Release 2.
• Worked in upgrading databases from Oracle 11g /12c to Oracle 18c and 19c Release 2.
• Involved in upgrading more than 50 databases from Oracle 9i to Oracle 10g Release 2.
• Involved in upgrading more than 20 databases from Oracle 11g to Oracle 19c Release 2.
• Experience in handling performance issues
• Configured additional nodes to existing RAC environment.
• Experience on 10g oracle enterprise manager (OEM) and oracle grid control.
• Configured oracle physical and logical standby databases in oracle 10g data guard
• Implemented switchover, failover and switchback in data guard setup.
• Experience on Oracle10g ASM Automatic storage management.
• Restored and recovered lot of databases by using both Rman and Manual backup methods.
• Experience on oracle Database Re-organization and oracle partitioning
• Expertise in cloning database for test and purposes using Oracle Recovery Manager.
• Experienced with UNIX Shell scripting.
• Migrated on premises database to AWS RDS using aws database migration service.
• Experienced in migrating databases toAWS cloud ecosystem using Services like VPC, EC2, RDS, S3
• Cloning/Refreshing databases from production for development, testing purpose
• Installed various Oracle bug fix patches on Sun Solaris and HP UX environments.
• Installed, administered and maintained Oracle software on Sun Solaris and Linux environments.
• Hands on experience with Change, Release, Incident and Problem management processes.
• Experience in working with ticketing tools Manage Now, ServiceNow
• Experienced with Oracle backup and recovery using both manual and RMAN.
• Experience in working with Oracle product support using metalink to resolve critical issues.
• Oracle SQL*Net Network Configuration, LDAP configuration with OID
• Provided 24x7 Oncall support for production databases in RAC and Non-RAC environment.
• Oracle Certified Professional for 9i.

TECHNICAL SKILLS

Databases: Oracle RAC, Oracle, PostgreSQL, SQL Server, MongoDB

Operating systems: Sun Solaris, HP-UX, AIX, Exadata and Windows.

Languages: SQL, PL/SQL, UNIX Shell Scripting, Python, Ansible

Tools: Oracle Enterprise Manager, grid control, ASM, Oracle Data GuardRMAN, LDAP, OID

PROFESSIONAL EXPERIENCE

Confidential, OVERLAND PARK KS

Lead Oracle DBA

Responsibilities:

• Performed database migration from AIX to EXADATA machine.
• Installing oracle 11g RAC software and configuring RAC database on Exadata machine.
• Installing oracle 12c/19c RAC software and configuring RAC database on Exadata machine.
• Experience in installing, configuring and maintenance of Oracle Golden Gate 11.x,12c.
• Supporting developers for day to day database and Golden Gate related issues.
• Configure Reporting database environment using Golden Gate Uni/Directional replication mode.
• Install, upgrade MongoDB standalone, replica set configurations in community and Enterprise versions.
• Setup MongoDB database backups using Mongo dump/restore, Ops Manager.
• Performed Mongo DB failover, switchover, troubleshooting and tuning MongoDB deployments.
• MongoDB user management and day to day operations support.
• Configured, optimized and supported high availability (Replication) MongoDB cluster.
• Optimized MongoDB CRUD Operations
• Monitored deployments for capacity, performance and reliability.
• Identify, troubleshoot and resolved MongoDB issues.
• Installing oracle 13c OEM monitoring agents and configuring targets on 13c OEM.
• Performing database backups, cloning using active duplication, restoring and recovering databases using RMAN.
• Supporting in application code migration on oracle databases.
• Perform operational support including security management, scheduling, error recovery, patching, upgrading, monitoring, change and incident management.
• Work closely with Architects, Developers, Business Analysts and Project Managers.
• Plan and design databases, including installation and upgrades, structure, documentation, 24x7 operational support, process maintenance and security/data protection.
• Monitor and fine tune large databases using tools like OEM, and scripting.
• Implement and maintain backup process through RMAN or applicable software, performing restore activities, working with backup team and implementing and maintaining appropriate database retentions.
• Upgraded databases from oracle 11g/12c to oracle 19c R2 version
• Configured data guard using physical and logical standby databases.
• Performed switchover and failover using Data guard configuration
• Performed daily routine backup checking and other user activities.
• Handled 24x7 On-call support for the databases availability.
• Upgraded databases from 10.2.0.2 version to 10.2.0.4 version.
• Cloned databases using rman hot backup.
• Written shell scripts to check the backup status
• Implemented RMAN Recovery manager & EXPDP data pump backups for all production databases
• Handled User management and resolving application connectivity issues.
• Coordinated with server team and backup team for any issues related to their respective track.
• Refreshed database from production to test and other development environments.

Confidential, Danbury, CT

Lead Oracle DBA

Responsibilities:

• Perform operational support including security management, scheduling, error recovery, patching, upgrading, monitoring, change and incident management.
• Work closely with Architects, Developers, Business Analysts and Project Managers.
• Plan and design databases, including installation and upgrades, structure, documentation, 24x7 operational support, process maintenance and security/data protection.
• Monitor and fine tune large databases using tools like OEM, and scripting.
• Implement and maintain backup process through RMAN or applicable software, performing restore activities, working with backup team and implementing and maintaining appropriate database retentions.
• Upgraded databases from oracle 9i to oracle 11gR2 version
• Configured data guard using physical and logical standby database.
• Performed switchover and failover using Data guard configuration
• Performed database point in time recovery using RMAN.
• Worked on oracle 11g grid control.
• Performed daily routine backup checking and other user actives.
• Applied oracle security patches databases every quarter.
• Handled 24x7 On-call support for the databases availability.
• Upgraded databases from 10.2.0.2 version to 10.2.0.4 version.
• Cloned databases using rman hot backup.
• Written shell scripts to check the backup status
• Implemented RMAN Recovery manager & EXPDP data pump backups for all production databases
• Handled User management and resolving application connectivity issues.
• Coordinated with server team and backup team for any issues related to their respective track.
• Worked with Patch Management on Oracle databases. Updated the database with latest patch updates.
• Refreshed database from production to test and other development environments.

Confidential, Richmond VA

Oracle Lead

Responsibilities:

• Worked on application objects creation.
• Refreshing databases using expdp/impdp.
• Handled 24x7 On-call support for the databases availability.
• Upgraded Oracle 9i databases to Oracle 10g.
• Upgraded databases from 10.2.0.2 version to 10.2.0.4 version.
• Implemented RMAN Recovery manager & EXPDP data pump backups for all production databases
• Handled User management and resolving application connectivity issues.
• Planned and setup database Disaster Recovery.
• Managed tablespaces, space related issues.
• Working on application issues.
• Worked with Patch Management on Oracle databases.
• Updated the database with latest patch updates.
• Routine monitoring of performance of databases.

Confidential, Danbury, CT

Lead Oracle DBA

Responsibilities:

• Installed, configured Oracle 11g/10g enterprise edition databases
• Installed oracle 11gR2 on Confidential aix and created databases
• Upgraded databases from oracle 9i to oracle 11gR2 version
• Configured data guard using physical and logical standby database.
• Performed switchover and failover using Data guard configuration
• Performed database point in time recovery using RMAN.
• Tuned the databases to optimal performance
• Worked on oracle 11g grid control.
• Performed daily routine backup checking and other user actives.
• Applied oracle security patches databases every quarter.
• Handled 24x7 On-call support for the databases availability.
• Upgraded databases from 10.2.0.2 version to 10.2.0.4 version.
• Cloned databases using rman hot backup.
• Written shell scripts to check the backup status
• Implemented RMAN Recovery manager & EXPDP data pump backups for all production databases
• Handled User management and resolving application connectivity issues.
• Managed tablespaces, space related issues.
• Coordinated with server team and backup team for any issues related to their respective track.
• Worked with Patch Management on Oracle databases. Updated the database with latest patch updates.
• Refreshed database from production to test and other development environments.

Confidential

Lead Oracle DBA

Responsibilities:

• Installed, configured Oracle 11g/10g enterprise edition databases and oracle 10g RAC.
• Installed security patches using all node down minimum downtime and rolling patching methods
• Adding additional nodes to existing RAC database
• Routine RAC database administration using RAC utilities srvctl & crsctl
• Installed oracle 11gR2 on sun Solaris and created databases
• Upgraded databases from oracle 9i to oracle 11gR2 version
• Configured data guard using physical and logical standby database.
• Performed switchover and failover using Data guard configuration
• Performed database point in time recovery using RMAN.
• Tuned the databases to optimal performance
• Worked on oracle 10g grid control.
• Performed daily routine backup checking and other user actives.
• Applied oracle security patches databases every quarter.
• Handled 24x7 On-call support for the databases availability.
• Upgraded databases from 10.2.0.2 version to 10.2.0.4 version.
• Cloned databases using hot backup.
• Written shell scripts to check the backup status
• Implemented RMAN Recovery manager & EXPDP data pump backups for all production databases
• Handled User management and resolving application connectivity issues.
• Managed tablespaces, space related issues.
• Coordinated with server team and backup team for any issues related to their respective track.
• Worked with Patch Management on Oracle databases. Updated the database with latest patch updates.
• Refreshed database from production to test and other development environments.
• Written shell script to monitor the databases status and backup status.

Confidential

Oracle DBA

Responsibilities:

• Installed, configured RAC databases on two node cluster using ASM
• Manual RAC database creation as well as database creation using DBCA
• Setup of High Availability of the database using RAC with ASM
• Routine RAC database administration using RAC utilities srvctl & crsctl
• RMAN cloning from RAC database to non-RAC
• Add new node to an existing two node cluster.
• Backup Real application cluster databases using RMAN.
• Troubleshooting installation issues, cluster issues
• Troubleshooting RAC database and instance issues using or a debug
• Handled 24x7 On-call support for the databases availability.
• Upgraded Oracle 9i databases to Oracle 10g.
• Upgraded databases from 10.2.0.2 version to 10.2.0.4 version.
• Implemented RMAN Recovery manager & EXPDP data pump backups for all production databases
• Handled User management and resolving application connectivity issues.
• Planned and setup database Disaster Recovery.
• Managed tablespaces, space related issues.
• Coordinated with server team and backup team for any issues related to their respective track.
• Worked with Patch Management on Oracle databases. Updated the database with latest patch updates.
• Refreshed database from production to test and other development environments.
• Wrote various Shell Scripts to monitor and maintain the Oracle database.
• Performing Database refresh using flash copy and Rman duplicate method.
• Scheduling the database availability check jobs.
• Created partitions & indexes for better performance.

Confidential, Richmond, VA

Responsibilities:

• Installation and upgradation of Oracle 8.x, 9.2 on Unix.
• Installed, configured Oracle 11g/10g enterprise edition databases and oracle 10g RAC.
• Database creation and re-organization.
• Allocating system storage and planning future storage requirements for the database system.
• Creating primary database storage structures (Tablespaces), altering according to the company’s requirement
• Modifying the database structure, as necessary, to accumulate application growth and maintain peak performance.
• Enrolling users and maintaining system security.
• Controlling and monitoring user access to the database.
• Configuration of Listener and TNSNames.
• Import and Export of Database Objects.
• Creation of clone Database.
• Prepared backup strategy.
• Performance and Tuning tasks including regular analysis of the database.
• Checking STATSPACK/AWR report on regular basis or weekly basis.
• Backup & Recovery of Oracle databases using RMAN and through OS commands.
• Patching the databases.
• Capacity planning for tablespaces.
• Performing recovery of databases using manual and rman methods.
• Scheduling analyzes and indexes rebuild jobs.

Confidential

Oracle DBA

Responsibilities:

• Creation of Primary Database Objects - Tables, Indexes, views and synonyms
• Designed new schemas, installed new releases into the databases.
• Written Shell scripts to automate the processes
• Implementing data guard
• Implementation of oracle Real application cluster (RAC) with 2 nodes.
• Database, SQL and PL/SQL tuning (Using OEM)
• Refresh the databases from the production to non-production on monthly basis.
• Schema refresh (Export/Import and Data pump),
• Setup the Environment for new accounts when new user joins the team.
• Managing privileges and roles to ensure database security. space management,
• Data purging.
• On call Production Support
• Materialized views and materialized view logs to implement the table level replication for the databases.
• Scheduling the database availability check jobs.
• Performed database media recovery (incomplete recovery)
• Performed rman incomplete recovery

Confidential

Consultant

Responsibilities:

• Upgradation and migration of the databases
• Scheduling backups both online, offline using automation tools.
• Performing Root Cause Analysis (RCA) and working with Problem Management.
• Tuning at Application level and optimization of queries for better performance of the database by creating sufficient Indexes and also creating additional new indexes when required
• Observing the space management by looking the periodical sizes of the data files and also marking the data files having number of extents.
• Creating the Environments for testing purpose.
• Problem Management and Change Management, Space management and Uptime.
• Planning and Validating Disaster Recovery
• Applying security patches every quarter released by the vendor
• Planning and implementing large and enhancement projects.
• Tuning the database for the optimal performance.