SUMMARY

• Over all 18+ years of IT experience as an Oracle Database Administrator providing 24/7 production and development support of Oracle 12c, 11g RAC,10g RAC, 9i, 8i, 7.x.
• Proficient in Database Administration activities such as installation, database creation, sizing, backup and recovery, performance tuning and capacity planning.
• Experience in query optimization, cloning, patches, up gradation, migration, troubleshooting, TAR support, space management and UNIX Shell Scripting.
• Excellent experience as an Oracle DBA in various platforms such as Sun Solaris, HP - UX, AIX, Red Hat Linux, Windows etc.
• Plan, install, configure and perform upgrades of Oracle software on various platforms.
• Implementation of high availability solutions with Oracle 10g RAC, Physical and Logical Standby database(Data Guard), Materialized views, VCS, Streams Replication, Golden Gate.
• Experience in database administration of OLTP and Data Warehousing applications.
• Experience with Systems Analysis, Design and Data Modelling.
• Backup and recovery with RMAN.
• Recovery of Databases (Recovering from Media failure, Recovering Tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.).
• Excellence in Performance Tuning using STATSPACK, TKPROF, EXPLAIN PLAN, SQL TRACE, AWR, ADDM.
• Proactive monitoring, identifying areas that need to be improved in the application and database using AWR, ADDM and OEM Grid Control.
• Experience with writing PL/SQL Packages, Stored Procedures, Functions and Database Triggers.
• Proficient in SQL, PL/SQL Programming, Shell Scripting and analyzed Batch programs.
• Worked on 4 nodes Linux RAC with ASM.
• Expert experience in Hot and Cold Backup and Recovery, cloning of databases using RMAN, VERITAS NetBackup and IBM Tivoli Storage Manager (TSM).
• Used DataPump (expdp, impdp) to take backup at database level or tablespace level and also to accomplish table level and full database de-fragmentation.
• Proficient in using various database Utilities like EXPORT/IMPORT, Datapump, TOAD and SQL*Loader.
• Experience in Extracting, Transforming and Loading (ETL) data using SQL loader, External Tables and PL/SQL.
• Experience with oracle ERP and interfacing with Oracle ERP.
• Automated many common tasks using crontab including Backups, exports and imports, archiving old records and verification of such processes.
• Worked on OLTP/DSS database systems, implementing and managing Large Oracle databases (VLDB).
• Expertise on upgrading and patching of CRS, ASM and Oracle RDBMS.
• Fair Knowledge of SQL Server, MySQL, Big Data.
• Worked on different types of storage structures (SAN/NAS).
• Strong analytical and problem solving skills, a very good team player and also has the ability to work independently when needed and a quick learner of new technologies.
• Excellent written and verbal communication skills.

TECHNICAL SKILLS

Operating System: Sun-Solaris, HP-UX, AIX, Red Hat Linux, MS Windows

RDBMS: Oracle 7.2 to 12c, MYSQL and SQL Server

Web Servers: Apache Webserver, OEM(Oracle Enterprise Manager),Oracle Web Server, BEA WebLogic, and Java Web Server, iPlanet Web Server

Languages/Packages: .NET, Java, PL/SQL, Pro*C, Developer 2000 (all tools), Designer 2000, DBArtisan, TOAD, ERWIN, Discoverer, HiveQL, HBase

Other: Veritas Clustering, RAID (Redundant Array of Independent Disks), PCI/SOX compliance, Big Data, Service Now, Remedy Identity Manager, Remedy IT Service Management.

PROFESSIONAL EXPERIENCE

Confidential, Raleigh, NC

Lead Database Administrator

Responsibilities:

• Oracle DBA for 11G with Data Guard (1300 plus)
• Set up Data Guard for Primary databases using production backup and BCV.
• Maintaining and troubleshooting more than 1300 Data Guard instances.
• Established stabilization plan, where we picked 5 worst application and made them perfect module for rest of application.
• Takes ownership of assigned responsibilities and follows through to effective solution
• Work closely with the Infrastructure, Operations, and SW Engineering staffs as needed to help troubleshoot and maintain production databases and to resolve production outages.
• Communicate complex technical information in a timely, concise and coherent manner.
• Regulate RCA(Root Cause Analysis) meeting and start doing documentation about every problem.
• On-Call every 3rd week.
• Enhanced/tuned many batch processing databases jobs.
• Tuned databases by setting SGA size, storage and tuning init parameters.
• Created automatic report for Capacity Planning.
• Improved Backup and Recovery procedures by using new and improved RMAN scripts according to Oracle Standards.
• Maintain and used Grid Control
• Earned a reputation as the performance tuning guy.
• Guidelines for offshore DBA's.

