SUMMARY

• Around 8 years of experience as an Oracle DBA (12c, 11g, 10g and 9i) in Production, Development and Test environments
• Expertize in Oracle 11g, 10g, 9i administration, performance tuning, upgrades on Solaris, HP - UX, AIX, Redhat Enterprise Linux, Windows platforms.
• In depth knowledge of Oracle Architecture Concepts.
• Recovery of entire Database, Data files, Table spaces using RMAN and User managed recovery.
• Good experience in Oracle Database Design, Installation, configuration and Administration, Backup and Recovery, Database Migrations. Installation of Oracle 11g RAC 2 nodes.
• Expertize on Data Guard brokers and standby databases.
• Expertize in Performance tuning of oracle databases using AWR, ADDM and STATSPACK.
• Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.
• Extensive experience in Recovery Manager (RMAN) and Export/Import/DataPumps backups.
• Automated many common tasks using crontab including Backups, exports and imports, archiving old records and verification of such processes.
• Oracle E- Business Suite 11i/R12 experience includes, installing 11.5.2 and then upgrading to 11.5.3, 2 instances run on 2 RHEL nodes.
• Experienced in Oracle Apps Administration and Sysadmin tasks like running apps util script.
• Schema / Table level and query based normal Export & Import and also Data Pump Export & Import utility.
• Migrating database between datacenters. Creating dataguards in different datacenters as and when requested by the clients or application teams.
• Worked as primary DBA for Switchover and switchback activities all over Comcast project.
• Good experience in applying Critical Patch Update (CPU Patches) on Databases.
• Strong experience in providing 24/7 support for corporate databases, timely resolution of tickets, and on-call rotation.
• Resolved database network problems using Oracle Net Configuration Assistant (NETCA) and also manually.
• Configuration of Oracle10g/11g Data Guard and Physical Standby using RMAN backup. Dataguard broker has been configured on them as per client requirement.
• Expertise in replication technologies including GOLDENGATE.
• Golden gate installation on Linux environments.
• GoldenGate schema replication, online change synchronization, ddl synchronization.
• Knowledge of Oracle Exadata.
• Raise SR to Oracle Support for Exadata related Issues, and works accordingly.
• PL/SQL objects creation. Create trigger/ function/ stored procedure/ packages. Manage cursor. Tune and trouble-shooting PL/SQL codes. Handle run-time errors. Write database Monitoring PL/SQL objects. Create Materialize view.
• Loading data using Import/export/ SQL loader. Purging /cleansing data. Used Data Pump. Estimate timing for imp/exp. Refresh schema.
• Scripting - Shell, PL/SQL, SQL. Write script for Monitoring, maintenance. Audit and as per required.
• Worked on Oracle Database Appliance (ODA). Configured ODA for 2 node RAC system.
• Implemented EUS (Enterprise User Security) on Red Hat system as IAM solution for Oracle Database.
• Configured Oracle Unified Directory (OUD).
• Supported production database servers and applications that provided secure mission and critical services.
• Worked on Change management Requests (CMR), Incident Management Requests (IMR).
• Ability to grasp new technologies quickly and adapt to the same.
• Good communication skills to handle end-users effectively and an excellent team player.

TECHNICAL SKILLS

Operating Systems: Windows NT/2003/2008, HP-UX, AIX, RHEL, Solaris

RDBMS: Oracle 9i/10g/11g/12c

Tools: RMAN, Imp/Exp, GoldenGate, expdp/impdp, DataPump, Standby databases, DataGuard Broker, RAC, Oracle Enterprise Manager, SQL Loader, AWR, ADDM, OEM, TOAD, Explain Plan, MS Excel, Statspack, SQL*Plus, BMC Patrol, Query Analyzer, OUD, ODA

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Senior Oracle DBA

Responsibilities:

