PROFESSIONAL SUMMARY:

• Over 13years of experience as an Oracle Database Administrator has hands on experience in database administration, production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation.
• Extensive knowledge on database administration for Oracle 9i, 10g, 11g&12cwith experience within very large scale database environment and mission critical large OLTPand OLAP systems.
• Excellent experience in installation, setup and configuration of Oracle 8i, 9i, 10g and 11g in Confidential - UX, Sun Solaris, IBM AIX, Windows and UNIX/Linux Environment.
• Expertise in upgrading the databases from Oracle 10g to Oracle 11g and Oracle 11g to Oracle 12c.
• 24*7 production database support with Support to developers & end-users.
• Installed Oracle 11g ASM&10g RAC software with ASM & OCFS2 File systems.
• Experienced in Installation of high availability RAC environment (2, 3 and 4 node clusters) and upgraded standalone databases to 10g RAC environment.
• Proficient in setting up Standby Database using shell scripts and RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical supported by DATAGUARD.
• Managed very large database (VLDB) of maximum size 5TB with 18 servers including 6 Productions, 6 testing, 6 Development and 3 Standby databases.
• Experience working on ORACLE EXADATA Machine X4-2 for the extreme performance of the database
• Experienced in Oracle Golden Gate installation, configuration, troubleshooting, and performance issues.
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousingusing customized shell scripts and stepwise.
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMANwith VERITAS Net Backup.
• Logica l and physical modeling using Erwin. And Expertise using tools like Erwin, ER/Studio and Toad.
• Implemented RMANbackup (Full, incremental and cumulative) and recovery, Incomplete recovery and disaster recovery using Standby database or Data Guard.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.
• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDMand Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.
• Data loading using SQL*LOADER, Logical backups using full export and DATAPUMP.
• Expertise in maintaining Database Security using security compliance auditing, and expertise in loading data from flat files using external tables, SQL*LOADER.
• Having experience in ODM (oracle data mining).
• Good experience of creating PL/SQL packages, Stored Procedures, Functions, Triggers and Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.
• Experienced in using Oracle's Transportable Tablespace (TTS) feature allows users to quickly move a user Tablespace across Oracle databases.
• Database replication using snapshots, materialized views and advanced replication methods.
• Experience in applying security patches to the databases.
• Effective troubleshooting of database and Performance problems.
• Good experience in Data Migration using export/import.
• Management of Objects, Schemas, Partitioning the tables and Indexes.
• Using Patrol, Foglight,HPSM and Precise Monitoring Tools

TECHNICAL SKILLS:

RDBMS: Oracle 12c/11g/10g/9i/8i/, Oracle 11g (RAC, Data Guard & Goldengate), SQL Server 2005, MySql and DB2.

Confidential: UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10, AIX 5.1, 5.2, 5.3, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x and Windows NT/2000/2003/XP.

SQL, PL/SQL, T: SQL,MYSQL,C, C++, VB, UNIX Shell Scripting, Ksh, bash and Perl Scripting.

SOFTWARES, APPLICATIONS & TOOLS: DBCA, DBUA, Oracle Data Guard, OEM (GC), RMAN, ASM, Clusterware, VCS, Shareplex, SQL*PLUS, SQL*LOADER, EXP, IMP, Data Pump (expdp, impdp), TOAD, ERwin, TOAD Data Modeler, Rational Rose, VERITAS Net Backup, DBArtisan,SAN, SQL TRACE, EXPLAIN PLAN, TKPROF, STATSPACK, AWR, and ADDM.

WEB TOOLS: HTML, XML, JSP, HTTP, TCP/IP, FTP, SFTP, SCP, EMC Storage, Metalink, MS Visio.

PROFESSIONAL EXPERIENCE:

Confidential, Austin, Texas

Sr. Oracle DBA

Responsibilities:

