SUMMARY:

• Over FOURTEEN years of IT experience this includes TWELVE years as an Oracle DBA and Oracle APPS 11i/R12 DBA. Production DBA Experience on Oracle releases 11g/10g/9i/8i. Experience installing, maintaining and administering Oracle EBS 11i (11.5.8, 11.5.9, 11.5.10, R12) instances.
• Experience in Installation and Configuration of Oracle RAC (11g/10g) on ASM. Installation, Configuration of Oracle databases (8i/9i/10g/11g), backup and recovery, performance tuning. Experience in Database backups and recoveries using conventional Hot & Cold backups and RMAN.
• Experience in Maintenance, Patching, Cloning, troubleshooting and Performance tuning of Oracle EBS. Proficient in Oracle EBS SYSADMIN activities, Concurrent Manager troubleshooting.
• Experience using ADPATCH, ADADMIN, ADCTRL, ADRELINK, ADIDENT, ADMERGE, ADCONFIG, ADMRGPCH, ADLICMGR tools in Oracle EBS environments. Implementation of HA solutions Physical and Logical Standby Databases (Data Guard).
• Experience in Replication using Golden Gate, Materialized views, Advanced replication. Experience managing databases on Exadata systems X4, X3. Experience managing the databases using OEM Grid Control (12c/11g/10g).
• Proficient in Database Up gradation and Migration, Upgraded Databases from Oracle 8i to 9i, 9i to 10g & 10g to 11g. Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM.
• Experience in UNIX shell scripts writing to monitor and maintain the database and Oracle EBS databases. Excellent experience in OLTP/DSS database systems, implementing and managing large Oracle databases.
• Excellent team - player, excellent interpersonal, written and verbal communication skills. Strong desire & aptitude to learn new technologies and ability to work effectively under pressure.

TECHNICAL SKILLS:

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

RAC: Oracle 11g/10g.

Oracle EBusiness Suite: R12/R11i.

Operating Platforms: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, IBM, Red Hat Linux, RHEL 2.1, 3.x, 4.x and Windows 95/98/NT/2000/XP.

Storage: ASM.

Database Monitoring Tools: OEM Cloud control/Grid control /11g, Sal Developer, TOAD.

Database Backup Tools: Recovery Manager (RMAN), command line tools.

Database tuning Tools: AWR, ADDM, ASH, Explain Plan, TKPROF.

Languages: SQL, PL/SQL, UNIX Shell Scripting.

PROFESSIONAL EXPERIENCE:

Confidential, McLean, VA

Responsibilities:

• Manage and Maintain data in all production and non-production databases and replication servers. Work with project teams to identify database changes needed. Manage database elements, including creation, alteration, and deletion and copying of schemas, databases.
• Perform backup and recovery and configure database parameters. Monitor database and replication servers for resource utilization. Handle testing, reporting, backup/restore, security and access requirements. Supporting 50+ databases in Production, test and development environments.
• Refresh/Cloning of Database and applications for development and testing purpose. Performing Backup & Restore of all the Oracle databases using RMAN. Apply Oracle Patches (CPU & PSU) on the Compliance databases.
• Performance Tuning using AWR, Explain-Plan, SQL-Trace, TKPROF reports. Scheduled jobs through Oracle JOB SCHEDULAR and UNIX Cron. Set up Active Data guard Configurations in multiple environments. Installed and configured 2 node RAC on HP-UX and Linux platform.
• Monitor databases on Exadata X4 systems. Administer Plug-ins to monitor the Exadata Storage Cells and other components in the Database Machine. Installation and setup of OEM grid control 11g and 12c.

Environment: Oracle 10g/11g, 11g RAC (2 node), Data guard, HP-UX, Exadata, Golden gate, RMAN, OEM Grid Control 11g, AGILE, OFSAA.

Confidential, Minneapolis, MN

Responsibilities:

• Production DBA support for Confidential B2B applications. Administered 2 Node 11g RAC databases on Linux. Cloned/Refreshed databases from production to test and development environments. Supported application deployment and implement changes in Production and test environments.
• Maintain physical database definitions and standard database access routines. Provide Physical Database Administration and Approve or reject all database changes. Setup OEM Grid Control (11g) to monitor and manage all the databases.
• Performance Monitoring and Tuning of Oracle Databases using OEM Grid Control, database tuning, SQL TRACE, TKPROF, Explain Plan, STATSPACK, AWR and ADDM. Applied PSU patches to the Oracle databases. Oracle Apps R12/R11i database administration on Linux.

Environment: Oracle 10g RAC (2 Node), Linux, RMAN, OEM Grid Control 11g/12c, MySQL, Apache Tomcat.

Confidential

Responsibilities:

• Project DBA and Apps DBA Support for Confidential IT applications. Administered Oracle Database and Oracle Apps R12 instances on HP-UX environments. Setup Golden gate unidirectional replication on multiple databases.
• Oracle Applications and Database cloning using RMAN and Rapid clone tools. Administered Concurrent manager and troubleshoot concurrent requests related issues. Applied AD patches on Oracle Apps instances. Upgraded Oracle E-business suit to 11.5.10.2 & R12 (12.0.x & 12.1.x).
• Manage and apply changes on middle and database tier using autoconfig. Upgrade of 10g CRS to 11g Grid infrastructure, Upgrade of 10g databases to 11g. Migration of databases using data pump and transportable table spaces method.
• Performance tuning of database, Oracle EBS, concurrent manager.

