SUMMARY

• About 8+ years of experience as an Oracle Database Administrator having 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, 12c cloud control and documentation.
• Extensive knowledge on database administration for Oracle 8i, 9i, 10g, 11g & 12c with experience within very large scale database environment and mission critical large OLTP and OLAP systems.
• Excellent experience in installation, setup and configuration of Oracle 8i, 9i, 10g and 11g in HP - UX, Sun Solaris, IBM AIX, Windows and UNIX/Linux Environment.
• Expertise in upgrading the databases from Oracle 9i to Oracle 10g and Oracle 10g to Oracle 11g.
• 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.
• DeliveringOracleDatabase performance-tuning services for customers with EXPLAINPLAN, TKPROF, STATSPACK, SQL TRACE, SAA,SQL MONITORING,SQL PLAN BASELINES,SQL PROFILES,STA and 11g/12cOEM Grid Monitoring.
• Expert in implementing ORACLE STREAMS (unidirectional, bi-directional and downstream capture) and managed Operational, Historical and reporting databases.
• 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.
• Having knowledge on the ORACLE EXADATA for the extreme performance of the database.
• Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup.
• Logical and physical modeling using Erwin. And Expertise using tools like Erwin, ER/Studio and Toad.
• Implemented RMAN backup (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, ADDM and 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.
• Extensive knowledge of Oracle Architecture, SGA, PGA, LISTENER, TNSNames, V$ and DBA views.
• Experience in implementation of enterprise databases on enterprise storage solution using Storage Area Network (SAN).
• Knowledge on Oracle Support Process for Technical requests using Metalink and other support procedures.
• Excellent interpersonal and strong analytical skills, Documentation & Problem-solving skills with customer service oriented attitude. A very good team player, self motivated, dedicated in any work environment.

TECHNICAL SKILLS

RDBMS: Oracle 12c/11g/10g/9i/8i/7X, Oracle 10g (RAC, Data Guard & Streams),SybaseSQL Server 2005 and DB2.

OPERATING SYSTEMS: HP-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.

LANGUAGES: SQL, PL/SQL, T-SQL, MYSQL, C, 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, Rational Rose, VERITAS Net Backup, SAN, SQL TRACE, EXPLAIN PLAN, TKPROF, STATSPACK, AWR, and ADDM.

WEB TOOLS: HTML.

PROFESSIONAL EXPERIENCE

Confidential, East Hanover NJ

Sr. Oracle DBA

Responsibilities:

• Installation, configuration, maintenance and tuning of Oracle 10g and 11g on Red hat 5.0, Oracle Linux 6.
• Successfully upgraded Oracle 10g (10.2.0.4) to Oracle 11g (11.2.0.3) on Oracle Linux 6.
• Involved in Installation and configuration of 11gR2 RAC using Clusterware and ASM.
• Successfully Migrated Non RAC single instance to Real Application Cluster (RAC) database instances.
• Installing12cOEM Agents on all assigned servers.
• Implemented Active Data guard, creating both Logical and Physical Standby databases in 11gRAC environment for the Production databases.
• Having experience in setting up Transparent data encryption(TDE) feature.
• Experienced in the installation of Enterprise Manager Cloud Control(12c) 12.1.0.3 and installing the Agents in all the production, test and development databases and configuring them.
• Experience in configuring OEM 12c cloud control load balancing by adding additional OMS using F5 Service Load Balancer(SLB).
• Experience in upgrading 11g OEM to OEM 12c Cloud Control with a Two system approach method having zero downtime
• Succesfully configured and installed Oracle Golden Gate for replication.
• Experence in performing Goldengate Replication with source and target on the same physical host.
• Successfully installed Goldengate Director server & client for configuration and management of the GoldenGate environment from a remote client.
• Experience in cloning Rac databases using Rman tool.
• Experience in partioning concepts ( Range, List, Interval) of large tables into sub partitions for benefit to a wide variety of applications by improving performance, manageability, and availability.
• Experience in working with Oracle Advanced Compression Advisor PL/SQL Package,Online Redefinition (DBMS REDEFINITION) for compression of tables for better performance in query retrieval.
• Extensively utilized RMAN for diagnosing corruption of persistent data on disks and repaired them using Data Recovery Advisor.
• Writing and modifying UNIX shell scripts to manage Oracle environments and for Backend Oracle Processes.
• Having hands on experience in installing SQL Server 2007 databases.
• SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
• Experience in trobleshooting the performance issues with the implementation of 11G SQL Baselines.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics for the same.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and automatic session history.
• Automated the nightly RMAN backups for the Production and Test Databases in Crontab.
• Creating and Scheduling Oracle Backend Process Jobs in Crontab.
• Cloning & duplicating databases using scripts as well as RMAN.
• Expertise in recovering the database. Performed complete recovery, data file recovery, incomplete recovery.
• Experienced in Database Security User Management, Privileges, Roles, Auditing, Profiling, Authentication.
• 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.
• Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers, Mat Views and Indexes on the tables.
• Used Secure SCP & FTP extensively for the File transfers from machines to remote server.
• Experienced in documentation, provided documentation for database design, analysis, modifications, creating schemas etc.
• Implementation of Oracle & Application Software Patches and maintaining SW License and maintenance agreements.

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

Confidential, Louisville KY

Sr. Oracle DBA

Responsibilities:

• Responsible for providing DBA support for multiple large databases in production, development and test environments.
• Part of a 5-member DBA team managing 450+ production/QA/Development instances with databases sizes varying from few GB's to 75 TB's.
• Developed UNIX shell script to automate the process of RMAN backups using RMAN Catalog.
• Developed SQL Scripts to perform database checks.
• Manage Oracle 11g/10g RAC databases of size 500g to 8TB.
• Installed, configured, add, remove nodes in RAC environment and migrated single instances to RAC environment and performed RAC administration.
• Involved in designing of disaster recovery using Data Guard, High Availability using 10g RAC
• Adjusting Optimizer settings for improve SQL performance.
• Role transition (Switchover/Failover) in Data guard.
• Involved in POC for DB Installation and configuration 11gR2 on Linux VM Environment’s.
• Installing and testing Oracle9i/10g and 11g Transparent Application Failover (TAF)
• Experience with Automatic Storage management implementation and also analyzing different problems including CSS related issues.
• Adding, deleting and creating different ASM disk groups.
• Performance analysis using AWR/ASH/ADDM reports and wait event analysis.
• Manage Oracle 11gR2 RAC database varying from 2-6 nodes.
• Implemented Simpana CommVault Backup & Recovery solution for configuring Backup & Restore for DB versions from 10.2, 11.1 and 11.2 RAC and non-RAC DB’s.
• Administered 10g/11g Real Application Clusters (RAC) system on Linux x86-64 bit systems on ASM storage environments.
• Involved in maintenance tasks like bouncing production databases and changing log modes of DB.
• Test and Implemented NetApp Snap Manager for Oracle solution for configuring Backup & Restore for DB versions from 10.2.0.4, 11.1.0.7 and 11.2.0.2.
• Installed Oracle 11gR1 & 11gR2 database for developers to test applications.
• Performed regular Database Administration activities which involved - Database
• Upgrades from 10g to 11gR1 and 11gR2. Installation of Oracle Software, Cloning Databases, Database Reorg and Backup and Recovery.
• Performed database Refresh using Oracle RMAN utility from an existing Production database.
• Responsible for storage management - Managing Space, Tablespaces, Segments and Extents, Rollback Segments & Data Dictionary.
• Installation of one-off, PSU patches using opatch utility on both Single Instance and RAC environment.
• Implemented DR Test project management / coordination process on yearly basis at Sunguard DR Site.

Environment: Red Hat Linux5, Oracle 10g/11g, DB2, Enterprise Manager GRID, RMAN, SAN/NAS, 10g/11g RAC, Data Guard, SQL*Plus, PL/SQL, ASM

Confidential, Stamford CT

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.
• 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.
• Monitoring and tuning using tools like Enterprise Manager 11G GRID, Oracle cost Based optimizer (CBO), SQL analyzer, automatic checkpoint tuning, SQL Advisors, Performance Manager, and Statspack.
• Performance analysis using AWR/ASH/ADDM reports and wait event analysis.
• 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.
• 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.2.0.4), Redhat4, HP-UNIX 10.0, RAC, TOAD, ASM, Oracle Enterprise Manager, Network setup and Management, ASM, RMAN, SQL*Plus, PL/SQL, SQL*Loader.

Confidential, Morgantown WV

Oracle DBA

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, 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 10g/9i, SQL Server 2000, Sun Solaris 8.0, SUN SPARC, HP UNIX, Windows 98/NT/2000, Oracle Enterprise Manager, SQL* Loader, T-SQL, STATSPACK, TKPROF, EXPLAIN PLAN.

Confidential

Oracle Developer/ DBA

Responsibilities:

• Developed and modified PL/SQL code to make new enhancements or resolve problems, as per customer requirements.
• Created complex analytical reports using inline view, lexical parameters with Oracle Reports 9i.
• Modified Korn shell scripts as per technical specifications.
• Prepared Data Flow Diagrams for existing PL/SQL code.
• Involved in coding of data extraction scripts as per technical specifications.
• Analyzed the table structures using Analyze command.
• Involvement in all phases of the project life cycle.
• Designed database tables as per technical specifications.
• Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.
• Implemented automated backup strategy using the UNIX shell script CRON UTILITY.

Environment: Oracle 8.1.7/9i, HP-UX, Windows NT/2000, PL/SQL, SQL Server 2000, T-SQL, Database Tools/Utilities, OPS, Shell Scripting.