SUMMARY

• Oracle Certified IT professional with around 9 years of experience as an Oracle Database Administrator with exposure to all phases of SDLC, having sound working experience in administration, installations, migration, upgradation, performance tuning, backup and recovery, space management, database security, SQL, PL/SQL, Unix shell scripting and documentation.
• Experienced in database Upgrade 10g to 11g.
• Installed Oracle Clusterware to provide infrastructure for RAC and configured 2 node Oracle 11g RAC with ASM.
• Migrated single instance databases to multinode 10g RAC environment for high availability and load balancing.
• Expertise in Replication of Oracle Database using Logical Standby and Oracle Golden Gate.
• Worked on Migration of Oracle Database from Windows to Linux
• Data transferring with Export, Import, Data Pump and SQL* Loader utilities.
• Experience in Oracle Enterprise Manager (OEM) Grid Control, TOAD, RMAN.
• Expertise in applying Patch sets and Interim patches
• Working on 24*7 production day to day and on call support and maintenance
• Proficient in all DBA responsibilities such as Instance tuning, user management, space management, monitoring.
• Delivering SQL and Database performance tuning services via V$/GV$ views, TKPROF, AWR (Statspack) reports, ADDM, SQL Tuning Advisor, SQL Access, Oracle Enterprise Manager (OEM), Grid control, analyzing SQL trace dumps for 9i/10g/11g.
• Strong knowledge and experience of managing Oracle 9i, 10g and 11g RAC environments using the OEM Grid Control tools.
• Knowledge on Oracle Support processes for technical requests through Metalink and other Support Procedures.
• Experience with SQL, PL/SQL coding, UNIX Shell Scripting, Scheduling jobs through Oracle Job Scheduler, Cronjobs (UNIX).
• Hands on Experience managing DBA daily activities, including schema, user management like (creating users, synonyms, privileges, roles, quotas, tables, index, sequence etc.), space management like (tablespace, rollback segment), monitoring (alert log, memory, CPU, connectivity to database), and handling scheduling management using UNIX Shell Scripting.
• Monitoring the performance on UNIX servers using TOP, PRSTAT, VMSTAT, IOSTAT, NETSTAT.
• Hands on experience in setting up, maintaining Disaster Recovery (DR) site using Standby Database
• Cloning databases using rapid clone and 10g Grid Utility.
• Strong experience in Backup and Recovery strategies, Cloning using Recovery Manager (RMAN)

TECHNICAL SKILLS

Database: Oracle 9i, Oracle 10g, Oracle 11g RAC

Operating Systems: Sun Solaris, Linux Server 3.0/4/5, HP UNIX, Windows Server 2003

Languages: SQL, PL/SQL

Tools: & Technologies: Toad, OEM, OAM, ASM, RAC, Golden Gate, AWR, PLSQL developer, Kintana, Grid Control

PROFESSIONAL EXPERIENCE

Confidential, Wayne, PA

Sr Oracle Applications DBA

Responsibilities:

• Migration of Oracle Database from HP - UX 11.11 to Linux 5.10
• Upgraded Database from 9i (9.2.0.8) to 10.2.0.5 to 11gR2 (11.2.0.4)
• Assist with the loading and configuration of Oracle software starting from space requirements, kernel parameters setup to the Oracle installation
• Creation and setup of Dev/TEST/QA environment from Production database.
• Implement backup and recovery procedures using (RMAN) for Oracle databases and test regularly in conjunction with Operations. Configuring scripts for backups (hot, cold and incremental).
• Cloning databases using scripts as well as RMAN.
• Database Refreshing / Replication from production to testing using hot/cold backup
• Scheduled UNIX scripts in crontab jobs to automate daily tasks like backups, monitoring the alert logs, backup logs, cleaning the old archive logs, old log files
• Created PL/SQL procedures (jobs) to automate maintenance tasks
• Open SR with Oracle Support and follow up for quick resolution
• Tracking invalid objects, compiling & validating the invalid objects.
• Trouble shooting in clone/patch/upgrade process
• Coordinating post-production support with focus on database performance monitoring
• Took ownership of project from design to documentation and delivery

