SUMMARY:

• Oracle certified Professional (OCP - 11g, 9i) DBA with 12yrs of experience in administration of Oracle database, Oracle E-Business Suite and Oracle Enterprise Manager. 6 years of onsite work experience in US.
• Worked as a Production Support DBA providing 24*7 support for environments consisting of mission critical systems accessed by users across the globe.
• Used Oracle Enterprise Manager ( Confidential ) Cloud Control for various activities like monitoring targets such as databases, hosts, EBS environments, setting up alerts, scheduling jobs and automating tasks.
• Oracle streams configuration - Worked on setting up streaming of data between source and target databases, configuring background processes and monitoring the health of data transfer
• Involved in annual disaster recovery drills and successfully recovered mission critical systems using regular backups and Dataguard method. Created and validated database disaster recovery plans for newly created production environments.
• Installed, created and maintained Production, Stage and Dev databases. Performed database upgrades-Versions 8, 9i,10g,11g,12c .Used DBUA tool and manual methods for upgrade
• RAC conversion and maintenance-Worked on converting single instance databases to Real Application Clusters
• Dataguard setup and maintenance- Created Standby databases for disaster recovery and tested recovery scenarios
• Extensively used SQL tuning advisor and other performance analysis tools available in database/ Confidential for detecting performance issues and implementing suggestions
• Involved in Security scans, post scan remediation and documentation for making the databases and applications in compliance with Confidential requirements
• Applied RDBMS and Application patches-Analyzed new PSU and bug fix patches, documented and applied in non-production and production environments
• Extensively used Datapump and export/import utilities for data transfer, schema and database refreshes. Recovered individual objects using Datapump
• Worked on installing, configuring and maintaining Oracle Application Express(APEX)
• Carried out database refresh and setup of Development environments. Worked on refreshing data from production to non-production environments, scrubbing sensitive data and post refresh activities
• Setting up Oracle Golden Gate for data replication for reporting purposes. Worked on adding new objects to replication and monitoring the health of data replication
• Database characterset conversion- Worked on changing the database characterset, used csscan utility for scanning data
• Shell scripting for monitoring critical environments and alerting DBAs, created scripts for automating various maintenance tasks.

TECHNICAL SKILLS:

Databases: Oracle Database 12c, 11g, 10g, 9i, 8, Cassandra Database 2.1.2, Microsoft SQL Server 2005 and 2008

High Availability Architecture: Oracle Real Application Clusters (RAC) - Release 11gR2, Oracle Dataguard 11gR2, VERITAS Cluster

Enterprise Management: Oracle Enterprise Manager Cloud Control & Grid Control - Version 12c,11g,10gR5, 10gR4

Operating Systems: R edhat Linux, Solaris 10, Solaris 9, Solaris 8, IBM AIX 5L, Windows 2003 AS, 2000 Professional, NT, Windows Server 2008, Windows 7, Windows XP

DBA Tools & Utilities: Datapump, Logminer, SQL Loader, SQL Tuning advisor, Tracing & TKPROF, AWR/ASH/ADDM/STATSPACK, AD utilities,APEX,streams,Goldengate Shell Scripting

Front End Tools: Oracle Developer 2000 (Forms 5.0, Reports 3.0), Toad, PL/SQL Developer

Languages: KornShell, SQL, PL/SQL, HTML

Business Domains: Payroll, Telecom, Manufacturing

WORK EXPERIENCE:

Confidential

Tech Lead

Responsibilities:

• Leading a team of 15+DBAs, provided support for implementing change requests in production and non-production environments
• Setup and maintenance of Dataguard/Physical standby databases, Dataguard switchover and failover testing
• RAC conversion and maintenance-Converting single instance databases to Real Application Clusters
• Database upgrades- Worked on upgrading databases (9i to 10g, 10g to 11g, 11g point upgrades). Involved in planning, documentation, execution and post upgrade support.
• Setting up monitoring and alerting in Confidential 12c Cloud Control-Worked on installing agents and adding newly created targets in Confidential
• Applied RDBMS and Application patches-Analyzed new PSU and bug fix patches, documented and applied in non-production and production environments
• Performed RMAN Backup Scheduling, Database restores and recovery-Used RMAN full and incremental backups depending on business requirements
• Worked on RMAN repository upgrade and regular maintenance of catalog database by implementing changes suggested by Oracle
• Extensively used SQL tuning advisor and other performance analysis tools, analyzed and implemented the suggested changes in non-production and production
• Implementing security for Confidential compliance- Fixed the vulnerabilities reported in security scans and documented them
• Creating Shell Scripts for various maintenance activities
• Used Oracle Enterprise Manager( Confidential ) Cloud Control for various database activities like monitoring Target databases & servers, scheduling jobs, performance issues, implementing suggestions, setting up alerts
• Collaborate with infrastructure team members on standard administration tasks as backup and recovery, patching, upgrades, installation, configuration, disaster recovery, meeting performance service level agreements and managing our growing ERP and analytical environments.
• Setting up Oracle Golden Gate for data replication for reporting purposes. Worked on adding new objects to replication and monitoring the health of data replication
• Identifying resources and grooming newly joined DBA resources for support.