• Upgradation of Grid Infrastructure and Oracle Database from 11.2.0.3 to 12.2.0.1 on 3-node RAC environment.
• Migration of database from one server to another server with zero downtime using Oracle Golden Gate.
• Implemented Data guard, creating physical standby databases in 11gRAC environment for production database.
• Installed, Configured and Administered Golden gate.
• Used Opatch utility for applying CPU and patch set Upgrade (PSU).
• Patching and Rolling Upgrade in Dataguard Environment.
• Installed and implemented GoldenGate to replicate table data between databases.
• Upgraded GoldenGate version from 12.1 to 12.2 release.
• Identified and resolved causes of Goldengate slow startups, monitored process lag and statistics, identified network and disk bottlenecks, and performed tuning of key components.
• Performed Extract and Replicat ETROLLOVER in cases when needed recovery due to loss of Trail files.
• Setup and managed Bounded Recovery interval in Goldengateto manage Long running transactions.
• Setting up the GoldenGate monitoring using OEM 12c / OEM 13c.
• Configured Integrated Extract & Integrated Replicat as a substitute to conventional Classic mode to increase the performance.
• Performed Successful Dataguard Switchover and Failover on production DB’s to maintain high availability.
• Troubleshoot the standby Archive log Gaps between the primary and standby database using RMAN incremental backup.
• Migrating single Instance Databases to 3 Node RAC environment using Rconfig.
• Load balancing of RAC instances using Services.
• Monitoring and administration of databases through OEM12c Cloud control 12.1.0.4.
• Using Oracle Data Pump utility making faster exports/imports using Network link on large databases and saving lot of time.
• Support application performance issues using 12c Cloud control / AWR / ASH / ADDM / Traces.
• Imporve DB performance by table reorganization.
• Install, upgrade Oracle Enterprise Manager (OEM) 12c.
• Build Oracle 11g R2 database on Veritas Cluster with failover/failback testing.
• Managing Oracle Real Application Cluster (RAC) for Oracle 11g R2.
• Apply Oracle Security Patches to adhere to the security policy.
• Loaded spatial data into database using SQL Loader and creating spatial Indexes.
• Optimized the queries, tuning of SQL statements using tools like Explain plan, Auto trace, DBMS PROFILER.
• Create and Configure new 12c pluggable databases (PDB’s) using DBCA. .
• Worked on Database Upgrade from 11.2.0.3 to 12.2.0.1 using DBUA.
• Migrated Non Container databases to 12c Pluggable databases.
• Upgraded 11g databases to 12c standalone and container database

Confidential, Irving, Texas

Sr. Oracle Exadata DBA

Responsibilities:

• Monitored & performed Exadata Cell storage server administration tasks using Cellcli & Dcli utility.
• Migrated databases from non-Exadata servers to the Exadata Database Machine using the RMAN 11g duplicate standby and using Rconfig method.
• Worked on Exadata X5 Super cluster Full rack Storage Server I/O Resource Management (IORM) PLAN to manage workloads across multiple databases and DBRM Plan within a database.
• Implemented and used Exadata Hybrid Columnar Compression (EHCC) for large objects in a Multiterrabyte Databases.
• Configuring storage cell disks and Grid Disks on Exadata cell servers.
• Patching of Exadata Cell Storage servers.
• Administration of Exadata Machine Using Cellcli & DCLI utility.
• Maintenance & troubleshooting of Alerts.
• Checking the Heath Condition of Exadata machines by Exacheck and Sundiag Utilities.
• Used Exadata Hybrid Columnar Compression for a very Large Tables greater than 2 TB.
• Monitoring the InfiniBand Switches/ports, DB/CELL nodes and IB topology through ILOM and OEM 12c.
• Applying One-off Patches to Cell servers for any bugs.
• Troubleshooting Exadata smartscan/offloading issues.
• Setup and configured databases on Exadata on netbackup.
• Enabling & Disabling Hybrid Columnar compression (HCC) on tables when necessary.
• Setting and Monitoring Exadata using OEM12c.

Environment: Oracle 11G, Exadata X5, 12c.

Confidential

Sr. Oracle/Goldengate DBA

Responsibilities:

• Successfully upgraded Oracle11g (11.2.0.3) to Oracle 11g (12.1.0.2) on IBM-AIX nodes
• Upgradation of Grid Infrastructure and Oracle Database from 11.2.0.2 to 11.2.0.4 on 3-node RAC environment.
• Installation, configuration, maintenance and tuning of Oracle 10g and 11g on Red hat 5.0, IBM-AIX 5.3
• Migration of database from one server to another server with zero downtime using Oracle Golden Gate.
• Implemented Data guard, creating physical standby databases in 11gRAC environment for production database.
• Used Opatch utility for applying CPU and patch set Upgrade (PSU).
• Patching and Rolling Upgrade in Dataguard Environment.
• Using Oracle Upgrade utility to upgrade CRS, ASM and logical DB from 10.2.0.4 to 11.2.0.3.
• Migrating single Instance Databases to 3 Node RAC environment using Rconfig.
• Load balancing of RAC instances using Services.
• Monitoring and administration of databases through OEM12c Cloud control 12.1.0.4.
• Using Oracle Data Pump utility making faster exports/imports using Network link on large databases and saving lot of time.
• Implementing Oracle TDE (Transparent Data Encryption) in /existing databases for Tablespace encryption.
• Maintaining Wallet files, and backing up using automated scripts/jobs to eliminate the loss of wallet files.
• Build Oracle 11g R2 database on Veritas Cluster with failover/failback testing.
• Upgraded/reimaged Exadata Cell Nodes, DB Nodes and IBs to the latest image 12.2.1.1.1.
• Completed OEDA deployment of the new Exadata Rack Machines.
• Expertise in ESS patching and database BP/QDPE patches.
• Administration of Exadata Storage cells.
• Administration and monitoring of Exadata components through ILOMs.
• Enabled Write-Back caching mode from Write-Through.
• To work resolving performance issues (Database /SQL) in Exadata.
• Troubleshooting smart scanning and cell offloading issue in Exadata.
• Resolving Cell Storage disk replacement issues, Cell related issue Cellsrv, RS, MS issue.
• CRS related issues in Exadata, ASM related issues in Exadata, Configuring DBFS in Exadata.
• Install, configure and support uni-directional and bi-directional Oracle-to-Oracle replicated environments utilizing GoldenGate.
• Used Golden gate for configuring online change synchronization between the source and target database using Datapump.
• Increased performance of Goldengate by using range parameter and multiple extracts/replicat processes.
• Successfully configured and installed Oracle GoldenGate for Schema/Table replication.
• Configured DDL Replication in GoldenGate to enable DDL Synchronization.
• Troubleshoot GoldenGate erroneous Skipping Transactions using LOGDUMP utility.
• Used Convchk Utility in Goldengate to repair the corrupted Checkpoint Table.
• Imporoved performance of replicat by using BatchSQL Parameter & MaxTransops parameter to split the trransactions to smaller one’s.
• Handled Erroneous transactions in GG, by using HandleCollisions & REPERROR Parameter.

Environment: Oracle Linux 6 & Red Hat Linux 5.0, Oracle 10g and 11g, Golden Gate, Oracle Spatial, Oracle Enterprise Cloud control 12c , RMAN,11g RAC, Active DataGuard , ASM, TKPROF, Explain plan, AWR, ADDM, SQL* Plus, PL/SQL, SQL* Loader.

Confidential

Sr. Oracle Production DBA

Responsibilities:

• Responsible for administration and supporting Oracle 10g and 11g databases.
• 24x7 Production database administration, support and monitoring to ensure a proactive problem.
• Used Srvctl Utility to create & maintain Oracle Services in RAC in order to manage workloads.
• Troubleshoot on Node Eviction Issues in RAC.
• Experienced in generating statistics of databases using ADDM in OEM 12c.
• Installation and configuration of 11gR2 3-node RAC. Upgrades of prior versions to Oracle latest release.
• Build Oracle Real Application Cluster (RAC) systems over ASM for the clients. Maintained and enhanced the scripts used for Oracle RAC/non-RAC installation.
• Implementation and Setup of Physical Data Guard and provide support for Oracle Data guard implementation for Disaster Recovery (DR) setup.
• Worked in setting up the Data guard broker for maintain the standby Databases.
• Experience in Fast-start Failover (FSFO) setup in Data guard as a solution to High Availability.
• Applied Latest PSU Patches (11.2.0.4.6 ) on Physical Standby Databases.
• Conducting technology audits and performing GAP Analysis.
• Configured replication of Tables using Goldengate.
• Performed Initial Load of Database replication using Goldengate.
• Implemented Oracle Advanced Security options such as data encryption for data privacy.
• Performed Patch set updates, CPU patches on RAC Databases to minimize the security issues and provide bugs fixes.
• Unix Shell scripting in csh, ksh for automating startup/shutdown, backup and recovery, Import and export procedure of databases, getting system alerts .
• Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
• Worked actively in planning for storage space requirements and placing them for optimum I/O performance.
• Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
• Monitored Exadata Database machines from OEM12c Cloud control.
• Experienced in the installation of Enterprise Manager Cloud Control (12c) 12.1.0.2 and installing the Agents inall the production, test and development databases and configuring them.
• Experience in configuring OEM 12c cloud control load balancing by adding additional OMS to support heavy agent traffic.
• Configuring and creating rules and setting up Metric templates in OEM12c as per the company standards.
• Integrated Zenoss third Party tool for Incident monitoring through OEM12c using SNMP.
• Created Dynamic groups in OEM12c for re-routing the newly incoming targets.
• Upgraded old 11g database OEM 12c agents and configured in 12c.

