PROFESSIONAL SUMMARY:

• About 7+years of experience as an Oracle Database Administrator having hands on experience in very large Production, Test, Design and Development environments in diversified domains. Experience in Database Design, Database creation, Oracle Server Installations/Upgrades/Patches, Capacity Planning, Backup & Recovery, Disaster Recovery, Performance Tuning.
• Experience in Golden Gate installation, configuration and management.
• Thorough knowledge in Oracle RAC environment and upgrade of standalone databases to 10g & 11g RAC environment.
• Experience in Installing and configuring ASM and RAC for high availability databases.
• Cloned Database from Production to Test and Development and from Development to Production.
• Experience in Upgrade and Migration of oracle database to higher version and installing patches.
• Experience in maintaining Oracle Data Guard & Standby Database and providing critical solution with strategic disaster recovery plans with different recovery procedures and methods.
• Designed and implemented Backup and Recovery strategies using conventional and RMAN utilities.
• Hands on experience of database backups and recovery methods like PITR, TSPITR Export/Import, Data Pump and Flashback Technologies.
• Experience in writing shell scripts to check to the Status, Space Management and Performance of Database.
• Extensively used Grid Control for database monitoring and tuning.
• Have experience in performance tuning using AWR and ADDM Reports.
• Experience in working on TKPROF, Explain Plan and SQL Trace for Performance Tuning.
• Hands on experience using various DBMS packages like DBMS SCHEDULER, UTL FILE, UTL MAIL, DBMS SQL.
• Well versed with Veritas Cluster Environment, SAN storage systems, RAID, Logical Volume Manger.
• Experience in Extracting, Transforming and Loading (ETL) data using SQL*Loader Utility.
• Extensive use of Crontab and Autosys in UNIX environment for scheduling routine tasks.
• Created and Maintained Users and Roles with Appropriate Privileges and Profiles.
• Experience in creating Partitions on Tables and Indexes in order to improve performance.
• Experience in working with different FTP Clients like Smart FTP, Cute FTP SFTP and SCP.
• Database Administration (Oracle 8i/9i/10g/11g) of the database, size varying from Medium to Large (100 GB to 2 TB).
• 24x7 remote support and on call Database support for Database developers & end - users.
• Result oriented, self-motivated, Team player, ability to work independently.
• Excellent analytical and problem-solving skills and excellent written and verbal communication skills.

TECHNICAL SKILLS:

OPERATING SYSTEMS: Oracle Solaris 8/9/10, IBM AIX 5.x, Red Hat Enterprise Linux 5/6, Windows Server 2003, Windows XP, Windows 7

RDBMS: Oracle 11g/10g/9i/8i

LANGUAGES: SQL, PL/SQL, C, C++, XML, UNIX Shell Scripting.

SOFTWARE/ APPLICATIONS/ TOOLS: SQL Loader, RMAN, DATA GUARD, ASM, OEM Grid Control, DBCA, SQL*Plus, Export/Import, Data Pump, Golden Gate Toad, SQL Developer, Putty, Secure CRT, Lotus Notes, Remedy, Vitalize, DBArtisan.

WEB TOOLS: HTML, XML, TCP/IP, SCP, Metalink, MS Visio.

PROFESSIONAL EXPERIENCE:

Sr.ORACLE DBA

Confidential, Houston, TX

Responsibilities:

• Installed Oracle 10g/11g and RAC (4-node) systems, 11g, 12c OEM in HA environment on different OS platforms (AIX, Linux, Solaris, RHEL and VMware).
• Upgraded 11gR2 (11.2.0.3) to (11.2.0.4) in rolling fashion.
• Capture, Propagation, Apply using Golden Gate and enable real time data integration and continuous data availability by capturing and delivering updates of critical information as the changes occur and providing continuous data synchronization.
• Worked on storage migration with EMC SAN team.
• Experience in Managing Applications on oracle 11g / 10g RAC databases using ASM.
• Involved in Implementation of Oracle 11g Active Data guard.
• Monitoringof the queries with high response time, high diskreadper execution, SQL Query performance tuning for optimized results using tools like Explain Plan, SQL TRACE, and TKPROF.
• Responsible for finding performance problems in production databases by identifying issues using AWR, ASH and ADDM reports.
• Upgraded Oracle 9i/10g databases to Oracle 11.2.0.4.
• Applied PSU & CPU patches for the oracle enterprise database servers.
• Monitoring production databases through Oracle Enterprise Manager (12c) to troubleshoot and diagnose database problems.
• Cloning databases for development/testing environments using RMAN.
• Setting up and monitoring RMAN backups that include archive log backups, full database backups, incremental backups and troubleshooting ORA errors for backup issues.
• Scheduled various maintenance jobs using DBMS SCHEDULER.
• Loading data using SQL Loader and Data Pump utilities.
• Good experience in schema management, objects & Partitioning of tables & indexes.
• Responding immediately to any critical conditions, and proactively to any developing conditions, including: Database locking, Database corruption, Low disk spaces and Performance issues.
• Monitoring tablespace usage and adding space, adding disks to ASM disk groups and performing ASM disk group rebalance when required.
• Closely monitored and administrated log transport services and log apply services in Physical/Logical databases.
• Apply database schema changes in Production, Development, UAT & SIT Environments.
• Worked as a primary for weekly and monthly releases and coordinated with application teams and development teams in release window times.

