SUMMARY

• Over 7+years of experience as an Oracle Database Administrator having hands on experience in database administration, production support, installation, configuration, upgrades, patches, Performance tuning, backup and recovery, cloning, space management, database security, Auditing.
• 24*7 on - call production database support and maintenance including remote database support.
• Implemented GoldenGate (till latest version) on11g Database RAC database servers.
• Migration of Oracle databases from Linux Boxes to Exadata machine using data guard switchover and Export & Import.
• Configured, managed, and monitored, Exadata hardware.
• Monitored GoldenGate using shell script, 12c GoldenGate plugin
• Have hands on experience on Automatic Storage Management (ASM).
• Excellent experience in Installation and configuration of Oracle 9i, 10g, 11g in UNIX/LINUX environment. Particularly installation of 11g RAC on ASM.
• Planned and implemented DR & high availability solutions using Oracle 10g Standby Database using Oracle Data Guard, 9i and 10g RAC.
• Excellent knowledge in Hot/Cold Backup, Recovery, and Cloning of databases using RMAN.
• Experienced in using 10g features Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring, Recycle Bin.
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF custom scripts troubleshooting oracle databases using sqltrace utilities.
• Experienced in Oracle Support processes for technical requests through Metalink and other Support Procedures.
• Strong ability with UNIX shell scripting to automate tasks and in Crontab and dbms scheduler for scheduling jobs.
• Extensive knowledge of Oracle Architecture, SGA, PGA, Binary structure, Listener TNSNames, SQLNet, V$ and DBA views.
• Good experience in SQL, PL/SQL, Shell Scripting, Perl Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Experience in basic and advanced replication using Oracle Streams and experience in using OEM, TOAD, and Data Migrations using export/import, benchmarking using load testing tools.
• Excellent Written and verbal Communication skills with a customer service oriented attitude.

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2Red Hat Linux RHEL 2.1, 3.x, 4.x and Windows 95/98/ME/NT/2000/2003/XP.

RDBMS: Oracle 11g/10g/9i, Oracle 10g and 11g Real Application Cluster

Languages: SQL, PL/SQL, UNIX Shell

Scripting Tools: RMAN, OEM, SQL*Loader, SQL Server, EXP, IMP, expdp, impdp, TOAD,VB

Tuning Tools: TKPROF, EXPLAIN PLAN, AWR, ADDM,ASH

Web Tools: HTML,XML

PROFESSIONAL EXPERIENCE

Confidential, VA

Sr. Oracle DBA

Responsibilities:

• Installation, configuration, Maintenance and Support of Oracle 11g, 12c Databases as a part new Project implementation.
• Installation and configuration of Oracle Enterprise Manger 12c Grid Control on Linux.
• Pro-Active Monitoring of the Databases using 11g and 12c Enterprise Manager and fixing the issues, also working on Root Cause Analysis and documenting the issue resolution steps for future reference.
• Implemented Golden Gate unidirectional replication on RAC using ACFS file system.
• Implementation of data Purge & Archive strategies for BPM/OLTP systems using Golden Gate.
• Building Oracle Stand by databases, both Active Data guard for real-time replication and normal Data guard for disaster recovery also referred as BCP clone purposes.
• Migration of Oracle databases from Linux Boxes to EXADATA machine using data guard switchover and Export & Import.
• Monitored Golden Gate using 12c Golden Gate Plugin and shell scripts for alerting GG process down alerts.
• Oracle RAC Database/Cluster upgrades from Oracle 11.2.0.2 to 11.2.0.4 on Linux.
• Implemented Oracle Golden gate (both Classic and integrated capture) and Shareplex for replicating data from Primary (OLTP system) to downstream systems such as data warehousing for reporting purposes and history databases for archival purposes.
• Worked on Database Wallet and TDE (Transparent Data Encryption) for encrypting the Sensitive data using column encryption and tablespace encryption.
• Responsible for Backup and recovery of the databases using RMAN Tool (Recovery Manager), and Database Flashback using GRP ( Guaranteed Restore Point ) and Export and Import (Data pump and Normal ) for restoring the specific objects at the database level.
• Implemented archive and Purge strategy for archiving the inactive data and purging the archived data from the primary database as a part of performance improvisation with minimal downtime using online redefinition.
• Responsible for installation of Oracle Cluster ware (CRS) also referred as Grid Infrastructure from 11g and creating the RAC and Standalone databases.
• Migration of databases from Non-ASM (file system also referred as Logical Volumes) to ASM i.e. Automatic Storage Management.
• Applied the Cluster ware (GI), Database (RDBMS) Patches i.e. PSU patches and one-off patches (for Bug resolution) using patch.
• 24X7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Customization and development of K- shell scripts required for monitoring space usage, backup jobs, stats gathering, Golden Gate Process Monitoring etc.
• Cloned and refreshed development and staging databases from production for development and testing.
• Responsible for optimizing Sql queries and tuning the long running queries as a part of performance improvisation.
• Providing the Go-live and Post go-live Support for the database performance related issues and Ensure that all the work is documented for future reference.
• Providing assistance in activities such as knowledge sharing and knowledge transfer.
• Management of schemas, objects partitioning the tables & indexes.
• Worked on Database Character set conversion from Universal Character set (AL32UTF8) to Western European (WE SO8859P1) and Vice-versa.
• Working with Server Admin to resolve the server level issues.

