SUMMARY

• 8+ years of professional experience as Oracle DBA. Worked extensively on oracle 12c, 11g, 10g and 9i versions involving database administration, Installation, Configuration, Backup and Recovery, Migration, Upgrades, Patches, Cloning, Replication, Database Security, Memory Management, RAC, Data Guard, Performance Monitoring and Tuning, Grid Control, Oracle Streams, Gloden Gate, Data Modeling.
• Expertise experience in installation, administration and configuration of Oracle 12c, 11g, 10g, 9i on OEL, RHEL, SUN SOLARIS, IBM - AIX, WINDOWS, HP-UX in OLAP and OLTP environment.
• Good Experience in Hot and Cold Backups, and Cloning of Databases.
• Experience in taking the logical backups of data using oracle DATAPUMP utilities EXPDP and IMPDP.
• Expertise in installing, configuring and maintaining Standalone as well as RAC databases on various platforms and responsible for full time availability of the database.
• Worked on Oracle Exadata Backup Configuration utility.
• Extensive experience in installation and implementing OEM and TOAD and setup of Oracle Grid Infrastructure.
• Installation and configuration of RMAN with and without Recovery Catalog on Oracle 12c/11g/10g/9i.
• Experience in SQL Tuning, Optimization, rule based optimization, cost based optimization and Hints.
• Upgrading databases by applying patches, patch sets and critical patch updates.
• Management of schemas, objects & Partitioning the tables & indexes, USERS and PRIVILEGES.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM).
• Migration of databases from one platform to another platform.
• Installation and configurationof Oracle Server 12c, 11g RACwithASMon multi node systems, 11g, 10g and 9i in different operating systems forOLTPenvironment onVery Large Databases(VLDB).
• Supported ASM database and performed migration of normal database to ASM database using RMAN.
• Recovery of Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.)
• Implementation of High Availability Solutions using Oracle 11g RAC, 10g RAC, Physical and logical Standby database (Data Guard).
• Excellent experience in configuring and tuning of Oracle 12c/11g RAC, CRS and ASM for high availability database.
• Database performance tuning using STATPACK, TKPROF, SQL Trace, Explain Plan, AWR, ADDM, and ASH.
• Detecting and diagnosing production system performance problem by analyzing STATSPACK reports, Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views.
• Experience of Oracle Gloden Gate installation, configuration and troubleshooting Gloden Gate issues.
• Experience in Oracle Support (raising process) processes for technical requests through metalink.
• Extensively used Oracle Enterprise Manager to do the daily tasks regarding the performance, maintenance.
• Worked on different types of storage structures (SAN/NAS).
• Experienced in loading data from flat files into database tables using SQL*Loader.
• Experience using Erwin as a Data Modeling tool.
• Proficient in writing PL/SQL procedures, Triggers, Functions, Packages and Cursors and Exceptional handling.
• Assisting in implementation of change control process in production.
• 24*7 on-call production database support and maintenance including remote database support.
• Possess technical ability and self-initiative to learn and implement new concepts in short duration.

TECHNICAL SKILLS

Databases: Oracle 12cRAC/11gRAC/10gRAC/10g/9i, SQL Server 2005/2008/2012.

Operating Systems: X 10.10/10.7 Windows XP, 7, 8 Red Hat Enterprise Linux 4.x, 5.x, 6.x Sun Solaris 5.8/5.9/5.10/5.11 , AIX 5.2/5.3/6.1

Languages: C, C++, SQL, PL/SQL, Unix Shell scripting, Perl.

Tools: and Utilities: Oracle Grid, OEM,TOAD, Putty, Erwin, SQL loader, Export / Import, Expdp / Impdp, AWR, ADDR, STATSPACK, RMAN, Win SCP, TKPROF, Cron jobs, Log Miner, SQL Server, Gloden gate, Exadata, Data Guard, VMware.

Protocols: HTTP, TCP/IP, FTP, SFTP, SSH, TELNET

PROFESSIONAL EXPERIENCE

Confidential, MI

Oracle DBA

Responsibilities:

• Configured Physical Standby for Production databases and converted Physical standby to Snap shot Standby and ACTIVE data-guard.
• Installed, configured and maintained Oracle 2 /3 Node Real Application Cluster.
• Installation, configuration and maintenance of Oracle 11g and 12c on SUN SOLARIS and UNIX.
• Monitoring Health checks of OCR, VOTING DISKS and Interconnect for better performance and troubleshooting issues in RAC environment (11GR2).
• Working on Oracle Exadata Backup Configuration utility.
• Configured disaster recovery databases using Data guard and perform switchover & failover and monitor using Data Guard manager command line.
• Working on Active data guard and performed Troubleshooting data guard environment.
• Applied patch set and interim patches whenever required to make the database software up to date.
• Up gradation of Grid Infrastructure and Oracle Databases from 11.2.0.3 to 11.2.0.4 on 3 node RAC environment.
• Migrating databases from 11g to 12c using export/import and data pump export/import utilities.
• Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement.
• Taking the RMAN incremental and cumulative backups.
• Weekly Data Refresh from Production to Development and Test environments using data pump export/import.
• Installed, Configured and monitored GOLDEN GATE replication and installed VERIDATA tool for comparing data synchronization between SOURCE and TARGET.
• Configuring Extract and Replicate pumps for Gloden gate replication. Troubleshooting issues in GOLDENGATE Environment using LOGDUMP.
• Implemented performance parameters in replicate process and also involved in Splitting replicates which improved performance of Gloden Gate environment.
• Scheduling the databases backup using Cron-tab and VERITAS net backup.
• Extensive experience in RMAN recovery in RAC and stand-alone database.
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases.
• Implementing Data guard, created physical standby databases in 10g and 11g RAC environment for production database.
• Scheduling the backups for the database using EM 12C cloud control.
• Configured Oracle Transparent Application Failover (TAF) setting for Production databases.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Performing Block Recovery and Data file recovery using RMAN.
• Performing database refresh from production to test environment in both RAC and NON RAC environment using RMAN.
• Performing data refresh at Table level, Schema level, Table space level using DATAPUMP.
• Performing Application Tuning by tuning queries, identifying problematic code, creation of indexes, re-writing queries using an optimized path, creation of materialized Views and
• Gathering necessary statistics on objects.
• Created User accounts, Roles and granting required access permissions and privileges to the
• Database based on the applications they are accessing.
• Performance Tuning for the SQL queries which are Running slow and consuming high resources.

Environment: Oracle 10g, 11g,12c, SQL, Oracle Grid Control, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, SQL*Loader, NT, Sun Solaris, ASM, Gloden gate, RAC, RMAN, AWR, ADDM, ASH, TTS, Data pumps, Exports/Imports.

Confidential, Hartford, CT

Oracle DBA

Responsibilities:

• Installation, configuration and maintenance of Oracle 10g and 11g database on OEL.
• Created databases in RAC environment and involved in moving databases from TEST to Production Environment.
• Installed DR for 8 databases using Data Guard for Single instance and also in RAC
• Environment and trouble shoot issues in DATAGUARD environment.
• Upgraded the Oracle 10g database to 11g version and also applied patch set and interim patches whenever required to make the database software up to date.
• Worked on X2-2 machine where backups, restores are run across all database instances in Exadata system with two or four RMAN channels allocated per instance.
• Migration of databases from 10g to 11g using export/import and Data pump export/import utilities.
• Monitoring Day-to-Day Backups, Log’s & recovering them as per the requirement.
• Configured and Implemented Cold/Hot Backups.
• Taking the RMAN incremental and cumulative backups.
• Weekly Data Refresh from Production to Development and Test environments using data pump export/import.
• Implementation and configuration of Oracle gloden gate.
• Configured Gloden Gate for database changes by defgen utility and maintained database replication 24x7.
• me has done initial load that is created new tables and Gloden Gate process for Gloden Gate replication.
• Scheduling the databases backup using Cron tab and VERITAS net backup.
• Extensive experience in RMAN recovery in RAC and stand-alone database.
• Created a Clone Database using RMAN on remote Server and used SRVCTL commands for Real Application Cluster (RAC) Databases.
• Implemented Data guard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.
• Implemented Data Guard with maximum availability, protection and performance configurations and worked with Data Guard Fail over and Switch over cases at the times of up gradation and migration.
• Weekly Data Refresh from Production to Development and Test environments using data pump export/import.
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Statistics.
• Supported development teams by providing SQL statement tuning and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.
• Always monitoring the Oracle Instances, Users, Tables, Table-spaces, Memory structures, and Rollback segments, Redo logs, Archived Redo logs and Alerts.
• Creation of Users and granting them the required Roles and Privileges accordingly.
• Involvement in space management, rectification of lock problems, managed quotas.
• Created, monitoring database objects like Tables, Indexes, Views, Users, and DB Links etc.
• Cloned schemas, objects and data on new server using Data pump.
• Responsible for capacity planning, recovery planning and installing patches.

Environment: Oracle 10g, 11g, SQL, Oracle Grid Control, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, SQL*Loader, NT, Red Hat Enterprise Linux, ASM, Gloden gate, RAC, RMAN, AWR, ADDM, ASH, TTS, Data pumps, Exports/Imports.

Confidential, Austin, TX

Oracle DBA

Responsibilities:

• Installed and Configured Oracle 10g, 11g databases on Linux and also Upgraded Oracle databases from 10g to 11gr2 version by applying Patches.
• Implemented Oracle Database 11gR2 Two node Real Application Cluster (RAC) using Oracle Cluster-ware and responsible for high availability and load balancing.
• Installed catalog server and involved in registering databases in catalog database.
• Oracle Grid Control 11g Installation and Configuration.
• Configured Oracle Data guard for Oracle Disaster recovery.
• Achieved High Availability, Data protection and Maximum performance by maintaining both physical and logical standby databases.
• Restoration and Recovery of databases at the times of occurrence of critical failures.
• Responsible for installing, upgrading and configuring the Oracle environment by creating databases, storage structures and objects, database backup and recovery, monitoring and optimizing database performance.
• Implemented Oracle database backup & recovery solutions using RMAN.
• Implementation and configuration of Oracle gloden gate.
• Extensive use of Oracle Data pumps Exports/Imports utility for moving data among the servers.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Performed Schema as well as Table level Replication using Oracle Streams.
• Implemented downstream capture at the destination database using Oracle Streams.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL; UNIX Shell Scripts for backups.
• Worked with Data pump to take the logical backups of databases.
• Experienced in performing Point in time recovery using RMAN.
• Used oracle configuration assistants like DBCA (Database Configuration Assistant) for Creating databases, DBUA (Database Upgrade Assistant) for Upgrading databases and NETCA (Network Configuration Assistant) for creating a Client-Server environment using Listener, TNS names etc.,
• Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor(ADDM),Automatic Workload Repository (AWR) for monitoring database performance.
• Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.
• Clear documentation was prepared on all the processes like program specification, bugs fixing logs & change requests for future reference.
• Estimate growth of database size by detail analysis of the company’s future policies and generating reports for the management to act in advance.

Environment: Linux, Oracle 10g, 11g, SQL, Moba-Xterm, Putty, ASM, Data Guard, Oracle Grid Control, TOAD, RMAN, Oracle Enterprise Manager, Gloden gate, RAC, AWR, ADDM, ASH, TTS, Data pumps, Exports/Imports.

Confidential, Kingston, NY

Oracle DBA

Responsibilities:

• Provided Primary architectural and administrative support for new projects.
• Installed Oracle 9i and 10g, RAC database on HP-UX 11.0, Red hat 5.
• Installed RAC on Oracle 10g and worked on ASM feature of Oracle
• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
• Performance Tuning me.e., Tuning RAC, tuning applications, shared pool, me/O distribution, rollback segments, buffer cache, redo mechanisms
• Configured, administered and monitored DATAGUARD environment.
• Installed 10g Oracle Grid Control Management Server.
• Installed and configured Oracle 10g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation
• Cloned schemas, objects and data on new server using exports from 9i database and imported in 10g using Oracle data pumps
• Handling large database environments (Data warehouse) 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
• 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
• Devised & Implemented backup strategies using hot, cold and exports based on the business requirements
• Implemented Backup-using RMAN (Recovery Manager) as a media management layer
• 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. Developed UNIX shell scripts to perform the above tasks efficiently.

Environment: RHEL, Oracle 9i, 10g, 11g, SQL, Oracle Grid Control, OEM, Database Control, TOAD, SQL Developer, SQL*Loader, NT, ASM.

Confidential

PL/SQL Developer/Oracle DBA

Responsibilities:

• Involved in 24x7 support for both Production and Development databases.
• Worked closely with technical and client management to design and implementoracle databases, associated support tools and processes in support of complex business application development requirements and processes.
• Responsible for the design, build, ongoing maintenance, failure avoidance, detection and repair of Oracle database instances related to various applications.
• Installation, creation of 10g RAC and 9i databases for Testing, Development and Production
• Performed Cloning/Refresh to setup Test and Development databases
• Up-gradation/Migration of Database from 8i to 10.2.0.2 and applying patches when required.
• Up-gradation/Migration of Database from 9.2.0.6 to 10.2.0.2 and applying patches when required.
• Responsible for optimizing the queries and application tuning
• Partitioned large tables to increase the performance
• Implementing Range, List, Hash Partitions
• Creating and refreshing Materialized views
• Performed SQL Tuning and assisted developers with coding PL/SQL
• Performance tuning of Oracle Database Objects by fixing row chaining
• Performed the daily Maintenance Tasks and Health Check of the Database
• Performance Monitoring using OEM 10g Grid Control
• Created scripts for hot backup on a daily basis scheduled with cron jobs and Autosys conducting sizing & capacity planning for Oracle databases Implement “stored procedures and triggers” based on business plans using PL/SQL
• Implemented Backup & Recovery procedures using RMAN, Hot/Cold Backups
• Continuous monitoring of the Database and troubleshooting the issues, if any
• Responsible for setting and managing user accounts, granting required privileges to users
• Tuning SQL queries using TKPROF, EXPLAIN PLAN, SQL TRACE

Environment: Oracle 8i,9i, 10g, 11g, RHEL 4.2, SQL, Windows 2003 with active directory, PL/SQL, OEM, TOAD, SQL Developer, SQL*Loader, NT, ASM.