Environment: Confidential -UX 11, Red Hat Linux4, Windows 2000/2003, OEM12c, Enterprise Manager GRID, RUP, RMAN, SAN/NAS, HSM, 10g RAC,11g, Streams, CDC, Data Guard, SQL*Plus, PL/SQL, ASM, J2EE, ToadV9.7 & SQL, Navigator V6.1.

Confidential

Sr. Oracle DBA

Responsibilities:

• Responsible for administration and supporting Oracle 10g and 11g databases.
• 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Successfully migrated databases from windows2000/2003 running oracle 9i over to Linux boxes 10g.
• Installation, Upgrade and Configuration of Oracle 9i and 10g Databases.
• Involved in designing of disaster recovery plan using Data Guard, and High Availability using RAC.
• Schemas refresh using Export/Import Pump, Creating the database table spaces, tables, indexes, setting privileges and user logins.
• Configuration, Administration and tuning of Oracle 10g and 9i RAC.
• Used cross platform transportable table space ( TTS) to transport tablespaces across platforms.
• Data Refreshin Test and Integration Databases using Transportable Table spaces.
• Performed Setup Recovery Manager ( RMAN) and Flash Recovery in RAC Environment.
• Oracle Streams Bi-Directional replication implementation at Table, Schema and Database Level .
• Implemented backup strategies using hot/cold, exp/imp used on the business req.
• Cloning databases using scripts as well as RMAN and performed Tablespace point in time recovery ( TSPITR) using RMAN.
• Implemented Streams replication between RAC and non RAC database environments.
• Installed Oracle 10g Enterprise Manager (Grid Control) for diagnosing and monitoring performance related problems and configured with Application servers on test databases.
• Assisted a team of DBA’s in migration of databases from Oracle 9i Release 2 to Oracle 10g Release 2.
• Worked on Automatic Storage Management (ASM) with SAN Storage for managing data in EMC Symmetrix.
• Monitoring and tuning using tools like Enterprise Manager GRID, Oracle cost Based optimizer ( CBO), SQL analyzer, automatic checkpoint tuning, SQL Advisors, Performance Manager, and Statspack.
• Performed conversion single instance to Real Application Cluster ( RAC) database instances.
• Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases.
• Provided database/application tuning including as reducing lock contention, analyzing objects.
• Downsizing and defragmenting the Very Large Databases by export / import, cloning those using RMAN duplicate features and then upgrading them to Oracle 10g and Production to development refresh.
• Storage Management Managing Space, Table spaces, Segments and Extents, Rollback Segments & Data Dictionary.
• Experienced on Database Security by monitoring User Management, Privileges, Roles, Auditing, Profiling, Authentication and Risk management.
• Used Oracle Advanced Replication feature to set up multi-master replication, dealt with conflict resolution and performance issues.
• Unix Shell scripting in csh, ksh for automating startup/shutdown, backup and recovery, Import and export procedure of databases, getting system alerts .
• Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.

Environment: Confidential -UX 11, Red Hat Linux4, Windows 2000/2003, Oracle 9.2.0.8/ 10.2.0.3/ 11g, DB2, Enterprise Manager GRID, RUP, RMAN, SAN/NAS, HSM, 10g RAC, Streams, CDC, Data Guard, SQL*Plus, PL/SQL, ASM, J2EE, ToadV9.7 & SQL, Navigator V6.

