SUMMARY

• 7+ years of experience as Senior Database Administrator in planning, designing, installing, configuring, upgrades and patches, performance tuning including RMAN backup and recovery, cloning, Database Security and administering multiple Oracle databases with EXADATA, RAC, DATA GUARD, GOLDENGATE in Oracle Enterprise Linux, Red Hat & Sun Solaris UNIX (SAN storage, RAID).
• Solid skills in database design, optimization and performance tuning, design and developed applications, and SQL queries, Flash - Back Recovery, Data Pump, ASM, ASH, AWR, ADDM, Automatic Undo management, OEM Grid Monitoring and Recycle Bin, SCAN, FAN, TAF, RAC ONE NODE, Server pools.
• Hands on experience in managing enterprise level (Multiple TB) size databases as well as 24x7 Production support of Oracle 9i/10g/11g/12c databases.
• Worked on Oracle Data Masking and Sub setting to help database customers improve security, accelerate compliance, and reduce IT costs by sanitizing copies of production data for testing, development, and other activities and by easily discarding unnecessary data.
• Experienced in Planning, Installation, Physical and Logical Database Design, Backup and Recovery, Cloning or Refreshing Database and Oracle Applications.
• Experienced in upgrading Oracle database to 10.2.0.4 to 11.2.0.4 to 12C.
• Experience in setting up and maintaining Oracle Data Guard for production databases.
• Expertise in using ORADEBUG, TKPROF and SQLT for fixing performance tuning issues.
• Proficient in analyzing and optimizing queries, performance tuning and providing reports using TKPROF and Explain Plan.
• Expertise in converting single instance database to two node Real Application Cluster (RAC) / Automatic Storage Management (ASM)
• Experience in registering services through OEM11g/12c GRID Control.
• Configured and maintained physical standby databases using Oracle DATAGUARD to perform quick disaster recovery.
• Experience in using Golden Gate to support data replication monitoring, tuning and capacity planning.
• Data Guard setup with Primary and Standby Databases.
• Good Experience on RMAN, Data pump, Flashback tables, ASM, ADDM, AWR, ASH.
• Development of automated RMAN scripts for both backups and cloning of Oracle Databases
• Install, configure and troubleshoot all components maintained multiple Oracle databases.
• Perform day-to-day database administration and ensure integrity, security and availability of applications environments.
• Implemented active Oracle Data Guard to facilitate data protection, site redundancy and disaster recovery.
• Written KORN shell scripts in UNIX and scheduled the job using CRON and Tivoli scheduling.
• Good experience in SQL, PL/SQL, Perl Scripting, Shell Scripting, Partitioning, Data modeling, OLAP, Logical and Physical Database Design, Backup and Recovery procedures.
• Expertise in SQL, PL/SQL, and developing various Data Database objects like Triggers, Stored procedures, Functions, Sequencesand Views etc.
• Proficient in SQL, PL/SQL, Perl Scripting, Shell Scripting, Oracle Data Dictionary - Meta data, Logical and Physical Database Design.
• Create, maintain and provide support to Oracle Cluster databases.
• Installed Oracle grid infrastructure & Oracle database software to meet the current needs and upgraded as needed to meet the expansion needs of the company.
• Utilized Golden Gate for data replication and synchronization
• Developed RMAN scripts for database Backup and recovery including- hot and cold backup
• Experience in Security Management and Database Auditing.
• Worked on Fusion applications and oracle Spatial with SaaS Pot environments, Worked on Oracle 12c database fusion applications
• Tuning the databases for optimal performance and monitoring CPU performance.
• Database Upgrading from one server to another using RMAN.
• Expertise in RMAN for recovery and cloning and in applying security patches.
• Basic Administration of UNIX systems (Solaris, LINUX, HP-UNIX TRU64, AIX).
• Experienced in writing UNIX shell scripts and setting up cron jobs for database needs.
• Expertise in Cloning of databases from RAC to RAC and RAC to non-RAC, Maintaining Hot Backups, Cold Backup.
• Monitored and managed various database components (logical & physical) like table- spaces, segments
• Work on Data Masking and sub setting can be performed on a cloned copy of the original data, eliminating any overhead on production systems
• Experience in working with ticketing tools BMC Track IT and Bugzilla.
• Strong Analytical skills and ability to interact with end-users, managers, and technical personnel, Good team player, self-motivated and a quick learner.
• Proficient in raising SR’s with Oracle Support and using Meta link to resolve the bottlenecks in the database environments.
• Installed and applied various patches which includes patch set, CPU/PSU, One-off patches and also upgraded oracle database 9i to 10g and 10g to 11g.
• Hands on experience in complete recovery, incomplete recovery (PITR, TSPITR), Flashback Recovery, Disaster Recovery, recovering data files and control files.
• Expertise in managing database security by creating new users, roles, profiles and providing required user privileges in development, test, and production environments.
• Worked on Creation of table spaces, data files, roles, redo logs, rollback segments, stored procedures, functions, packages and Triggers.
• Managed and supported 24X7 Production Database support on call.
• Excellent communication skills, good organizational skills, outgoing personality, self-motivated, hardworking and grasp quickly.

