SUMMARY

• Over 11+ years of strong IT and Oracle experience in the field of Analysis, Design, Development and Database administration.
• Over 8+ years of Information Technology experience includes Oracle Database Administration 12c/11g/10g on different Unix operating environments like AIX, Sun Solaris, Linux Advance Server, HP UX and Windows Server .
• Hands on experience in database administration, Monitoring DB, production support, installation, configuration, upgrades, performance tuning, backup and recovery, migration, cloning, space management, and database security with Oracle Software 12c/11g/10g on Sun Solaris, Red Hat Linux, HP - UX, AIX, and Windows Platforms.
• Experienced in Upgradation and Migration of Oracle Database across various platform
• Configure, installing and set up the Golden gate replicate, extract or pump on Golden Gate.
• Upgrading Golden Gate environments.
• Monitoring Golden Gate processes and fix the error which occur while starting any GG process.
• Troubleshoot Golden Gate related errors where extract, pump or replicate is abended/stopped.
• Create the Definition file of the Golden Gate after the release changes and provide that to all downstream applications.
• Frequently using Golden Gate command like info, report, params, logdump etc.
• Created and maintained Oracle RAC/RAC One Node 11gR2
• Experience in handling ASM, ACFS and handling database with Active Passive file system failover configuration on different servers.
• Performed Performance Tuning of Database, Application, System Global Area, I/O, Rollback segments using different tools like Oracle Enterprise Manager, Toad, Explain Plan, Tkprof reports, grid control and AWR reports
• Worked On call for 24X7 Production Support with across different Timezone.
• Experience in handling large size Databases (30 TB+)
• Excellent communication, presentation and interpersonal, team building skills, versatile team player, highly motivated and will be able to achieve results in a fast paced team environment.
• Experience in automation of day to day DBA tasks, like getting different reports for DB health checks.

PROFESSIONAL EXPERIENCE

Confidential, Richardson, TX

Senior Oracle DBA

Environment: Oracle 12c, 11gR2, RAC 11gR2, Dataguard, Golden Gate 11.2.1.0.18 , Linux, Unix

Responsibilities:

• Working in team of 10 members to support various Confidential &T databases.
• Maintenance and monitoring of the Databases which are running on Linux environment and standalone DB on HP-UX environment.
• Upgrading GG binaries and moving Golden Gate processes from one version to other
• Dataguard setup between primary and standby Databases.
• Managing and troubleshooting Dataguard errors and issues.
• Capacity planning to predict the space required on DB on yearly basis.
• Addition and removal of disks on the ASM Diskgroups.
• Performing the annual DR exercise to test the availability of DR system.
• To apply the Oracle PSU patches on the databases.
• Performed SQL performance tuning and provide tuned queries to the ADBA team.
• To configure the backup and recovery of the Database and archive logs.
• Configure and Set up the Dataguard and DG broker for the physical standby database
• To perform the failover and failback activity on the Standby database and vice versa using the DG Broker
• Open Standby DB into snapshot standby DB and then revert back to physical standby DB.
• To write and debug the Unix shell script for taking the backup
• Configure, installing and set up the Golden gate replicate, extract or pump on golden gate.
• Troubleshoot golden gate related errors where extract, pump or replicate is abended/stopped..
• Performed tuning Confidential database level by tuning the parameters like (pga aggreate target and SGA size) to increase the throughput of the database.
• To debug the database performance generated and analyze the AWR, ADDM and ASH reports and also used the explain plan to analysis and review for the performance of the queries
• Coordinated with the Netbackup and SA team members to fix any backup related issues.
• Perform the export and import of the particular tables from the restored database. Perform the recovery and restoration of the database from the backup to get create new database to retrieve old data for legal query purpose.
• To ensure that the weekly database backups and daily archive backups are completing on time and fix errors in case any type of issue is reported.
• Providing fix to Listener and network related error which user are facing while running their queries.
• Adding and recover the space from the tablespace which are running out of space or if space is over allocated.
• Write and debug the database objects like procedure, functions and triggers
• Implemented encryption Confidential Tablespace level through wallet and encryption key as a security major to secure the confidential and highly secure data.
• Interaction and meeting with client to provide the database solutions for the different type of the request.
• To fix all the Vulnerability issue which are found in the vulnerability report by providing the fixed or revoking the unnecessary privilege or file permission issues.
• Monitor the various types of ORA error alerts and provide fix of them.
• Automated Golden gate test environment for new installation and upgrade.
• Automated couple of Database reports which give details of tablespace usage, backup failure, dataguard sync-up status.
• Performed automation for task to start all our standby databases after every quarterly release.
• Automated few reports which runs and send information about database which is having noncompliant database parameters.
• Automated task to set parameter in one go, over all intended databases.
• Directly worked with our dedicated automation team to automate many of repitive tasks like, starting of goldengate processes for databases, any particular process or bunch of processes related to same application as we have one to many environment.

