SUMMARY

• Have over 11+ years of focused experience in IT industry in various fields like banking, insurance, financial, retail and manufacturing. Extensive experience in relational database design, analysis, modeling, development, administration, implementation, trouble shooting and quality management.
• Comprehensive experience as Oracle DBA; proficient in Oracle 9i/10g/11g/12c Software Installations, Migrations, Database Capacity Planning, Automated Backup Implementation, Tuning Oracle 12c/11g/10g/9i on Unix and Windows NT platform. Involved with architect group in designing the logical and physical model of the databases.
• Thorough understanding of the Oracle data dictionary.
• Have good experience in UNIX administration, Shell scripting.
• Have impeccable communication and interpersonal skills and an exceptional team player. Managing the team of Oracle DBAs and actively coordinated with the end user community.
• Proficient in ORACLE - Installation of Oracle Server, Designing & Testing of database, Administration, Backup & Recovery Strategy Implementation according to the volatility of the data, database security auditing and user management, Performance Monitoring/Tuning.
• Installing & configuring Oracle clusterware & Database Software (Troubleshooting using cluvfy & handling common issues that arise during integration of the whole - bugs, network issues, configuration files issues, OCR issues, deinstallation & cleanup of clusterware).
• Configuring Oracle Data guard in multiple Rac nodes and troubleshooting Sync issues.
• Configuring Heterogeneous ODBC drivers and created listeners from Multiple Sources to Oracle databases.
• Worked with customer for different RAC related issues: hang check timer, split brain, RAC recovery, ASM, OCR corruptions, Voting disk loss & so on .
• Troubleshoot performance issues for the RAC instances (GC events).
• Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle clusterware) & also issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files.
• Resolved/Diagnose Node Eviction.
• Handled Multiple issues with Data Block corruption on ASM Disks.
• Add or Remove Node from RAC.
• Knowledge in Exadata architecture.
• Proficient in scheduling jobs, patches, alerting for database critical metrics validation, hosts and also complete target administration through OEM grid control Worked as a DBA providing 24*7 support
• Oracle 11g/10g Data Guard, Installation, Monitoring and Administration.
• Integrate databases to source system using Oracle Streams, Attunity replicate to report on real-time data.
• Data Modeling, Physical Database Design.
• Performance Tuning, Troubleshooting and Capacity Planning.
• Implementing Oracle partitioning based on the application design and requirement
• Worked in migrating SQL Server 2008 to Oracle 11.2.0.3
• Monitors current DBMS performance and develop procedures, shell/SQL and windows batch scripts to automate monitoring, generate email alerts (via Linux/Unix cronjob) to compress archive logs once applied to the physical standby monitoring the multiple instances on a single server and trigger alert when they are not up
• Purging old archive logs
• Monitoring standby environment and trigger mail on high sequence gap.
• Performing Database backups & recovery using Oracle Flashback, RMAN, Data Pump, Physical Cold backup
• Tuning the PLSQL program and database instances. Performing analysis and providing tuning solutions based on OEM, ADDM & AWR reports.
• Responsible to keep database compliance to security scans (ISRA) and organization policies
• Maintaining schema, user security access, tablespace and data files.
• Refreshing non-prod database using Rman and data-pump.
• Apply quarterly Oracle CPU patches and AD patches on Oracle Applications.
• Writing SOPs & Work Instruction, Functional & design Documents and handling pretty large team.
• Cloning oracle Database/Applications (11.5.10.2 and 12.1.3) through Rapid clone methods.
• Cloning Database/Applications through Rapid clone methods.
• Applying Application patches using Auto patch utility ad patch and ringmaster tool. Performing RDBMS patches using Opatch. Trouble shooting Workers related issues while applying patches.
• Resolved Concurrent requests & Concurrent Managers issues.
• Deploy the .ear files in WebLogic server and managing WebLogic components.
• Apply the latest PSU patches to the RDBMS Oracle Home.
• Configuration of workflow setup for EBS R12 and resolving the issues.
• Used Ad admin to generate jar files, forms and compiling the invalid objects and validating Apps Schema and relinking executables and also, performed generate and compile forms manually.
• Upgraded databases from 10.2.0.4 and 11.2.0.3 to 12.1.0.6 Releases.
• Create workflow & ETL mappings to load the enterprise warehouse data
• Created completely automated load process using Shell scripting and SQL*Loader
• Installing and configuring OWB ETL tool
• Upgrading OWB tool and migrating the metadata repository
• Design and Develop PL/SQL ETL code
• Performing data analysis on user queries

