SUMMARY:

• Over 8 years of experience as an Oracle Database Administrator, with hands on experience in Installation, Implementation, Production support, Backups and Recovery, High Availability, Migrating, Upgrading, Patching, Performance Tuning and Storage Management of Oracle databases on Unix and Windows platforms.
• Experience as Oracle DBA (11g/10g/9i) on Linux, HP - UX, Solaris, AIX and Windows 2000/NT platforms.
• Installed, Implemented and Supported High availability architectures - Exadata, Real Application Clusters (RAC), Datagaurd and Automatic Storage Management (ASM).
• Worked on RAC (10g/11g) Installation, Administration, Troubleshooting and Performance Tuning.
• Good experience in implementing Disaster Recovery for RAC databases on Exadata platform using RMAN and Datagaurd (Standby).
• Worked on Very Large Databases (VLDBs) - Data warehouse, OLTP and hybrid environments (OLTP+ Data warehouse).
• Good experience on replicated database environments, data warehousing, partitioned databases.
• Worked on database migrations from single instance databases to multiple instance RAC databases, cross platform migrations and migration from single instance databases to Exadata RAC databases.
• Upgraded Exadata X2-2 half racks to full racks, applied patches to database servers and cell servers, performed cell servers storage expansion.
• Experienced with Golden Gate replication. Maintained and tuned existing Golden Gate replications and supported implementation of new Golden Gate setups.
• Implemented backup strategies, Hot/ Cold backups and Incremental/Full backups. Automated RMAN backup jobs using UNIX shell scripts and Cron utility and also through Oracle Enterprise Manager (OEM).
• Tuned oracle databases and applications, using Tuning Tools like OEM GC, SQL analyzer, Performance Manager, Statspack, AWR, ADDM, ASH, Explain plan, TKPROF and SQL TRACE
• Utilized traditional Export/Import and Datapump EXPDP/IMPDP utilities to perform Database migrations, On- Demand Backups (Schema, Tablespace, Tables etc..).
• Applied Patch sets, Patches, Critical Patch Update (CPU)/Patch Set Update (PSU) and One-off Patches using OPatch and runInstaller on UNIX and Windows platforms.
• Installed Oracle 10g and 11g Enterprise Manager (OEM) Grid Control and deployed agents for diagnosing and monitoring performance related problems.
• Created and maintained databases to Oracle Optimal Flexible Architecture (OFA) and Maximum Availability Architecture (MAA) standards.
• Involved in writing stored Procedures, Functions and Triggers to interface application with database system.
• Managed Database Structure, Storage Allocation, Table/Index segments, Undo segments, Constraints and Database Access.
• Provided 24x7 on-call support for production databases.
• Worked extensively with Oracle support to resolve several show stopper issues.
• Managed CAB(Change Advisory Board) meetings. Worked on improving change management procedures.
• Exceptional ability to quickly master new concepts and technologies.

TECHNICAL SKILLS:

OPERATING SYSTEMS: RHEL, Sun Solaris, AIX, HP-UX and Windows NT.

RDBMS: Oracle 11g r1/r2, 10g r1/r2, 9i

LANGUAGES: SQL, PL/SQL, C, C++, UNIX Shell Scripting and Perl scripts.

High-Availability& Performance: RAC (11g/10g/9i), Exadata X2-2/X2-8, Datagaurd

SOFTWARE/ APPLICATIONS/ TOOLS: Golden Gate, Recovery Manager (RMAN), AWR, ADDM, OEM Grid control, one command, SRVCTL,CRSCTL, DCLI, DBCA,DBUA, exp/imp, Datapump, STATSPACK, SQL Loader, VMware, Tivoli, Legato, VERITAS, VCS, Oracle Clusterware, SQL Developer, TOAD, DBArtisan, Quest SQL Optimizer, Knowledge Xpert.

PROFESSIONAL EXPERIENCE:

Confidential, Merrimack, NH

Oracle DBA

Responsibilities:

• Responsible for Installing, upgrading and maintaining the availability of Oracle 11g, 10g, 9i databases on AIX and Linux platforms in production and non-production environments.
• Installed 11g RAC databases and upgraded databases from Oracle 10g to 11g.
• Performed 10g to 11g database migrations, Cross platform migrations and single instance databases to RAC databases.
• Setup and maintained RMAN backups and Autosys jobs.
• Maintained and tuned existing Golden Gate replications and supported implementation of new Golden Gate setups.
• Monitored databases and setup custom alerts using OEM 11g and 12c.
• Supported one of the largest initiatives at Confidential to consolidate all commonly used data by various business domains across the company for making critical investment decisions into Common Database Environment (CDE).
• Supported implementation of fine grained access policies (VPD).
• Worked closely with development and engineering groups. Conducted design reviews, code reviews and performance tuning.
• Came up with custom stats gathering strategies based on application design and requirements and setup appropriate autosys jobs to gather stats.
• Created a dashboard to display daily top SQLs from production databases.
• Implemented standard security policies across all databases including creating and assigning custom profiles to Badge IDs, Service accounts and Schemas.
• Created and assigned resource plans using Oracle Resource manager.
• Applied PSU/CPU Patches, ASM Patches, Grid Infrastructure Patches, Online Patches, one-off Patches and Exadata cell sever patches.
• Participated in Biennial organization wide DR-drills to test switchover and failover capabilities.
• Conducted CAB meetings. Improved change management practices.
• Coordinated with Off-shore teams. Following proper hand-off procedures.
• Provided On-call support. Supported production changes on weekends.

Environment: Linux, AIX, Oracle 10g/11g, RAC, Exadata, Data Gaurd,Golden Gate, ASM, Streams, DBFS, (OEM) Grid Control 11g/12c, Delphix.

Confidential, Cleveland, OH

Oracle DBA

Responsibilities:

• Responsible for Installing, upgrading, Implementing and supporting oracle 10g R1/R2 and 11g R1/R2 databases.
• Supported VLDBs - Data warehouse databases, OLTP databases and hybrid environments on Exadata platform.
• Designed and implemented Disaster Recovery using RMAN and Datagaurd for RAC databases on Exadata platform.
• Migrated single instance databases to 4-node and 8-node RAC databases.
• Upgraded Exadata X2-2 half rack to full rack, performed cell servers storage expansion.
• Configured and Implemented Oracle Streams. Performed table level replication across databases.
• Performed Oracle Golden Gate installation, configuration and troubleshooting.
• Assisted in implementing Oracle Financial Services Analytical Applications Infrastructure (OFSAAI - Reveleus & Basel products) on Exadata RAC databases
• Worked with ETL - Informatica teams and developers to co-ordinate data loads, EIP releases & iterations from data warehouse database to OLTP databases.
• Implemented Partitioned Tables for regional data in centralized data warehouse for better performance. and managing data lifecycles.
• Tuned oracle databases and applications using Tuning Tools like OEM GC, Cost optimizer, SQL analyzer, AWR, ADDM, ASH, Explain plan and SQL TRACE.
• Applied PSU/CPU Patches, ASM Patches, Grid Infrastructure Patches, Online Patches, one-off Patches and cell sever patches.
• Performed capacity planning and reporting, monitoring of storage utilization, reclaiming space and optimizing space allocation.
• Provided on call 24*7 support for production databases. Part of Exadata on call team.
• Worked extensively with Oracle support to resolve several show stopper issues.
• Documented procedures. Participated in knowledge transfer sessions.

Environment: Linux, Solaris, AIX, Oracle 10g/11g, RAC, Exadata, Data Gaurd, ASM, Streams, DBFS, (OEM) Grid Control, Oracle Partitioning, RMAN, TSM, Legato, Data Pump, TOAD, SQL Developer.

Confidential, Collierville, TN

Oracle DBA

Responsibilities:

• Responsible for installing, implementing and supporting Oracle 9i, 10g and 11g databases.
• Installed, implemented and supported Oracle 11g and 10g RAC databases
• Performed conversion of single instance databases to Real Application Cluster (RAC) databases.
• Implemented disaster recovery using Data Guard, and High Availability using RAC
• Performed Oracle version upgrades. Migrated oracle databases from 10g to 11g and from single node databases to multiple node RAC databases.
• Applied Oracle patches. Patch set and One-off Patches and Quarterly security Patches (CPU/PSU)
• Setup Recovery Manager (RMAN) and Flash Recovery in RAC Environment.
• Implemented backup strategies using hot/cold backups and Datapump. Performed backups to virtual tape using VERITAS Net Backup, HPDP and shared storage Option
• Performed Schemas refresh using Export/Import Pump.
• Installed Oracle 10g Enterprise Manager (Grid Control) for diagnosing and monitoring performance related problems.
• Monitored and tuned databases and SQLs using tools like Oracle cost Based optimizer (CBO), SQL analyzer, automatic checkpoint tuning, SQL Advisors, Performance Manager, and Statspack. Installed and configured OEM GC and intensively used for Diagnostic & tuning activities
• Provided database/application tuning including reducing lock contention, analyzing objects.
• Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.
• Downsized and defragmented Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 10g and Production to development refresh.
• Performed management of Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary.
• 24x7 Production database administration, support and monitoring. Collaborating with Oracle SR support to resolve issues.
• Assisted in implementing ITIL, SOX, HIPPA and PCI best practices.
• Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.

Environment: Linux, Windows 2000/2003, Solaris, AIX, OAS 10g Oracle 8i (8.1.6/8.1.7 ), Oracle 9i/10gR2, (OEM) Grid Control, Oracle Partitioning, Oracle Replication, Physical Standby, SQL*Plus, PL/SQL, SQL*Loader, VNB and Toad.

Confidential, Phoenix, AZ

Oracle DBA

Responsibilities:

• Responsible for Installing, Upgrading and Configuring Oracle 9i, 10g and 11g Databases.
• Installed RAC on Oracle 10g, 11g and worked on ASM feature of Oracle.
• Configured Oracle data guard and Oracle Streams.
• Handled large database environments (Data warehouse) using Oracle Enterprise Manager (OEM) Grid control on daily basis observing the performance of the production database and constantly active regarding performance and space management issues and accordingly providing on-fly solutions to make database healthy and running.
• Made performance improvements to the database by building Partitioned tables, Index Organized Tables, Materialized Views and Bitmap Indexes.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, AWR, ADDM, TOAD and Oracle Enterprise Manager.
• Devised & implemented backup strategies using hot, cold, and exports based on the business requirements.
• Used SQL*Loader for loading legacy data.
• Performed migration of databases, schemas, objects and data from 9i to 10g databases and single node to cluster databases using traditional export and Datapump.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Generated reports using crystal reports.
• Developed UNIX shell scripts to perform the above tasks efficiently.

Environment: Oracle 9i and 10g, Solaris, AIX and Linux, Windows NT / 2000, TOAD, Erwin, Citrix, (OEM) Grid Control, RMAN, SQL*Plus, PL/SQL, SQL*Loader.

Confidential

Oracle DBA

Responsibilities:

• Performed day-to-day DBA jobs for managing Production/Development databases.
• Provided 24X7 supports for production problems.
• Logical and Physical Modeling using ERWIN Data Modeler.
• Management of tablespaces for different users by granting quota on Default & Temporary tablespaces.
• Estimated Storage capacity for database objects.
• Monitored the growth of the database objects UNIX Shell scripting. Implemented for capacity planning.
• Created UNIX shell scripts to automate batch jobs through CRON.
• Extraction of data from different flat files into Oracle Database using SQL*Loader and automated the process by using Basic Replication using materialized views.
• Utilized SQL*loader and data pump import to load data into tables.
• Database Administration and Planning including logical design, physical design, backup & recovery.
• Created and implemented Oracle database backup and recovery strategies using RMAN.
• Monitored the various database activities such as backup, error logs, space, object, performance, user and session monitoring to ensure proper capacity and availability
• Performed Database and SQL tuning by using various Tools like STATSPACK, TKPROF, EXPLAIN PLAN, optimizer hints and SQL tuning advisor.
• Tuning test and production database by altering the parameters.
• Export and Import of database objects to copy from one database to another database.
• Investigating suspicious database activity using Auditing.

Environment: Oracle 10g/9i, HP-UX, AIX, Sun Solaris, Linux, Windows NT/2000, Oracle Enterprise Manager, SQL, PL/SQL, TOAD, RMAN, TPROF, Explain plan and STATSPACK, SQL* Loader.