Environment: Oracle Database 12c/11g/10g/9i/8i, Cassandra database, RAC, Dataguard, RHEL

Confidential, Portland,OR

Lead DBA

Responsibilities:

• Production Support DBA - Provided 24*7 Support for 120+ instances of Oracle databases and applications
• Setup & Maintenance of 11g Dataguard/Physical standby databases- Involved in validating switchover and failover scenarios and documenting the recovery plans
• Carried out database refresh and setup of Development environments. Worked on refreshing data from production to non-production environments, scrubbing sensitive data and post refresh activities
• Installed, created, upgraded and maintained Production, Acceptance & Development (Version 12c/11g/10g/9i) databases. Worked on adding newly created databases in Confidential to configure monitoring and alerting.
• Resolved Concurrent Managers and concurrent requests problems - Worked on Concurrent manager startup issues and various performance and long running issues reported by users
• Applied RDBMS and Application patches-Worked on applying PSU/one-off patches in database, EBS and Confidential . downloaded, analyzed and applied patches in non-production and production
• Worked on Backup and Recovery-Configured backups using RMAN and custom scripts. Recovered using hot/cold/full and incremental backups. Performed User-Managed recovery, Logical Backups (DP) & Data migration
• Involved in DR drills and successfully recovered mission critical environments. Used RMAN, custom backups and Dataguard for disaster recovery. Created database disaster recovery plans for newly created production environments and validated them.
• Reorganizing database for better space utilization- Worked on reorg to save space and improve the performance. Performed scheduled and on demand purge and re-org
• Oracle streams configuration- Worked on setting up source and target databases, configuring the background processes, adding tables to streaming and monitoring data transfer.
• Install, configuration and administration of Oracle Enterprise Manager Cloud Control-12c.Worked on setting up monitoring, alerting and configuring jobs in Confidential
• Involved in Security scans for reporting the security vulnerabilities, post scan remediation and documentation of fixes applied for Confidential and ISRA compliance
• Created Oracle SRs, worked with Oracle support on high priority issues and issues related to bug fixes. Also opened cases with other third party software vendors.
• Worked on installing, configuring and maintaining Oracle Application Express(APEX)
• Worked on RMAN catalog upgrade and maintaining repository database to improve backup/recovery performance
• Database characterset conversion- Worked on changing the database characterset, used csscan utility for scanning data
• Password maintenance-Changed database passwords every quarter as per recommendation from security team.
• Extensively used Datapump for data transfer, used Datapump export/import for schema and database refreshes. Recovered individual objects using Datapump
• Shell Scripting and CRON job scheduling- Created scripts for monitoring critical environments and also to automate various day-to-day tasks

Environment: Oracle Database 12c/11g/10g/9i/8i, Confidential GC 12c, Confidential 10g,11g

Confidential

Applications DBA

Responsibilities:

• Production Support DBA- Provided 24*7 Support for an environment consisting of multiple instances sized over 10TB.Involved in monitoring of Database, long running jobs, long running form sessions, locking issues and space related issues.
• Performed Production data refresh and setup of Development environments. Worked on annual data refresh from production to non-prod and any Adhoc request
• Troubleshooting concurrent request and manager issues- Worked on issues related to concurrent managers and performance issues like long running concurrent jobs
• Configured Confidential monitoring for databases- Worked on configuring newly created databases in Confidential, setting up monitoring and alerting for critical events
• Involved in RMAN Backup, Database restore and recovery, Duplication/Cloning as per requirement. Used both full and incremental backup strategy. Performed User-Managed recovery, Logical Backups & Data migration.
• Created and maintained Materialized views- Extensively used materialized views to improve the performance of data retrieval queries
• Created and monitored Oracle SRs - Worked with Oracle support on P1(high priority) and general bug fix issues
• Shell Scripts for monitoring mission critical systems- Created and modified shell scripts for monitoring critical databases and alert DBAs when any event was raised.

Environment: Oracle Applications 11i, Oracle Database 9i/10g, Microsoft SQL Server 2005

Confidential

Oracle DBA

Responsibilities:

• Carried out Installation of Oracle Software and created databases. Worked on setting up schemas, user authentication in newly created databases
• Upgraded database from 8i to 9i, used DBUA and export/import methods for upgrade.
• Setting up RMAN repository, database Backup & recovery testing. Also involved in Annual Disaster Recovery drills.
• Performance tuning of the database, SQL queries and the application.
• Refresh non production data from production, data loading using Sql loader, Materialized view creation and refresh
• Configuration of Oracle client,cCreation of users, Tablespaces, Profiles, Roles & granting privileges
• Handling monthly payroll cycle and the Year-End processing of the payroll system
• Monitor alert logs, Confidential and system alerts, acting on them

Environment: Oracle Database 8, 9i, Oracle Forms Reports