Environment: Oracle 11g/12c, AIX, RHEL, OEM Grid Control 12c, RMAN, Flashback, ASM.

Confidential, Knoxville, TN

Sr. Database Administrator

Responsibilities:

• Set up 11g Release 1 RAC on Sun Solaris and migrated data over to RAC db.
• Set up 11g Release 2 db instance on RHEL and migrated data from RAC to here.
• Cross platform migration of Oracle 10g db from Sun-Solaris to RHEL.
• Setup Oracle standards for creating databases, Backup & Recovery and RCA.
• Rotated between Prod and Dev/application DBA every 6 months.
• On-Call every 4th week.
• Did Deployments of Application Code.
• Performed Tuning for PL/SQL code, SQL's and worked on with AD team on different issues.
• Setup Backup and Recovery using RMAN for many databases.
• Configured and setup Grid Control with HA(DataGuard).
• Migrated some warehouse data to Hadoop and created business critical reports based on that.
• Restored oracle db tables in minutes using flashback for critical application.
• Upgraded db from 10g to 11g using Rolling Upgrade with Oracle Data Guard, which brought downtime from days to 5 mins.
• Supported and maintained MySQL Databases.
• Created MySQL databases.
• Trained junior DBA's.

Environment: Oracle 9i/11g, SunOS 5.10, RHEL, OEM Grid Control 10g/11G/12c, RMAN, Flashback, ASM, MySQL.

Confidential, Orlando, FL

Sr. Team Lead Database Administrator

Responsibilities:

• Capacity Planning, performance tuning for databases, backups and middle layers ODBC drivers.
• Configured Grid Control for proactive messages and alerts about DB issues

Environment: Oracle 9i/10g, SunOS 5.10, AIX, HP, Linux, MS Windows and Oracle Enterprise Manager 10g Grid Control, RMAN with Veritas Netbackup.

Confidential, Knoxville, TN

Database Administrator Production & Dev

Responsibilities:

• Backup & Recovery, Performance Tuning, Space Management. On-call rotation
• Installed and Configured 10g on RAC and Non-RAC, ASM on Raw devices
• Migrated Oracle DB from 8i to 10g.
• Shell scripting and some system administration.
• Installation of Oracle software and creation of test and production instances.
• Prepared Disaster Recovery Plan
• Database design using ERWIN for forward and reverse engineering.
• A lot of coding in Oracle Forms 6i in early years at this company, PL/SQL coding.

Environment: Oracle 10g (with RAC, ASM, Raw devices), SunOS 5.10, RHEL, Oracle Enterprise Manager 10g Grid Control, OID, MS windows, Oracle 8i (with Veritas clustering, EMC storage), Oracle Forms, Oracle Application 11i, .NET, Java, RMAN with Legato.

Confidential, Sacramento, CA

Oracle DBA/Oracle Web DBA

Responsibilities:

• Conversion of existing application from Perl and Flat file system to an N-tier Oracle e-commerce application and plus putting some new features and making web-sites more flexible due to database.
• Converted the Sybase data into Oracle database.
• Data modeling, physical database design, installation of Oracle 8i database, backups and recovery, security strategy implementation and performance tuning.
• On-Call rotation
• OEM used to for the multi-master replication sites, events.
• Installed Oracle8i 8.1.5 on Sun-Solaris 5.7 and Windows 2000 and configured for production.
• Physical/Logical database design, backups and recovery, Upgrade of Oracle database from 8.1.5.0.0 to 8.1.6.0.0, security strategy implementation and performance tuning of the database and Advanced replication environments.
• Conversion from Btrieve to Oracle database.
• Data import from flat file to Database done using SQL*Loader

Environment: Oracle8i, OEM, ERWIN, Web Logic Server, Windows 2000, Sun Solaris OS 5.7/ Compaq Server, Red Hat Linux, JDBC, Oracle Spotlight from Quest, CVS, Windows NTHCL Infosystem Ltd(Core), India