TECHNICAL SKILLS

Applications: DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, Erwin, TOAD, Data Pump (expdp, impdp), Autosys, Query Analyzer, SQL*Plus, SQL*Loader, GoldenGate,Database Vault,Guardium,Toad,SQL Developer

Databases: Installation, Implementation, Administration, Upgrading and Troubleshooting of Oracle 8i, 9i, 10g RAC, 11g RAC, 11gR2 RAC, 12R1 RAC

Tool: /Utilities: TKPROF, STATSPACK, Explain Plan, ORACLE Bug DB, OEM.

Backend Scripting: SQL*Plus, PL/SQL, UNIX Shell Script, Perl Scripting.

Operating Systems: Sun Solaris 8, 9, 10.AIX 5.1, 5.2, 5.3, 6.1, RHEL 4.x, 5.x, 6.x .Linux Enterprise Server 10.Windows NT/2000.

Others: AD Utilities, SQL * Loader, TOAD, Workflow Builder, SQL Developer.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. Oracle Database Administrator

Responsibilities:

• Upgraded databases from 11.2.0.3 to 11.2.0.4 to 12C
• Performed Oracle11g/12c RMAN refresh of different environments such as development, testing etc. from production environment.
• Installed, configured, and maintained Oracle 11gR2 on Linux and also Upgraded from Oracle 11g to 12c.
• Installed, Configured Oracle 12c Golden gate on Oracle 12c Database.
• Used Golden Gate in moving large volumes of transactional data, with minimal impact to online systems.
• Experienced in configuring Autosys Jobs on utility servers.
• Extensively worked on maintaining Oracle Internet Directory (OID) which enables fast retrieval and centralized management of information about dispersed users and network.
• Experienced in OID content changes like add, modify and delete of OID entries which provides high performance, scalability, robustness and availability of an oracle database.
• Worked on setting up/installation and configuration of release 11g R2 RAC with ASM and 11g CRS on IBM AIX 6.1.
• Performed conversion of Single Node Instance to multi node RAC with ASM, and adding instance to existing RAC.
• Implemented backup and recovery procedures (Cold/Hot backups, RMAN Incremental backups & Import/Export).
• Strong script writing skills using shell and Perl languages, Correcting the sql/plsql queries and guide user understandable methods.
• Merging user traffic to replicated database and keep physical for reporting in Golden Gate environment.
• Configured Databases for online backups and manage the complete Database recovery.
• Rebuilding of Indexes for better performance, maintenance of Oracle Database.
• Cloning of production Databases to the test environment using Recovery Manager (RMAN).
• Help developers writing database triggers, packages, procedures, functions, utilities for application development.
• Export and Import of User, Tables and Database using exp/imp and Data Pump.
• Configured RMAN backups.
• Experienced in decommission of old databases which have been migrated to EXADATA.
• Performed Non-RAC to RAC and RAC to Non-RAC cloning, Performance tuning of Oracle Database, applications and queries
• Conduct Pre-patch analysis for different types of patches as requested by customer.
• Configured Workflow Notification Mailer for inbound and outbound processing.
• Maintenance and support of Development, Test and Production environments.
• Converted single instance e-business database to Oracle 11g RAC
• Worked with technical, functional teams and Oracle Support to troubleshoot and resolve issues.
• Database Management - Backup, & Recovery, Performance Tuning, Configuration of Database, Table space administration, User management and Index management.
• Created Users, Roles and Managing Security & Concurrent Managers administration.
• Daily DBA activities like Tuning of SQL/PLSQL, Performance Tuning, Database auditing and managing user groups, Database security, OS space monitoring etc.
• Strong written scripting in both bash, korn shell, Perl scripts.
• Running the scripts for hours to perform backup, recovery operations. Check out and get feedback by writing the shell scripts in RMAN backup.
• Optimize and Tune Database /Application. Provide solutions and enhancements for existing and new environments.
• Simplify the sql/plsql queries to process within time span, making sure database available by replicating physical database with Golden Gate, Data capture before the change with recording Streams.
• Maintaining data broker functionality in Data guard.Installation and administration replication tools like Golden Gate.
• Experience in the installation ofOracle Grid Control agents.
• Documented all Oracle 12c installation/Up gradation work and delivered KT to all team peers.
• Good experience in PATCHING AND UPGRADATION from 11.2.0.x to 12.1.0.x
• Configuring and managing ASM instance and migrating database from NON-ASM to ASM.
• Responsible for RMAN backups and created RMAN scripts for full / incremental backup, DATAPUMP scripts.
• Setup of Jobs using the Oracle Enterprise Manager (OEM) database control.
• Weekly Data Refresh from Production to Development and Test environments using data pump export/import.
• Replicated data using Oracle Golden Gate and import/export.
• Performed day-to-day activities such as creating users, roles, schemas, tables, views, indexes and rebuilding Indexes and running scripts given by the clients.
• Table space monitoring, Performance monitoring and tuning for performance improvement.
• Interacted and Worked with Oracle Support (SR) whenever we faced production issues.
• Daily health checkup of the database using TKPROF, AWR, ADDM and Monitoring alert log/system log.
• Managing Database Locks and blocking sessions.

