SUMMARY:

• Oracle Database Administration on 24x7 critical production and large databases using Oracle 12c RAC, 11g RAC, 10g, 9i.
• Implementation of High Availability solutions with Oracle 10g RAC, 11g RAC, Standby Database Data Guard for large financial applications.
• Installing and configuring ASM for the RAC storage implementation.
• Installations of Oracle 11g RAC, 10g RAC, 9i, 8i on Sun Solaris/Red Hat Linux, Oracle Enterprise Linux/HP - UX/IBM-AIX/Windows platforms and creating databases.
• Cloning database from production to test and development.
• Experience in Patching the Oracle Software and Databases.
• Upgrade/Migration of databases from Oracle 10g to 11g, 11g to 12c .
• Experience working with Export/Import, Data pump.
• Install and configure Oracle GoldenGate
• Debugging GG issues such as abend
• Good knowledge of Syntax of various Extract, Data Pump, Replicat Parameters
• Backup of Databases (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup, RMAN incremental backups.)
• Recovery of Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.).
• Experience with system analysis, design and Data Modeling.
• Experience providing 24X7 on-call support to maintain all Databases up and running in Production environment.
• Performance tuning using STATSPACK, TKPROF, SQL Trace, Explain Plan, AWR, ADDM.
• Knowledge on Oracle Support processes for technical requests with Metalink.
• Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies. Strong interpersonal and communication skills in dealing with customers.

TECHNICAL SKILLS:

Databases:: Oracle 9i/10g RAC/11g RAC, 12c SQL Server 2005/2008R2, DB2

Operating Systems: : Red Hat Linux 5.x, 6.X,7.x Sun Solaris 9, 10,, HP-UX 10.x, 11.xIBM-AIX 5.1, 5.2, 5.3, Oracle Enterprise Linux, Windows

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

Oracle Tools:: RMAN, ASM, OEM Grid Control, TOAD, GoldenGate

Hardware/Storage:: HP9500, Pure, NetBackup

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

Sr. Oracle DBA

Responsibilities:

• Primary DBA for one of the busiest Databases of CMS (Centers for Medicare and Medicaid Services, formerly HCFA ).
• Resolve Incident Ticket via Service Manager.
• Oncall support every two months for a week.
• More than ten DBs on 4 nodes Exadata.
• Several RAC clusters, Stand alone and Data Guard.
• Upgrade to 12c from 11g.
• Rebuild RAC cluster from the scratch.
• Recovery and restore - Flashback and RMAN.
• Quarterly patching and one off patching.
• OEM 13c
• Cloning.

Sr. Oracle Database Administrator

Responsibilities:

• Support for Oracle, SQL Server and DB2 and Golden Gate.
• Migration of Oracle Database
• Implementing SOX Audit.
• Golden Gate replication and troubleshooting.
• Installing RAC, Grid Infrastructure and Oracle 12C on Linux 7.
• Apply patch and upgrade version.
• Fixing RMAN backup issues.
• Data Pump
• Restore database from backup.
• Golden Gate setup and trouble shoot.
• SQL query tuning optimization. Performance tuning using tools such as SQL TRACE, STATSPACK, EXPLAIN PLAN, AWR, ADDM, ASH report.
• Provide day-to-day databases support for users & application teams. Implementing database backup & restorations
• Implemented new features of Oracle 11g like Automatic Memory Management, Automatic SQL Tuning, AWR Baseline Enhancements, Case Sensitive Passwords, Data Recovery Advisor, Database Replay, Query Result Cache, Read-Only Tables, Secure Files, SQL Access Advisor, SQL Performance Analyzer, and SQL Plan Management, Statistics Collection Enhancements, Table Compression Enhancements, Tablespace Encryption, Tablespace Enhancements to the Dev/TST/PROD environments successfully.
• Installed and Configured 4 Node 11gR2 RAC on Red Hat Linux 5 platform and added 2 Node to make it a 6 Node RAC.
• Installed 11g Physical Data Guard in Maximum Performance Mode. Verify the Redo Generation, Redo Transfer and Redo Apply Services between the primary and standby database. Performed the Switchover, Switchback and Failure tests of the primary and physical standby and verified the successful catching up of standby with the primary DB.
• Installation, setup and configuration of physical Standby Database using Active data Data Guard.
• Setup DEV/TEST/UAT/QA environments from Production database using Snap mirror and RMAN.
• Installed & Configured Oracle 11g Grid Control for monitoring over 200 Prod / Non Prod Hosts.
• De-fragmentation/Reorganizing of database using Export/Import, Rebuild Index and move table.
• Used Materialized Views (snapshots) for replication of data.
• Experience in migrating large databases up to three TB
• Cloning/Duplicating production databases using scripts as well as RMAN.
• UNIX shell scripting in csh, ksh to be controlled from Crontab.
• Troubleshoot 11g RAC Database Performance Tuning issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM). Tuned database for optimum performance.
• Installed 12c grid infrastructure, 12c Oracle software, 12c database and 13c EM
• Provide primary DBA support for establishing, upgrading and maintaining the RDBMS software environments.
• Rendering 24*7 on call production DBA support