• Administration and supporting Oracle 12c, 11g and 10g databases in DEV, QA, UAT and Prod environments.
• Managing Security, User groups and Users by using roles, grants, privileges and Profiles.
• Installation of Oracle databases on standalone and RAC nodes on HP UX, Linux, AIX and Solaris environments.
• Managing Oracle 12C databases on Exadata appliances.
• Good understanding of RAC architecture.
• Handling Customer Query, Work on change requests, Weekly Maintenance Activity, troubleshoot common SQL codes, Error Messages and Database issues.
• Upgradation of databases from Oracle 10g to Oracle 11g.
• Upgrading Oracle RAC clusters.
• Architect Golden Gate 11g replication solutions to facilitate data flow between oracle environments.
• Configuration of Oracle 11g Data Guard. DG broker has been configured on all of them as per client requirement. Rebuild standby if there is a large gap in DataGuard.
• Setting up production databases for Go-Live. Testing with Switch-Over/Switch-Back before go-live.
• Troubleshooting Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Performing Database Administration activities like space management, user and roles administration, schema management, checking alert log of all the databases.
• Refresh of databases, Schema, tables using expdp/impdp.
• Used OEM to monitor Blackout Servers in case of any maintenance activity. Database health, Bottlenecks, session information, table privileges, user roles and grants.
• Database Cloning to create Test/Dev databases from Production systems.
• RMAN restore using Netbackup.
• Designed and Implemented database security using Oracle roles and privileges. Set up the password for new users and then managed users and their respective sessions.
• Worked on PL/SQL development with application team.
• Applying Bug Fix patches on defective systems and as per Oracle Support recommendations.

Environment: RHEL, AIX, SOLARIS, Oracle 9i/10g/11g/12c, RMAN,RAC,DATAGUARD Broker, Standby, SQL, EXP/IMP, EXPDP/IMPDP, Goldengate, ASM, SQLLOADER, AWR, ADDM, Explain Plan

Confidential, Princeton, NJ

Sr. Oracle DBA

Responsibilities:

• Responsible for administration and supporting Oracle 12c, 11g and 10g databases in DEV, QA, UAT and Prod environments.
• Managing Security, User groups and Users by using roles, grants, privileges and Profiles.
• Installation of Oracle databases on standalone and RAC nodes on HP UX, Linux, AIX and Solaris environments.
• Upgradation and migration of databases.
• Applying PSU patches in a rolling upgrade manner in RAC environment.
• Configures DataDomain Backups on Exadata Machines.
• Raise SR to Oracle Support for Exadata related Issues, and works accordingly.
• Good understanding of RAC architecture, CRS, OCR, OLR, Gpnp etc.
• Handling Customer Query, Work on change requests, Weekly Maintenance Activity, troubleshoot common SQL codes, Error Messages and Database issues.
• Upgradation of databases from Oracle 10g to Oracle 11g using RMAN backup.
• Upgrading Oracle RAC clusters.
• Architect Golden Gate 11g replication solutions to facilitate data flow between oracle environments.
• Assisting the ETL team to improve performance by analyzing SQL statements, reorganizing database objects and design indexes to improve response of queries.
• Used Explain Plan to monitor the query execution and views to make sure the operations run without any issues.
• Troubleshooting Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Performing Database Administration activities like space management, user and roles administration, schema management, checking alert log of all the databases.
• Configuration of Oracle 11g Data Guard. DG broker has been configured on all of them as per client requirement. Rebuild standby if there is a large gap in DataGuard.
• Setting up production databases for Go-Live. Testing with Switch-Over/Switch-Back before go-live.
• Refresh of databases, Schema, tables using expdp/impdp.
• Used OEM to monitor Blackout Servers in case of any maintenance activity. Database health, Bottlenecks, session information, table privileges, user roles and grants.
• Database Cloning to create Test/Dev databases from Production systems.
• Configuring VERITAS Netbackup/Data Domain backups and also moving the backups which run on tape/disk to NB/DD. Schedule backup jobs in crontab.
• Performing Database Administration activities like space management, user and roles administration, schema management, checking alert log of all the databases.
• Designed and Implemented database security using Oracle roles and privileges. Set up the password for new users and then managed users and their respective sessions.
• Monitoring the databases locks and blocking sessions using OEM or SQL Scripts.
• Standardizing control files, log files according to the project standard.
• Worked on PL/SQL development with application team.
• Applying Bug Fix patches on defective systems and as per Oracle Support recommendations.
• Design and Install OUD (Oracle Unified Directory) on Linux Server.
• Create Mapping of Active Directory with Oracle Schemas using OUD.

