SUMMARY:

• An astute ORACLE DBA and with 9 years of IT experience in Oracle database and Oracle Enterprise Manager.
• Expert - level skills in Installation, Configuration, Upgradation, Patching, Troubleshooting and Performance tuning of oracle databases ranging from 9i to 12c.
• Worked extensively on diverse platforms covering Solaris, Red Hat Linux, HP-UNIX, IBM AIX, and Windows NT/2000 Server.
• Experience in using backup/recover strategy, designing and implementation using cold backup, hot backup and RMAN methodologies.
• Experience in installing and supporting Oracle RAC- ONE (11g) and RAC (12c, 11g and 1og) with Multi node Cluster on Shared and ASM file system.
• Hands on experience in creating Physical standby databases using DATAGUARD (11g and 10g) for disaster recovery using RMAN.
• Proficient in Oracle Enterprise Manager 13c installation, SQL* Net, SQL * Loader, SQL Navigator, TOAD, Export, Import and SQL*PLUS.
• Experience in providing 24/7 support to Production, Test and development databases comprising of some of the challenging environments.
• Hands on experience in upgrading the databases from 9i and 10g to 11gr2 and from 11g to 12c (12.1.0.2) and solved the issued during and after upgrade and also applied PSU patches.
• Hands on experience in migrating the databases from one server (with same and different endian) using RMAN. Also, used expdp/impdp utilities to migrate the database at schema level.
• Worked on Sysadmin tasks like creating and managing users and their responsibilities.
• Worked on Design and Implementation of Database security, Schema management, Back-up, Restore, Scheduling and Maintenance task in ORACLE.
• In depth knowledge of Oracle internals, Oracle Database Tuning, Usage of SATSPACK, Database Migration, AWR, ADDM, ASH and UNIX native commands.
• Skilled in SQLPLUS, PL/SQL and UNIX shell scripting.
• Also, worked on problem resolution, applied patches, upgraded and migrated Oracle Database.
• Cloning of databases using various methods including create control file, RMAN.
• Handled the large database with size up to 25 TB on different platforms like AIX, RHEL AND HP-UNIX.
• Strong interpersonal and leadership skills worked with users and have tried to resolve their technical issues in the applications and database issues.
• Good communication, organizational and interpersonal skills.

TECHNICAL SKILLS:

Database: Oracle 9i/10g/11g/12c Enterprise/Standard Edition.

Platforms: Sun Solaris, AIX, Red hat Linux, HP-UX 11i, Win2k

Languages: SQL, PL/SQL, UNIX shell scripting, C, C++, XML.

Tools: SQL*PLUS, TOAD, ERWIN, OEM, RMAN, SQL* LOADER, EM Grid Control, Imp/Exp and Data pump, STATSPACK, SQL Developer.

PROFESSIONAL EXPERIENCE:

Confidential, Iowa

Sr. Oracle Database Administrator

• Upgraded database from 11.2.0.1 to 11.2.0.2 and then to 12.1.0.2.
• Worked on creating and supporting Multitenant (CDB and PDB) databases and apply the quarterly PSU patches and setup the database backups using RMAN.
• Migrated the 11g databases from HP-UX to AIX (7.1) using RMAN and upgraded the databases from 11g to 12c running on AIX (7.1) servers
• Applying patches for enhancement and fixing bugs using Opatch.
• Upgraded RAC databases from 11.2.0.3 to 11.2.0.4.
• Used ASMCA to create ASM diskgroups and add disks to ASM diskgroup. Used SRVCTL, CRSCTL utilities to monitor and manage the RAC services.
• Installed and maintained 2 node RAC with ASM and 11g database.
• Installation, creation of 11g, 12c databases for Testing, Development and Production.
• Supported RAC on Oracle 11g using Automatic Storage Management (ASM).
• Worked on Oracle backup and recovery strategy, designing and implementation using cold backup, hot backup and RMAN methodologies.
• Involved in day to day activities like user/table management, performance tuning, backup/recovery database replication for high availability etc.
• Customizing autoconfig templates according to the environment requirements.
• Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration
• Performed cloning of database using RMAN cloning.
• Worked on database backups and disaster recovery strategies using RMAN.
• Closely worked with SQL loader, Export/Import, Data pump for data transfer.
• Created Users, roles, profiles, triggers, procedures, functions, and sequences as per business requirements.
• Create AWR reports to determine any new issues or long running queries on database.
• Deployment of OEM12c for monitoring of database in OEM.
• Applied Regular Security patching on oracle database and interim patching for various bug fixes on database products.
• Refreshed the DEV and QA databases from PRD database BCV and RMAN backups. Also, used datapump (expdp & impdp) utilities to refresh schemas/tables between the env. Knowledge and tested the database refresh using delphix tool.
• Ensured DR servers are in Sync with production environment.

Environment: HP-UX, AIX (7.1), Oracle 10g, 11g & 12c., RAC and ASM.

Confidential, MD

Sr. Oracle Database Administrator

Responsibilities:

