PROFESSIONAL SUMMARY:

• Over 9 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 (12c/11g/10g/) on Linux, HP - UX, Solaris, AIX and Windows platforms.
• Installed, Implemented and Supported High availability architectures - Real Application Clusters (RAC), Datagaurd and Automatic Storage Management (ASM).
• Worked on RAC (12c/11g/10g/) Installation, Administration, Troubleshooting and Performance Tuning.
• 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.
• Experience working in Multitenant architecture. Installed container database and multiple pluggables on 12.1.0.2 RAC cluster. Cloning pluggable databases across multiple containers.
• 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.
• Experienced with Golden Gate replication. Maintained and tuned existing Golden Gate replications and supported implementation of new Golden Gate setups.
• Excellent exposure to Datagaurd, standby databases, materialized views, Oracle Spatial, transportable tablespaces.
• Implemented backup strategies, Hot/ Cold backups and Incremental/Full backups. Automated RMAN backup jobs using UNIX shell scripts and Cron utility and 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, SQLT, 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, opatchauto on UNIX and Windows platforms .
• Installed Oracle12c 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 Security for transparent data by enabling Encryption (TDE) for Tables, Columns and on entire Tablespace level by Creating Wallets.
• Provided 24x7 on-call support for production databases.
• Enthusiastic, client support /communication skills, implementing best practices and eager to meet challenges and quick to learn and assimilate new concepts and ideas.

OPERATING SYSTEMS: Sun Solaris 10/9/8/7, IBM AIX 4.3.3/5.x, Red Hat Linux RHEL 2.1/3.x/4.x/5.x, HP-UX 10.x/11.x, and Windows 2008 R2 x64, 2012 R2 x64

RDBMS: Oracle 12c/11g r1/r2, 10g r1/r2, 9i, MS SQL Server 2005/2008, MySQL, MS Access.

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

High-Availability& Performance: RAC (11g/10g/9i), 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, Pittsburgh, PA

Sr. Oracle DBA

• Experience handling Oracle 3-node and 2 node RAC installations, upgrades and database maintenance of 11g and 12c container and pluggable databases
• 24X7 production support and on call rotation for Oracle 12.1.0.2/12.1.0.1/11.2.0.4 RAC databases on AIX, Redhat Linux environments.
• Performed 11g to12c database migrations, Cross platform migrations and single instance databases to RAC databases.
• Setup both DDL and DML replication using Oracle Goldengate.
• Setup, configuration and maintenance of standby databases (Oracle Data Guard) to ensure disaster recovery, high availability and data protection and performed disaster recovery testing.
• 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.
• Scheduled and Monitored Batch and Cron Jobs for RMAN on Windows, Linux and Unix Platforms.
• Applied Quarterly security Patches (CPU/PSU), Patchset and One-off Patches on Oracle RDBMS and Grid.
• Worked closely with development and engineering groups. Conducted design reviews, code reviews and performance tuning.
• Tuned the databases for optimal performance using EXPLAIN PLAN, SQL Optimizer, AWR, ADDM and ASH Reports.
• Installed OEM 12c Cloud Control and OEM Grid Agents (11.1.0.1.0 ) on Linux and UNIX for monitoring of production databases.
• Troubleshooting Database performance issues using Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM) and SQLTXPLAIN to diagnose the SQL statements.
• Refresh/Cloning of Database from production environment to test environment using RMAN Duplicate feature.
• Configured multiple listeners on different ports and of TCP/IP protocols for various databases using listener control utility. Used both the host naming and local naming for the connectivity.
• Automated the nightly RMAN backups for the Production and Test Databases in Crontab.
• Coordinated with Off-shore teams. Following proper hand-off procedures.
• Automated data loading into database tables from files using SQL*LOADER.

Environment: HP -UX, Linux, Windows, Oracle 10g, 11g & 12C, Oracle Enterprise Manager, RMAN, RAC, DataGuard, ASM, TOAD, SCP/SFTP, AWR, ADDM, TKPROF, Explain plan, SQL* Plus, PL/SQL, Shell Scripting, SQL* Loader.

Confidential, San Jose, CA

Oracle DBA

• Responsible for Installing, upgrading, Implementing and supporting oracle 11g R1/R2 and 10g R1/R2 databases.
• Designed and implemented Disaster Recovery using RMAN and Datagaurd for RAC databases
• Migrated single instance databases to 4-node and 8-node RAC databases.
• Configured and Implemented Oracle Streams. Performed table level replication across databases.
• Performed Oracle Golden Gate installation, configuration and troubleshooting.
• Worked with ETL - Informatica teams and developers to co-ordinate data loads, EIP releases & iterations from data warehouse database to OLTP databases.
• Used cross platform transportable table space (TTS) to transport tablespaces across platforms.
• Restore and Recover, cloning and duplicating databases using scripts as well as with RMAN.
• Setting up Automated nightly RMAN backups for production and Test databases in Crontab.
• 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, SQL analyzer, AWR, ADDM, ASH, Explain plan and SQL TRACE.
• Performed security issues concerning creating and administering roles, object and system privileges for users, user account creation, and maintenance.
• A pplied 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.
• Documented procedures. Participated in knowledge transfer sessions.

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

Confidential, San Jose, CA

Oracle DBA

• 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.
• Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.

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

Confidential, Irvine, CA

Oracle DBA

Responsibilities:

• Installation and configuration of Oracle 10g and 9i RAC on Linux.
• Responsible for administration, Supporting production and development of Oracle 10g and 9i RAC.
• 24*7 on-call production database support.
• Upgradation and migration from oracle 9.2.0.8 databases to 10.2.0.3.
• Cloning databases using scripts as well as RMAN. Installation, setup and configuration of DataGuard.
• Expertise of Database Restore using RMAN, Cold Backup, Export and Flash Recovery.
• Performed database refresh with the hot backup using DUPLICATE or full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Involved in user creation and user access control, Involved in Schema creation and management. And Developed stored procedures.
• Worked on Automatic Storage Management (ASM) for managing data.
• Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Tables, index analyze jobs, database backup logs etc.
• Performed Database tuning-Applications Tuning, Memory Tuning, Disk usage tuning.
• Experience of Performance Tuning of various aspects of the database using utilities like Tkprof, Explain Plan, Statspack, OEM.
• Sizing database objects for effective space management and optimal performance.
• Managing database security. Creating and assigning appropriate roles and privileges to users depending on the user activity.
• Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary
• Experience in identifying and resolving performance and scalability bottlenecks.
• Worked with table partitioning and tablespaces creation etc.
• Creating and rebuilding indexes and optimizing the code to improve the performance.
• Moved database Schema changes to stage or production.
• Managed and resolved design issues during development stage. Worked closely with developers.
• Database server tuning. This included tuning the shared pool, database buffers and redo buffers.

Environment: Windows NT / 2000 , AIX and Linux, HP UNIX, SQL Server, Oracle 9i and 10g, TOAD, RMAN, Enterprise Manager, FTP, TKPROF , Explain plan, STATSPACK , Crontab, SQL Navigator, SQL* Loader.