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, Golden 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.
• Configured and support Exadataand clustered Linux servers (RHEL and OEL) to host Oracle 11g and 12c RAC technology stack supporting both OLTP and DSS (data mart/data warehouse) databases.
• Experience in taking the logical backups of data using oracle DATAPUMP utilities EXPDP and IMPDP.
• Experience in SQL Tuning, Optimization, rule based optimization, cost based optimization and Hints.
• Implement Enterprise Manager Grid Control (11g and 12c) to provide monitoring and management of the Oracle database estate.
• Utilize Oracle Automatic Storage Management (ASM), Oracle Managed Files (OMF) and Recovery Manager (RMAN) to improve I/O performance, reduce administration overhead and provide a comprehensive backup and recovery strategy.
• Upgrading databases by Applying patch set and interim patches whenever required to make the database software up to date.
• 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).
• Installation and configurationof Oracle Server 12c, 11g RACwithASMon multi node systems, 11g, 10g and 9i in different operating systems forOLTPenvironment onVery Large Databases(VLDB).
• Develop and implement automated Oracle and MSSQL database refresh and migration processes using traditional techniques as well as SAN split-mirroring technology.
• 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.
• Extensive experience in writing and tuning complex sub queries, SQL, PL/SQL stored procedures, functions, and triggers.
• 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.
• Architect GoldenGate(10.x/11.x/12.x) replication solutions to facilitate data flow between heterogeneous (SQL Server and Oracle) environments.
• Developed custom utilities to automate manually intensive tasks including mass schema changes, recovering GoldenGatecorruptions and managing host/cluster maintenance mode blackouts.
• Experienced in loading data from flat files into database tables using SQL*Loader.
• Experience using Erwin as a Data Modeling tool.
• Lead database security audit vulnerability assessment and remediation projects.
• Proficient in writing PL/SQL procedures, Triggers, Functions, Packages and Cursors and Exceptional handling.
• Excellent experience in project management methodologies Including Agile methodology.
• 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, TKPROF,Cron jobs, Log Miner, SQL Server, Golden gate, Exadata, Data Guard, VMware, Tivoli.

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

PROFESSIONAL EXPERIENCE

Confidential, Canton, MI

Oracle DBA

Responsibilities:

• High Level Evaluation and Performance Tuning, Load Balance and TAF Failover, Scan Listener, RMAN, Dataguard DR Plan with Dataguard and different DB Performance Tuning with latest 11g/10g Grid Tools and Technologies for Production Full Life Cycle support.
• Configured Physical Standby for Production databases and converted Physical standby to Snapshot Standby and ACTIVE data-guard.
• Monitoring Health checks of OCR, VOTING DISKS and Interconnect for better performance and troubleshooting issues in RAC environment (11GR2).
• 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.
• 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.
• Utilize a variety of tools including EMC Time Finder, RMAN, Data Guard, Unix shell scripts and In depth for Oracle to backup, duplicate, refresh and tune databases across multiple servers
• Weekly Data Refresh from Production to Development and Test environments using data pump and RMAN.
• 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 Golden 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 Golden Gate environment.
• Scheduling the databases backup using Cron-tab and VERITAS net backup.
• 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 and Tablespace 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.
• 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, Golden 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 RACEnvironment and troubleshoot 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.
• 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, Incremental and cumulative backups.
• Weekly Data Refresh from Production to Development and Test environments using data pump export/import.
• Configured GoldenGate for database changes by defgen utility and maintained database replication 24x7.
• Implement GoldenGate replication solutions to facilitate data flow between heterogeneous (SQL Server and Oracle) environments
• Done initial load test by configuring new tables in Golden Gate for 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.
• Extensive experience in writing and tuning complex sub queries, SQL, PL/SQL stored procedures, functions, and triggers.
• Created, monitoring database objects like Tables, Indexes, Views, Users, and DB Links etc.
• 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, Golden 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.
• Oracle Grid Control 11g Installation and Configuration and Configured Oracle Data guard for Oracle Disaster recovery.
• 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.
• Implement GoldenGate replication solutions to facilitate data flow between heterogeneous (SQL Server and Oracle) environments
• 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 and performing Point in time recovery using RMAN.
• 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, Putty, ASM, Data Guard, Oracle Grid Control, TOAD, RMAN, Oracle Enterprise Manager, Golden 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 i.e., Tuning RAC, tuning applications, shared pool, I/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 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.
• Creating and refreshing Materialized views.
• Performed SQL Tuning and with coding PL/SQL under the supervision.
• Performance tuning of Oracle Database Objects by fixing row chaining
• 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.