Environment: Oracle 10g/11g, RHEL 5.1, IBM AIX 6.1, TOAD, SQL Developer, DBArtisan, SQL*PLUS, UNIX Shell, RMAN, 11g RAC, Golden Gate, ASM, 12c OEM, Data Guard, Putty, Secure CRT

ORACLE DBA

Confidential, Memphis, TN

Responsibilities:

• Participated in Oracle Golden Gate 11.2 installation, configuration and management, and supporting Bi-directional data replication.
• Upgraded golden gate from 11.1 version to 11.2 version on 11gR2.
• Configured High availability and setup custom monitoring through Heart beat tables using Golden Gate.
• Worked with application team for setting up conflict handlers in Golden gate.
• Used BATCHSQL, RANGE functions to improve throughput in Golden gate REPLICATES.
• Troubleshoot slow running EXTRACTS, REPLICATES and tuning.
• Performed Oracle 11g RDBMS installation, upgrade, configuration, backup, recovery, archiving & purging activities
• Involved in implementing 11g RAC (Real Application Clusters) with ASM disk on Linux servers (RHEL5), AIX 5.3.
• Duplicated RAC Databases in non-production environment through RMAN.
• Migrated database Schemas from Single instance to RAC.
• Upgraded multiple Oracle instances from version 10.2.0.4 to 11.2.0.3.
• Involved in applying CPU/PSU patches to the databases as recommended by Engineering team
• Worked on Automatic Storage Management (ASM) for managing data in SAN.
• Implemented and troubleshooting Data Guard (Standby) for high availability/disaster recovery purpose.
• Installation and configuration of Oracle Grid Control and installing OEM agents on all the database server hosts.
• Provided support on performance issues during project development resulting in improved response times and reduced contention.
• Monitoring the operating system response in terms of CPU usage, disk space, and swap space by using various UNIX utilities like VMSTAT, ISOSTAT and TOP.
• Used Stored Outlines, SQL Profiling, SQL Plan Baselines, SQL Trace, ADDM, AWR, ASH and Explain Plan tools to diagnose performance issues.
• Database recovering using Veritas Netbackup and RMAN.
• Performed backups and recoveries using RMAN/conventional hot & cold backups.
• Extensively used exp/imp & Data Pump utilities to refresh the databases from Production to Test environments.
• Performing daily maintenance tasks like memory management, Tablespace management, Lock conflicts, Indexes and daily health check of Databases.
• Monitored on a regular basis, as part of database preventive maintenance, the database growth, alert logs and arc hive log destination space by setting up alerts through OEM.
• Monitored daily lod of data from Oracle and offline data sources and troubleshoot problems as needed. Worked closely with the user community to resolve problems, answer questions, and provide solutions. Worked with Oracle Corporation to resolve applications/database issues by creating SRs.
• Involved in process documentation for knowledge sharing across the team.
• Support for fixing the daily database problems at segment, extent, and data-file and tablespace level.
• Supporting Development and QA team’s requirements in terms of database backup, performance and tuning.
• Responsible for maintaining around 100 databases in Oracle 10.2.0.4 and 11.2.0.3 varying from 2G to 2TB.
• 24*7 Production on Call Support for LDB on rotation basis.

Environment: Oracle 9i/10g/11g, Sun Solaris 5.9/10, Linux (SUSE, Red Hat), IBM AIX 5.3, VERITAS, TOAD, SQL*PLUS, UNIX Shell, RMAN, 11g RAC, Golden Gate, ASM, OEM, Data Guard, Putty, Vitalize

Oracle DBA

Confidential, Okemos, Michigan

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, HP-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.

ORACLE DBA

Confidential

Responsibilities:

• Installation and configuration of Oracle 9x / 8.x
• Creation of new instance and Database, Creation of Rollback Segments, Creation of users, Granting Roles and Privileges to Users, Troubleshooting utilities, Stripping of the database, Database Sizing.
• Automated Hot Backup and Logical (Export/Import) backup procedures.
• Backup and Recovery through RMAN for Oracle Database.
• Reorganization of the database segments through Storage Parameters.
• Database Designing and Creation as per the requirements.
• Configuring Listener and Adding TNS Entry in the Tnsnames.ora file for Oracle network configuration.
• Creating Database users and granting appropriate privilege.
• Creating Tablespace and add datafiles or resizing datafiles.
• Startup and Shutdown of production database.
• Killing Oracle as well as OS sessions.
• Adding or removing parameters in pfile /spfile .
• Installation of Oracle 9i/ Oracle 8i binaries on UNIX, Linux, Sun Solaris.
• Applied Oracle Patch 8.1.7.4, 9.2.0.6, 9.2.07, 9.2.08 on Production database.
• Starting Apache server / DBNMP agents.
• BCV Testing on test server. This was done for testing whether the database where BCV happens could be recovered or not.
• Migration from Oracle 8i to Oracle 9i.
• Production database recovery due to crash.
• Installing and creation of Stackspack Report.
• Tuning SGA through Spreport.
• Housekeeping of Export Dump at every Night.
• Monitoring RMAN Full and Archive backups and housekeeping of Duplicate Archive destinations.

Environment: Oracle 9i, Windows XP/NT, Solaris, TOAD, MS Office, Import/Export, Data pump, OEM, RMAN.