SUMMARY

• Around 9 years of focused experience in IT industry wif extensive experience in relational database design, analysis, modeling, development, administration, implementation, trouble shooting and quality management.
• Comprehensive experience as an Oracle DBA (8 years) wif 2 years of Exadata and 2 years of GlodenGate experience.
• Proficient in Oracle 10g/11g/12c Software Installations, Migrations, Database Capacity Planning, Automated Backup Implementation, Tuning Oracle 11g/10g on Unix and Windows NT platforms, and proficient in OEM, RAC and RMAN. Involved wif architect group in designing the logical and physical model of the databases.
• Thorough understanding of the Oracle data dictionary. Have good experience in Linux/Unix administration, Shell scripting. Excellent communication and interpersonal skills.
• A collaborative exceptional team player. Experience managing a team of Oracle DBAs and actively coordinating wif the end user community.
• Extensive noledge in database administration for Oracle 10g, 11g&12c wif experience wifin very large scale database environments and mission critical large OLTP and OLAP systems.
• Hands - on experience in creating and monitoring tablespaces, allocating tablespaces for users.
• Proactively Monitoring file system growth, Alert Log and Archive Destination.
• Experience in Configuration and Maintenance of Oracle Database Appliance (ODA), and experience to minimize downtime for ODA maintenance
• Hands-on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN wif VERITAS Net Backup.
• Implemented RMAN backup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard.
• Hands-on experience on Oracle database cloning to a different Unix Server, through user managed cloning, Database cloning from hot & cold backups, RMAN database cloning to same/different servers.
• Knowledgeable in build release management, software configuration, design, development and cloud implementation.
• First hands-on experiences in software and firmware maintenance of both the Database and Storage servers in the Exadata database machine including upgrades and patching.
• Provide and implement performance tuning recommendations of all components in Exadata database machine.
• Advise, provide guidance and develop Disaster Recovery strategies for the Exadata Database machine.
• Strong experience to configure Exadata to meet company internal security requirement.
• Analyze and determine the feasibility of leverage the Oracle Enterprise Manager solution to report on performance, provide metrics, and become the centralized proactive maintenance solution for Exadata distributions.
• Develop and record certified processes/procedures for all potential IT downstream support groups to maintain and upgrade the Exadata database machine.
• Integration of Exadata monitoring and escalation into existing IT monitoring and actionable events solutions.
• Experienced in designing, deploying and operating highly available, scalable and fault tolerant systems using Amazon Web Services (AWS).
• Extensively worked using AWS services along wif wide and in depth understanding of each one of them.
• Highly skilled in deployment, data security and troubleshooting of the applications using AWS services.
• Experienced in implementing organizational DevOps strategy in various operating environments of Linux and windows servers along wif cloud strategies of Amazon Web Services.
• Ability to diagnose database & application performance issues and using explain plan, TKPROF, AWR to generate reports for checking Performance
• Hands-on experience on installation, configure, upgradation, migration of Oracle RAC for 11g/12c, and creating ASM database using ASM/ACFS.
• Hands-on experience in setting up & managing oracle Standby Databases using RMAN utility, for both Physical and Logical supported by DATAGUARD
• Expertise in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Enterprise Manager (OEM) 11g/12c, TOAD, Oracle SQL Developer in various versions.
• Expert in Performance Tuning me.e. tuning applications, shared pool, me/O distribution, rollback segments, buffer cache, redo mechanisms.
• Streamlined Upgrades, Patch Set Updates (PSU’s), Critical Patch Updates (CPU’s), and Security Patch Updates (SPU’s) in various environments. Performed both In-place and Out-of-place Upgrades.
• Installed Oracle 11g ASM&12c RAC software wif ASM & OCFS2 File systems.
• Experience in data loading utilities like SQL*LOADER, Logical backups using full export, import and DATAPUMP
• Extensive noledge on SQL Server Administration.
• Experience on database Migration and Up-gradation from 9.2.0.6 to 10.2.0.1 and 10.2.0.1 to 10.2.0.4 and 10.2.0.4 to 11g and 11g to 12c
• Having experience on applying database patches using Opatch Utility
• Experience on Database cloning wif ACFS.
• Experience on RAC Installation in Oracle 11g and 12c, Administration of RAC Database and cluster ware using SVRCTL, CRSCTL, configuration of ASM, maintaining the database, Real Application Cluster Installation (Two nodes) using Net App Filer and troubleshooting network-related issues
• Experienced in using Oracle's Transportable Tablespace (TTS) feature allows users to quickly move a user Tablespace across Oracle databases.
• Expertise in PL/SQL, SQL and UNIX Shell Scripting using which me optimized SQL Tuning, Index rebuilding and Index Tuning.
• Experience in Real Application Cluster (RAC) environment wif Auto Storage Management (ASM).
• Working experience in Linux and Unix Administrative tasks, like Networking, Filesystems, User Management, LVM’s)
• Solid experience wif Oracle grid control, Oracle enterprise manager (OEM), ASM, AWR, ADDM, Flashback Technology, SQL tuning advisor, SQL access advisor, and SQL server undo advisor.

