SUMMARY

• Oracle Certified Professional (OCP) with more than 15 Years of experience as Oracle Database Administrator in both SAP and non - SAP RAC environments providing 24/7 Production support for Oracle databases 12c/11g/10g/9i on various Unix platforms like Solaris, HP-UX, Linux and Windows
• Extensive experience in Installations, Configurations, Cloning, Patching, Upgrades, Performance Tuning, Backup-Recoveries, Data Archiving, DB Monitoring, Space and Capacity Management, User Management, Index Management, Managing Data Dictionary Objects, and Database Troubleshooting with SAP and Oracle tools.
• Experience in full life cycle SAP implementation project.
• Experience in deploying and configuring HA/DR with Data Guard and RAC configurations.
• Experience in deploying secondary and disaster sites with physical standby databases using Data Guard
• Designed and implemented Oracle Real Application Clusters (RAC) on OEL for a high transaction volume OLTP application with Transaction Application Failover with ASM storage.
• Experience with using Oracle EXADATA Deployment Assistant (OEDA) and SAP provisioning manager (SWPM)/SAPInst installing SAP database on ASM with RAC.
• Experience in Upgrading Oracle databases (11g to 12c, 10g R2 to 11g, 10g R1 to 10gR2, 9i to 10gR1).
• Experience with RMAN/BRTOOLS cloning, backup and recovery configurations
• Responsible for applying patches using standalone OPATCH or via OEM Grid Control
• Experience in Data Migrations using SQL Loader and DATA PUMP
• Excellent working experience on EMC storage, Hitachi Storage with NetApp and ASM Storage technologies.
• Experience with Advanced Oracle Tuning, Partitioning, Security Management and Compression techniques.
• Expertise in supporting replication with snapshots, Materialized Views and Streams.
• Experience in using OEM, TOAD, OEM Grid Control Data Patches using OPATCH and Data Migrations using export/import, expdp/impdp and benchmarking using Load testing tools
• Experience in Database level tuning using SAR reports, TOP, IOSTAT, VMSTAT, Session wait monitoring etc
• Code level PL/SQL tuning using Explain Plan with efficient usage of query level optimizer HINTS
• Implemented strategy for partitioning and management of historical data tables in non-RAC and RAC DBs.
• Excellent working experience on EMC storage, Hitachi Storage with NetApp and ASM Storage technologies.
• Experience in installation and configuration of Real Application Clusters (RAC) - Configured multi node RAC environment along with implementing Cisco WAN technology optimizations to reduce network traffic.
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.

TECHNICAL SKILLS

Operating Systems: HP-UX 11, Red Hat Enterprise Linux RHEL 3.x/4.x/5.x/6, Sun Solaris OS 5.9/5.10/5.11

SAP: NetWeaver 7.0/7.4, ECC 6.0, BRTOOLS, BW, BI, CRM, Solution Manager

Databases: Oracle 7/8/8i/9i/10g/11g/12c, Microsoft SQL Server 2000/2005/2008/2012, SQL Litespeed

Database Management: TOAD 9/10/11, OEM 9.2/10g/11g Grid control (RAC)

Virtualization: VMWARE, Oracle VM Server for SPARC

Tools/Utilities: Oracle Management Server, DBCA, DBUA, DBVERIFY, OUI, ORAPWD, SQL*Loader, Export/Import, TOAD, Data Pump, Query builder, Crystal Report, Putty, RAT

Backup Tools/Utilities: SQL Backtrack, Hitachi Universal Replicator (HUR) Shadow Image, RMAN, EMC clone snapshot BCV, EMC RecoverPoint, NetApp, VERITAS NetBackup, IBM Tivoli Storage Manager, HP Omni back up

Data Modeling: Erwin, Power Designer, Toad Data Modeler and Oracle SQL Developer

Programming: SQL, PL/SQL, C, C++, UNIX Shell Scripting, PERL, Bourne

Familiarity: Oracle GoldenGate 11g, Power Builder 7/10, HTML/5, JavaScript, PHP, Java, .Net C#, Visual Basic

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Senior Oracle DBA Team Lead

Responsibilities:

• Installation with OEDA and SWPM/SAPInst
• Installation of OPATCH utilities and SAP bundle patch for Oracle EXADATA.
• Migration of SAP databases with RMAN duplicate from active database enabling online copy

SAP DB Administration

Confidential

Responsibilities:

• Oracle DB installation and configuration for SAP ECC 6.0 on HP Itanium/EXADATA servers.
• Daily SAP System Monitoring using CCMS, DBACOCKPIT, DB03, DB12, DB13, DB24, DB26 etc.
• Data migration activities using DMIG coupled with Oracle DATA PUMP
• Defining and monitoring database background jobs using SM36, SM37 etc.
• Analysis for SAP system performance issues using ST04, ST05, ST06 etc
• Instance, Segment, Performance monitoring using BRTOOLS
• Scheduling backups and performing recovery using BRTOOLS and RMAN
• Fast database cloning with Oracle RMAN DUPLICATE for dev and test system refresh
• Monitor ABAP dumps, System Logs, Update failures, System workload, work processes and Database space, Locks, performance etc., using DBACOCKPIT etc
• Periodic database reporting of service levels with SAP Early Watch Alert data
• Transporting the changes using STMS between the systems in the landscape.
• Downloading database related support packages and SAP Notes from SAP marketplace.

Oracle DBA

Confidential

Responsibilities:

• Responsible for 24x7 Oracle Production, development and test Database Administration of Oracle 12c/11g/10g RAC and non-RAC database configurations
• Upgraded database instances from 11.2.0.1.0 to 11.2.0.4 and 11.2.0.4 to 12.1.0.1.0.
• Experience with maintenance of Disaster Recovery and High Availability solutions with Oracle 11g RAC, Physical and Logical Standby Databases with Data Guard
• Extensive experience with monitoring and performance tuning using AWR, ASH, OEM Grid, SQL Trace and TKPROF
• Experience in Script Programming using Korn shell, bash shell, Perl. And knowledge of archiving tools like file archiver, tar, gzip etc on various Unix/Linux platforms
• Experience with Oracle 10/11g features: Flash-Back Recovery, Data Pump, CRS, ASM, ASH, AWR, ADDM, ASSM, ASMM, Automatic Undo management, Grid Monitoring and Recycle Bin.
• Experience with Transparent Data Encryption (TDE) and data redaction to make database PCI compliant.
• Experience in identifying TOP SQLs consuming OS and database resources and perform tuning using Unix/Linux utilities like SAR, IOSTAT, TOP, VMSTAT etc and database utilities like STATSPACK, AWR and custom scripts
• Member of database change review board (DCRB) which reviews changes to database objects by business applications. Data modeling, table design and review of PL/SQL code are some of the development related activities.
• Experience with range and list table level partitions to improve query performance and manageability.
• Work with System Administrators in defining and standardizing backup and recovery procedures depending upon Business Strategy - Configured Daily Backup, weekly Backup etc using RMAN/BRTOOLS/Hitachi Shadow Image.
• Developed scripts and database performance reports using SQL, PL/SQL and Perl.
• Automated the process of analyzing tables and tablespace every night with CRONTAB
• Deploy new database objects like tables, indexes, views, synonyms, sequences into dev, test and production DBs.

Environment:Landscape: 15 production databases instances sized from 40 GB - 20 TB with corresponding dev and test instances.

Confidential, Town and Country, MO

Senior Oracle DBA (Remote)

Responsibilities:

• Involved in Datacenter site identification, hardware procurement and maintenance contract negotiations
• Primary to Secondary physical standby setup with synchronous maximum availability configuration
• Secondary to DR physical standby setup with asynchronous configuration
• Oracle 11.2.0.1 DB installation and configuration on new HP Itanium servers
• Applied CPUs and PSUs using standalone OPATCH and via OEM Grid Control using MOPATCH.
• Daily SAP System Monitoring using CCMS, DBACOCKPIT, DB03, DB12, DB13, DB24, DB26 etc.
• Experience with defining and monitoring database background jobs using SM36, SM37 etc.
• Experience with analyzing SAP system performance issues using ST04, ST05, ST06 etc
• Created RFC connections using SM59 in place of database links for information exchange between SAP systems.
• Worked with Hitachi Universal Replicator, RMAN and DATA GUARD to setup HA/DR sites.
• Responsible for monitoring, trouble shooting and maintenance of Oracle database production, development and test 11g/10g RAC and non-RAC database configurations
• Cloned active production databases using RMAN DUPLICATE for test refreshes.
• Refreshed dev and test databases using DATA PUMP, RMAN and Recover with backup control file methodology.
• Upgraded database instances from 11.2.0.1.0 to 11.2.0.4
• Day to day monitoring like availability of system, listener, databases, alert log files, trace files.
• Experience with point in time recovery of data using flashback technology
• Experience with point in time recovery of data and database objects using RMAN with recovery catalog/control file.
• Setup numerous schema export and import jobs using DBMS SCHEDULER and ControlM tool.
• Deployed business application PL/SQL code into dev, test and production during scheduled releases
• Setup logon triggers and audits using DBMS FGA to make database SOX compliant.
• Employed Oracle advanced compression techniques to optimize storage and standby redo.
• Landscape: 15 production databases instances sized from 40 GB - 5 TB with corresponding dev and test instances.
• DB Versions: Oracle 11.2.0.1.0/11.2.0.4.0

Confidential, Columbus, OH

Senior Oracle DBA

Responsibilities:

• Responsible for installation, maintenance, and troubleshooting and performance administration of Oracle 11g
• Responsible for managing, troubleshooting and resolving oracle database, RAC, non-RAC and applications issues.
• Responsible for refresh of production databases into dev and test instances for development and testing purposes.
• Experience with applying patches using OPTACH on both non-RAC and RAC instances.
• Experience with upgrading oracle databases from Oracle 9i to Oracle 10g.
• Responsible for working with System Admins in monitoring and scheduling Online and Offline database backups.
• Responsible for monitoring performance and availability of customer facing high availability web-based applications running Oracle9i/10g RAC on HP-UX cluster with disk spindles on EMC SAN
• Responsible for managing RMAN for small DBs and User Managed backup methods like SQL Backtrack and EMC BCV for VLDBs with EMC RecoverPoint for better plan and control.
• Generate and analyze STATSPACK reports and monitor statistics for performance tuning of the database.
• Review alert logs and dump files to check for any problems related to the database/user.
• Perform database cloning/exp/imp to setup identical databases in the production and development environments.
• Upgrade/Migrated the production and development databases from 9i to 10g.
• Identify Top SQL that are consuming heavy resources and provide support to the development team in identifying SQL queries that are consuming high resources and to see if these queries can be fine tuned for better performance.
• Presenting user-friendly reports, and providing training to end users on reporting functions.
• Involved in monitoring the lock/block processes, releasing locks in case of resource blockage and gathering statistics.
• Net8 Configuration for Clients Connection including creating ODBC for users and Application Developers.
• Establish remote database access via public and private database links
• Database user administration with Help Desk tickets created using Remedy tools.
• Create database objects and managed the permission access on the objects with necessary security roles.
• Quarterly deployment activities to create database objects like tables, indexes, views, synonyms, sequences.

Environment: Landscape: 15 production databases instances sized from 40 GB - 5 TB with corresponding dev and test instances.