Environnent: Oracle 11g, OEM (Grid Control), Oracle Data guard, GoldenGate, ASM, RAC, Unix Shell scripting, RMAN, Datapump, Import Export, TOAD, AIX, HP-UX, Sun Solaris and Red Hat.

EBS Resource

Responsibilities:

• Migration of EBS R 12.1.2 as is from HP data center to GM’s data center
• Migration from physical prod to preprod (VM) then preprod to prod(VM)
• Cloning apps tier from legacy on to two nodes VM
• Configuring Loadbalancer
• Configuring SSL
• Installing Report server AS 10.1.2.0.2

Oracle Database Administrator

Responsibilities:

• Installations of Oracle 11g RAC, 10g RAC, 9i, on Oracle Enterprise Linux/HP-UX/IBM-AIX/Windows platforms and creating databases.
• Table Partitioning, Creating Locally managed Table spaces.
• Experience in Database Administration activities such as installation, database creation, sizing, backup and recovery, performance tuning and capacity planning
• Extensive experience Real application Clusters (RAC), ASM, RMAN, Data Guard and maintain Standby database.
• Applying patches for upgrade and bug fix.
• Golden gate replication.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Involved in Upgrading of the oracle databases from 9i to 10g, 9i, 10g to 11g.
• Logical backup using Datapump and Import/export.
• Refreshing/cloning databases using RMAN.
• Responsible for continuous database monitoring and reorganization for ensuring performance.
• Partitioning large objects to improve the performance and manageability.
• Proactive monitoring of databases and applying RDBMS patches, security patches.
• Logical and physical Data Modeling.
• Installation, configuration and administration of GoldenGate Replication.

Environment: Oracle 10g/11g, IBM AIX, SQL, TOAD, OEM, SQL Loader, RMAN, Statspack, Data Guard, ASM, Share plex, Shell Scripts, Grid Control, AWR, ADDM, Oracle 10g RAC

DBA/Developer

Responsibilities:

• 24x7 Oracle Production Database Administrations.
• Managing, troubleshooting and resolving oracle database and applications issues.
• Refresh/Cloning of Database and applications for development and testing purpose.
• Working alongside programmers and contributing to the development process.
• Planning and recommendations for optimum performance.
• Extraction of data from flat files into Oracle Database using SQL*Loader.
• Defining and Setting backup and recovery procedures.
• Responsible for SQL query tuning optimization. Performance tuning using tools such as SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF
• Developing Hot, cold and logical backup scripts to automate the backup procedures.
• Tuning and balancing I/O by monitoring file system and tablespace I/O statistics.
• Monitoring and managing the Storage Usage by Resizing Older Tablespaces, Creation of New Tablespaces and relocation of data files for better Disk I/O.
• Cloning Oracle databases from Production to Development, Test
• Refreshing/cloning databases using RMAN.

Environnent: Oracle 11g RAC/10g RAC/9i/8i, OEM (Grid Control), Oracle Data guard, ASM, RAC, PL/SQL, Unix Shell scripting, RMAN, Datapump, TOAD, Spotlight, SQL*Loader, Import Export, AIX, HP-UX, and Red Hat.

Service Desk

Responsibilities:

• Diagnose, troubleshoot and resolve a wide range of software, hardware and network issues
• Provide technical support for 3800 of diverse users nationally
• Handle an average of 10 calls per day
• Prioritize and escalate issues where required.
• Install, configure and modify hardware and softwareto ensure optimal performance
• Plan and lead training sessions for new and existing user.
• Monitor, log and track all phases of helpdesk support.

Environment: Windows 2000, 2008, NT