SUMMARY

• An Oracle DBA professional having 7+ years of experience in Development and Production environments involving Oracle 9i/10g/11g/11gR2 and RAC and IBM DB2.
• Involved in different scenarios of OLTP as well as DSS (Data warehouse) databases.
• Installation, configuration maintenance of Oracle 10g, 11g, Standby Databases (Data Guard).
• Extensively performed database administration tasks: installation, configuration, upgrades, patches, migration, backup and recovery, Space management, database security, Golden Gate, performance tuning and cloning on Oracle 8i, 9i, 10gand 11gR2 on large scale database environments and mission critical large OLTP and OLAP systems.
• Hands - on experience with RAC Cluster ware configuration, administration and patching, RAC Backup and recovery.
• More than 5 years of experience in migrating and upgrading databases of different versions of Oracle (8i, 9i, 10g, 11g) and in different environments.
• Very good experience in doing cross platform migrations using RMAN and Transportable table spaces.
• Proactive Monitoring, identifying areas that need to be improved in the application and database using Stats pack, AWR, ADDM and OEM Grid Monitoring.
• Experience in using OEM, TOAD, and Database Migrations using transportable table spaces, transportable database, benchmarking using load testing tools.
• Extensive performance tuning activities like Operating System Tuning, SQL Tuning, and Database/Instance Tuning.
• As a Golden Gate DBA, I am defining and developing software for tasks associated with the developing, debugging or designing of software applications or operating systems
• Experience in a variety of hardware and software platforms including Unix/Linux, Sun Solaris, HP-UX & AIX, MS-Windows 2000,2003 and RHEL
• Outstanding knowledge and hands on experience in Oracle 10g/11g RAC implementation & administration (Oracle Cluster ware setup and configuration, RAC installation using ASM, Grid installation).
• Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, AWR, and SQL TRACE.
• Hands on experience using Oracle Enterprise Manager (OEM), SQL*PLUS, TOAD and Grid Controlling using OEM
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
• Hot/Cold Backup and Recovery and Cloning of databases using RMAN with VERITAS Net Backup.
• Experience in writing Shell scripts to backup, restore database and automate daily activities.
• Complete range of Oracle DBA activities including day-to-day production database monitoring includes alert log, trace file, and achieve files, Troubleshooting production issues and Performance Tuning issues.
• Specify, design and implement modest changes to existing software architecture to meet changing needs. Oracle Golden Gate (OGG) provides a complete solution in high availability, real-time data integration, transactional change data capture, data replication, transformations, and verification.
• Performed code reviews and implemented bestPythonprogramming practicesand experience in writing test scripts, test cases, test specifications and test coverage.
• Strong experience in Data warehouse concepts, ETL and good knowledge on logical and physical Data Modeling using normalizing Techniques.
• Created Tables, Views, Constraints, Index (B Tree, Bitmap and Function Based).
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Expertise in Dynamic SQL, Collections and Exception handling. Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Troubleshooting production issues, Performance Tuning, Physical Database design, Table Space Administration and managing Data Dictionary objects. Extensive SQL and PL/SQL skills
• Skilled in reducing the SQL query time by monitoring queries on TOAD and removing deadlocks.
• Created and modified Database objects such as Tables, Indexes, Views, Sequences, Functions, Procedures, Triggers, Stored Procedures, and Packages.
• Experienced in providing 24/7 support for database systems including performance monitoring, performance tuning, troubleshooting and client support.

TECHINICAL SKILLS

Databases: Oracle 11g R2 RAC, 10gR2RAC, IBM DB2

Operating Systems: HP-UX, Sun Solaris, AIX, Linux and Windows, IBM DB2, Informix on IBM.

Languages: SQL, PL/SQL, Java, C, UNIX Shell Scripting.

Tools: RMAN, OEM, SQL*Loader, EXP, IMP, Data Pump, Erwin, TOAD, DB

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM, OEM Grid Control

ETL Tools: Informatics 5.1, Data pump.

Data Modeling: Erwin Modelling

Other: Oracle Golden Gate

PROFESSIONAL EXPERIENCE

Confidential, Sacramento, CA

Sr. Oracle DBA

Responsibilities:

• Installation and maintenance of Oracle 11g Data Guard (Active).
• Plan Golden Gate setup to achieve Unidirectional replication
• Data Guard using physical standby database, implement log miner, Data guard / Standby both physical and logical standby perform switchover/failover and monitor using Data Guard manager command line and GUI.
• Setup GoldenGate Database User with necessary privileges
• Upgrading databases to Oracle 11g and 11gR2 from Oracle 10g.
• Provided backup/recovery, problem diagnosis, performance tuning, data reorganization, and database upgrade.
• Oracle 10g, 11g (R1 and R2) installation on all major UNIX flavored operating system like RHEL, Oracle Unbreakable Linux (OUL), and WINDOWS server 2000, and 2003.
• Installed Oracle 10g, 11g RAC database on Red Hat Linux.
• Installation, Configuration and Maintenance of Oracle RDBMS Software.
• Experience in applying critical patches and patch sets whenever required.
• Applying patches both Server side and Client side.
• Coordinate with UNIX administrators for space management on various servers.
• Setting up new environments (Development, Production etc.).
• Database backup and recoveries using RMAN.
• Cloned database from production to Test using RMAN.
• Installed and Implemented Backup & Recovery procedures. Implement Hot, Cold and Logical backup plans.
• Setup backup and recovery procedures using RMAN.
• Involved in I/O tuning by moving data files and redo log files to faster disks.

Environment: WinSCP, RHEL/AIX, IBM DB2, Oracle 10g/11g, RMAN, DataGuard, SQL Developer, Oracle Goldengate.

Confidential, Providence, Rhode Island

Oracle DBA

Responsibilities:

• As an Oracle DBA, I am working directly with the Confidential (UHIP) to facilitate reviews of data scripts and data root and run queries to test data fixes within an Oracle environment and root cause analysis with double as data script approver (focusing on data integrity checks and fixes)
• Performing day to day activities using OEM such as performance diagnosis and tuning, setting up and scheduling RMAN database backups, and setting up and managing Oracle Active Data Guard, cloning and provisioning, configuration management and monitoring of the server, operating system and database management to schedule and execute scripts at the database or operating system level.
• Created and modified Database objects such as Tables, Indexes, Views, Sequences, Functions, Procedures, Triggers, Stored Procedures, and Packages.
• Meeting with the State Client, Deloitte and working RI Bridges tickets for the data fix scripts.
• Providing 24/7 support for database systems including performance monitoring, performance tuning, troubleshooting and client support.
• Understanding the Architecture by the kind of data modelling and the work flow by executing SQL scripts

Environment: Oracle OEM, Share Point, Jira, Jama, Windows 2010, RHEL 6.0, Pl/Sql Developer, RMAN, Data Guard, UHIP VPN Production Database.

Confidential, OH

Sr. Oracle DBA

Responsibilities:

• Responsible for performing all Database Administration activities i.e. schema management, checking alert log of databases, space management in database, user and roles administration.
• Involved in performing cross platform migrations from Oracle 9i, 10g to Oracle 11g.
• 24x7 production support for several mission critical systems which utilize multiple Oracle databases.
• Created Databases on SUSE 10 and SUSE 11 servers.
• Installation and maintenance of Oracle 11g Data Guard (Active).
• Plan Golden Gate setup to achieve Unidirectional replication
• Install GoldenGate software in Test region to perform POC
• Data Guard using physical standby database, implement log miner, Data guard / Standby both physical and logical standby perform switchover/failover and monitor using Data Guard manager command line and GUI.
• Expertise on database design, SQL performance tuning and all aspects of high-value add applications database support and bull
• Setup GoldenGate Database User with necessary privileges
• Upgrading databases to Oracle 11g and 11gR2 from Oracle 10g.
• Provided backup/recovery, problem diagnosis, performance tuning, data reorganization, and database upgrade.
• Oracle 10g, 11g (R1 and R2) installation on all major UNIX flavored operating system like RHEL, Oracle Unbreakable Linux (OUL), and WINDOWS server 2000, and 2003.
• Installed Oracle 10g, 11g RAC database on Red Hat Linux.
• Creating and maintaining the Oracle databases.
• Installation, Configuration and Maintenance of Oracle RDBMS Software.
• Experience in applying critical patches and patch sets whenever required.
• Applying patches both Server side and Client side.
• Coordinate with UNIX administrators for space management on various servers.
• Setting up new environments (Development, Production etc.).
• Database backup and recoveries using RMAN.
• Cloned database from production to Test using RMAN.
• Installed and Implemented Backup & Recovery procedures. Implement Hot, Cold and Logical backup plans.
• Setup backup and recovery procedures using RMAN.
• Involved in I/O tuning by moving data files and redo log files to faster disks.
• Performed Explain Plan analysis for Query Optimization and SQL tuning with OEM.
• Performed Database and SQL tuning by using various Tools like STATSPACK, AWR, TKPROF, EXPLAINPLAN, and optimizer hints.

Environment: Oracle 12c/11gR2 databases, Data pump, Export/Import, Physical Backups, Oracle Streams, Solaris 9.0, AIX Windows 2000/XP, RHEL, HTTP, Golden Gate, F-Secure SSH, F-Secure FTP, Oracle Enterprise Manager 12c, TOAD, ASM, Data Guard other Oracle tools.

Confidential

Oracle DBA

Responsibilities:

• Supported Oracle 11g, 10g and 9i databases
• Performed upgrades from Oracle 10g (10.2.0.3) to 11g (11.1.0.1) on Intel and HP boxes
• Successfully migrated databases from Intel boxes (Win2000 and Win2003 servers) running Oracle 10g over to HP Itanium boxes running Oracle 11g.
• Installed Oracle 10g RAC software with ASM & OCFS2 file systems
• Configuration, maintenance and tuning of 10g RAC
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices
• Performed Database and SQL tuning by using various tools like STATSPACK, AWR, ADDM, TKPROF, EXPLAIN PLAN, and Optimizer hints
• Experienced in migrating databases to higher releases including incremental migrations
• Migrated database from 9i to 10g and 11g supporting various incremental releases
• Setup of Disaster Recovery databases (Data Guard)
• Refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins
• Installing and Configuring Recovery Manager (RMAN)
• Created & Managed Jobs using AutoSys Job Scheduler
• Good knowledge in UNIX Shell scripting in csh, Pro*C
• Planned version control of production source code using Clear case
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication
• Made performance improvements to the database by building Partitioned tables, Index organized Tables, Materialized Views and Bitmap Indexes

ENVIRONMENT: Oracle 9i, 10g, and 11g, Oracle RAC (11g, 10g), Data Guard, Oracle Enterprise Manager (OEM), RMAN, ASM, STATSPACK, EXPLAIN PLAN, Linux,Oracle 10g, 11g, RAC, LINUX, RMAN, RAC, Data Guard, ASM, AWR.

Confidential

Oracle DBA

Responsibilities:

• Configured and installed Oracle 9i/10g Databases; handled migration/upgrades of databases from 8i to 9i and 10g manually and with DBUA.
• Data modeling / Logical database design and implementation (including index design)
• Performed Backup/Recovery using RMAN and established testing standards utilizing the advantages of 10g Flashback.
• Performance tuned application/table design, data access methods, memory allocation, disk I/O, CPU usage and resource contention.
• Supported Oracle 11g, 10g and 9i databases
• Performed upgrades from Oracle 10g (10.2.0.3) to 11g (11.1.0.1) on Intel and HP boxes
• Successfully migrated databases from Intel boxes (Win2000 and Win2003 servers) running Oracle 10g over to HP Itanium boxes running Oracle 11g.
• Installed Oracle 10g RAC software with ASM & OCFS2 file systems
• Configuration, maintenance and tuning of 10g RAC
• Extensive Performance Tuning, Memory (SGA) Tuning, Net backup, EMC (Time finder and SRDF), RAID, RAW Devices
• Performed Database and SQL tuning by using various tools like STATSPACK, AWR, ADDM, TKPROF, EXPLAIN PLAN, and Optimizer hints
• Experienced in migrating databases to higher releases including incremental migrations
• Migrated database from 9i to 10g and 11g supporting various incremental releases
• Setup of Disaster Recovery databases (Data Guard)
• Refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins
• Installing and Configuring Recovery Manager (RMAN)
• Created & Managed Jobs using AutoSys Job Scheduler
• Good knowledge in UNIX Shell scripting in csh, Pro*C
• Planned version control of production source code using Clear case
• Security User Management, Privileges, Role, Auditing, Profiling, Authentication
• Made performance improvements to the database by building Partitioned tables, Index organized Tables, Materialized Views and Bitmap Indexes
• Analysis and management of Oracle problems/defects using SRs and/or Metalink with Oracle Corporation and installation of patches
• Data Modeling, Database Design and Creation using Erwin.
• Oracle Database 11gR2 Real Application Clusters (RAC) Installation and Configuration on Linux
• Server release 5
• Upgrading databases from 10.2.0.4 to 10.2.0.5 and Migration of databases between the RHEL AS4 update 8 to SOLARIS 5.10
• Patching, upgrading the database to 10g, 11g
• Creating databases as per client Standard
• Duplicating Database with RMAN from RAC to Single Node
• Duplicating Database with RMAN from RAC to RAC
• Data Guard Rebuild
• 11gR2 DR drill for Data Guard
• Migrated database from non ASM to ASM
• Check the performance of the database and tune as and when requires using tools AWR, EXPLAIN PLAN
• Understanding execution plan of top SQL statements by using Explain plan, Auto trace and TKPROF
• Refreshing Test Databases with EXPDP/IMPDP
• Handling database management and change requests in form of import and export.
• Oracle Server and client software installation

Environment: Oracle 9i, 10g, and 11g, Oracle RAC (11g, 10g), Data Guard, Oracle Enterprise Manager (OEM), RMAN, ASM, STATSPACK, EXPLAIN PLAN, TOAD, SQL*Plus, PL/SQL, PostGre SQL, SQL*Loader, HP-UX, Windows 2000/2003, Linux,Oracle 10g, 11g, RAC, LINUX, RMAN, RAC, Data Guard, AWR, Auto trace, TKPROF, EXPDP/IMPDP.