SUMMARY

• More TEMPthan 15 years of experience as Oracle DBA, providing 24/7 support of test, development and production 12c/11g/10g/9i/8i databases on Various Platforms.
• Excellent experience in Installation and configuration of Oracle 8i/9i/10g/11g/12c on Unix/Linux and Windows
• Designed and implemented Oracle Real Application Clusters (RAC) on OEL for a high transaction volume OLTP application with Transaction Application Failover.
• Experience in installation and configuration of Real Application Clusters (RAC) - Configured 2 node RAC environment for a 3TB database along with implementing Cisco WAN technology optimizations to reduce network traffic.
• Experience in Oracle8i Parallel Server, Oracle9i/10g/11g RAC and other replication methodologies.
• Experience in Upgrading databases (11g to 12c, 10g R2 to 11g, 10g R1 to 10gR2, 9i to 10gR1).
• Proficient in Database Administration activities such as Installation, Upgrades, Patches, Cloning, TAR support, Performance Tuning, Capacity Planning, Partitioning, Script development and Sarbanes Oxley (SOX) documentation.
• Excellent experience in OLTP database systems, implementing and managing large Oracle databases (VLDB).
• Collaborated with Oracle support on critical and significant level bugs and issues
• 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.
• Implemented DR and high availability solutions using Oracle RAC and Standby Database using Oracle Data Guard
• Expertise in supporting replication with snapshots, Materialized Views and Streams.
• Experience in using OEM, TOAD, 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
• Expertise in maintaining Database Security using DBMS FGA auditing.
• Experience with SQL, PL/SQL coding, stored procedures, triggers, functions, packages, UNIX Shell Scripting, Partitioning, Indexes, Logical and Physical database design.
• 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 in Advanced Replication including synchronous and asynchronous scenarios
• Experience with Oracle 10/11g features: Flash-Back Recovery, Data Pump, ASM, ASH, AWR, ADDM, ASSM, ASMM, Automatic Undo management, Grid Monitoring and Recycle Bin.
• Knowledge of Data transfer between SQL Server and Oracle.
• Ability to function successfully in a highly stressful, 24x7 mission critical environment.
• Excellent analytical and problem-solving skills.
• Result oriented, self-motivated, team player with ability to work independently.
• Excellent written and verbal communication skills.

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

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

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

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 Others: SQL, PL/SQL, C, C++, UNIX Shell Scripting, PERL, Bourne

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

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Manager DBA Services

Responsibilities:

• Responsible for 24x7 Oracle Production Database Administration including Oracle 10g/11g RAC and non-RAC DBs.
• Responsible for managing, troubleshooting and resolving oracle database, RAC and applications issues.
• Responsible for Upgrade/Migration of the oracle databases from Oracle 10g to Oracle 11g using OUI and DBUA
• Responsible for applying security and critical patches using OPATCH utility.
• Responsible for implementation of Disaster Recovery and High Availability solutions with Oracle 11g RAC, Physical and Logical Standby Databases using Data Guard
• Responsible for database change review board (DCRB) process which reviews back-end logic developed for business applications using SQL and PL/SQL code in turn deploying tables, views, procedures, indexes, triggers etc.
• Responsible for performing monitoring and performance tuning using AWR, OEM Grid, SQL Trace and TKPROF
• Established best practices and best procedures for database administration.
• Responsible for Software life-cycle support to include migration of all custom application changes through four different instances to production.
• Developed 2 node RAC environments for a 3TB database and implemented Data guard on dis RAC environment with another RAC physical read-only standby database.
• Monitored the 2 node RAC database using OEM Grid control configured with RMAN database backup and recovery.
• Worked alongside programmers and contributed to the development process; Enabling and analyzing trace files
• Worked with System Administrators in defining and standardizing backup and recovery procedures depending upon Business Strategy: Daily Backup, weekly Backup etc.
• Identify TOP SQLs consuming OS and database resources and perform database level tuning using Unix/Linux utilities like TOP, VMSTAT etc and database utilities like STATSPACK, AWR and custom scripts
• Responsible for continuous database monitoring and reorganization for ensuring performance
• Responsible for tuning and balancing me/O by monitoring file system and tablespace me/O statistics.
• Responsible for writing Shell Scripts for managing day-to-day activities and automation of backup for small DBs.
• Responsible for monitoring optimal space utilization in tablespace to avoid fragmentation.
• Implemented range and list table level partitions to improve query performance and manageability.
• Developed scripts and database performance reports using SQL, PL/SQL and Perl.
• Installation and configuration of Oracle Client software and Tools.
• Automated the process of analyzing tables and tablespace every night.
• Supported fail over procedures by writing shell scripts to support HP Service Guard, Oracle shutdown, listener shutdown, and other application processes linked to the database
• Developed SQL Loader scripts to extract, transform and load (Call Records/Routing) data into tables
• Day to day monitoring like availability of system, listener, databases, alert log files, trace files.
• Created database objects like tables, indexes, views, synonyms, sequences (Change Requests)
• Database user administration with Help Desk tickets created using Remedy tools.
• Installed and configured Oracle GlodenGate in development Oracle EXADATA sand box as part of a proof of concept server upgrade initiative
• Responsible for establishing standards, policies and procedures for GlodenGate replication administration.
• Responsible for planning, installing and configuring GlodenGate 11g on Oracle Servers

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

Confidential, Columbus, OH

Senior Oracle DBA / Team Lead

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.
• Responsible for applying patches using OPTACH on both non-RAC and RAC instances.
• Responsible for 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
• Implementation and Configuration of OEM and Oracle Management Server for maintenance and monitoring.
• Responsible for performing daily archive log file backup and checking alert log files.
• Monitoring the table space growth and resizing the table spaces in 9i/10g/11g RAC environment.
• 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.
• Involved in Database sizing and Capacity Planning.
• 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. 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.

Oracle DBA

Confidential

Responsibilities:

• Designed, developed, and implemented two critical systems for Database replication and job scheduling
• Systems facilitated row-level replication, procedure-level replication, offline instantiation, serial propagation and parallel propagation with scope for conflict resolution. Oracle parallel propagation was used to improve the performance of replication among machines.
• Designed, coded and tested functional PL/SQL stored procedures, triggers and functions
• Created snapshots and scheduled nightly refreshes.
• Implemented processes for Compliance with Y2K standards
• Implemented auditing using in-built mechanisms of database audit control
• Created replicating Unix scripts for database synchronization scheduling
• Provided solutions to optimize query’s - such as missing indexes and poorly constructed queries.
• Assessed available system memory, CPU, and me/O when queries were sampled.
• Identified TOP resource consuming queries and optimized query performance at various times
• Performed data modeling and database architecture design using Oracle Designer/2000 CASE tool
• Identified database architecture strengths and weaknesses
• Involved in standardization of database object architecture, naming conventions, and relationships

Environment: Oracle 8i, Power Builder 5