Environment: Oracle RDBMS 9i, 10g, 11g, RMAN, Shell scripting, PL/SQL,Toad, Export/Import, Linux, HPUX

Confidential, Denver, CO

Oracle DBA

Responsibilities:

• Upgraded production, development, test and stage databases from 10.2.0.3, 10.2.0.4, 10.2.0.5 to 11g
• For high availability solutions configured Standby and Reporting database.
• Data Refresh/Cloning from Production environment to setup QA/ DEV using RMAN Duplicate.
• Created new databases/ instances on 11g/10g RAC and single instances using DBCA
• Installation of Golden gate Replication 10.4 for one-way replication to a Reporting Database and conversion of streams processes
• Performed Initial load, extract, replica, trial files and exporting data onto Repository Database using Golden Gate tool.
• Performance monitoring and Database/Instance/clustered Application tuning using Dictionary views, AWR (Statspack), ADDM, ASM reports, OEM Grid Control, tuned SGA/PGA parameters, initialization parameters and reorganized physical objects (tables & indexes) and tablespaces to improve the performance
• Applied Bug fixes patches, Quarterly Security Patches.
• Prepare backup strategy according to the Business Rule Specified by the company.
• Performance tuning using SQL application tuning using TKPROF, SQL TRACE (For session), STATSPACK, Explain plan.
• Tune Memory structure like Shared Pool, Buffer Cache and Redo Log Buffers.
• Tracking invalid objects, compiling & validating the invalid objects.
• Implementing OEM 10G monitoring tool to monitor and manage Oracle Instances.
• Maintaining Production, Stage, Test and Development instances with multi node setup.
• Upgraded production, development, test and stage databases from 10.2.0.3, 10.2.0.4, 10.2.0.5 to 11g
• Written pl/sql code to upload bulk insert jobs related to business objects
• Scheduled UNIX scripts in crontab jobs to automate daily tasks like backups, monitoring the alert logs, backup logs, cleaning the old archive logs, old log files, tablespace monitoring to send notification emails
• Intensively used latest 10g/11g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control
• Resolve critical issues by raising SR with Oracle Support and Root Cause Analysis (RCA)
• Being Primary point of contact, ensuring high availability of the instances.
• Documenting procedures and best practice to use time efficiently and fix issues fast.

Environment: Oracle RDBMS 10g/11g, RAC, ASM, Golden gate, iStore, OEM, RMAN, PL/SQL, Grid Control, Toad, Datapump, Linux

Confidential, Atlanta, GA

Oracle DBA

Responsibilities:

• Provided 24x7 on call DBA support for over 250 Oracle 10g/11g production, QA, DEV databases on RHEL, HP-UX, Sun Solaris
• Involved in the installation, configuration of multi node - 2 and 3 Node Oracle 10g/11g RAC with ASM
• Upgraded production, Development databases from Oracle 10.2.0.5 to 11g/11g RAC.
• Add new nodes to RAC 11g Cluster to distribute the load.
• Upgraded database from 10.2.0.4 to 11.2.0.2
• Upgraded database from 10.2.0.4 to 10.2.0.5
• Performance monitoring and Database/Instance/clustered Application tuning using Dictionary views, AWR (Statspack), ADDM, ASM reports, OEM Grid Control, tuned SGA/PGA parameters, initialization parameters and reorganized physical objects (tables & indexes) and tablespaces to improve the performance
• Designed daily, weekly Backup and Recovery procedures for production, non- production databases using RMAN backups taking periodic Complete, cumulative and differential Incremental Backups
• Data Refresh/Cloning from Production environment to setup QA/ DEV using RMAN Duplicate
• Perform Regular Maintenance on the Production Oracle Database Instances to ensure the dead processes are cleared and to address memory leaks.
• Scheduled Monitor Maintenance Related Programs & alerts like Gather Schema Statistics, Purge programs etc.
• Handling P1 and P0 issues 24X7 and make sure to resolve it within SLA and work on the action plan to ensure the issues are not repeated again.
• Working with release managers, functional team and development team for planning the cutover to ensure error free delivery and minimum down time on database.
• Working with the client closely to plan the enhancements and upcoming upgrades/projects and ensure to plan the resource in offshore and maintain the timely communication.
• Representing in weeks client calls and plan the changes accordingly on the database and to ensure the resource availability in the team
• Troubleshooting Oracle 10g/11g databases day to day issues
• Ensuring successful & periodical Backup using Hot, Cold, RMAN backups
• Administrating Database segment growth on Tables, Indexes and rebuilding indexes if fragmented, also doing large tables re-org to get rid of fragmentation

