EXPERIENCE SUMMARY

• Having 10.8 years of vast experience across IT in the field of Oracle DBA/System Administrator.
• Completed Oracle Certified Expert, Oracle Real Application Clusters 11g and Grid Infrastructure Administrator in Sep 2016 (OCE)
• Completed Oracle Database 11g Administrator Certified Professional in Apr 2016. (OCP)
• Completed Oracle Database 11g Administrator Certified Associate in Jan 2015 (OCA)

EXPERIENCE SUMMARY

Confidential, Richardson TX

Oracle DBA

Responsibilities:

• More than 4 years experiences and solid hands - on experiences in installation, configuration, performance tuning and troubleshooting Oracle GoldenGate in Oracle to Oracle homogeneous environments and heterogeneous environments
• First-hand experiences in setting up Oracle GoldenGate one-way, two-way/bi-directional, active-to-active and active-to-passive data replication with conflict detection and resolutions.
• Extensive skills in upgrading OGG 11gR2 to 12c, configuring OGG in RAC high available environment.
• Primary technical resources for GoldenGate configuration and troubleshooting on any GG issue
• Deep understanding Oracle GoldenGate internal mechanism
• Experience of Oracle Golden Gate (GG) installation, configuration and troubleshooting Golden Gate Extract and Replicate issues
• Worked on databases sizes 2TB and involved in scheduling backups
• Provide support and maintain very large number of complex Oracle database systems in a multi-platform 24x7 environment.
• Performed database administration like User Management and implement Security using Roles, Privileges, Grants, applied patches, Database upgrades
• Build and maintain Golden Gate Processes for replicating purposes including RAC databases. Troubleshoot with Golden Gate ERRORS.
• Worked as production DBA in 10g/11g.
• Tablespace management and capacity planning.
• Build Oracle RAC systems over NFS and ASM for the clients. Maintained and enhanced the scripts used for Oracle RAC/non-RAC installation.
• Administer RAC databases and also STARTING/STOPPING RAC SERVICES.
• Worked on Backups and Recovery policy Hot/Cold Backup using RMAN.
• Implementation and Setup of Data Guard and provide support for Oracle Data guard and streams implementation for DR setup.
• Monitoring and optimizing the performance of the database through Tuning Applications, Tuning Memory, and Tuning Disk Usage etc. Performance and tuning using AWR reports, ADDM, 10G Advisors.
• Gathering statistic, analyzing tables and indexes.

Confidential

Oracle DBA

Responsibility

• Manage the planning and implementation phase of major activities.
• Special work with sub-project i.e. VPMO (Virtual project management Activities).
• Working with Mission critical applications and respective databases.
• Major Cutover activities for Database migrations.
• Apart from the above, special intervention needed for Incident / Change management.
• Outage calls management, subsequently execution up to root cause analysis.
• Project specific and customized Shell scripting.

Confidential

Oracle DBA

Responsibility

• Worked with huge DB infrastructure environment, The Project support more than 1000 Database all over the world.
• Responsible for administering Oracle Real application Clusters AIX
• Manage the implementation ofbackup and recovery procedures.Working Tape Libraries ()
• Working with OS clusters / Veritas Environment.
• Troubleshooting the RAC availability issues
• Install and upgradeOracle and supporting products.
• Major Database upgrade Activities (Single Node and RAC databases)
• Patch Management and version upgrades (PSU / CPU /Bug Patches on Single node / RAC nodes db )
• Major Cutover activities for Database migrations
• Shell scripting
• Flashback database
• Working with SAP Databases / Backup / Daily activities
• Basic performance tuning activities
• Diagnose and resolve locking conflicts / Sessions Conflicts
• Use data dictionarytables and views.
• Monitor a database instance.
• Collect and analyze relevantdatabase performance information.
• Identify and implement appropriate solutions fordatabase performance problems.
• Know how touse vendor support serviceswhen necessary.
• Identify and solveSQL*Net problems.
• Other than technical environment: -
• Incident management / Change management / Release management
• Working with new joiners to share knowledge
• Pursuing the Oracle 11G R2 RAC Administration course.

Confidential

Oracle DBA

Responsibility -

• Responsible for administering Oracle Application System on Linux RHEL 5 / AIX
• Working with RAC clusterware.(create and manage RAC databases)
• Maintain daily checklist and Troubleshooting the problems faced in daily routines.
• Maintain Oracle Operated system files.
• Temporary and Undo Tablespace management.
• Maintaining archive logs And Backups to backup media.
• Checking of alert logs and checking operating systems logs.
• Checking free space of tablespace and Index usage.
• Installation of Oracle 10G on RHEL 5 and working with Standby database managed, manual.
• User management; roles and privilege management.
• Backup Recovery Operations.
• Export-Import and Expdp-Impdp Utilities.
• Backup Contingency.(RMAN Restoration / User managed Restoration)
• RMAN Utilities with RMAN scripting.
• Maintaining various storage structures.
• Identify bottlenecks and Performance Tuning. ( statspacks / AWR / ADDM )
• Worked application servers Oracle / WebSphere Apps Servers.
• Shell scripting (for Automation Project.)

Confidential

Oracle DBA

Responsibility -

• Responsible providing 24x7 on-call production/development/testing database support.
• Involved in installation of Oracle on different platforms, loading of user data to reproduced the problem
• apply new Oracle patches to production/Quality/development instances
• managed database backup using RMAN
• Involved in Weekly Database refresh from production to quality
• Supported Oracle DB backups (hot/cold), logical backups and UNIX scripts Alert monitoring using Autosys and BMC Remedy.
• Coordinate Knowledge transition sessions for new Hires. Development which supports project needs.