Environment: Oracle Apps 11i/R12, Oracle 10g/11g, HP-UX, Golden gate Replication, RMAN, HP Data Protector.

Confidential

Responsibilities:

• Production Support DBA for Wal-Mart ASDA (UK), SamsClub (US & Canada) applications. Administered 10g RAC instances on Sun Solaris environments. Administered Physical Standby and Logical Standby databases on PROD, DEV environments.
• Applied CPU and PSU patches on RAC instances. Executed DR (Disaster recovery) operations including failover and switchover. Performance tuned database, Slow running batch jobs and SQL statements. Performed backup, restore and recovery operations.
• Configured and Managed all the databases in OEM 10g Grid Control.

Environment: Oracle 10g RAC (4 Node), 4 Node RAC standby (physical), Logical Standby, RMAN, OEM grid Control 10g, Data guard, Disaster Recovery.

Confidential, Irving, TX

Responsibilities:

• Lead Oracle DBA support for Confidential IT applications. Managed Single Instance and Oracle EBS instances on Sun Solaris environments. Oracle Database and Oracle Applications cloning using RMAN restore rapid clone and autoconfig.
• Managed Logical Standby and physical databases on multiple environments. Analyzing and applying Application patches using ADPATCH and Database patches using OPATCH. Applied Quarterly patches on Databases and Enhancement, bug fix patches on Oracle Apps instances.
• Implemented Oracle Backup and recovery procedures in RMAN. Compiling APPS Schema, Forms, Menus and Libraries using ADADMIN.
• Performed Oracle Apps Sysadmin tasks like Creating Users, Assigning Responsibilities, Profile Setup, Registering Printers, Scheduling Concurrent Requests and Monitoring Concurrent Managers. Upgraded database instances from Oracle 10g to 11g instances.
• Troubleshoot Database performance issues and resolution.

Environment: Oracle 10g/11g, Oracle Apps 11i, Sun Solaris 5.8/5.9, Physical Standby database, Replication, Logical Standby database, RMAN, OEM Grid Control 10g.

Confidential, Winston-Salem, NC

Responsibilities:

• Production DBA support for GMAC Claims Applications (Siebel CRM). Managed Primary and Logical Standby environments in Production, UAT, Dev environments. Implement and maintain database security (create and maintain users and roles, assign privileges).
• Performed database tuning and performance monitoring. Performed application tuning and performance monitoring. Setup and maintain documentation and standards. Interface with Oracle Corporation for technical support. Performance tuned Siebel generated SQL statements.
• Applied Quarterly patches to production and test databases. Upgraded 40+ databases from 9i to 10.2.0.4 versions on Solaris environments. Backup, Restore and Recovery of the databases.

Environment: Oracle 9i/10g, Sun Solaris 5.8/5.9,Siebel CRM, Logical Standby database, OEM Grid Control 10g, VERITAS Cluster, CRON Scripts, TSM, TOAD.

Confidential

Responsibilities:

• Lead a team of 5 Oracle DBAs to provide production DBA support for BP IT databases. Managed 10+Primary and physical standby databases in Sun Solaris 5.8 environments. Upgraded Multiple Oracle 9i (9.2.0.4) databases to Oracle 10g versions.
• Coordinated with Application team to implement code releases and performance tuning. RMAN Backup and Recovery of the databases and Database refreshes. Create physical standby databases in production and test environments.
• Database performance tuning and SQL tuning on multiple environments.

Environment: Oracle 9i, Sun Solaris 5.8, Physical Standby, RMAN, Disaster Recovery, TOAD.

Confidential

Oracle Apps DBA India

Responsibilities:

• Production Apps DBA Support for Oracle Applications (11i, 11.5.9) Databases on HP-UX. Managed Oracle EBS Applications and Databases to Ensure 24 x 7 availability. Scheduled concurrent programs and troubleshoot issues with concurrent requests.
• Applied multiple Application patches using ADPATCH and database patches using OPATCH. Creation of user accounts and assigning responsibilities define profiles and profile setup. Manage and troubleshoot Oracle Apps components like Apache/Forms.
• Cloning of Oracle Apps instances and Cold backup of the database and apps. Using tools like FNDCPASS to change Passwords of APPS and SYSADMIN. Resolve Performance issues of Oracle Apps and database including environment slowness.

Environment: Oracle Apps 11i (11.5.9), Oracle 9i, HP-UX, Oracle Enterprise Manager, TSM.

Confidential

Oracle DBA

Responsibilities:

• Onsite Production DBA support for Confidential - SBI/ Confidential -Countrywide Applications at Confidential Location. Managed 20+ Oracle 8i/9i databases on IBM AIX and Windows environments. Applied Quarterly patches to databases on UNIX and service packs to databases on Windows.
• Upgraded multiple databases from Oracle 8i to 9i on UNIX and Windows. Scheduled backups in UNIX crontab and verified the daily backups. Executed database refreshes and troubleshoot database performance issues. Managed physical standby databases and fixed sync issues.

Environment: Oracle 8i, IBM-AIX, Windows, Oracle Parallel Server (OPS), Physical Standby, CRON.

Confidential

Web Developer

Responsibilities:

• Developed Webpages using ASP, HTML, JavaScript, test and deployment. Developed Application modules in Visual Basic, test and deployment.

Environment: Visual Basic 6.0, ASP, HTML, JavaScript, MS Access.