TECHNICAL SKILLS

Operating Systems: UNIX - Solaris, HP UX, AIX, Red Hat- 5, 6, 7 OEL-5, 6, and Windows NT/ 2000

RDBMS: Oracle V9i, 10g R1 & R2, 11g R1 & R2, 12C

Software: Veritas Volume Manager 3.5/4/5, Logical Volume Manager, VMware, MS-Office family

Web/Application Servers: Tomcat, Apache, Oracle Enterprise Manager, AWS

Monitoring Tools: HPOM, Nagios, Splunk, HPSA, vROPS

Hardware/Server: Oracle X2/X3/X4 full rack Exadata machine

Tools: SQL*Plus, TOAD, Loader, Grid Control, SQL*Loader, RMAN, RAC, Exadata, GlodenGate. Tracing, StatsPack, Explain-Plan, AWR, Scheduler, Data Pump, Shell Scripting, ASH

PROFESSIONAL EXPERIENCE

Confidential, Collierville, TN

Sr. Database Engineer

Responsibilities:

• Ensuring High Availability and Performance support for Production databases.
• Maintaining high transaction financial RAC and Data Guard databases to avail them 24x7x365.
• Managing all database objects in very large mission critical systems and provide end to end administration support.
• Monitoring databases and performance tuning enhancements to optimize the performance and secure access wif minimal downtime for ODA Maintenance. l Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects. Assisted in integration of Exadata applications into current IT actionable events and solutions.
• Part of team that successfully installed, validated and deployedExadataX2-2, X3-2 and X4-2 quarter, half and full rack for various clients
• Migrated over 500 databases Exadata, RAC and single instance database for multiple clients
• Successfully utilized rman restore,external tables, gloden gateand data pump for several multi-tera byte database migration to Exadata and other databases
• Strategic involvement wif team for Server virtualization and manageability of infrastructure.
• Continuous monitoring of Oracle Enterprise Manager 12c for production databases and check for Oracle alert logs for the database errors.
• Maintaining Real Application Clusters (RAC) wif 2 and 4 node clusters while administrating over 7000 databases.
• Migrating Oracle databases from Non Exadata machines to Exadata using Data Pump and GlodenGate procedures.
• Installing and Configuring Oracle 12c GlodenGate to Oracle 12c databases using Oracle Universal Installer Utility (OUI) and enable real-time data integration and continuous data availability by capturing and delivering updates of critical information as the changes occur and providing continuous data synchronization across environments.
• Implementing Oracle Enterprise Manager 12c Repository database, OEM 12c Agent and gloden gate plugin Installations.
• Configuring Automatic Storage Management (ASM) and handling issues by suggesting feasible workarounds for ASM Metadata corruption.
• Extensively working wif ASMCMD for managing ASM.
• Working on upgradation of oracle 11g databases to oracle 12c wif the halp of Database Upgrade Assistant (DBUA).
• Working on designing and rolling-out the Oracle 12c databases for Test/Development and QA environments.
• Backup of Database (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.) as per Service Leasing Agreement (SLA).
• Streamlining 12c and 11g databases wif Data Guard wif one physical database as a standby database.
• Design, configure and maintain backup and recovery policies including Recovery Manager (RMAN) backups.
• Use Oracle 11g/12c AWR & ADDM to monitor database activities and performance tuning.
• Perform query tuning by using tools like Explain Plan, SQL*Trace, TKPROF.
• Proactive performance monitoring, and capacity planning for future database and server growth using OEM.
• Perform Cross platform migration using transportable table spaces and RMAN.
• Transforming logical database designs into physical databases using ERWIN Data Modeling Tool.
• Coordinate strategies to move data between databases using Data Pump utilities like ExpDP/ImpDP.
• Working noledge of multi-tier web application on to AWS cloud for which me need to automate the required configurations using Terraform and Chef.
• Working experience on architecting, designing, implementing and supporting of cloud based infrastructure and its solutions.
• Perform Patch Set Updates (PSU’s) and Critical Patch Updates (CPU’s) to databases to keep them up-to-date to maximize the performance and reduce the bugs from previous builds.
• Provide technical analysis and solutions to issue and technical direction.
• Provide on call support by rotation 24/7.

Environment: Red hat Linux 5/6, OEL 6, UNIX, and SunOS, Oracle 11 g R1/R2/12c, VMWare ESX 4.x, Shell Scripting, and Nagios.

Confidential

Sr. Database Administrator

Responsibilities:

• Manage day-to-day database support and operations.
• Providing *24/7 Support on Production instances.
• Analyzing various types of traces generated in databases e.g. ora-04030/31, ora- 00600/07445.
• Decommissioning and build the data base
• Check out crs status and Administration of RAC Instances using SRVCTL Utility.
• Managing of Tablespaces for Different User by Granting Quota on Default & Temporary Tablespaces.
• Managing Redo Log files in Archive log Mode for Online Backup.
• Improving existing support/operations processes and defining new for high availability/performance of databases
• Capacity planning of the database.
• Taking a backup of export and import using data pump
• Database refresh, Schema refresh and table restore using data pump.
• Creating of database indexes on certain tables to improve query performance after thoroughly testing the same in the development environment.
• Planning for backup and recovery of database information.
• Cloning from cluster database to Normal database for test environment.
• Handling escalation calls/issues. Working wif Application team/management for RCAs and fixing major long running issues.
• Resolving issues related to Database administration, backup, recovery, performance, Installation, RMAN Cloning the database though RMAN as per the requirement.
• Scheduling the jobs at database level.
• PSU/CPU patches application. Version upgradation of databases
• Creation of oracle roles, granting privileges and profiles etc.
• Implement backup strategies (regular Hot and Cold backups and logical backups.)
• Managing undo segments redo logs, Checking alert log and trace files for errors.
• Development and Implementation of Database Backup Strategy, hot & cold Backups.
• Configured Oracle11g database server using Net Manager tool/creating Configuration files such as LISTENER.ORA
• Database recovery, moving data files to different locations.
• To Check Alert Log errors and to make necessary actions to rectify them.
• Taking Cold Backups.
• Export/Import of Tables, Users and Databases.
• Recovery of lost objects and data files.
• Backups using RMAN and Incremental Backups.

Environment: Environment: Red hat Linux 5/6, OEL 6, UNIX, and SunOS, Oracle 11 g R1/R2/12c, VMWare ESX 4.x, Shell Scripting, and Nagios.

Confidential

Database Administrator

Responsibilities:

• Providing *24/7 Support on Production instances.
• Handling dbs using Grid Control
• Managing Redo Log files in Archive log Mode for Online Backup.
• Monitored table spaces & their growth and took proper actions.
• Taking a backup of export and import using data pump
• Database refresh, Schema refresh and table restore using data pump.
• Creating of database indexes on certain tables to improve query performance after thoroughly testing the same in the development environment.
• Planning for backup and recovery of database information.
• Cloning from cluster database to Normal database for test environment.
• Maintaining archived data on appropriate storage devices.
• Backing and restoring the database using RMAN
• Cloning the database though RMAN as per the requirement.
• Load balancing across the instances.
• Tacking backup of OCR and CSS files using cluster utilities.
• Managing of Tablespaces for Different User by Granting Quota on Default & Temporary Tablespaces.
• Backing up Non- Critical databases wif the halp of Cold and Hot Backup processes.
• Used Net Configuration Assistant (NETCA) and Net Manager (NETMGR) to create Listeners, Net Service Name configuration and Naming methods configuration.
• Solved many user management issues like account unlocking and changing passwords where ever necessary.
• Implemented traditional export (EXP) and import (IMP) techniques to back up the logical structures of the databases.
• Also used the Data Pump method of export (EXPDP) and import (IMPDP) to refresh the databases.
• Daily Health Check Up of the Database using Automatic Database Diagnostic Monitor (ADDM) wif the halp of Automatic Workload Repository (AWR) report.

Environment: Red hat 3.x, 4.x, 5.x, Solaris 8,9,10,, Oracle 9i/10g,11g R1, Tivoli Storage Manager 5.x, VMware 2.x, Shell Scripting.

Confidential

Associate Database Administrator

Responsibilities:

• Installing Configuration and maintenance of Solaris 9/10/11, RedHat Linux 4/5/6, SUSE 10.3, 11.1, HP-UX 11.x and IBM AIX operating systems.
• Installed Oracle10g and Created the database
• Design and physical layout of the server
• Creating Oracle users and assigning roles and privileges
• Created separate tablespaces for various users.
• Trained user on several topics like backup, recovery, troubleshooting for most common problems and daily checkup of database.
• Providing 24/7 on call Production support.
• Managing Redo Log files in Archive log Mode for Online Backup.
• Monitored table spaces & their growth and took proper actions.
• Taking a backup of export and import using data pump
• Database refresh, Schema refresh and table restore using data pump.
• Creating of database indexes on certain tables to improve query performance after thoroughly testing the same in the development environment.
• Performed patching, backups on multiple environments of Solaris, Linux and VMware.
• Assisted other UNIX administrators when halp was needed (me.e. creating UNIX accounts, writing scripts to perform system administrator functions, responding to trouble tickets, etc).
• Involved in preparation of functional and system specifications. Estimated storage requirements for applications.
• Planning for backup and recovery of database information.
• Cloning from cluster database to Normal database for test environment.
• Maintaining archived data on appropriate storage devices.
• Backing and restoring the database using RMAN
• Cloning the database though RMAN as per the requirement.
• Load balancing across the instances.
• Tacking backup of OCR and CSS files using cluster utilities.
• Managing of Tablespaces for Different User by Granting Quota on Default & Temporary Tablespaces.

Environment: RHEL 3, 4, 5, Oracle 10g/11g, VMware, Shell Scripting.