Confidential

Oracle DBA

Responsibilities:

• Installed RAC on Oracle 10g release1 and worked on ASM feature of Oracle.
• 24x7 Production database administration, support and monitoring to ensure a proactive problem
• Recognition and resolution of database issues.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
• Performance Tuning i.e. Tuning RAC, tuning applications, shared pool, I/O distribution, rollback segments, buffer cache, redo mechanisms
• Oracle Grid Control Management Server Installation.
• Used transportable tablespaces (TTS) to move the data Oracle on a different platform and also much faster than performing either an export/import or unload/load of the same data.
• Implementation of 10g Data Guard and Bi-directional streams implementation.
• Handling large database environments using Oracle Enterprise Manager (OEM) 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.
• Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager.
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Created Users, Groups, Roles, Profiles and assigned users to groups and granted privileges and permissions to appropriate groups.
• Implemented and followed data security standards and Security User Management, Privileges, Roles, Auditing, Profiling, Authentication and Risk management.
• Performed application migrations to non-cluster databases to cluster databases.
• Devised & Implemented backup strategies using hot, cold, and exports based on the business requirements.
• Implemented Veritas Net Backup-using RMAN (Recovery Manager) as a media management layer.
• Applying security patches both Server side and Client side and Performed testing.
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pump.
• Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances.
• Trouble shooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
• Worked with production DBA team in perfect coordination with seniors and team members.

Environment: Oracle database 10g (10.1.0.5 to 10.2.0.4), 9i (9.2.0.8 ), Redhat4, Confidential -UNIX 10.0, RAC, TOAD, TTS, Erwin 7.2, J2EE, ASM, Oracle Enterprise Manager, Network setup and Management, ASM, RMAN, SQL*Plus, PL/SQL, SQL*Loader.

Confidential

Database Administrator

Responsibilities:

• 24x7 Database administrations, support and monitoring to ensure a proactive problem recognition and resolution of database issues.
• Migration of Oracle databases from windows to Linux.
• Applied patches to Oracle Databases and Oracle Applications.
• Upgrading development and production databases to Oracle 10g.
• Proactive database monitoring using 10g grid monitoring tool.
• Database tuning using SQL-Trace, STATSPACK, AWR, EXPLAIN PLAN and TKPROF.
• Extensive Performance Tuning, Memory (SGA) Tuning, net backup, EMC (Time finder and SRDF), RAID, RAW Devices.
• Performed database cloning to setup test and development databases.
• Responsible for optimizing the queries and application tuning.
• Performed SQL tuning and assist developers with coding PL/SQL.
• Provided support to Application Database Administrators in designing the database.
• Used RMAN for backup and recovery. Performed Hot, Cold and Logical backups. And performed backup validations using RMAN.
• Management of schemas, objects partitioning the tables & indexes.
• Automation of data load using Korn shell scripting and SQL*Loader.
• Responsible for setting and managing user accounts, and granting required privileges to users.
• Performed other DBA activities like including space management and performance monitoring.
• Experienced in Oracle Database monitoring, troubleshooting and resolve the issues.

Environment: Oracle 8i/9i,10g SQL Server 2000, Sun Solaris 8.0, SUN SPARC, Confidential UNIX, Windows 98/NT/2000, Oracle Enterprise Manager, SQL* Loader, T-SQL, STATSPACK, TKPROF, EXPLAIN PLAN.

Confidential

Database Administrator

Organization

Responsibilities:

• Experienced in Oracle Database monitoring, troubleshooting and resolve the issues.
• Installation and Configuration of Oracle Related Products.
• Minimize the database down time and troubleshoot the database and application fast
• Perform day to day Database Maintenance activities such as observing database object size, its growth, log switch timing, alert log files etc.
• Managing rollback segments redo log files to avoid the resource contention.
• Performed a time based recovery of the database using on-line archived log files
• Removing unwanted data and columns from database in year end
• Database Migration from Oracle 8i to oracle 9i using export and import
• Taking logical backups by using Export Utility.