SUMMARY

• 10 Years of diversified experience in Oracle Database and Apps Administration in various environments.
• Extensive Database Administration in SuSE Linux, SUN SOLARIS, IBM - AIX and Windows NT/2000 and HP-UX.
• Provided 24x7 Production Support for Oracle 11g/10g/9i RAC and standalone databases on various platforms.
• Proficient in all DBA responsibilities such as Installation, Configuration, Upgrades, Patches, Performance Tuning, Backup (Cold and Hot), Recovery, Cloning, Space management, Database Security, Auditing, Troubleshooting, Database Design, SR support, Unix Shell Scripting and Documentation.
• Implement Oracle Enterprise Manager Cloud/Grid Control (OEM 12c/11g/10g) for centralized monitoring and administration.
• Planned and implemented high availability solutions using Oracle 11g/10g RAC.
• Standby Database creation and configuration using Oracle Data Guard and set up real time Replication using Golden Gate.
• Adept in Oracle performance tuning using Automatic Database Diagnostics Monitor (ADDM), Automated Workload Repository (AWR), Active Session History (ASH), Statspack, TKPROF and EXPLAIN PLAN.
• Support Oracle E-Business Suite applications developed using Oracle Forms and Reports.
• Cloning/Patching of E-Business Suite Application and Database Tier.
• Database Security management using Fine Grained Auditing (FGA).
• Solid exposure to Software Development Life Cycle.
• Experience in SQL, PL/SQL, Data Modeling, Logical and Physical database design.
• Proactive monitoring and performance tuning of databases including Table/Index partitioning and creating/using materialized views.
• Experience in User Management (Synonyms, Privileges, Roles, Quotas, Table Partitioning, Indexes, and Sequences), Space Management (Tablespaces, Rollback Segments) and Monitoring (Alert logs, Memory, Disk I/O, CPU, Network activity).
• Configuration of Oracle Streams for replication between two databases.
• Experience in managing 15 TB VLDB including OLTP and OLAP.
• Expertise in working with File Systems, RAW Devices, Volume groups and Shared Storage for creating large databases including ASM.
• Experience in Data Migration using Oracle Data Pump, Export/Import, SQL*Loader.
• Design and Document backup and disaster recovery plans for critical databases using conventional HOT, COLD and RMAN backups.
• Experience in using Oracle Managed Files and Optimal Flexible Architecture (OFA).
• Experience in working with Oracle Customer Support using Metalink to resolve critical issues.
• Demonstrated ability to identify root causes of problems, considering both long-term and short-term impact of proposed solutions. Strong interpersonal and analytical skills.
• Ability to manage multiple project tasks with changing priorities and tight deadlines.

TECHNICAL SKILLS

Operating Systems: SuSE Enterprise Linux 11/10/9, Sun Solaris 10, AIX 6.1/5.x, RHEL 2.1/3.x/ 4.x/5.x, HP-UX 11.31.

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

Programming Languages: SQL, PL/SQL, C, Perl, Shell Scripting.

Tools: RMAN, OEM 12c/11g/10g GRID, SQL*Loader, EXP, IMP, EXPDP, IMPDP, ERwin, TOAD, F-Secure, PuTTY, SCP, GoldenGate.

Tuning Tools: TKPROF, EXPLAIN PLAN, Statspack, ADDM, AWR, ASH.

Data Modeling: ERwin 4.0, ER Studio.

Reporting Tools: Business Objects XI R3/R4.

Backup Tools: EMC Networker, NetApp, Veritas NetBackup, TSM.

Web Tools: HTML, XML, PHP.

PROFESSIONAL EXPERIENCE

Confidential, Herndon, VA

Senior Oracle DBA

Responsibilities:

• Upgrade databases from 4/11203.
• Supported Multi-Terabyte databases in Dev/Test/Prod environments.
• Follow SDLC and Change Management process to deploy code.
• Assisted developers in Tuning Issues with slow queries.
• Experience in Partitioning - Table/Index Management.
• Co-ordinate Application downtime for Host/Database upgrade as part of Tech Refresh Project.
• Monitor and Manage databases using OEM 11g/12c; Configure proactive metric/threshold alerts to prevent issues.
• Apply CPU/PSU Patches in scheduled maintenance windows.
• Maintain and Support 11gR2 RAC/Standalone databases in Prod/QA/Dev environments.
• Maintain and support standby and DR environments using Oracle Data Guard.
• Configure and implement Backups using RMAN for newly created databases and monitor scheduled daily/weekly backup jobs.
• Install Oracle 11gR2 software; Create/Configure/Maintain new DBs.
• Physical Data Modeling and generate DDL scripts for Database deployment.
• Working with Oracle Metalink support to resolve issues through SR’s.
• Database/Schema level Refresh using Data Pump.
• Shell scripting to automate Schema level Refresh process.

Confidential, Wilmington, DE

Senior Oracle DBA

Responsibilities:

• 24/7 On call Production support for 100+ databases on rotational basis.
• Manage 15TB Data Warehouse environment.
• Install, Configure and Maintain OEM 12c Cloud Control.
• Experience in Partition Management including Tables, Indexes (Bitmap and B Tree) and Materialized Views.
• Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
• Migrating databases to Oracle Exadata Database Machine.
• Analyzing database performance and tuning database on Oracle Exadata using Real Application Testing (RAT)
• Maintain and Support 11gR2 RAC in Prod/QA environments.
• Install CPU/PSU Patches during scheduled maintenance windows.
• Performance Tuning to resolve and improve query performance of Production jobs/reports.
• Re-evaluate and update existing Statistics gathering jobs.
• Configure proactive metric/threshold alerts on OEM to prevent issues.
• Worked closely with developers/business users in identifying issues and resolving them.
• Configure and implement Backups using RMAN and monitor scheduled backup jobs.
• Experience with Oracle Metalink support to resolve issues through SR’s.
• Monitor and Configure databases using 11g OEM/Grid Control.
• Assisted developers in tuning the SQL code to improve query performance using ADDM, ASH reports and Explain Plan.
• Storage management at OS level and database level using ASM.

Confidential, Pittsburgh, PA

Senior Oracle DBA

Responsibilities:

• Install, configure and support Oracle 11gR2 RAC databases on RHEL 5.x and Windows 2008.
• Upgrade 10gR2 databases to 11gR2 with minimal downtime.
• Upgrade legacy 9i databases to 11gR2 including platform migration.
• Backup configuration and monitoring using RMAN.
• Plan, Schedule, co-ordinate weekend maintenance activities to install CPU Patches.
• Worked with Oracle Metalink support to resolve issues.
• Monitor databases using 11g OEM/Grid Control.
• Assisted developers in tuning the SQL code to improve query performance using ADDM, ASH reports and Explain Plan.
• Provided 24/7 Production Support.

Confidential, Columbus, OH

Senior Oracle DBA

Responsibilities:

• Install, Configure and Build 11202 databases on new servers.
• Assist application developers/Architects in Requirements gathering, database design and Capacity Planning.
• Upgrade RAC and Standalone databases to 11202 from lower versions.
• 24/7 on-call support with rotational schedule.
• Database/Schema level Data migration using Oracle Datapump.
• Resolve issues using ticketing systems with varying SLA agreements.
• Configure daily RMAN backup jobs and monitor reports for completion.
• Experience with Oracle Metalink in raising service requests.
• File system management using RAW disks and ASM.
• Performance tuning of databases using ADDM, AWR reports, Explain plan.
• Configure Hot and Cold RMAN backups.
• Setup and Maintain Oracle GoldenGate for Replication.
• Experience working with OLTP and OLAP databases.
• Create/Configure Stand by databases using Active Dataguard.
• Monitor database and file system growth/trending using scheduled reports through OEM.
• Configure Grid Control for monitoring all Databases and corresponding targets like Listener, ASM instances and Application Servers/ Middleware.

Confidential, Winston Salem, NC

Oracle Database Administrator

Responsibilities:

• 24x7 Production Support with on call rotation.
• Install, Configure, Maintain and Monitor databases using Oracle 11g/10g RAC with ASM as storage medium.
• Upgrade databases from 10gR2 to 11gR2.
• Refresh Development and Test databases using Production databases in both OLTP and OLAP environments.
• Duplicate/Clone databases using RMAN.
• Upgrade OEM 10g Grid Control to 11g including Repository Upgrade.
• Refresh Oracle E-Business Suite development/test databases using Production including the Application Tier.
• Apply latest CPU patches on Dev/Test/Prod databases on scheduled maintenance windows working closely with business users.
• Refresh databases using RMAN Transportable Tablespace feature.
• Monitor Sql Server 2005/2008 databases.
• Proactive monitoring of Backups, Hardware, OS performance.
• Enable Auditing to monitor user activity.
• Implement Backup and Recovery techniques using RMAN.
• User/Schema management tasks like Create users, grant/revoke roles, privileges.
• Export/Import Schemas using Datapump.
• Tablespace, datafile space management, file systems, SAN maintenance.
• Capacity planning for new databases and future growth of existing databases.
• Performance tuning using ADDM, ASH, Explain Plan, TKProf.
• Shell scripting to automate jobs, purge log files.
• Install SuSE Linux Enterprise Server 10/11.
• Advised developers in rewriting code to achieve efficient and optimal utilization of resources.

Confidential, Albany, NY

Oracle DBA

Responsibilities:

• Overall maintenance of ORACLE database, performance tuning, backup and recoveries and other database administration activities.
• Creation of users, roles, profiles, and security management.
• Scheduling and monitoring timely Backups.
• Proactive monitoring of database for growth and performance.
• Monitoring of database objects like rollback segments, temp segments, undo segments and tablespaces.
• Diagnose and troubleshoot Database problems and failures.
• Plan, Prepare, Establish and Document Backup and Recovery strategies using Hot/Cold/RMAN backups.
• Cloning of databases.
• Involved in the Database Design (Logical and Physical).
• Administering Oracle database running on UNIX and Windows Machines.
• Installation of Oracle 10g/9i on UNIX and Windows platforms and Creation of databases.
• Configured OEM 10g Grid for centralized monitoring and administration of databases.
• Storage and space management including table spaces and data files.
• Constantly monitor the performance (V$ Dynamic Performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Monitor and resolve database fragmentation issues.
• Tuning databases using ADDM, AWR, ASH, SQL Trace, TKPROF, EXPLAIN PLAN.
• Monitoring growth of tables and undertaking necessary re-organization of database as and when required.
• Export/Import databases using Data Pump.
• Performed database Refresh activities.

Confidential, Austin, TX

Oracle DBA

Responsibilities:

• 24x7 production support for several mission critical systems which utilize multiple Oracle databases.
• Performed database cloning to setup test and development databases.
• Installation, Configuration and Maintenance of RAC, Stand by database.
• Upgrading databases to Oracle 10g from Oracle 9i.
• Applied patches to Oracle database products.
• Responsible for optimizing the queries and application tuning.
• Perform SQL tuning using Explain Plan and SQL Tuning Advisor, ADDM, AWR and assist developers with coding PL/SQL.
• Provided support to Application Database Administrators in designing the database.
• Installed and Implemented Backup and Recovery procedures.
• Implemented Hot, Cold, Logical (Data Pump, Export/Import) and RMAN backups.
• Performed block recovery and backup validations using RMAN.
• Experience in using VERITAS Netbackup.
• Customization and development of shell scripts.
• Refreshed databases according to the requirements.

Confidential, Melville, NY

Oracle DBA

Responsibilities:

• 24 X 7 Production database administration support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Database Refresh from production to Development/Testing as per requirements.
• Experienced in performance tuning at Instance level (SGA and PGA) and database level.
• Analysis on database design and functionality.
• Creation and maintenance of Databases and Database objects.
• User management like creation of users, roles, and privileges; granting and revoking rights.
• Review and Execute scripts on production and staging environment.
• Implemented Logical and Physical data modeling.
• Worked on the projects related to the data warehouse design and implementation.
• Database Export/Import, Hot, Cold and RMAN Backups and evaluating the Backup and Recovery Procedures periodically.
• Analyzing and monitoring the system performance and tune accordingly.
• Planning for storage spaces requirements and placing them for optimum I/O performance.
• Cloned databases.
• Conducted multiple “dry runs” (test runs) to gather timings for production upgrades.
• Security management using Auditing.
• Setting up and configuring Stand by database (Data Guard).
• Experience in using SQL*Loader.