• Responsible for installing, supporting the oracle stand alone, RAC(2node), RAC-ONE databases of the version 11g on RHEL 5.8 and Windows 2008.
• Responsible for installing Oracle Enterprise Manger (OEM 12C) and setup email notification and rules of database monitoring alerts.
• Created RAC and RAC-ONE database on ASM file system on SAN storage and on shared file system and supported RAC databases running on ODA.
• Responsible for creating the disk groups and adding disks to diskgroups in ASM filesystem. Also, used v$views and ASMCMD utility to maintain and monitor ASM.
• Have used SCAN LISTENER (new feature in 11g) for load balancing in RAC environment and created services using SRVCTL to connect to RAC preferred instance.
• Worked on installing the data guard on RAC databases for disaster recovery and setup the dataguard broker. Tested the dataguard switchover on the RAC databases manually and using dataguard broker.
• Worked on resolving the gap between primary and standby databases in dataguard by registering the missing archive logs in the standby database.
• Worked on setting up the flashback and restore points on the databases and also flashbacked the databases to restore point when required.
• Applied PSU and CPU patches manually. Worked on installing the Rollover patches for RAC databases.
• Kept tracking the database performance using oracle enterprise manager and checked the users’ sessions which consumes more CPU and taken the necessary steps to reduce the CPU usage.
• Worked on refreshing the tables, schemas using exp & imp and also using expdp & impdp. Also, used datapump utilities for migrating the databases to 11gr2.
• Refreshed and cloned the databases from PROD to UAT, QA, and DEV using RMAN.
• Monitored the databases and added the data files to the tablespaces or resized the tablespaces and monitored the sessions running on the databases.
• Upgraded the databases from 10g to 11gr2 and resolved the issues during and after upgrade.
• Responsible for deploying and monitoring the daily jobs and resolving and finding reasons for failed jobs.
• Perform production system problem analysis and recommend corrective measures in a timely manner.

Environment: Oracle 11g/10g/9i, TOAD, GRID CONTROL(11g,12c), STATSPACK, DATAGUARD, AWR, RHEL(5.8), WEBLOGIC, ASM, PeopleSoft, RAC,RAC-ONE.

Confidential, Florida

Sr. Oracle Database Administrator

Responsibilities:

• Responsible for installing RAC (grid infrastructure 11g), RAC-ONE (11g), standalone databases (11g) on ASM file system on AIX (6.1) and RHEL (5.5) on SAN storage.
• Migrated the databases from NON-ASM to ASM filesystem and on to different server using RMAN backup and recovery and upgraded the databases from 10.2.0.4 and 11.1.0.7 to 11.2.0.3 during migration.
• Used utilities like ASMCMD, ASMCA for monitoring and maintain the ASM file system. Used ASMCA and sql command prompt to alter disks from and to ASM disk groups.
• Have used v$views to monitor the disks rebalancing in ASM filesystem with necessary rebalance power and controlled the rebalancing with rebalance power parameter.
• Worked on scan listener, used SRVCTL to create and maintain the services on RAC-ONE and RAC databases.
• Used utilities like DGMGRL, SRVCTL, CRSCTL, CLUVFY, TOAD, and GRID CONTROL for monitoring and maintain the databases.
• Upgraded the databases from 10.2.0.4 to 11.2.0.2 and from 11.2.0.2 to 11.2.0.3. Resolved the issues during and after upgrade.
• Installed the data guard (11g) for disaster recovery and enabled the dataguard broker. Tested the read only feature (11g) on standby databases, switch over & switch back and failover scenarios using dataguard broker utility DGMGRL and using GRID CONTROL.
• Responsible for scheduling RMAN backups in prod and non-prod environments. Worked with TSM team to find the reasons in case of backup failure.
• Validated the backup before the restore and recovering the databases using RMAN. Restored and recovered (point in time recovery and full recovery) the databases using RMAN when necessary.
• Refreshed the objects, schemas, databases using exp&imp and expdp&impdp utilities. Also used RMAN to refresh the databases from prod to non-prod environments. Have used ASM and NON-ASM filesystem for export and RMAN backup.
• Created the triggers to generate the trace (for oracle SR'S) for sessions causing the performance issues. Debugged the root cause for invalid packages, triggers and views.
• Worked on movement of objects from one tablespace to another and worked partitioning the tables based on range to improve the performance.
• Worked with oracle to resolve the issues caused during the refresh of the materialized views and performance problems after migrating and upgrading the databases to 11g.
• Responsible for creating the databases users and grant the necessary privileges. Created the wallets for batch jobs and tested wallets. Resolved the issues causing the login issues using wallets.

Environment: Oracle 11g/10g/9i, TOAD, GRID CONTROL(11g), STATSPACK, DATAGURD, AWR, IBM-AIX(6.1), RHEL(5.5), WEBLOGIC, STREAMS, ASM, PeopleSoft, RAC,RAC-ONE.

Confidential, BOSTON, MA

Oracle Database Administrator

Responsibilities:

• Administered and maintained Oracle10g, Oracle 11g databases along with 2 node RAC database running on Sun Solaris environments.
• Provide Production environment support and Troubleshoot performance issues.
• Perform database performance monitoring and tuning using OEM Grid to ensure databases run at peak performance. Worked on Performance tuning for optimized results using tools like Explain Plan, SQL*Trace and TKPROF, STATSPACK.
• Created and maintained database objects using TOAD or SQL*Plus.
• Performed Object migration/Code promotion from one database environment to another including production releases either using Datapump utilities.
• Create and Managed user, Indexes, table spaces, datafiles, logfiles as per needed.
• Work on Functions, Procedure, triggers, synonyms and profiles as per needed.
• Provided support for database backup, recovery, load and refresh activities.
• Design and Implement database security by defining roles and privileges.
• Applied Regular Security patching on oracle database and interim patching for various bug fixes on database products.
• Setup 2 node Oracle RAC 11gR2 on Oracle enterprise Linux 6.3.
• Worked with other Team members of the production support group to resolve daily tickets/issues created in their ticketing System.
• Ensured batch jobs and loads completes successfully every day.
• Supported application development through SQL tuning.
• Ensured DR servers are in Sync with production environment.
• Startup/Shutdown database environments as needed.
• Liaised and worked with Oracle support to resolve database issues.

Environment: Sun Solaris 5.10, Linux, Oracle 9i and 11g, SQL plus, Import/Export, Datapump, TOAD, Oracle Grid Control, Oracle RAC, Oracle Dataguard, Automatic Storage Management, Oracle Application Server.

Confidential, Cambridge, MA

Oracle Database Administrator

• Create and Managed user, Indexes, table spaces, datafiles, logfiles as per needed.
• Worked with other Team members of the production support group to resolve daily tickets/issues created in their ticketing System.
• Successfully implemented Physical and Logical standby database using Oracle Data Guard feature for High availability configuration.
• Work on database backups and disaster recovery strategies using RMAN.
• Provided support for database backup, recovery, load and refresh activities
• Applied client patches and other patches as required.
• Provide day-to-day Database support that includes monitoring, troubleshooting, and performance tuning of development, UAT, and production environments.
• Perform server installations, configuration, upgrades, maintenance of Data and Replication servers, contingency testing, implementation and enforcement of the standards, scripting and documenting.
• Provide 24x7 production supports on rotated basis. Environment includes multiple Oracle Servers, distributed database systems, Oracle replication across multiple locations
• Monitors and maintains all production and development databases in a proactive manner to minimize the potential for database outages and performance problems.

Environment: Enterprise Linux, Solaris, Oracle 10g and 11g, SQL plus, TOAD, Oracle Grid Control, Oracle RAC, Oracle Dataguard, Automatic Storage Management.

Confidential, Clinton, MA

Oracle Database Administrator

• Closely worked with SQL loader, Export/Import, Data pump for data transfer.
• Created Users, roles, profiles, triggers, procedures, functions, and sequences as per business requirements.
• Create AWR reports to determine any new issues or long running queries on database.
• Setup 2 node Oracle RAC 11gR2.
• Installation of Oracle 11g/10g on Linux 5.2
• Involved in day to day activities like user/table management, performance tuning, backup/recovery database replication for high availability etc.
• Implemented oracle auditing and create triggers for tracking database changes and improve database security.
• Monitoring the space utilization, monitor and adjust PGA, SGA, Manager users for security.
• Monitor RMAN backups, monitor RAC env, run databases patches and has an expert knowledge on database software and resolving all the production issues.
• Performed sql tuning other database activities like tables/users/indexes creation using TOAD.
• Monitoring and managing Production, Development, Test databases.
• Extensively worked on stored procedures and triggers.
• Worked closely with ASM disk group management and management of ASM users.
• Managing and administrating more than 1TB database with larger partitioned tables.
• Troubleshooting and Tuning of production & RAC databases.
• Troubleshoot Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for optimum performance.
• Closely work with SQL loader, Export/Import, Data pump for data transfer.
• Applied oracle quarterly oracle Cumulative Patch using the latest Opatch utility. Upgraded all servers to the most current Opatch level.
• Created Users, roles, profiles, triggers, procedures, functions, and sequences as per business requirements.
• Created AWR report to tune the instance also used Oracle Enterprise manger to monitor database activities.
• Capacity planning considering future growth with different hardware and software requirements.
• Experience in supporting production databases in a 24x7 environment.

Confidential

Junior Oracle Database Administrator

• Team member in 5-member DBA team, which is supporting development/ testing/ demo instances.
• Installation of Oracle 9i, 8.1.7 Configuration and patches.
• Created the Development, Test and Production databases.
• Have written shell scripts for automation of various database-monitoring activities.
• Database security - this activity includes creating/revoking users. Creating roles, grant/revoke roles from users/roles.
• Extensively involved of the Performance Tuning of Production database which includes identification of Resource consuming / Problematic SQL. Also, tuning at the database level to ensure Optimal Performance of Database. Also, using TKPROF.
• Capacity planning for development, test, Production databases for next six months.
• 24 X 7 Support to the Production database, which includes off-hour support also.