Environment: Oracle Applications R12/11i, Oracle RDBMS 11g/10g RAC, ASM, 12c OEM, RMAN, Grid Control, VERITAS Cluster, Toad, Datapump, Sun Solaris, and HP Unix

Confidential, Atlanta, GA

Oracle DBA

Responsibilities:

• Providing 24 X 7 troubleshooting and support for over 120+ Oracle databases which includes Production, Stage, Development & Test instances with 99.5% uptime as SLA.
• Modifying the database structure, as necessary, from information given by application developers
• Installed 11gR1 RAC, Upgraded databases to Oracle 11g for test purposes and explored new features
• Installed, Configured and maintained multiple 10g RAC with ASM production, test databases
• Developed, Configured and maintained Dataguard (Standby database) for faster Disaster Recovery
• Monitor capacity & system growth and usage for new hardware or software requirements and communicate these capacity requirements to Business in the Monthly Performance calls
• Cloned/ Data Refresh from production to setup test and development environments using RMAN duplicate
• Excellent experience with OEM Grid control, TOAD which acts as a great platform where Database Quality, Performance and Availability functions for administration and development enable perform tasks
• Recovery of Database (Recovering from Media Failure, Recovering the tables from Flashback, Recovering data files, recovering from Block Corruption) using Flashback Recovery, TSPITR and from previous RMAN backups, Hot, Cold and user managed backups
• Discussing about the new enhancements and patching outage window on production boxes with business in ccb calls.
• Performance monitoring, Database tuning, Cluster Interconnect tuning using Dictionary views, OEM Tuning Pack, Diagnostic Pack, AWR (Statspack) reports
• Customer support over phone, OWC, customer tracking system tool.
• Documenting Database Operations & Creating a CHECKLIST to manage smooth and stable environment
• Applied database patches using Opatch utility.
• Daily DBA activities: managing all the database files, alert logs, tablespaces, segments, extents, data blocks & physical storage, database network connectivity, database links, users, granting/revoking system/object privileges, querying data dictionary tables for metadata, setting init.ora parameters, database locking issues
• Taking schema level backups using Import & Export
• Experience in monitoring and tuning system resources associated with the database performance hit ratios, I/O, lock, latch contention and also monitoring for ORA-00600, ORA-07445 errors
• Creating and updating Service requests (SR)

Environment: Oracle Applications R12, 11.5.10.2, Oracle RDBMS 11g/10g, RMAN, Hot and Cold backups, OEM, Sun Solaris and HP Unix

Confidential

Oracle DBA

Responsibilities:

• Maintaining and Administering of Oracle Databases and other Oracle products of Large DB Sizes
• Taking backups, disk space/ user management.
• Backup and Recovery Planning Implementation (Cold Backup, Hot Backup and Export Backup)
• Coordinating with Oracle support for troubleshooting major issues
• Debug enabling and Trace enabling at Site, User and Responsibility Levels
• Applied database patches using Opatch utility.
• Performing code migration and db links creation.
• Monitoring table spaces for space usage and adding required space whenever it reaches threshold value
• Performing operations like Creation of Users, Session Management, and Granting Privileges to users from Applications.
• Taking schema level backups using Import & Export
• Monitoring alerts and clearing the locks on the database
• Tablespace management by creating table spaces and adding data files
• Controlling and monitoring user access to the database
• Generating TKPROF files for trace files
• Configuring Database in Archive log mode
• Refreshing the test database with the production database
• Compiling invalid objects

Environment: Oracle Applications 11i, Oracle RDBMS 10g/9i, HP-Unix, Red Hat Linux, Sun Solaris, Export/Import, ftp and putty