SUMMARY:

• 8+ years of experience as an Oracle core/apps DBA, implemented business systems under various platforms to handle all database administration activities including database design, installation, upgrades, patching, scheduling backups/recovery and maintenance of high availability databases using Data Guard / Standby and RAC (Real Application Clusters & GRID Infrastructure).
• Involve in Disaster management and High Availability of production environments. Managing password security and user roles.
• Understanding the pre - requisite for installing oracle software on Windows and Unix operating systems.
• Oracle database creations on unix flavors/windows systems including build, administration and troubleshooting.
• Experience in implementing Oracle Advanced Security, replication and administering RDBMS Oracle 9i/10g/11g/12c including SQL within enterprise-wide database environment and critical large OLTP systems.
• Production DBA Support for 11g/10g RAC Multi Node configuration and experience in database change/data management through the various stages of Production Full Life Cycle support.
• Migration, Upgradation works of all critical Production Databases from 10g to 11g RAC/Non-RAC on different OS platforms (HP-UX, RHEL, OEL, Solaris, IBM AIX, Windows server).
• RMAN backup and recovery configuration using IBM TSM and Veritas net backup.
• Implementing Oracle 10g, 11g clusterware/grid environment with ASM.
• Clone/refresh UAT and development environments from production database using RMAN backup based or Active duplication methods
• Experience in system design and implementation of databases on storage solution using SAN.
• Migration of databases from single instance architecture to Real Application Cluster.
• Database Advanced Security and performance tuning in analyzing and tune PL/SQL scripts.
• Implement, maintain physical/logical standby databases and monitoring of Data Guard configurations using OEM (GUI) or DGMGRL (CLI).
• Knowledge on Goldengate installation, configuration and maintenance.
• Experience in shell scripting and data loading using SQL*LOADER.
• Cloning oracle EBS applications and applying application patches by adpatch

TECHNICAL SKILLS:

RDBMS: Oracle 9i/10g/11g/12c versions

Languages: SQL, PL/SQL, Unix shell scripting

High Availability: Data guard, Golden gate

Tools/Packages: RMAN, OEM, Datapump, Grid control, TOAD, ASM, Data guard broker

Operating System: RHEL, OEL, IBM AIX, HP Unix, Solaris 10, Windows Server 2003, SQL server 2008

Others: VMware workstation/server, Virtual Box

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

Sr. Database Administrator

Responsibilities:

• Developed PL/SQL code to capture encryption and scrambling table/data activities by scheduling an automated jobs. Partitioned large tables to enhance faster querying.
• Tuning of SQL statements & handling performance tuning issues.
• Refresh development databases from production using Mviews, datapump and RMAN.
• Encrypting database exports and RMAN backups, Oracle SQL*Net network traffic
• Setup SSL based authentication for network data and con
• Identify and encrypt critical application tables or individual columns using TDE based
• Applying CPU patches and upgrading databases whenever required.
• Work with change management engineers to support any changes during maintenance windows.
• Involved in disaster recovery testing and high availability of production environments and prepare documents to client for future
• Configured ASM (Automatic Storage Management) which includes creating disks, disk groups for standalone and RAC databases.
• Migrated single instance databases to multi-node 10g/11g RAC for high availability with ASM.
• Configured RAC standby database for RAC primary databases.
• Work with the development team in troubleshooting pl/sql issues and during deployments.
• Experience in Oracle OEM 12c implementation and operations in an enterprise scale.
• Wrote Unix Shell Scripts to process the files on daily basis.

Environment: Oracle 11g RAC/10g, UNIX OS flavors, OEM, SQL*Loader, Data pump.

Confidential, Charlotte, NC

Sr. Database Administrator

Responsibilities:

• Analyzing database performance
• Resolution and tracking of the most complex Oracle issues and communicate critical support issues identified to Oracle Support Services
• Managing escalations for Severity 1 service requests
• Creating problem workarounds for open service requests and monitor service requests and communicating status to others on the team
• Investigating recent SR reports, filing, tracking, reporting SRs and recommending best practices designed to minimize future SRs
• Creating and implementing backup and recovery procedures
• Providing available product-specific white papers and bulletins
• Provide on-call coverage for first response problem tickets for DBMS from Oracle, and patching on UNIX systems
• Handle various large-scale complex data/database management activities including designing physical databases
• Cloned production Databases to the test environment using Recovery Manager (RMAN).
• Refreshing schema's in non-production environment with production backup or using mviews.

Environment: Oracle 11g/10g, UNIX OS flavors, OEM, Data pump.

Confidential, Columbus, OH

Sr. Database Administrator

Responsibilities:

• Created databases from scratch and handle database administration activities.
• Troubleshoot RMAN remote database connectivity issues and database net connectivity issues.
• Installed oracle server binaries and configured RAC with RAC Standby Databases for high availability.
• Upgraded several databases from 9i-10g/10g-11g and converted to RAC database.
• Monitoring the ASM disk groups, add and resize the disk groups monitor the replication between primary and standby and manually apply the missing logs to standby from primary
• Cloned production Databases to the test environment using Recovery Manager (RMAN).
• Database management, backup & recovery activities, performance tuning.
• Troubleshoot RMAN remote database connectivity issues and database net connectivity issues
• Optimize and tune database memory/application for effective enhancement.
• Developed and implemented disaster recovery (DR) Plan for critical databases.
• Experience in identifying performance bottlenecks on high volume transaction systems.
• SQL tuning and refreshing statistics of database objects, including performance tuning database as well as applications by reducing disk contention, fragmentation, tuning SGA.
• Configured and maintained huge OLTP and Data warehouse databases.
• Installed and Configured Oracle EBS R12.1.2.
• Oracle apps R12 Cloning/Refresh
• Migrating a Microsoft SQL Server Database to Oracle Database 11g using developer tool.

Environment: Oracle 9i/10g/11g, RHEL, IBM AIX, HP-UX, Oracle 11i/R12 on IBM AIX

Confidential, Auburn Hills, MI

Database Administrator

Responsibilities:

• Involved in database design, planning and created multiple databases from scratch.
• Installed and configured Oracle 9i & 10g sever binaries on Oracle Enterprise Linux.
• Assisted development team in resolving pl/sql issues during deployments.
• Upgraded databases from 9i-10/11g including version upgrades.
• Applied patches and cloned databases for development needs.
• Migrated sql server database to oracle database.
• Refresh staging databases from production and schemas using datapump
• Monitoring performance using AWR, ADDM reports and resolve locks on database
• Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.
• Installed Cluster software, oracle server on two node boxes, implemented RAC and ASM.
• Upgraded database from Oracle 9i to Oracle 10g RAC on windows
• Setup Golden Gate to execute unidirectional replication and setup user with privileges.
• Troubleshoot complex problems with root cause analysis during product deployment/release.
• Developed database objects like stored procedures, functions, packages and triggers.
• Developed UNIX Shell scripts to automate repetitive database processes.
• Implement a disaster recovery (DR) plan for critical production database
• Installation and Configuration of Oracle EBS.
• Patched the R12 instance for Product enhancements using adpatch.
• Supported SAP application on Oracle databases.
• Worked with latest TOAD 9.6 having new features PLSQL & SQL script debugger, database

Environment: Oracle 9i/10g & 11g RAC, Unix flavors, SAP on AIX, Oracle 11i/R12 on IBM AIX, OEM, PL/SQL developer, TOAD

Confidential

Jr. Database Administrator

Responsibilities:

• Installed oracle server binaries on Linux/Solaris/AIX systems.
• Created 9i Database using DBCA and created tables, indexes, constraints.
• Managed network address information and configuring naming methods.
• Performed daily health check for databases.
• Resolved database and application connectivity issues by modifying TNSNAMES.ORA file.
• Built physical standby database using RMAN online backup of primary database and this test is the simulation of real time FDR scenario as a part of yearly scheduled DR test.
• Upgraded Oracle Database 9.2.0.8 to 10g on Solaris
• Apply interior patches every whenever possible
• Creation of database indexes on certain tables to improve query performance after thoroughly tested the same in the development environment.
• Performed user and table level export/import whenever required.
• Continuous monitoring and tuning of the databases and application using OEM Tuning Pack, diagnostics pack and STATSPACK
• Tuning SQL, PL/SQL queries using hints, explain plan and SQL trace, TKPROF.
• Participate in and sessions.

Environment: Oracle 9i/10g, unix flavors, RMAN, TKPROF, Export/Import.

Confidential

Trainee Software Engineer

Responsibilities:

• Installed RHEL 3/4 oracle 9i server binaries on i386 machine.
• Applied interim (opatch utility) patches on all the databases.
• Migrated oracle 9.2.0.1 to 9.2.0.4 and to 9.2.0.
• Refresh development and test instances with data from Production on a regular basis.
• Monitored the various database activities such as backup, error logs, space, performance, user and session monitoring to ensure proper capacity and availability.
• Scheduled shell scripts for activities like gathering schema statistics, exports, table space usage report using crontab.
• Troubleshoot RMAN remote database connectivity issues and database net connectivity issues
• Upgraded Oracle server Database Version 8.1.7.4 to 9i (9.2.0.4) on Solaris
• Database performance tuning using STATPACK, TKPROF, SQL Trace, Explain Plan
• Linux system installation, configuration, monitoring and troubleshooting.
• Manage setup, maintain groups and user accounts.
• Creating partitions, including DNS, DHCP, Samba Server, Mail Server and Client configuration.
• Experience in creating LVM, creating Quotas and backups

Environment: Oracle 8i,9i, RHEL 3/4, Solaris, TOAD