SUMMARY

• Technically proficient DBA with more than 5 years’ experience in facilitating database and application tuning, interface for application testing and coding to integrate upgraded applications into the production environment.
• Able to manage the Oracle software and hardware configuration for Business Systems applications employed on Oracle Parallel Servers to improve efficiency, productivity, and profitability.
• Skilled in various Oracle database Environment to provide architecture design and implementation of all production database replication, upgrade, backup and contingency recovery strategies for all database management systems to ensure their optimum performance.
• Managing 11+ TB Oracle 10g & 11g databases in Data warehousing environment.
• Providing 24x7 oracle database support for multiple business units.
• Highly proficient in performance Tuning, Sql tuning
• Implementing high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems.
• Highly experience in Dataguard configuration for disaster recovery.
• Highly experienced in Oracle 11g, 10g Automatic Storage Management (ASM) required to fulfil the storage needs.
• Proficient in Golden Gate installation, configuration, and application for data replication in the Oracle database environment 11g and 12c.
• Proficient with Database Cloning, Migration, and Patching of Oracle Databases.
• Skilled in RMAN Backups, Hot and cold Backups and Logical Backups.
• Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
• Applying security patches (Patch set, Critical Patch Updates (CPU), Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “Opatch”.
• Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
• Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
• Extensive knowledge in UNIX platforms includes HP, SOLARIS, AIX, and LINUX.
• Knowledge in configuring ASM (Automatic Storage Management)
• UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.
• UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.

TECHNICAL SKILLS

• Skilled in RMAN Backups, Hot and cold Backups and Logical Backups.
• Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
• Applying security patches (Patch set, Critical Patch Updates (CPU), Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “Opatch”.
• Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
• Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
• Extensive knowledge in UNIX platforms includes HP, SOLARIS, AIX, and LINUX.
• Knowledge in configuring ASM (Automatic Storage Management)
• UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.

EXPERIENCE

Confidential,Bloomington, IL

Oracle Database Administrator

• Managed all aspects of Oracle database administration, physical and logical database design, documentation, maintenance and backups.
• Planned and implemented system-wide upgrade of all Oracle databases from 10g to 11g and to 12c as part of performance improvement by utilizing the new features.
• Applied Database (RDBMS) Patches that is PSU patches and one-off patches (for Bug resolution) using Opatch.
• Setup Goldengate 12c Integrated Capture on Exadata Servers for replication purposes from OLTP system to downstream systems.
• Troubleshoot Database Performance issues using OEM, AWR, ASH, TKPROF 10046 traces etc.
• Tune application using CBO, SqlTrace, Tkprof, Explain Plan, Statspack, AWR and ASH/ADDM.
• Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• Responsible for setup and implementation of 2 Node RAC on Linux in 10g and 11g R2.
• Troubleshooting ORACLE RAC issues using ORACLE cluster ware and Database logs.
• Implemented ASM on RAC and stand-alone databases.
• Sizing the SGA, database buffers, shared SQL area, log buffer based on the requirements.

Environment: Oracle 10g, 11g, 12C, Unix shell script, Grid Control, DataGuard, IBM AIX, Sun Solaris, Oracle Linux, SQL*Plus, Toad, Various 10g and 11g Advisories, AWR and Statspack Reports, EXPDP/IMPDP, EXP/IMP, PL/SQL, RMAN, Crontab, Tivoli Storage Management for DB tape backups, BMC Patrol for DB monitoring.

Oracle Database Administrator

• Provided technical support for multiple databases on production, development, test and staging purposes on Sun Solaris and Windows environments.
• Responsible for developing PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.
• Installed Oracle 11g on Linux platform using ASM.
• RMAN point in time recovery and Instance recovery done on 11g.
• Efficiently performed installation, setup and creation of four node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.
• Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.
• Successful installation/maintenance of Physical Standby database using Oracle DataGuard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases
• Assist in SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping unnecessary indices, using hints wherever possible, amongst others.
• Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.

Environment: Oracle 11g/11g RAC/9i, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.