Confidential

Lead DBA

Environment: Oracle 12c, 11gR2, RAC 11gR2, Dataguard, Golden Gate 11.2.1.0.18 , Linux, Unix

Responsibilities:

• Working in team of six to seven members to support various Confidential &T databases.
• Maintenance and monitoring of the Databases which are running on Linux environment and Standalone DB on HP-UX environment.
• Dataguard setup between primary and standby Databases.
• Managing and troubleshooting Dataguard errors and issues.
• Capacity planning to predict the space required on DB on yearly basis.
• Addition and removal of disks on the ASM Diskgroups.
• Performing the annual DR exercise to test the availability of DR system.
• To apply the Oracle PSU patches on the databases.
• Performed SQL performance tuning and provide tuned queries to the ADBA team.
• To configure the backup and recovery of the Database and archive logs.
• Configure and Set up the Dataguard and DG broker for the physical standby database
• To perform the failover and failback activity on the Standby database and vice versa using the DG Broker
• Open Standby DB into snapshot standby DB and then revert back to physical standby DB.
• To write and debug the Unix shell script for taking the backup
• Configure, installing and set up the Golden gate replicate, extract or pump on golden gate.
• Troubleshoot golden gate related errors where extract, pump or replicate is abended/stopped..
• Performed tuning Confidential database level by tuning the parameters like(pga aggreate target and SGA size) to increase the throughput of the database.
• To debug the database performance generated and analyze the AWR, ADDM and ASH reports and also used the explain plan to analysis and review for the performance of the queries
• Coordinated with the Netbackup and SA team members to fix any backup related issues.
• Perform the export and import of the particular tables from the restored database. Perform the recovery and restoration of the database from the backup to get create new database to retrieve old data for legal query purpose.
• To ensure that the weekly database backups and daily archive backups are completing on time and fix errors in case any type of issue is reported.
• Providing fix to Listener and network related error which user are facing while running their queries.
• Adding and recover the space from the tablespace which are running out of space or if space is over allocated.
• Write and debug the database objects like procedure, functions and triggers
• Implemented encryption Confidential Tablespace level through wallet and encryption key as a security major to secure the confidential and highly secure data.
• Interaction and meeting with client to provide the database solutions for the different type of the request.
• To fix all the Vulnerability issue which are found in the vulnerability report by providing the fixed or revoking the unnecessary privilege or file permission issues.
• Monitor the various types of ORA error alerts and provide fix of them

Confidential

Oracle DBA

Responsibilities:

• Worked as offshore support analyst for Oracle DB and client applications.
• Managing Client’s Databases through remote sessions as per request raised in Peoplesoft.
• Troubleshooting different ORA- errors encountered by user.
• Handling database configuration, performance issues.
• Advise and help the client site systems administrator and DBA's for improved database performance, installation issues or enhance the existing ones.
• Upgrading databases for testing on different versions.

Confidential

DBA

Responsibilities:

• Involved in 24*7 Production and Development Support.
• Checking Runaway process and killing the process if required.
• Performing the regular Health checkup of the Oracle Database.
• Monitoring RMAN, COLD, HOT and Export Backup in the datacenter.
• Monitoring of database for growth and performance.
• Diagnose and troubleshoot Database problems and failures.
• Cloning the Production database to different systems and supporting them.
• Tablespace management.
• User management.
• Taking Backup and Restoring backup as per client requests.
• Responsible for database backup and restore, monitor production servers activity. Problem solving, scheduled jobs.
• Other activities as per assigned by the client.
• Interacting with Client.
• Proper handling of blocking sessions of user, system and database.
• Migrating concurrent programs and value sets for developers in oracle applications
• Proper handling of Appwrox tool for monitoring and scheduling chains.
• Using Foot Print ticketing tool for creating tickets and maintaining the issue details.
• Database Installation & Configuration, Tablespace Management, Extents Management, Segment management and Table Administration
• Monitoring the various backup jobs (logical, cold and hot backups) to ensure the system adheres to Oracle and SQL resilience principles.
• Maintaining a list of daily activities followed for space monitoring, error log monitoring and alert logs.
• Creating and maintaining the documents for daily activities