SUMMARY

• Over 7 + years of professional experience in Information Technology in design, development, implementation, maintenance, documentation and administration in various domains like pharmaceutical, Finance, and Insurance industries.
• Hands on experience on Oracle (8i/9i/10g RAC/11g RAC) database administration, schema implementation, backup, recovery, cloning, performance monitoring and tuning on different platforms like Windows, Unix /Linux (IBM AIX, Sun Solaris, HP - UX).
• Experienced in maintaining databases on large Production environments.
• Expertise in installing, configuring and maintaining Standalone as well as RAC databases on various platforms and responsible for 24x7 availability of the database. .
• Experience in Installation and administrations of Oracle 10g RAC, 11g RAC.
• Implemented Dataguard and configured both the physical and logical standby database in the production environments.
• Also responsible for well functioning of the database by Checking and Applying Patch set and Interim patches, Upgradations there by making the database software up-to-date. Upgraded databases from 8i to 9i, 9i to 10g and 10g to 11g.
• Worked extensively on Oracle Migrations. Migrated database from Windows to Linux, HP-UX to AIX.
• Proficient in using Recovery manager (RMAN), Flash-Back Technology, Automatic Storage Manager (ASM) & Automatic Database Diagnostic Manager (ADDM).
• Monitoring and optimizing the performance of the database through Database Tuning - Tuning Applications, Tuning Instance, and Tuning Disk Usage.
• Developed database monitoring/health check alert scripts
• Experience in using OEM/Grid Control.
• Expertise in generating reports, Forms using MS-Access databases.
• Planning and scheduling the Physical (Cold/Hot) backups, Logical backups and RMAN incremental backups.
• Experience in taking Full and partial backups, Incremental and Cumulative backups using RMAN (Recovery Manager).
• Experience in taking backup and performing recovery.
• Experience in performing point in time recovery at times of necessity.
• Created Clone databases in Dev and Test environments using RMAN cloning procedure as well as User manual cloning.
• Implemented data transfer using Data Pump, Export/Import utilities.
• Experience in Security Administration, system monitoring by adding and removing users, configuring quotas, auditing, and analysing security problems.
• Extensive Experience in writing Stored Procedures, Functions, Triggers and packages using PL/SQL.
• Configured Oracle on different Operating Systems for OLTP & Data Warehousing environments.
• Experienced in loading data from flat files into database tables using SQL*Loader, ETL Tools and External Tables.
• Excellent communication skills, with strong troubleshooting, and problem solving ability.
• Worked as a team member to provide 24x7 on call production database support.

TECHNICAL SKILLS

Database: Oracle 7.3, Oracle 8i, Oracle 9i, Oracle 10g RAC, Oracle 11g RAC, MS SQL ServerDB2, Sybase. MS Access.

Operating Systems: Red Hat Enterprise Linux RHEL 4.x, 5.x, Sun Solaris 8, 10, AIX 5.3,6.1,HP-UX 10.x,11.x, Windows NT/XP/2000/2003,HP-UX 10.x,11.x.

Technologies: OEM/Grid Control, Data pump Import/Export, Oracle Streams, GoldenGate, RMAN, ASM, SQL*Loader, Oracle Data Integrator, Erwin, Data stage, OID (LDAP), SSO.

Tools: and Utilities: PL/SQL, SQL*Plus, SQL * Loader, Stored Procedures, Triggers, UNIX Shell Scripting, TKPROF, STATSPACK, AWR, Toad, VMware

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Oracle DBA

Responsibilities:

• Implementation and support of 11g migrations and upgrades from Oracle 10g to Oracle 11g databases including RAC databases on HP-UX and Linux.
• Installation, configuration and support of Oracle RAC and Standby Databases (Active Data Guard) for High Availability and Disaster Recovery.
• Performed Database Refresh from Production to QA, UAT and Development databases.
• Implemented 11G Data Guard Physical and Logical Standby using DG Broker, experienced with 11G Data Guard new features Active Dataguard and Snapshot Standby.
• Implemented backup/recover strategies using Hot backup, Cold backups, RMAN and Export/Import utilitites.
• Performance monitoring and tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF, AWR, ADDM.
• Experienced in installing Golden gate replication and developing monitoring scripts for extracts, replicates and pumps.
• Experienced working on Golden gate replication issues like extract/pump abends and resolved them affectively.
• Extensive use of Oracle Data pumps Exp/Imports utility for moving data among the servers.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Used oracle configuration assistants like DBCA(Database Configuration Assistant) for Creating databases, DBUA(Database Upgrade Assistant) for Upgrading databases and NETCA(Network Configuration Assistant) for creating a Client-Server environment using Listener, tnsnames etc.,
• Performed Replication setup between 2 Node RAC ASM Databases and 3 Node Databases.
• Performed database migration from SQL to Oracle platforms.
• Creating and managing database objects such as tables, indexes, partition tables, views, rebuilding indexes and optimizing the code to improve the performance.
• Performed Database upgrades from 10.2.0.4 to 11.2.0.4.
• Implemented Shell scripting for managing day-to-day activities and automation of backups and replication.
• Managing Database Locks and blocking sessions. Defragmentation of tables an indexes for improve performance and efficient.
• Performed daily backup jobs, cleanup jobs using Autosys job setup.
• Implemented Materialiazed views, database links on 11g Environments.
• Tablespace Monitioring, Performance monitoring and tuining for performance improment using OEM monitoring tool.
• Managed appropriate use of freespace within tablespaces, reclaimed space whenever possible. Reoraganized tables and indexes within databases when needed.