Environment: Oracle 11gR2 RAC, 12c, Red Hat LINUX, HP-UX,OEM/Grid Control, AWR/ADDM, RDBMS, SQL, PL/SQL, Backups, GoldenGate, AIX 5.2/ 5.3, BMC Remedy, Autosys, ASM, Active Data guard, RMAN, Explain Plan, Oracle Database Vault.

Confidential, Erie, PA

Sr. Oracle DBA

Responsibilities:

• Provided production 24*7 support several databases, Installation of Oracle Database
• Responsible for supporting multiple instances, activities include installation, maintenance and upgrade of Oracle databases.
• Supported cross-product support across database/middle-tier issues with the development and release of Application products.
• Install, configure and troubleshoot all components of Multiple Oracle.
• Installed, upgrade and configured Oracle Enterprise Databases 11.1 to 11.2 and configure data guard 11g for DR with two physical standby database for upgrade, migrations and patch sets application, Creation and maintenance of Active Data guard in 11g.
• Switch over and Fail over between Primary and Standby whenever needed.
• Data guard Broker setup, which would help in Fast Start Fail Over.
• Worked on Fusion applications and oracle Spatial with SaaS Pot environment, Worked on Oracle 12c database fusion applications
• Installation and creation of 10g and 11g databases in Dev/Test environment.
• RAC: Installation, Configuration and Administration of Oracle 11g RAC.
• In depth knowledge of Oracle 11g RAC, RAC internals and RAC tuning.
• Migrated single instance databases to multinode 10g RAC environment for high availability and load balancing.
• Creating, maintaining, Tuning Standby databases, Disaster recovery using data guard Broker.
• Planned and performed the database migration from SQL Server to Oracle using Golden Gate.
• Installed Oracle Cluster ware to provide infrastructure for RAC and configured 2 node Oracle 10g RAC with ASM.
• Implementation of High Availability solutions with Oracle 10g RAC, Physical and Logical Structures
• Knowledge of the Oracle Golden Gate installation, configuration. Proficiency using Oracle Golden Gate replication monitoring, tuning and capacity planning.
• Performed bi-directional replication from source to target Database using Golden Gate.
• Participate in disaster recovery exercises using Oracle Dataguard technologies including Fail-over and Switch-over operations.
• Proficient with 11g new features: Active Data guard, configuring Snapshot standby database.
• Upgrading production and development databases to Oracle 11g, Applied patches to Oracle Databases and Oracle Applications.
• Migrating databases from existing 10g environment to the Oracle Database Appliance (ODA).
• Extensive performance tuning experience, specializing in Operating system tuning, SQL tuning, managed databases on Exadata and Golden Gate.
• Utilized Oracle Streams and Golden Gate for data replication and synchronization
• Extract/Replicate with Golden gate for active-passive, live setup
• Implement and Manage Oracle Golden Gate for Databases replication, Query offloading, Data loading from Oracle to Oracle
• Worked on data loading and extract using Export/Import, Data Pump, SQL loader and External Tables.
• Worked High Availability Oracle Golden Gate (OGG) systems on Oracle 11g and 11gR2 RAC environments (Front-end: Linux 5, Back-end: Oracle Exadata).
• Worked on setup and configuration of OEM11g/ 12c, experience in registering services through OEM11g/12c GRID Control.
• Manage storage and host resources for all the development and QA teams.
• Regular database activities, backups monitoring, issue resolving through EMS(Environment Management System Tool)
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like TKPROF, EXPLAIN PLAN, AWR, ADDM, ASH and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes
• Used hints for SQL tuning and optimization
• Highly experienced in Oracle 11g, 10g Automatic Storage Management (ASM) required to fulfill the storage needs.
• Experienced in ASM administration.
• Conduct and mentor new hires on the core environment management platform.
• Upgraded Database to 11g (11.2.0.4) RAC in both TEST and PRODUCTION environment.
• 24*7 on-call production support handling weekday, weekend, nighttime, and holiday outages with focused effort to minimize downtime.
• Configured RMAN backups, Performed NON-RAC to RAC and RAC to NON-RAC cloning.
• Tuning of I/O, which includes separating data files and redo log files on different locations, separating of data files and index files on different locations, reducing disk contentions.
• Conduct Pre-patch analysis for different types of patches as requested by customer.
• Configured Workflow Notification Mailer for inbound and outbound processing.
• Maintenance and support of Development, Test and Production environments.
• Converted single instance e-business database to Oracle 11g RAC
• Oracle Data Guard Implementation for High Availability and remote Disaster Recovery (DR) site.
• Work on Data Masking and sub setting can be performed on a cloned copy of the original data, eliminating any overhead on production systems
• Development of automated RMAN scripts for both backups and cloning of Oracle Databases.
• Performance tuning of Oracle Database, applications and queries.
• Cloning of database RMAN and other cloning options to create an in house instance for internal research and development.
• Work on Oracle Data Masking and Sub setting to help database customers improve security, accelerate compliance, and reduce IT costs by sanitizing copies of production data for testing, development, and other activities and by easily discarding unnecessary data.
• Performance Monitoring, Space Monitoring / Capacity planning, concurrent manager tuning.
• Conduct Pre-patch analysis for different types of patches as requested by customer.
• Responding to different types of alerts automation using oracle alerts.
• Worked with technical, functional teams and Oracle Support to troubleshoot and resolve issues.
• Performing pre and post health checkups of oracle databases.
• Researched and documented available options to create a DB Link between oracle and SQL Development databases to rewrite the existing interface.

