SUMMARY

• 6 plus years of experience in Oracle Database Administration, Database Analysis, Design, Development, Implementation and Testing of Relational Database Management systems for Business solutions.
• Good analytical and planning skills.
• Strong verbal and personal communication skills.
• Have worked with global clients while supporting offshore teams.
• Extensive experience in deployments while working with developers
• Provided production system support to customers with critical issues.
• Provided 24x7 critical production support on large databases using Oracle 11g, 10g
• Worked with Oracle 12c cloud control.
• Performed RAC build from scratch.
• Strong experience in supporting development and production databases.
• Have worked on all Windows, AIX, Sun Solaris, HPUX and different flavors of Linux.
• Implemented High Availability solutions with Oracle 10g/11g R2 RAC, Standby Database Data Guard, Replication.
• Good decision making skills.
• Experience in Managing/working with RAC databases
• Upgrade/Migration of Databases from Oracle 9i to 10g and 10g to 11g
• Expertise in Database Space Management, Memory Tuning and Application Tuning.
• Expertise in troubleshooting and performance tuning.
• Experience in Upgrading database instances to 10g R2 to 11g R1 to 11g R2
• Experience in apply PSU patches.
• Worked on different backup methods using RMAN.
• Recovery of Databases (Recovering from Media Failure, recovering tables dropped accidentally, recovering data files, Recovering from Block Corruption etc.).
• Expertise in maintaining Database Security using auditing.
• Working experience in both OLTP, DW and DSS environments
• Extensive Knowledge on Flashback
• Extensive experience in Data Guard physical standby databases
• Good knowledge on partitions and clustering of tables
• Worked with different performance utilities like Statspack, ASH, AWR, ADDM, ORADEBUG, HANGANALYZE etc. to troubleshoot performance issues.
• Extensive experience with designing and implementing Oracle databases, cloning of databases and setting up RAC database
• Worked with several Multi node and multi - tier environments.
• Excellent experience in writing SQL
• Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN
• Good working knowledge in tuning the oracle databases.
• Strong knowledge of Oracle Dynamic Views and Dictionary Tables
• Working knowledge on PL/SQL.
• Used TOAD and ERWIN.
• Extensive knowledge on Oracle Support processes for technical requests with oracle support

TECHNICAL SKILLS

Operating Systems: HP-UX, AIX, Windows, Linux, SUN Solaris

Languages: SQL, PL/SQL, BASH shell.

Oracle Tools: TOAD, RMAN, OEM, TOAD, SQL*Loader, DATAPUMP, Export/Import

Hardware/Storage: HP MSA 5000, EMC, VERITAS Net Backup, Tivoli Storage Manager

Tuning Tools: TKPROOF, EXPLAIN PLAN, STATSPACK

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

Oracle Database Administrator

Responsibilities:

• Configured ASM
• Worked with different teams
• Provided 24/7 Production support.
• Worked on Migration projects.
• Operating systems on clustered/shared HP-UX UNIX, Linux and Windows servers
• Configuration of Oracle Data guard in Oracle 10g environment, using 11g/12c Grid Control.
• Migration of Oracle database 10g to 11R2.
• Migration includes the migration from Windows to Linux using Transportable tablespaces.
• Use of AWR and Statspack tools to diagnose performance issues with Oracle Application
• Provided Automated Storage Management (ASM) technical assessment document.
• Worked on SQL Server 2005 and SQL Server 2008
• Configuration and troubleshooting of Oracle Agents connections to Oracles OEM Grid Control.
• Daily use of Oracle Grid Control.
• All work completely documented.
• Perform daily database administration as required.
• Applied CPU/PSU Patches
• Troubleshoot networking issues.
• Worked on SQL Server Log shipping issues.
• Resolved Data Guard Gaps.
• Worked with different teams to achieve results.
• Setup alerts via cloud control.

Confidential, Bellevue, WA

Oracle Production Database Support

Responsibilities:

