EXPERIENCE SUMMARY:

• 10 years of experience in the Information Technology as an Oracle Database Administrator (DBA).
• Experience in the area database design, database administration, planning, database space needs, growth analysis and future disk need analysis.
• Extensive experience in Installing, Configuring, Administering and Managing Oracle 9i/10g/11g databases on Unix, Linux and Windows platforms.
• Experience in planning and keeping the data in respective mount points to avoid the performance issues.
• Experience in administering application schemas and end users by creating and assigning proper profiles and roles to maintain the security.
• Experience in upgradingthe oracle database from Oracle 9i to 10g and 10g to 11g.
• Experience in planning and implementing the backup strategy using RMAN, Hot backup, Cold Backup and Logical backup.
• Performed Table level, User level and Full database level backup using Export/Import and Data Pump Export/Import (Expdp/Impdp).
• Experience in restoring tables, tablespaces, schemas and full database through Data Pump backup.
• Experience in restoring and recovering the database through RMAN backups.
• Experience in High Availability technologies such as Data Guard and RAC.
• Experience in Oracle 10g and 11g RAC installation and configuration.
• Experience in ASM technology in RAC servers.
• Experience in handling Log sync issues between primary and standby databases in Data Guard.
• Experience in managing and supporting SQL Server2005 and 2008 Instances.
• Experience in handling performance issues, closely working with application teams and recommending the changes to improve the performance.
• Proactive monitoring, identifying areas that need to be improved in the application and database using AWR, ADDM, OEM Grid control, tuning SGA & PGA parameters.

TECHNICAL SKILLS:

Hardware / Platforms: Unix, Linux, Windows.

Technology: Oracle Database Administration.

Programming Languages: SQL and Shell Scripting.

Databases: Oracle 9i/10g/11g.

Tools: and Utilities SQL*Plus, Vi Editor, Oracle Enterprise Manager (OEM), RMAN, AWR, DBCA, NETCA, DBUA, Export/Import and Expdp/Impdp.

PROJECT EXPERIENCE:

Confidential, NJ

Lead Oracle DBA

Operating System: Unix, Red Hat Linux

Tools: 11g Oracle Enterprise Manager (OEM), Toad, RMAN,Expdp/Impdp, DBCA, SQL*Plus, Vi Editor

Responsibilities:

• Playing a Lead role in handling and managing very large sized Oracle 10g/11g databases on Unix and Linux platforms.
• Involved in capacity planning of the databases and took proactive steps in getting the extra storage for the application growth in order to avoid the last minute Job failures.
• Guiding offshore team members and providing them technical tips for quickly resolving the issues.
• Installed and created Oracle 11g databases, applied required CPU and PSU patches.
• Upgraded databases from 10g to 11g.
• Handling schema management, end user management by assigning proper profiles and roles.
• Installed 11g OEM Grid control to manage all our databases and applied required patches.
• Involved in all the major performance issues, closely working with application teams and recommending the changes to improve the performance.
• Identifying long running sessions/ queries, analyzing the reason for this and implementing the right actions to improve the performance.
• Proactive monitoring, identifying areas that need to be improved in the application and database using AWR and OEM Grid control.
• Reclaiming the wasted space by reorganized the fragmented tables & indexes which is caused due to High Water Mark (HWM).
• Setup the jobs for daily/weekly export backup, daily/weekly RMAN backup as per the application requirement through Tidal and Crontab.
• Restored tables, tablespaces, schemas and full database through Data Pump backup.
• Restored and recovered the database through RMAN backups.

Confidential, NJ

Oracle Database Administrator

Operating System: Suse Linux, Red Hat Linux

Tools: 12C Oracle Enterprise Manager (OEM), Toad, RMAN,Expdp/Impdp, DBCA, SQL*Plus, Vi Editor

Responsibilities:

• Planned and Build the Red Hat Linux Server with proper Configurations and File System Layout.
• Installed the 11.2.0.3 Oracle Binaries with recent CPU Patch on Red Hat Linux Server.
• Created Databases on 11.2.0.3 Oracle Binaries.
• Migrated Databases from 11.2.0.3 Suse Linux to 11.2.0.3 Red Hat Linux.
• Installed 12C Agent and Configured databases to monitor under 12C OEM Grid.
• Scheduled Daily and Weekly RMAN Backups.
• Scheduled Daily Stats Gathering Scripts.
• Enabled the Oracle Processes and Listener Processes to monitor under OVO.
• Handled all the Performance issues and made sure the database performance is good as expected by business.

Confidential

Oracle Database Administrator

Operating System: Unix,Red Hat Linux, Windows

Tools: 12C Oracle Enterprise Manager (OEM), RMAN,Expdp/Impdp, DBCA,DBUA, SQL*Plus,Vi Editor

Responsibilities:

• Handled all the RFS and Change requests.
• Involved in Installing, Configuring, Administering and Managing Oracle 10g/11g.
• Migrated databases from 9i and 10g to 11g.
• Installed, Created and configured the 11g databases.
• Involved in regular client meetings and status calls, updating the action items of the meetings to Onsite and Offshore team members.
• Taking initiative on escalations.
• Handled L2/L3 requests, Handled and worked on Change Management and Incident Management Tickets through IRIS (Service - Now) and Remedy tools.
• Taking whole responsibility of the number of databases which are assigned.
• Managed all the activities related to maintenance and administration of databases.
• Installed Patch Sets and upgraded Oracle.
• Upgradeddatabases from Oracle 9i to 10g and 10g to 11g.
• Analyzing tables and rebuilding the indexes to increase the performance.
• Responsible for backup of database using Logical (Export/Import and Data Pump Export/Import).
• Performed Table level, User level and Full database level backup using Export/Import and Data Pump Export/Import (Expdp/Impdp).
• Performed Full/Incremental backup using RMAN.
• Performed Backups and Restores using Export/Import and RMAN.
• Verified backup logs, analyzed failures of backups, resolved the problems and rescheduled the backups.
• Identify the poorly performing queries using Explain Plan, STATSPACK reports and assisting the developers in optimizing and tuning the SQL and PL/SQL code.
• Extensive use of performance tools like Explain Plan, Statspack and AWR for performance monitoring and troubleshooting.

Confidential

Oracle Database Administrator

Operating System: Unix, Red Hat Linux, Windows

Tools: 10gOracle Enterprise Manager (OEM), RMAN,Expdp/Impdp, DBCA,DBUA, SQL*Plus,Vi Editor

Responsibilities:

• Installed, Created and configured the 11g databases.
• Involved in regular client meetings and status calls, updating the action items of the meetings to Onsite and Offshore team members.
• Taking initiative on escalations.
• Handled L1/L2 requests, Handled and worked on Change Management and Incident Management Tickets through IRIS (Service-Now) and Remedy tools.
• Taking whole responsibility of the number of databases which are assigned.
• Managed all the activities related to maintenance and administration of databases.
• Experienced in Maintenance and Support of SQL ServerInstances.
• Involved in Installing, Configuring, Administering and Managing Oracle 8i/9i/10g/11g.
• Installed Patch Sets and upgraded Oracle.
• Upgradeddatabases from Oracle 9i to 10g and 10g to 11g.
• Analyzing tables and rebuilding the indexes to increase the performance.
• Responsible for backup of database using Logical (Export/Import and Data Pump Export/Import).
• Performed Table level, User level and Full database level backup using Export/Import and Data Pump Export/Import (Expdp/Impdp).
• Performed Full/Incremental backup using RMAN.
• Performed Backups and Restores using Export/Import and RMAN.
• Verified backup logs, analyzed failures of backups, resolved the problems and rescheduled the backups.
• Handled Log sync issues between primary and standby databases in Data Guard.
• Identify the poorly performing queries using Explain Plan, STATSPACK reports and assisting the developers in optimizing and tuning the SQL and PL/SQL code.
• Extensive use of performance tools like Explain Plan, Statspack and AWR for performance monitoring and troubleshooting.

Confidential

Oracle Database Administrator

Operating System: Unix, Red Hat Linux, Windows

Tools: SQL*Plus, Vi Editor, 10g Oracle Enterprise Manager (OEM), RMAN,Expdp/Impdp, DBCA

Responsibilities:

• Involved in installing, configuring, administering and managing Oracle 10g/11g databases.
• Installed Patch Sets and upgraded Oracle.
• Upgradeddatabases from Oracle 9i to 10g and 10g to 11g.
• Analyzing tables and rebuilding the indexes to increase the performance.
• Responsible for backup of database using Logical (Export/Import and Data Pump Export/Import).
• Performed Table level, User level and Full database level backup using Export/Import and Data Pump Export/Import (Expdp/Impdp).
• Performed Backups and Restores using Export/Import and RMAN.
• Verified backup logs, analyzed failures of backups, resolved the problems and rescheduled the backups.
• Handled L1/L2 requests.
• Installed and configured Oracle 10g and 11g RAC.
• Involved in L1/L2 level support for Oracle RAC Databases.
• Involvedin RAC pre-installation tasks like hardwarerequirements, software requirements and environment configuration.
• Involved in adding services to applications to use specific node in RAC.
• Involved in creating and configuring standby database (Data Guard) from primary database.
• Handled Log sync issues between primary and standby databases in Data Guard.
• Identify the poorly performing queries using Explain Plan, STATSPACK reports and assisting the developers in optimizing and tuning the SQL and PL/SQL code.
• Extensive use of performance tools like Explain Plan, Statspack and AWR for performance monitoring and troubleshooting.

Confidential

Oracle Database Administrator

Responsibilities:

• Involved in installing, configuring, administering and managing Oracle 9i/10g databases.
• Upgradeddatabases from Oracle 9i to 10g.
• Analyzing tables and rebuilding the indexes to increase the performance.
• Responsible for backup of database using Logical (Export/Import and Data Pump Export/Import).
• Performed Table level, User level and Full database level backup using Export/Import and Data Pump Export/Import (Expdp/Impdp).
• Performed Backups and Restores using Export/Import and RMAN.
• Verified backup logs, analyzed failures of backups, resolved the problems and rescheduled the backups.
• Handled L1 requests.
• Identify the poorly performing queries using Explain Plan, STATSPACK reports and assisting the developers in optimizing and tuning the SQL and PL/SQL code.
• Extensive use of performance tools like Explain Plan, Statspack and AWR for performance monitoring and troubleshooting.