SUMMARY

• An Oracle DBA with 8+ years of progressively responsible positions in diversified and very large production and development environments in various domains with database implementation in various Linux and Windows platforms.
• Good exposure of Oracle DBA tasks Installation, Patching, Cloning and Upgrade of databases.
• Analyze ability to install and administer Oracle databases in a variety of operating system environments including Microsoft Windows, IBM AIX HACMP, Solaris, Red Hat Linux, HP - UX, AIX and UNIX.
• Experienced in designing, building and administering Oracle Clustered Server configurations supporting 10g and 11g Real Application Clusters (RAC) installations.
• Experienced in planning, implementing & supporting Oracle RAC10g/11g with Data Guard as Oracle Maximum Availability Architecture (MAA).
• Experienced in migrating single instance databases to multimode 10g/11g RAC for high availability and load balancing.
• Experienced in configuring Oracle 10g/11g Physical Standby database (Data Guard) and Active Data Guard to ensure high availability.
• Experienced in configuring Data Guard Broker as it automates centralized management and monitoring of Data Guard configuration.
• Knowledge in working with Golden Gate in setting up unidirectional and bidirectional replication and used Golden Gate to migrate teh database across heterogeneous servers with minimal down time.
• Worked on all backup operations using RMAN (full database, data file, image copies, incremental backup sets, validating) and recovery operations.
• Excellent noledge in Flashback Recovery and cloning of databases using RMAN, recovery of databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, recovering from Block Corruption etc.)
• Extensively worked on Export/Import and Data Pump Export/Import tools.
• Excellent experience in Performance tuning of oracle databases using Oracle Grid Control, AWR, ADDM, STATS PACK and tuning of SQL scripts using SQL Trace, Explain Plan and Hints.
• Extensive experience in programming shell scripts for monitoring and backup jobs using Perl and shell scripting.
• Experience in working on large databases 4TB.
• Implement Enterprise Manager Grid Control to provide monitoring and management of teh Oracle Database estate.
• Installed and configured Oracle Enterprise Manager (OEM 12c Cloud Control) and hands on experience with tuning tools in OEM 12c.
• Performed upgrades from Oracle 9i to 10g, 10g to 11g and 11g to 12C.
• Solid experience using tools like OEM, TOAD and SQL Developer and performing data migrations using Exp/Imp utility.
• Data loading using SQL*Loader, Logical backups using full Export and Data Pump.
• Experience with SQL, PL/SQL coding, stored procedures, triggers, cursors, and functions.
• Experience in migrating from MYSQL to Oracle using SQL*Developer and DB2 to Oracle using CDC (Change Data Capture IBM).
• Extensive noledge of Oracle Architecture, Data Models, Database design, Normalization & System study.
• Responsible for migration of all objects into different test instances like Development, Integration, Test, Production and applying patches whenever required.
• Expertise as On-Call 24x7 production DBA and application/development DBA and oracle support processes for technical requests through Meta link and other support Procedures.

TECHNICAL SKILLS

Operating Systems: IBM AIX HACMP, HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 6.1, Red HatLinux RHEL 4.x, 5.x,6.x and Windows 95/98/NT/2000/XP/07 Windows server 2008

RDBMS: Oracle 12c, 11gR2, 10gR2/9iSoftware Applications Srvctl, Crsctl Recovery Manager (RMAN), Real Applications Cluster (RAC), Data Guard, OEM, STATSPACK, ERWIN, IBM CDC (Change Data Capture), ClustersVeritas Backup, Golden Gate, SQL Loader.

Languages: SQL, PL/SQL, C, C++, UNIX Shell Scripting, Perl.

Web Tools: HTML 5.0, XML.

PROFESSIONAL EXPERIENCE

Confidential, Lincolnshire, IL

Oracle DBA L3

Responsibilities:

• Support, administer and maintain 12c, 11gR2, 10gR2 production and test environments on AIX HACMP, RedHat Linux and Solaris platforms.
• Installed and configured Oracle Real Application Clusters on 2-Node with Physical Data guard for Maximum Availability Architecture (MAA).
• Rolling upgrade(11.1.0.7 to 11.2.04) using Transient Logical Standby database with minimal downtime
• Upgraded databases from 11.1 to 11.2 and 11gR2 to 12c on Tier 1 Pharmacy Applications.
• Applied PSU patches on Standalone, GRID and RAC environments for keeping them in compliance.
• Migrated databases from Non-ASM to ASM in OLTP environment
• Configured Physical, Active and Snapshot standbys to maximize database availability and quality assurance testing for application team.
• Configured Data guard broker for switchover/failover on Tier 1 Pharmacy systems.
• Installation and configuration of Oracle Enterprise Manager 12c
• Ensure backup and recovery of database using RMAN, Datapump.
• Configured and optimized strategy of NMDA managed database backups on EMC DataDomain.
• Successfully executed database migration from VMWare to ODA’s (Oracle Database Appliance) using transportable tablespaces.
• Configured efficient backup and recovery strategy on engineered systems ODAs.
• TEMPEffectively managed external tables and materialized views.
• Applied conceptual model concepts to existing systems and data structures to adhere to data compliance.
• Analyzed application performance with respect to OS, network, database, procedural and suggested possible improvements.
• Involved in Oracle Golden Gate replication setup and troubleshooting maintenance issues.
• Support migration to data warehouse environments dat are used for reporting purposes. Also supported teh associated ODI.
• Recommendations on database parameter changes, partition strategy, reorganization strategy and scheduled purge jobs on huge tables resulted in enhanced database performance.
• Supported rigorous application development, testing and tuning efforts for business critical applications by closely coordinating with application teams, Golden Gate teams and Offshore DBAs.
• Extensively worked on Oracle Service requests to troubleshoot and fix issues.
• Maintained databases on AIX HACMP clustering environments and supported failovers.
• Created and analyzed AWR/ASH/ADDM reports to compare performance and suggested improvements.
• Schedule automatic maintenance jobs, alerts and emails on OEM 12c, crontab and through scripts in oracle scheduler.
• Configured a robust, reliable RAC environment and associated support procedures according to requirements of a 24x7 environment.
• Standardization of best practices and documentation for efficient noledge transfer.
• TEMPEffective coordination and management of planned and unplanned changes and incidents relating to teh PROD and Non-PROD databases.
• 24x7 on-call support on rotation.

Environment: IBM HACMP, Oracle 12c/11gR2/10gR2, Oracle RAC, ODA, Exadata, Oracle Golden Gate, RMAN, OEM 12c, Java, IBM Storage, BMC Remedy, Toad, Foglight, Tuxedo.

Confidential, Chicago

Oracle Database Administrator

Responsibilities:

• Involved in projects supporting 2-node Production RAC databases on Oracle 10g/11g on RHEL.
• Installing and configuringData guard with Data Guard Brokerfor fasterDisaster Recovery.
• Installed/ManagedOEM 12Cagent on new Linuxservers.
• TEMPEffectively planned/implementedOEM targetsmigration from11gto12C.
• Configured newdatabase/hosttargets andcreated/managed usersin OEM 12C.
• Upgraded teh databases from10g to 11.2.0.3in Development,TestingandProductionenvironments.
• Installed and migrated databases from NON-ASM to ASM.
• Responsible for Capacity Planning and physical database design to create and maintain teh databases and implements/enforces security for teh entire oracle database.
• Performed Schema Refresh, Code Migrations and Data Migrations in several environments.
• Experience in analyzing AWR, ADDM, ASH reports in troubleshooting teh contention and concurrency in teh database.
• Performed DR test for high availability.
• Involved in planning and scripting to collect DB metrics and configure it with alert systems.
• Performed SQL Tuning using SQL TRACE/TKPROF, Explain Plan and Auto Trace.
• Monitoring Operating System level processes for CPU utilization, Load average and Memory utilization.
• Performed block recovery using RMAN backups.
• Performing regular backup validations using RMAN.
• Involved in taking backups using Oracle RMAN, Expdp and VERITAS Netbackup.
• Involved in monitoring daily Crontab Jobs for RMAN Backups, Data guard Standby validation, LOG Shipping, CRS Processes, Listeners and Sessions.
• Knowledge in Golden Gate setup to achieve unidirectional replication and test initial Data Load option of Golden Gate during environment build.
• Specialist in creating huge table partitioning (Interval Range and Hash).
• Identify risks involved with replicating highly volatile tables with large data volume.
• Developed custom utilities to automate manually intensive tasks such as mass schema changes.
• Identically working with application team/developers to ensure teh database integrity, high availability and security.
• Migrated MYSQL database to Oracle and DB2 to Oracle using SQL-Developer and CDC (change Data Capture from IBM) on data ware environment.
• Experience in writing backend procedures, functions, packages and triggers using PL/SQL and also kshell scripts for automatic recovery.
• Provides technical support to application development teams and administers all database objects.
• Additionally part of rotation on call DBA to support Production databases 24x7.