Environment: LINUX, IBM-AIX, Oracle 10G, and 11G, OEM 11G and 12c, UNIX, SQL, Oracle Auditing, Oracle Partitioning, Golden Gate, Shareplex, Physical Standby (Active Data guard, normal standby), Log Miner, Oracle 11gR2 and 10g R2 RAC and Standalone.

Confidential, AZ

Sr. Oracle DBA

Responsibilities:

• Configured, managed, and monitored, Exadata hardware.
• Knowledge on Smart scan and advanced compression of Exadata.
• Installing & Configuring Oracle Clusterware and troubleshooting using cluvfy and handling common issues.
• Ongoing proactive database-level performance tuning, with a good working knowledge of Oracle internals.
• Configured and built Golden Gate Extracts/replicat for multiple databases.
• Implemented High availability using GoldenGate Replication. Implanted Bi-directional replication using GoldenGate.
• Manage Oracle RAC database configurations using GoldenGate and Data Guard to ensure maximum availability and data protection.
• Install, configure and support uni-directional and bi-directional Oracle-to-Oracle replicated environments utilizing GoldenGate
• Provide accurate and complete answers to general use and environment questions in a timely manner.
• Responsible for optimizing the queries and application tuning.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Implement Hot, Cold and Logical backup plans.
• Customization and development of K- shell (Korn Shell) scripts.
• Management of schemas, objects partitioning the tables & indexes.
• Automation of data load using Korn shell scripting and SQL*Loader.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Defining and Implementation of backup and recovery strategies.
• Actively participate in analyzing and evaluating emerging software and hardware technologies/standards.
• Oracle Database monitoring, troubleshoot and resolve the issues.
• Management of schemas, objects partitioning the tables & indexes.
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices
• Providing Go live and post Go- live Support for Database performance related issues.
• Ensure that all the work is documented for future reference.
• Determine time estimates and schedule for own work and resolve issues in timely manner.
• Providing assistance in activities such as knowledge sharing and knowledge transfer.

Environment: IBM AIX 6.1, RedHat Enterprise Linux, EXADATA Oracle 11g, 12c. RAC, OEM 12c, GoldenGate, Data Guard, RMAN, Datapump, Oracle Virtual Private Database, Transparent Data Encryption (TDE).

Confidential, Irving, TX

Oracle DBA

Responsibilities:

• Database Upgrades Using OUI (Oracle Universal Installer) from 10g to 11g.
• Installation of OEM agent (Both for 10g and 11g) and OEM grid (Oracle Enterprise Manager), Monitoring tool for oracle databases.
• Database patching using opatch Perl script.
• Installation, Configuration and Maintenance of RAC (both 10g and 11gr2 (GRID)) and Non-RAC databases including standby databases.
• Implementation of Database Replication using Dataguard (Physical Standby) and Oracle Goldengate.
• Involved in the Disaster Recovery Exercise (DR) and recovered Production Databases with backups from tape (TSM).
• Checking Database Backups periodically and ensuring they were successful, fixing the failed backups.
• Cloned/Refreshed Oracle Databases and Oracle Applications for development and testing.
• Provide accurate and complete answers to general use and environment questions in a timely manner.
• Responsible for optimizing the queries and application tuning.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Implement Hot, Cold and Logical backup plans.
• Customization and development of K- shell (Korn Shell) scripts.
• Management of schemas, objects partitioning the tables & indexes.
• Automation of data load using Korn shell scripting and SQL*Loader.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Defining and Implementation of backup and recovery strategies.
• Actively participate in analyzing and evaluating emerging software and hardware technologies/standards.
• Oracle Database monitoring, troubleshoot and resolve the issues.
• Providing Go live and post Go- live Support for Database performance related issues.
• Ensure that all the work is documented for future reference.
• Determine time estimates and schedule for own work and resolve issues in timely manner.
• Providing assistance in activities such as knowledge sharing and knowledge transfer.

Environment: IBM-AIX Oracle 9i, 10G, and 11G, OEM, UNIX, SQL,TOAD 9.7 /10.6 Oracle Auditing, Oracle Partitioning, Oracle Replication, Hot Standby, Oracle 11g/10g R2 RAC.

Confidential, Houston, TX

Oracle Database Administrator

Responsibilities:

• 24 X 7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Migration oracle databases from windows to Linux.
• Proactive database monitoring using 11g grid monitoring tool.
• Developer Environment Setup, Support, Cloning and Refreshes.
• Performed database cloning to setup test and development database.
• Installation, Configuration and Maintenance of RAC, Stand by database.
• Conducting sizing & capacity planning for Oracle databases.
• Upgrading development and production databases to Oracle 11g.
• Cloned/Refreshed Oracle Databases development and testing.
• Responsible for optimizing the queries and application tuning.
• Perform SQL tuning and assist developers with coding PL/SQL.
• Provided support to Application Database Administrators in designing the database.
• Installed and Implemented Backup & Recovery procedures.
• Used RMAN for backup and recovery. Performed backup validations using RMAN.
• Implement Hot, Cold and Logical backup plans.
• Customization and development of Korn shell scripts.
• Management of schemas, objects partitioning the tables & indexes.
• Automation of data load using Korn shell scripting and SQL*Loader.
• Responsible for setting and managing user accounts, Granting required privileges to users.
• Defining and Implementation of backup and recovery strategies.
• Perform other regular DBA activities including space management and performance monitoring.
• Involved in process improvement, Oracle Server Installations / Upgrades/Patches, Space Management, Capacity Planning, Backup & Recovery, Disaster Recovery, Database Performance Tuning, Memory Tuning, Application Tuning, Security Administration, Data Warehousing, Data Guard, Oracle Advanced Replication, Real Application Clusters, Oracle Standby.
• Oracle Database monitoring, troubleshoot and resolve the issues.
• Management of schemas, objects partitioning the tables & indexes.

Environment: Sun Solaris 5.10, Oracle 9i, 10G, and 11G, OEM, UNIX, SQL, Oracle Auditing, Oracle Partitioning, Oracle Replication, Hot Standby, Oracle 11g/10g R2 RAC.

Confidential

Jr.Oracle DBA

Responsibilities:

• Involved in production support activities 24/7 during on call and resolved database issues.
• Backup scheduled Script creation and Standardization. Performed Database Installation and up gradation.
• Experience in working with cold and hot backups and recoveries.
• Installation and creation of databases.
• Worked on user management mainly on grants, privileges, roles and profiles.
• Designing and developing SQL procedures, query performance tuning.
• Created materialized views, Rebuilding Indexes and partitioned tables and Index organized tables.
• Setting up new development and QA environments and involved in deployments and migration. Cloned databases for development and testing.
• Customized database backups for Disaster Planning and implementation.
• Creating profiles and attaching them with users, performing hot and cold backups.
• Performed database tuning for daily loads and slow response issues by refining queries.
• Used STATSPACK, TKPROF utilities for Tuning and analysis.
• Recovery of database from media failures, dropped accidentally and data block.

Environment: ORACLE, 9i, SQL, PL/SQL, Import/Export, UNIX AIX 5.1, Windows NT.