• Build and supported RAC
• Build Data Guard Servers
• Configured ASM
• Worked with different teams
• Provided 24/7 Production support.
• Worked on projects.
• Migration
• Automating
• Upgradations.
• Setting up new database environment.
• Build Oracle DBA in the Database Management Services group (DMS), which supports and maintains the database infrastructure
• Worked on project to move from standalone servers to RAC
• Build physical Standby Data Guard.
• Practiced DR by performing switchover and failover using data broker.
• Supporting Production and Development databases in 24x7 Environments
• Database environments Installation, upgradation, Migration, Patching, Maintaining of all Oracle versions 8i, 9i, 10g and Oracle 11r2 and
• Operating systems on clustered/shared HP-UX UNIX, Linux and Windows servers
• 200 corporate databases in production, acceptance, development and training environments.
• Work in conjunction with application DBAs to develop and maintain the application database.
• Configuration of Oracle Data guard in Oracle 10g environment, using 11g/12c Grid Control.
• Migration of Oracle database 10g to 11R2.
• Configuration and testing of RMAN, with implementation to production.
• Migration includes the migration from Windows to Linux using Transportable tablespaces.
• Provided test plan documentation for uni-directional GoldenGate.
• Performance tuning and reorganization of Oracle Financials database.
• Use of AWR and Statspack tools to diagnose performance issues with Oracle Application
• Provided Automated Storage Management (ASM) technical assessment document.
• Extensive experience with RAID and ASM configuration.
• Administered ASM from command line and grid control.
• Upgrade of ASM from Oracle 11.2.0.2 to Oracle 11.2.0.3
• Responsible for the creation of the ASM Operation(s) Manual and Quick Reference documentation for use of other team members.
• Automation of Oracle Restart Configuration for the instances under the ASM configuration, part of the Oracle High Availability Services configuration.
• Configuration and installation of VM Ware in Oracle 10g and Oracle 11gR2 environment.
• Worked on SQL Server 2005 and SQL Server 2008
• Configuration and troubleshooting of Oracle Agents connections to Oracles OEM Grid Control.
• Daily use of Oracle Grid Control.
• Installation and configuration of Oracle 10gR1, 10gR2, 11016, 11R2 on HP Itanium HP-UX UNIX servers.
• All work completely documented.
• Perform daily database administration as required.

Confidential, Chicago IL

Oracle DBA

Responsibilities:

• Provided 24/7 support.
• Worked on Clustered databases.
• Installed standalone Databases.
• Helped other teams with client installation.
• Installed databases using scripts
• Worked with oracle on ongoing issues.
• Configured Flash Recovery area.
• Written shell scripts.
• Applied patches.
• Worked with developers
• Supporting Production and Development databases in 24x7 Environments.
• Tuning by Statspack/AWR collecting various hourly Snapshots statistics and differentiating
• Creating Tar with oracle support for Internal Errors Ora-600/7445.
• Refresh of development/test/QA databases from Production backup using Data pumps.
• Proactively Monitoring alerts, assigning to right queues, resolving in time based on SLA.
• Identifying issues and resolutions, providing feedback to other team members, and offering any information uncovered throughout daily operations that could benefit other team members.
• Written RMAN shell scripts to purge out old archive logs and backups.
• Creating Performance Reports using AWR and ADDM
• Cloning and managing Duplicate/Standby on databases using RMAN.
• Recovering the databases using RMAN. Scheduling and managing cron Jobs.
• Managing Physical structure of Oracle database like Data files, Redo log files, Control files.
• Monitoring the growth of Tablespaces and taking proper actions
• Doing Trend Analysis of Database for future need of space and capacity planning on disks.
• Maintaining security and integrity of database systems.
• Monitoring and maintaining database availability and resources.
• Planning and managing database backup and recovery.
• Taking Backups of databases using Logical (Export & Import) and Physical (Offline and Online) backups.
• Managing User Level Control Access with Roles and profiles.
• Installing, maintaining and monitoring the database software products, including technical advice and support to the applications Development and Maintenance staffs if required.
• Expertise in performance monitoring and performance tuning
• Defining and Setting backup and recovery procedures, Configuration of backup.
• Tuning the database using statspack and custom scripts
• Refresh/Cloning of Database for development and testing purpose.
• Involved in Upgrade/Migration of the oracle databases from Oracle 10g to Oracle 11g.
• Worked with Standby Database (Data Guard) setup and configuration using data broker.
• Used EXPDP & IMPDP to take backup at database level or tablespace level and also to accomplish table level and full database de-fragmentation.
• Provided DBA and programming support for all internal and client based Oracle implementations.

Environment: Oracle 8i/9i/10g/11g, RAC, Toad for Oracle v.9.0.1.8 PL/SQL, Oracle SQL Developer, Data Pump, SQL*Loader, Windows/RHEL.