Environment: RHEL 6.3, Oracle 12c/11gR2/10gR2, RAC, MYSQL, DB2, SQL-Developer, OEM 12c, DATAGUARD, Data Guard Broker, RMAN, Golden Gate, Data Pump, PL/SQL, Diagnostic and Tuning Advisors, Change Data Capture (CDC) IBM.

Confidential, St.Louis

Oracle Database Administrator

Responsibilities:

• Performed Installation, Configuration, Design, troubleshooting, performance tuning and production Support of Oracle 10g, 11g, and RAC (10g and 11g R2) databases on LINUX and AIX.
• Involved in performing migration from Oracle 10.2.0.4 RAC to 11.2.0.2 RAC database.
• Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment.
• Keeping teh databases up to date with respect to Latest PSU’s and very comfortable in applying patches.
• SQL tuning and Database tuning TEMPhas been done based on reports generated by SQL Trace, TKPROF Reports, Explain Plans and monitor teh database performance on daily basis.
• Creation, configuration and setting up of RMAN catalog databases and registering target databases with teh catalog.
• Worked on this project as Oracle Core DBA. Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export /Import), Database backup (Hot & cold).
• Worked on Features: Data Pump, ASM and RMAN. Data Base Recovery (complete & Incomplete).
• Experience in ER & Data Flow Diagrams, Data Modeling using Erwin, Physical/Logical Database designing.
• Administration of all database objects, including tables, Indexes, views, sequences, packages and procedures.
• Installing ASM environment and migrating database from NON-ASM to ASM.
• Migration of oracle database from 9i to 10g, 10g to 11g and applied oracle security patches.
• Experience in Planning Database, Sizing table space, Create database, scripts, Monitor databases, Interact with developers, Oracle Install, Upgrade and 24x7 production support.
• Monitored and troubleshooting database issues with OEM grid control.
• Experience in Performance and Tuning databases using various techniques. Collected performance statistics memory usage, data storage and created database triggers using PL/SQL.
• Used shell scripts for monitoring jobs, for startup and shutdown, health check of databases, analyzing stats at different levels, rebuilding indexes and for purging as well.
• Additionally part of rotation on call DBA to support Production databases 24X7.

Environment: Oracle 10g, 11g, RAC, Sun Solaris 5.10, AIX 5.1, 5.2, HP-UX, Toad, ASM, ERWIN, GRID, AWR, ADDM, PL/SQL, OEM, Data Guard, RMAN, Shell Scripting.

Confidential

Oracle Database Administrator

Responsibilities:

• Installation and administering 10g/11gR1 databases on RHEL and Solaris platforms
• Setting up new development and QA environments and involved in deployments and migration. Cloned databases for development and testing. Refreshed Dev &QA databases from production.
• Performed database tuning for daily loads and slow response issues by refining queries.
• Experience in Configuring Physical, Logical Standby database and Active Data Guard.
• Ensure database backups and recovery using RMAN, Datapump and Exp/Imp.
• Experience in working with cold and hot backups and recoveries.
• Customized database backups for Disaster Planning and implementation.
• Worked on user management mainly on grants, privileges, roles and profiles.
• Adding teh required User Logins, Groups and Users, Granting and Revoking Permission to/from teh users. Co-coordinating with on-site counterpart as well as Clients and understanding requirements.
• Designing and developing SQL procedures, query performance tuning.
• Created materialized views, Rebuilding Indexes and partitioned tables and Index organized tables.
• Creating profiles and attaching them with users, performing hot and cold backups.
• Recovery of database from media failures, dropped accidentally and data block
• Proficient in managing Oracle Instance, database storage structure, schema objects.
• Administration of all database objects, including tables, Indexes, views, sequences, packages and procedures.
• Skilled with STATSPACK, AWR, ADDM, SAR to check health of database & hardware.
• Experience in Performance and Tuning databases using various techniques. Collected performance statistics memory usage, data storage.
• Experience in designing Data Model using Erwin.

Environment: RedhatLinux, IBM-AIX, Windows2000/2003, Oracle9i/10g/11g, RAC, Dataguard, Oracle Streams, Toad v10, PL/SQL, SQL*Loader, ASM, OLTP, OEM, Erwin 4.1.2, VERITAS Net backup.