SUMMARY:

• Worked as Oracle DBA   team   lead   managing a team of 3 database administrators.
• Database Administrator with over 17 years of IT industry experience.
• 16 years as Oracle DBA (11g, 10g, 9i, 8i, 8.x, 7.x).
• 4 years as Oracle Applications Database Administrator (11.0.3, 11.5.3, 11.5.5).
• Administered very large databases (The largest being 10 Terabytes).
• Administered 1.0.2, 9.0.2, 9.0.3 and 10g (10.1.2.2) versions of Oracle Application Server.
• Administered Oracle Databases on UNIX and Windows environments.
• Administrator for Oracle Financial Services Application (4.5.x), Oracle Express 6.3.4.
• Install, configured and administered 9i RAC Databases.
• Implemented Oracle Names Server and Oracle Transparent Gateways.
• Implemented backup and complex recovery procedures.
• Setup databases to use ASM.
• Proficient in Oracle architecture, installation, configuration and database maintenance.
• Proficient in Oracle Database migration (7.x ? 8i / 8.x ? 8i/ 8i ? 9i/9i - 10g/10g -11g).
• Proficient in UNIX shell scripting.
• Excellent Oracle tuning skill and proficient in Oracle Data Dictionary.
• DBA support of multiple production, development, and test environments.
• Superior analytical and communication skills.
• Can respond quickly to a variety of requests and problems requiring wide experience with Oracle.
• Conducted training and support for database administration personnel.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle DBA

Responisiblities:

• Tune database for optimal performance
• Provide assistance to development team when required
• Design appropriate partition strategies to improve code performance
• Review AWR reports to identify issues proactively
• Automate data transfer from production to test environments

Confidential

Oracle DBA Team Lead

• Tuned databases and application to handle 10000 concurrent users after Hurricane Katrina.
• Ensured uptime and SLA compliance for numerous databases.
• Managed the daily tasks of a team of database administrators.
• Helped design Disaster recovery procedure for the client.
• Currently involved in designing Oracle application server upgrade roadmap for the client.
• Part of the team that setup ELA (Electronic Loan Application) application for the client.
• Created database refresh procedures for reporting requirements.
• Upgraded databases from 9i to 10g for the client.
• Upgraded databases from 10g to 11g for the client.
• Was involved in the upgrade of Oracle application server to 10g.
• Provided project management support when required.
• Mentored and trained staff members in addition to scheduling hands-on training to increase knowledge.
• Worked closely with developers to design database structures and ensure objects are created efficiently.

Confidential

Senior Oracle DBA

• Database administrator for VLDB
• Installed and configured 9i RAC on Solaris 10 using VERITAS cluster
• Tuned databases for optimal performance ( Extensively tuned   SQL  statements )
• Installed and configured OID
• Provided on call support and off hour support.
• Created procedures and documentation for numerous database activities.
• Troubleshooting issues with Informatica   running   on oracle databases.
• Installed and configure 10g (10.2.0.1) databases and extensively used 10G new features.
• Upgraded databases   from  9i to 10G
• Setup databases to use ASM

Confidential

Senior  Oracle DBA

• Provided primary DBA support for production databases and numerous testing/development systems
• Coordinating with offshore DBAs, providing them the required information for the required transition
• Provide on call support and create procedures and documenting the current system
• Create monitoring infrastructure (OEM) and providing other enhancements like Oracle Names Server
• Successfully transitioned the database administration and maintenance to off-shore team in a very short   period

Capital One

Senior Oracle DBA

• Maintained Oracle Parallel Server databases.
• Hardware and software requirement analysis for numerous database systems based on application and user requirements.
• Tuning very large databases for quick response time.
• Maintained 99% uptime for all databases.
• Participated in disaster recovery for production systems.
• Migrated databases to 9.x
• Assisted Developers in tuning SQL and acquiring skills with Oracle. Identify worst performing SQL statements and tuned for better performance.
• Provided on call support for over 120 production databases totaling 40 Terabytes.

Confidential

Oracle DBA 