Environment: Oracle 10/11g, 11g RAC, Oracle Enterprise Management(OEM), Oracle Golden Gate, RMANData Guard 11g Active Data Guard, Toad 10.6, DBArtisian 9.0.1, HP-UX 11.31, Linux 6.5, Solaris, ASM, OEM Grid Control 11.x

Confidential, CA

Oracle DBA

Responsibilities:

• 24x7 production database and applications support
• Installation, configuration and maintenance of Oracle 10g and 11g databases.
• Implementation multi node RAC on Oracle 10g and Oracle 11g.
• Involved in construction of DR sites for all the Production databases.
• Experienced in a multi-platform environment supporting varying databases of 40+ TBs.
• Performed Database Refresh from Production to QA, UAT and Development databases.
• Upgraded the Oracle 10g database to 11g version and also applied patch set and interim patches whenever required to make the database software up to date.
• Monitoring Day-Day Backups, Log’s.
• Expertise in generating reports, Forms using MS- Access.
• Successfully implemented Backup & Recovery using RMAN, Conventional Hot and Cold backups.
• Managing backup strategy for all production databases.
• Taking the RMAN incremental (Differential & Cumulative) backups.
• Extensive experience in recovery.
• Cloning of Databases from Production to Development and Test.
• Implemented Data Guard with maximum availability, protection and performance configurations and worked with Data Guard Fail over and Switch over cases.
• Installed GoldenGate, upgraded from 10 to 10.4
• Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.
• Implemented DRP (Disaster recovery plan) for critical databases.
• Provided instance level performance monitoring and tuning for Wait Events, Sessions, Physical and Logical IO and Memory Usage.
• Worked extensively on Performance tuning of Queries
• Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, TKPROF, AWR and ADDM.
• Creation of Users and granting them the required Roles and Privileges accordingly.
• Involvement in space management, rectification of lock problems, managed quotas.
• Created database objects like Tables, Indexes, Views, and DB Links etc.
• Responsible for capacity planning, database security, recovery planning and installing patches
• Setup and implementation of Oracle Financial Analyzer.
• Conducted time to time analysis and monitoring of the software and hardware requirements and act accordingly.

Environment: Oracle 9i/10gR2 RAC/11g R2 RAC, Red Hat LINUX, Solaris 10, HP-UX, Windows 2003, MS, SQL Server 2000/2005/2008 , MS Access, OEM/Grid Control, AWR/ADDM, RDBMS, SQL, PL/SQL, OID (LDAP), SSO, DB2.

Confidential, Milwaukee, WI

Oracle DBA

Responsibilities:

• 24*7 Production Database Administration Support
• Installation, configuration and support of Oracle RAC and Standby Databases (Active Data Guard) for High Availability and Disaster Recovery.
• Cloned/Refreshed Oracle Databases for development and testing
• Upgraded databases from Oracle 9i to 10g, Oracle 10g to 11g.
• Experienced in a multi-platform environment supporting varying databases of 20+ TBs
• Performance monitoring and tuning using SQL TRACE, STATSPACK, EXPLAIN PLAN, TKPROF, AWR, ADDM.
• Involved in construction of DR sites for all the Production environments.
• Expertise in generating reports, forms using MS-Access databases.
• Performed Database Refresh from Production to QA, UAT and Development databases.
• Implemented and managed optimum physical database design (tablespaces, datafiles, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space.
• Provided instance level performance monitoring and tuning, Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Backup and recovery, Cold backups, hot backups, Logical backups, RMAN backups (Full, Incremental Backups, Differential, Cumulative Backups).
• Implemented Standby Databases with high availability and performance configurations and participated in Switchover and Fail over tests
• Monitoring Day-Day Backups, Log’s.
• Successfully implemented Backup & Recovery solutions using RMAN (Full, Incremental Backups, Differential, and Cumulative Backups).
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
• Database cloning for development, testing from production
• Responsible for capacity planning, database security, recovery planning and installing patches
• Writing Stored Procedure, Functions, Trigger and packages using PL/SQL.
• Installed and configured Golden Gate
• Replication using Materialized Views, Oracle Streams and Golden Gate.
• Partitioned large tables for better performance and manageability
• Migrating databases from Windows to Linux, Sun Solaris to IBM AIX.
• Experience in Logical Database Design, Physical Database design

Environment: Oracle 11g RAC/10g RAC/Oracle 9i, Data Guard, Sun Solaris, IBM AIX, HP-UX, Sybase, Red hat Linux, RMAN, ASM, SQL*Loader, MS-Access, Data Pump, Golden Gate, TOAD, OEM/Grid Control, SQL, PL/SQL, TKPROF,EXPLAIN PLAN, AWR

Confidential, Irving, TX

Oracle DBA

Responsibilities:

• 24x7 production database and applications support
• Installed and Configured Oracle 10g RAC and 11g RAC databases
• Upgraded Oracle databases from 9i to 10g and 10g to 11g version.
• Maintenance of around 200 databases combined on all the production, development and testing environments.
• Configured Oracle Standby Databases (Dataguard) for Oracle Disaster recovery.
• Achieved High Availability, Data protection and Maximum performance by maintaining both physical and logical standby databases.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Implemented Oracle database backup & recovery solutions.
• Extensive use of Oracle Data pumps Exp/Imports utility for moving data among the servers.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Configured and implemented Oracle Streams.
• Performed Schema as well as Table level Replication using Oracle Streams.
• Implemented downstream capture at the destination database using Oracle Streams.
• Responsible in configuring and backing up database using Hot backups, Cold backups, Logical backups and RMAN incremental backups
• Performed automated backups and scheduling using scripting.
• Responsible for migration of databases.
• Written PL/SQL functions, stored procedures, packages and triggers
• Worked with Data pump to take the logical backups of databases.
• Experienced in performing Point in time recovery.
• Used oracle configuration assistants like DBCA(Database Configuration Assistant) for Creating databases, DBUA(Database Upgrade Assistant) for Upgrading databases and NETCA(Network Configuration Assistant) for creating a Client-Server environment using Listener, tnsnames etc.,
• Used Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
• Tested database performance issues (monitoring and tuning) to ensure database optimization.
• Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.
• Involved in gathering requirements from end users.
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.
• Estimate growth of database size by detail analysis of the company’s future policies and generating reports for the management to act in advance.

Environment: Oracle 11g/10g, Oracle 11g RAC, Oracle 10g RAC, Dataguard, RedHat Linux, HP-UX, Sun Solaris, IBM AIX, Windows, Sybase, TOAD, Grid Control, ERWIN, SQL, PL/SQL.

Confidential

Oracle DBA

Responsibilities:

• Installation and configuration of Oracle 9i, 10g software
• Installed and configured Oracle 10g RAC
• Upgraded databases from 8i to 9i, 8i, 9i to 10g. Applied CPU and PSU patches
• Adjusted data models when necessary under direction of data architects.
• Implemented Oracle Dataguard in order to achieve the high availability of the database by maintaining the Standby database.
• Used Recovery Manager (RMAN) and Created recovery catalog on separate server.
• Responsible for backups and recoveries
• Assured Daily Backups and Archiving were done accurately and consistently.
• Implemented and maintained Database security.
• Created / Altered / Dropped Users as and when required and administer their respective quotas and profiles.
• Cloned the database using RMAN to migrate data from PROD to UAT/QA/SIT and Dev databases.
• Implemented shell scripts for backup and recovery
• Restoration of dropped tables using Flashback technology.
• Created Database Links and Snapshots (Materialized views).
• Performed Hot Backups and maintained database availability to support non-stop Business operations.
• Developed UNIX shell scripts with embedded SQL*Loader calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.
• Optimized SQL, PL/SQL code and performance tuning using AWR, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM
• Knowledge in Data warehousing and implementation and supported as Oracle Database administrator in Data warehouse projects.
• Writing PL/SQL stored procedures and functions for data operations team and suggesting developers to write proper query to get optimal performance.

Environment: Oracle 10g/9i/8i, Oracle 10g RAC, Dataguard, RedHat Linux, Sun Solaris, TOAD, Grid Control, ERWIN, SQL, PL/SQL.,SQL*LOADER