TECHNICAL SKILLS

RDBMS: Oracle Enterprise Edition /9i/10g/11g, MS SQL Server 2005/2008

High Availability: RAC, Oracle Data Guard, VERITAS Cluster Services

Database Tuning and Monitoring Tools: Oracle partitioning, Oracle Enterprise Manager, SQL Advisor, TDE, SQL Performance Analyzer, AWR, ADDM, STATSPACK, TOAD for Oracle.

Operating Systems: Sun Solaris 8/9/10/11, Linux RHEL 4/5, Windows NT 4.0/2000/2003.

Programming Languages: SQL, PL/SQL, Unix Shell Scripting.

ETL Tools: Oracle Warehouse Builder 10.1/11.2

Tools: & Utilities Oracle Streams, Attunity Studio and Replicate console, Attunity Streamflow, Toad, PLSQL Developer, Erwin, Precise, SQL Developer for MigrationNAGIOS, Litespeed for MS SQL server, X-Windows, Gpg encryption

Documentation & Change Control Tools: Microsoft Visio, MS Office, VCS.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Lead Oracle DBA

Responsibilities:

• Installation of RAC Cluster on Multiple nodes and Managing RAC Environment efficiently.
• Scheduling and performing all clones from different Divisions.
• Configuring Oracle data guard(Standby) databases on Multiple Nodes Across Different Data Centres.
• Apply the latest patches on Oracle databases on Single and multiple Rac nodes.
• Install, configure Golden Gate for Capturing live data Across multiple databases.
• Provide on-call support 24/7 on rotation.
• We have converted Single Node Non-ASM Database to Multiple Node RAC ASM Databases.
• Migrated Large databases over 40+ Terabytes of Databases from Aix to Linux Environments.
• Refresh Non-Prod environments and oracle applications on regular basis to support development team.
• Configuring Multiple Heterogeneous ODBC setups and Creating listeners to pull data from Multiple Database Sources (Netezza, Seibel, Microsoft, MemSQL etc.) to Oracle databases.
• Facilitate and Support Development team’s with Performance Issues.
• Setup database servers for new applications and whenever we migrate/upgrade our servers
• Co-ordinating with Oracle support for any Production issues which affects business.
• Upgraded Multiple databases from 10g and 11g and 12c versions with Minimal Downtime.

Confidential, Auburn Hills, Michigan

Sr. Oracle DBA

Responsibilities:

• Monitoring alerts through OEM and scheduling the Jobs
• Scheduling and performing all clones from different Divisions
• Apply the latest PSU patches to the RDBMS Oracle Home
• Install, configure and administrate Jaspersoft Reports.
• Provide on-call support 24/7 on rotation.
• We have converted Single Node Non-ASM Database to 2 Node RAC ASM Database.
• Refresh Non-Prod environments and oracle applications on regular basis to support development team.
• Integration of Attunity Replication tool with the different source system to report on real-time data
• Monitoring Oracle Streams to replicate the data from Source to Target databases.
• Patching all of non-production and production environments whenever Oracle releases patches
• Facilitate and Support Development team’s build through SCM process
• Setup database servers for new applications and whenever we migrate/upgrade our servers
• Co-ordinating with Oracle support for any Production issues which affects business
• Upgraded databases from 10g and 11g Versions to 12c versions