• Proficient in Oracle RDBMS installation, upgrade and implementation.
• Installed and configured Oracle 9i for third party applications.
• Migrated Oracle 7.3.4 to Oracle 8.0.5,  Oracle 8.0.5.x to 8.1.6.x and Oracle 8I to Oracle 9i
• Authored generic shell scripts to provide customized Hot Backup solution for the client.
• Setting up Oracle Recovery Manager (RMAN) to provide the bank with a comprehensive backup and restore strategy. This backup method is also being tested for DR implementation.
• Setup databases monitoring and alerts through Oracle Enterprise Manager and shell scripts.
• Provided DBA support for MIS databases, Reporting databases and various other databases running third-party applications such as Comfort-Corona, Exim Bills, Tickmark, NEON and SWIFT.
• Identified worst performing SQLs and rewrite, index or otherwise tune for high performance. Extensively used Explain Plans for SQL statement tuning.
• Expertise with Oracle Transparent Gateway (OTG).
• Designed and implemented batch process using Oracle HS to download data from DB2 and UDB.
• Installed and configured OTG for DRDA 4.0.1 and 8.0.4 on AIX using SNA to access DB2 6.1 on MVS.
• Installed and configured OTG for DRDA 8.0.4 on AIX using TCP/IP to access UDB 7.2 on AIX.
• Installed and configured OTG 10G for DRDA on AIX using TCP/IP to access UDB 7.2 on AIX.
• Implemented Oracle Names Server.
• Designed and implemented encrypted password security for automated batch programs and OLTP.
• Provided primary DBA support for Oracle APPS (Financials) databases.
• Installed Oracle APPS Software 11i using Rapid Install.
• Migrated Oracle Applications from 11.0.3 to 11.5.3.
• Migrated Oracle Applications from 11.5.3 to 11.5.5.
• Applied various patches for Oracle Applications as a bug fix and preventive as well.
• Performed administrative tasks such as forms recompiling, reports regeneration, recreating synonyms, granting privileges, recompiling database #LF objects, activating new modules within the database and the applications etc. using ADADMIN, ADAIMGR, ADPATCH, ADSPLICE and Rapid Install.
• Troubleshoot Forms, Reports, Concurrent Manager and JINITIATOR issues.
• Tune the APPS database using Analyze such that both Concurrent processes and Discoverer reports have an optimal performance.
• Provided DBA support for Oracle Financial Services Applications (OFSA) database.
• Installed OFSA  4.5.20  (Balance and Control, Performance Analyzer modules)
• Upgraded OFSA from  4.5.20  to 4.5.34 and from 4.5.34 to 4.5.36 (Balance and Control, Performance Analyzer, Budgeting and Planning modules)
• Installed Oracle Express 6.3.4 and Oracle Financial Analyzer (OFA) 6.4 (Super DB, User DB)
• Integrated OFA, Oracle Express with 9iAS  (1.0.2.2)
• Supported various major production implementations including European   operations merger, Bank merger,   HR and Payable modules implementation.
• Expertise with the Oracle 9i Application Server
• Worked with 1.0.2, 9.0.2 and 9.0.3 versions of 9iAS.
• Configured 9iAS Components like Web Cache and OC4J Instances
• Tuned various server options, oc4j options and data source properties to improve performance.
• Extensive exposure to command line utilities of 9iAS such as   DCMCTL and EMCTL  .
• Coordinate and ensure a smooth SDLC for each project with proper documentation including operating and maintenance instructions.
• Monitor databases? and nodes? performance daily for production and non-production environment.
• Monitor security exceptions on all the databases and report as per the Bank?s security policy.
• Troubleshoot and resolve batch job failures and end-users? issues such as database connectivity.
• Determine system requirements and provide design for new databases based on application and user specifications.
• Production database restore to non-production environments for performance and QA testing.
• Assist Developers in tuning SQL and acquiring skills with Oracle.
• Setup and carryout periodical backup of non-production environments.

Confidential

Oracle DBA

Production support DBA for 6 Production Databases and numerous testing / development systems. #LF Database administrator for one of the largest databases at Sprint (CRM Database: Size 1700 MB). Did administered multiple Decision support systems and OLTP systems including web applications.   Was the   Oracle   team lead   for various projects. Created strategies for data replication. Involved in mentoring junior database administrators and was responsible for maintaining project schedule. Created migration plans taking in account the database size and availability.