PROFILE:

• Oracle APPS DBA, Oracle Core DBA, SQL Optimization, Instance Tuning, Oracle RAC, Golden Gate, Proactive DB Monitoring.
• BigData DBs - EXADATA, Cassandra, MySQL, Hadoop Administration.
• Troubleshooting and fixing DB Instance's IO, Memory, Load and Concurrency issues.
• Tuning DB with Oracle Wait Interface and Oracle CPU statistics
• Identify issues with Long Running JOBs/Queries and share with developers and fixes needed to tune the query/JOB.

TECHNICAL SKILLS:

Operating Systems: Linux, Unix.

Replication Tools: Golden Gate, SHAREPLEX,FAST READER

PROJECT EXPERIENCE:

Oracle Apps DBA

Confidential, Chicago

Responsibilities:

• R12 ERP support, Patching, DB upgrades, DB tuning
• Exadata Migration & Support
• Cassandra, Hadoop, MySQL database Administration.
• Participating in weekly meetings and Status reporting to clients
• Planning, Coordinating, Managing and executing various projects and services
• Participating in periodical business meetings
• Appraising the performance of subordinates and recommending pay hikes and promotions
• Determining the resource requirements and hiring the required resources for the project
• Providing strategic and tactical direction to the team
• Defining responsibilities, estimating efforts, monitoring the progress of work and reviewing deliverables
• Establishing & managing the processes for Issue Management, Change Management and Quality Management.
• Training and Mentoring team members.
• Tracking and mitigating the risks.

Technology: Oracle 10G, 11G, Linux, Sun Solaris, Unix, Java, Oracle Apps EXADATA, Cassandra, MySQL, Hadoop

Confidential, Chicago, IL

Project Leader - Oracle DBA

Responsibilities:

• Business Continuity Planning and Disaster Recovery
• Golden Gate Implementation and Administration in TTSL Billing and CRM systems
• Responsible for seeking data ware housing solutions for TTSL and dealt with various CDC tools (Golden Gate, SharePlex, Oracle Streams/ODI) and data extraction tool FAST Reader.
• RAC database Installations & Maintenance, DB Upgrades & patch applying.
• Responsible for the Administration, Analysis, Design and implementation of Oracle database systems under Unix platforms.
• Responsible for system monitoring and troubleshooting, capacity planning and performance tuning, aid application modifications, implementing application upgrades and enhancements.

Technology:Oracle 9i,10G Sun Solaris 5.8, Unix, Linux

Confidential, Carlsbad, CA

Oracle DBA

Responsibilities:

• Environment setup form the new application
• Database maintenance.
• Oracle Streams used to synch INDPROD and USAPROD databases
• Replication of remote sites using materialized views.
• Monitoring the Production Databases using GRID control.

Technology: Oracle 10G, Linus, Unix

Confidential

Team Member - Oracle DBA

Responsibilities:

• Installed and Configured Web based Oracle Enterprise Manager on Linux (Oracle 10G)
• Responsible for system monitoring and troubleshooting and performance tuning, aid application modifications, implementing application upgrades and enhancements.
• Cloned many Production databases on other unix servers as part of Restore/recovery backup validation.
• Managing users and security management, database space management, planning growth and addition of new systems to the enterprise.
• Have written Unix Shell scripts to aid database creation, database cold and hot backups, triggering e-mails to the DBA group on critical database errors and status of the database. These scripts aid as a sample for the other members of the DBA group for subsequent setup of the databases under various releases of Oracle.
• Recovery Manager Configuration and Backup Recovery scripts for Recovery and Restore using RMAN.
• Extensive experience in restore/recovery using hot backup and RMAN backup.

Technology: Oracle 10G, Linus, Unix

Confidential

Team Leader - Oracle DBA

Responsibilities:

• Responsible for the Administration, Analysis, Design and implementation of Oracle database systems under Unix and Novell platforms.
• Responsible for system monitoring and troubleshooting, capacity planning and performance tuning, aid application modifications, implementing application upgrades and enhancements.
• Extensive experience in the technical project management of Complex database migration/upgrades and installations.
• Project Management

Technology:Oracle 8i/9i, Sun Solaris 5.8, Unix

Confidential

Backup Project Leader - Oracle DBA

Responsibilities:

• Responsible for system monitoring and troubleshooting and performance tuning, aid application modifications, implementing application upgrades and enhancements.
• Managing users and security management, database space management, planning growth and addition of new systems to the enterprise.
• Recovery Manager Configuration and Backup Recovery scripts for Recovery and Restore using RMAN.
• Extensive experience in restore/recovery using hot backup and RMAN backup.

Technology: Oracle 8i/9i, Sun Solaris 5.8, Unix

Confidential

Module Leader

Responsibilities:

• IBM Script to Generate Reports
• Bug fixing
• Coding and testing for maintenance and enhancement
• User Documentation

Technology: IBM Mainframe, VS COBOL II, DB2, CICS, JCL, VSAM

Tools: IBM utilities, ENDEVOR, FILE-AID, CA-Intertest