PROFESSIONAL SUMMARY

• Accomplished IT Professional with 16 years of experience in the areas of Oracle Database Administration, Oracle Applications (E - Business) Administration, Project Planning and Operations management.
• Have worked with some of the fortune 200 companies and Federal agencies and possess a broad based experience with expertise in Oracle Database management
• Oracle Applications Administration (Release 11i and R12), IT infrastructure management and Project Support.
• Other strengths include planning and implementation coupled with solid documentation, communication, presentation and decision-making skills and a strong desire and aptitude to learn new technologies. I am certified PMP and ITIL Expert

PROFESSIONAL EXPERIENCE

Confidential

Sr. DBA (Team Lead)

Responsibilities:

• Managed mission critical Oracle Applications (30+ based on OAS and Oracle E Business 11i and R12), Oracle Databases (40+ production, 200+ non-production), UNIX (100+ Physical and Virtual servers) and 60+ TB of SAN Storage environment.
• Managed production databases from Version 9i, 10g to 11gR2 and upgraded Databases from 10g to 11gR2.
• Supported several key projects like Conversion of Accounts Payables Application to E-Business, Oracle E-Business CRM upgrade from R11i to R12, SAN Upgrade, Consolidation & Migration, and Implementation of Oracle Web logic Middle Tier for new Benefit Calculation Application, etc.
• Implemented Oracle Enterprise Manager to monitor the database and the application server environment
• Implemented Oracle Data Guard for replication from Production to COOP site
• Installed OID and SSO and integrated Oracle applications to enable Single Sign On
• Performed proof of concept with installation of 2 node oracle RAC 10g
• Supported Bi-annual COOP exercises for last 5 years, with the success rate of database failover of 100% and application failover of greater than 95%
• Supported the Application Development Projects throughout the SDLC by taking part in design reviews, change lifecycle and transition of application releases in production
• Developed a comprehensive technical disaster recovery plan for Oracle databases and applications.
• Provided incident escalation support, Problem Resolution, Root Cause Analysis Activities, Risk Management, Change Review and Management and Security Compliance Activities
• Mitigated the audit findings, resulting in 80% reduction of high and 60% reduction of low findings
• Worked with the team in proposal writing and developing LOE (Level of Efforts) for new work orders
• Meticulously involved in tuning the year-end activity & processes and server upgrade
• Supported the Oracle SOA Suite (BPEL) upgrade project
• Supported the Technology Refresh & Implementation Project consisting several phases to migrate the mission critical databases to the new database server and application server middle tier to the virtual server environment on VMware and Red Hat Linux
• Recognized by the customer for providing excellent service and received “Award of Excellence” for project support

Confidential

Sr DBA

Responsibilities:

• Responsible for supporting the E-Business R11i upgrade project.
• Maintained Oracle Apps 11i (11.5.10.2) for Development, Integration and Training Instances with multi-tier configuration (DB Server, Report Server, Load Balanced Form Server)
• Maintained 10gR2 Database on Solaris platform including patching, backup etc.
• Performed several clones from Production environment for Integration Testing and development during PPS Application Testing
• Prepared Deployment Guide for Production implementation and performed deployment of codes to Integration Instances

Confidential

Sr. DBA

Responsibilities:

• Supported the Development Database for the LIMS system.
• Maintained Oracle Databases in the development environment.
• Tuned SQL, PL/SQL code, performed performance and load testing.
• Supported deployment of the LIMS system on the customer site.

Confidential

Sr. DBA

Responsibilities:

• Maintained and supported the Production and Non-Production Oracle Application ( Financials), HR applications and Oracle databases for portfolio of 25+ HR applications
• Provided 24*7 support for the applications and databases
• Implemented monitoring solution based on Oracle Enterprise Manager and Tivoli to provide the end to end monitoring of the environment
• Design and Implementation of Disaster recovery solution for the Application and critical HR databases
• Served as the DBA team lead for major relocation of corporate data center.
• Worked on getting the Databases and application Sarbanes Oxley (SOX) compliant.
• Install, patch and maintained oracle applications 11.5.10 environment.
• Provided production support for all the managed instances including weekly 24*7 pager support on rotation basis.
• Performed core DBA tasks of tuning of Data Warehouse and Oracle Applications 11i database, backup and recovery solutions and day-to-day database and oracle application 11i administration for more then 40+ Production/Dev databases.
• Troubleshoot problems with concurrent managers, Apache, Jserv processes, and database performance.
• Clone Oracle applications 11i instances for patch testing.
• Implemented Dataguard as a disaster recovery solution.
• Troubleshot Shareplex related issues for replication between oracle applications and financial data warehouse.
• Implemented ASM (Automatic Storage Management) for Oracle Data Warehouse.
• Implemented table partitioning in data warehouse.
• DBA Team lead for merger integration between Confidential Chase and BankOne for Oracle applications and data warehouse application.
• Implemented RMAN backup with Veritas Net Backup for multiple databases
• Demonstrated continuous improvement in delivery of day-to-day service and projects.
• Played a key role in architecture review and RFP process for strategic data center migration.
• Proposed, planned and implemented shared database services by consolidating servers and databases in a server farm.
• Effective coordination and communication with proactively following all the issues and resolving them.
• Configured Oracle Enterprise Manager (OEM) for enterprise-wide database event monitoring and performance tuning.
• Developed and implemented the disaster recovery plans and published it, resulting in a foolproof recovery of critical applications.
• Involved in server and environments consolidation plans to reduce operating cost.
• Produced consolidated monthly report for management for the entire managed infrastructure.

Confidential

Database Architect

Responsibilities:

• Supported database upgrade project. Was responsible for upgrading the clinical trial databases from version 8i and 9i to 10g and performance tuning of the databases and also supporting the load tests
• Supported E-Business implementation project, responsibilities included cloning, patching and tuning the E-business environment. Planned and performance the Load and Stress test for the E-business project.
• Installed Oracle Enterprise manager to manage and monitor 75+ server and database environment. The successful implementation of the project led to winning of several new task orders for Confidential .
• Standardized database environments with fully documented procedures. Implemented backup and recovery Solution. Recommended and Implemented solution for Disaster recovery using Oracle Standby databases.
• Led the data conversion project to migrate data from legacy data sources to a single database

TECHNICAL SKILLS

Oracle Databases: Oracle 11g, 10g, 9.x, 8.x and 7.x, Oracle RAC

Oracle Applications: Oracle E-Business R11i and R12

Oracle Application Server: Oracle Application Server 10g, Oracle SOA Suite (OID/SSO/BPEL) and Weblogic

Languages: SQL, PL/SQL and Shell Scripting

Other Oracle Technologies: Oracle RAC, Shareplex, Oracle Data Guard, RMAN, Oracle Streams & Oracle Configuration Management

Monitoring Tools: Oracle Enterprise Manager, HP Site Scope, HP BAM, BMC Patrol, Tivoli, Quest Spotlight, Toad & DB Artisan

Hardware Platforms: Sun M8000 Servers, HP 9000 and 8400 Series, Sun 6500 and E 10K, IBM P550 and P570 Servers, Veritas Clusture Servers

Operating Systems: HP-UX 11.11, Solaris 8, 9, 10, Red Hat Linux 5.0, AIX & Windows

Change Management Tools: HP Service Manager, Kintana and PVCS

Microsoft Technologies: Microsoft Project, Office and SharePoint

Collaboration Tools: Microsoft SharePoint, Clear Quest, Quick Place and Lotus Sametime

Others: BCV, Hitachi SI Copy and Winbind