Environment: Red Hat Linux 5, OEL 5.4,Windows 2003,11g R1, Oracle 11g RAC/10g,Sun Solaris, HP-UX, IBM AIX, Red Hat Linux, Windows, OEM, RMAN, ASM, SQL*Loader, Golden Gate, TOAD.

Confidential

Oracle Database Administrator

Responsibilities:

• 24x7 Production Oracle Database Administration.
• Maintaining production, development & test databases and applications.
• Oracle 10g Database Implementation/Upgrade/Support.
• Oracle 10g Application Server Implementation/Upgrade/Support, Schedule backup in 11g using db console.
• Constant monitoring of database space and space management
• Implementing backup and recovery procedures including logical backup (RMAN), physical backup (online/offline) and integrating the backup procedures.
• Performed recovery from instance and media failures.
• Performed capacity planning and space management.
• Worked on RAC Installation, Configuration and Administration of Oracle 11g RAC.
• In depth knowledge of Oracle 11g RAC, RAC internals and RAC tuning.
• Migrated single instance databases to multinode 10g RAC environment for high availability and load balancing.
• Implementation of High Availability solutions with Oracle 10g RAC, Physical and Logical Structures.
• Knowledge of the Oracle Golden Gate installation, configuration. Proficiency using Oracle Golden Gate replication monitoring, tuning and capacity planning.
• Worked on disaster recovery exercises using Oracle Data Guard technologies including Fail-over and Switch-over operations.
• Extensive performance tuning experience, specializing in Operating system tuning, SQL tuning, Database/Instance tuning.
• Assisted in disaster recovery procedures and recovery using Data Guard.
• Maintained users, roles and privileges in Oracle database for the development team.
• Carried out disk space maintenance on various UNIX servers. Provided suitable mount points for each database and additional disk space for testing purposes.
• Provided Oracle installation support, database maintenance, version control for source code and backup using RMAN, Setting up Oracle Standby Data Guard.
• Tuning of I/O, which includes separating data files and redo log files on different locations, separating of data files and index files on different locations, reducing disk contentions.
• Responsible to improve the performance by Using the Hints, Indexes, Explain Plan
• Performance tuning of SQL statements using STATSPACK, TKPROF, Explain Plan and SQL Trace
• Devised an efficient backup and recovery strategy and implemented it in line with Business requirements (SQL Backtrack and RMAN)
• Automating the backup processes using shell scripts. Performing recovery in cases of system crashes, Worked with RAC implementation team. Added nodes.
• Have implemented standby databases supported by Data Guard, logical standby and physical standby databases in 11gR1 on two node RAC
• Expertise in converting single instance database to Real Application Cluster (RAC) / Automatic Storage Management (ASM)
• Configured RMAN backups. Performed NON-RAC to RAC and RAC to NON-RAC cloning.
• Table space management including, adding/resize data files, allocated quotas to user and managed disk space
• Help developers writing database triggers, packages, procedures, functions, utilities for application development.
• Responsible for database refreshes/cloning from production to QA/Reporting environments. Responsible for localizing the cloned databases for QA/Reporting use e.g. creating users, resetting privileges/passwords, resetting sequences, resetting database links etc.
• Export and Import of User, Tables and Database using exp/imp and Data Pump.
• Oracle Applications Systems Administration. RMAN used in scheduled recovery, hot and cold backup of Oracle10G database.
• Pre-patch or Impact analysis for the patches and document preparation with pre and post patch installation steps.
• Oracle Data Guard Implementation for High Availability and remote Disaster Recovery (DR) site.
• Development of automated RMAN scripts for both backups and cloning of Oracle Databases.
• Performance tuning of Oracle Database, applications and queries.
• Conducted database and applications performance tuning operations making significant improvements in database system performance. Supported developers in tuning DB and apps for optimal performance.
• Administered, maintained, developed and implemented policies and procedures for Managing DB Security and alert log entries.
• Resolved database performance issues, database capacity issues, and distributed data issues.

Environment: Red Hat Linux 4/5, SUN Solaris 9, HP-UX 11i v1 (B.11.11), Windows XP, Oracle 10g (10.2.0), Oracle 10g RAC, TOAD, Developer 6i.Oracle Golden Gate, EXPLAIN PLAN, TKPROF, SQL Trace, Query Analyzer, Oracle Fail Safe, AD Utilities.