Environment: RHEL, AIX, SOLARIS, Oracle 9i/10g/11g/12c, RMAN,RAC,DATAGUARD Broker, Standby, SQL, EXP/IMP, EXPDP/IMPDP, Goldengate, ASM, SQLLOADER, AWR, ADDM, Explain Plan

Confidential

Oracle DBA

Responsibilities:

• Handling Customer Query, Work on change requests, Weekly Maintenance Activity, troubleshoot common SQL codes, Error Messages and Database issues.
• Responsible for administration and supporting Oracle 11g, 10g and 9i databases on different Linux OS such as AIX, HP-UX, Solaris in DEV, QA, UAT and Prod environments.
• Installation and Setting up of Standalone databases,2 node 11g RAC in Linux environment and 11g ASM on RAC databases.
• Installation of Oracle 11g on standalone and RAC 3 nodes on HP UX, Linux, AIX and Solaris environments.
• Upgradation and migration of databases.
• Addition of new node to the existing 2 node RAC.
• Supporting Oracle Apps databases running on Oracle 11G versions.
• Was involved in Oracle Apps upgrade from 11.5.2 to 11.5.3.
• Experienced in Oracle Apps Administration tasks like running apps util script.
• Applying PSU patches in a rolling upgrade manner in RAC environment.
• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Clone production databases to lower environment.
• Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups to the FRA.
• Monitored and resolved day-to-day tickets. Created CMR and Participated in DR activities.
• Managing tablespaces, control file, data file, log file and parameter file.
• Using GoldenGate replication, replicate schemas to other databases and manage them.
• Goldengate installation on Linux environments.
• Replicate schemas using GoldenGate schema replication which includes online change synchronization and ddl synchronization.
• Troubleshoot and optimize performance on databases in high availability production environments.
• Cross platform migration Solaris to RHEL, AIX to windows.
• Setting up and monitoring Cron jobs to schedule database backups with the help of RMAN scripts and daily night exports.
• Performance tuning using Explain Plan, AWR reports and ADDM reports.
• Database upgradation and migration from 9i, 10g to 11gR2.
• Creation of databases, Schemas and tables on request.
• Clone databases, backup and recovery using RMAN with TSM.
• Maintain DB admin owner login, Schema owner login and users supports.
• Created different users and assigning default tablespace, temporary table spaces, privileges, profiles.
• Creation of profiles, roles and granting privileges.
• Writing up and Responsible for setting up shell scripts in crontab.
• Detection and analysis of failures and solving database issues.
• Setting up Authentication & Privileges to access DB.
• Implementation of database deployment in production and development databases.
• Creating and managing various indexes and monitoring usage.
• Creation and maintenance of standby physical databases.
• Configured dataguard broker. Switchover between physical and standby using dataguard broker.
• Capacity planning for the databases.
• Monitoring tablespaces free space proactively.
• Exposure to PL/SQL and complex SQL queries.
• Applying Quarterly Oracle CPU Patches and other bug fixing patches.
• Install and Configure Oracle Database Appliance ODA.
• Monitor and manage database backups using Recovery Manager.
• Use Logical Export and Import as and when required.

Environment: RHEL, AIX, SOLARIS, Oracle 9i/10g/11g, RMAN,RAC, DATAGUARD Broker, Standby, SQL, EXP/IMP, EXPDP/IMPDP, Goldengate, ASM, SQLLOADER, AWR, ADDM, Explain Plan