SUMMARY

• 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, Red hat Enterprise Linux, Windows platforms.
• In depth knowledge of Oracle Architecture Concepts.
• Recovery of entire Database, Data files, Tablespaces 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 brokersand standby databases.
• Expertize in Performance tuning of oracle databases using AWR, ADDM, 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.
• Schema / Table level and query based normal Export & Import and also Data Pump Export & Import utility.
• Migrating database between datacenters. Creating data guards 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. Data guard broker has been configured on them as per client requirement.
• Expertise in replication technologies including GOLDENGATE.
• Golden gate installation on linux environments.
• Golden Gate 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, 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 Data Guard.
• 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 controlfiles, logfiles according to the project standard.
• 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, Moline, Illinois

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, and 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.
• 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 Golden Gate replication, replicate schemas to other databases and manage them.
• Goldengate installation on linux environments.
• Replicate schemas using Golden Gate 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 data guard broker. Switchover between physical and standby using data guard broker.
• Capacity planning for the databases.
• Monitoring tablespaces free space proactively.
• 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

Confidential

Oracle DBA

Responsibilities:

• Adhering to SLAs Reporting, Handling tickets/requests, Troubleshooting technical issues with help of Other Team members.
• Responsible for administration and supporting Oracle 11g, 10g and 9i databases on different linux OS such as RHEL, AIX, HP-UX, Solaris and Windows 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.
• 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
• Downsizing and defragmenting the Large Databases by export/import, cloning those using RMAN duplicate features and then upgrading them to Oracle 11g.
• Setup, configuration and maintenance of standby databases (Oracle Data Guard) to ensure disaster recovery, high availability and data protection.
• Automate switchover with data guard broker.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Troubleshooting Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
• Used Explain Plan to monitor the query execution and views to make sure the operations run without issues.
• Performed Upgrade of development, production and QA databases from oracle 10.2.0.3 to Oracle 11gR1.
• Migration of oracle databases between different endian format systems.
• Installation of Golden Gate on linux environments.
• Participated in DR activity every 6 months.
• Capacity planning of the databases.
• Replicate schemas using Golden Gate schema replication which includes online change synchronization and ddl synchronization.
• Export and Import of database objects to copy from one database to another database between different environments.
• Troubleshooting errors and using the expdp/impdp utility on a very regular basis for copying data across schemas.
• Created UNIX shell scripts to automate batch jobs through Cron.
• Developed and modified scripts to work efficiently for alerts for ORA error backup and recovery, automatic startup and shutdown databases.
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
• Assisting the ETL team to improve performance by analyzing SQL statements, reorganizing database objects and design indexes to improve response of queries.
• Setting up and monitoring Cron jobs to schedule database backups with the help of RMAN scripts and daily night exports.
• Monitoring Growth of tables and undertaking necessary re-organization of tables and indexes as and when required.

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

Confidential

Oracle DBA

Responsibilities:

• Installed and Configured Oracle 10G database on Unix OS such as Linux and Solaris.
• Performed Database refresh using expdp/impdp.
• Database Cloning to create Test and Development environments from Production.
• Created different users and assigning default tablespace, temporary table spaces, privileges, profiles.
• Monitor and manage database backups using Recovery Manager.
• Design and implementation and monitoring of Backup and Recovery activities using RMAN & Export/Import utilities.
• Involved in database auditing to capture modification to Database.
• Wrote process/work instruction documents.
• Worked on Database PSU patching
• Creation of SR with Oracle for critical ORA errors like ORA-600.
• Worked 24*7 as a part of on call schedule.

Environment: Oracle 10g, Toad, Putty, RHEL, SOLARIS