Confidential

Oracle DBA Lead

Responsibilities:

• Application database modeling and ETL design flow.
• Managing 2 node RAC environment.
• Installation of RAC and Managing RAC Environment efficiently.
• Design ETL work solution for loading customer person information world-wide.
• Delegate customer meeting and gathering requirements
• Handling offshore team and deliverables
• Tuning the performance and set environment standards for optimal coding using Toad and Precise monitoring tool
• Creating users, roles and profiles in compliance with organization security policies
• Performing ISRA scans on all physical servers and Oracle 11g database
• Setting up and testing RMAN backup/recovery solution for the environment
• Setting up physical standby data guard for the application residing on Oracle 10g and 11g database environment on Solaris, Linux platform.
• Upgraded ETL tools like OWB from 10g to 11g versions
• Tuning database instances using the report generated by Precise monitoring tool & AWR
• Monitor user activities, managing tablespaces, re-organizing the logical structures to reduce fragmentation and row-migration, performing data analysis, RCA on data issues using Oracle Toad and OEM
• Using Oracle data pump to refresh non-production environments based on export from production data copy
• Creating build promotion & deployment process by SCM process for a standard definition and a unified maintenance framework
• Creating database jobs and programs for maintenance and load process in Oracle 11g environment
• Created shell script to trigger mail on user account lockout/expire report, tablespaces threshold report, Oracle errors in the diagnostic file.
• Running database health checkup every month using DBMS package to ensure the dictionary integrity & data block integrity check
• Created and managed standby databases at remote location using Data guard technology for multiple projects.

Confidential

Oracle DBA

Responsibilities:

• Production support of critical production databases used by external web and Intranet.
• Managing Oracle 11g database software installation, configuration and upgrades
• Establishing and maintaining sound database backup and recovery policies using RMAN & User managed backup strategy upon business requirement
• Creating Oracle partitions based on the application design and business domain
• Performance tuning of the databases, PLSQL programs and SQL queries
• Planning and devising methodology for migration of system to next version of Oracle.
• Training the team on efficient coding and coding standards.
• Maintaining backups and refreshing non production environment on monthly basis
• Creating shell script to automate application jobs and DBA monitoring activities
• Loading data into the environment using Sql*Loader, External tables in Oracle 10g database.
• Providing On-call support as on when required.

Confidential

Oracle DBA

Responsibilities:

• Database Administrator in Installation, upgrade, migration and day-to-day maintenance of Oracle Databases, servers
• Configuring and implementing Oracle Data Guard physical and physical standby databases
• Worked in Veritas cluster-ware environment which ensures High-availability of all production & non-production servers.
• Performance tuning SQL queries, PLSQL programs and tuning database instances
• Providing suggestions and solutions based on ADDM, AWR & STATSPACK reports
• Doing Backup and Recovery using hot backup, Cold backup, Export and Import. Recovery of database, tablespace, data files and control files based in situation
• Creating Logical and physical design of the database and reverse engineering of the database as required
• Partitioning the tables to the application data and fine tune the code for efficient performance
• Monitoring current DBMS performance and develop procedures, shell/SQL scripts to automate monitoring, generate email alerts (via Linux/Unix cronjobs)
• Monitoring multi-instance servers to make sure all instances are up all time
• Compress archive logs after being applied in the physical standby
• Trigger mail to the team when the sequence gap goes high
• Purging old archive logs
• Tablespaces’ monitoring tool
• Supporting all 4 application team’s build any time during the week where 3 applications mounted on Oracle 10g database and one application on SqlServer 2005 on Solaris/Windows Server 2000 platform
• Refreshing all 8 non-prod environments for all the four applications once in a quarter using Oracle data pump/Quest Lite speed Console.
• Providing design consultation to the application team and training the team to hone their technical capabilities for efficient time and work management
• Coaching the team on SQL, PLSQL functionalities and training them on coding standards
• Maintaining the database through SCM process