PROFESSIONAL SUMMARY:

• Around 6.5 years of IT experience as an Oracle database administrator in Oracle database administration, installation, configuration, migration, sizing and space management, backup and recovery, cloning, upgrades, RAC, standby, replication, patching, performance tuning and troubleshooting, documentation and auditing and implementation of technology solutions.
• Extensive knowledge on database administration for Oracle 10g, 11g and 12c with experience in very large(>10TB) scale database environment and mission critical large OLTP and OLAP systems.
• Experience in a variety of hardware and software platforms including; OEL, UNIX/Linux, Sun Solaris, HP - UX & AIX and RHEL, Windows Environments
• Have Hands on experience in Installation of 12C RDBMS S/W, installation of 12c RAC and handy in configuring Dataguard on 12c.
• Hands on experience in Grid Control 10g & Grid Control (11g) and INSTALLED 12C for database Monitoring/Performance/Diagnostics.
• Experience in Performance Tuning, tuned various large critical OLAP and OLTP databases of Terabytes size using various tools like STATSPACK, AWR, SQL-Trace, Tkprof, Analyze, ADDM and Explain Plan Methods.
• Tuned the Database with Initialization Parameters. Viewing the Initialization Parameters with Enterprise Manager. Increasing Performance by Tuning the DB CACHE SIZE parameter.
• Good experience in PATCHING AND UPGRADATION from 10.2.0.x to 11.2.0.4.
• Extensive experience in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB, Flash-Back Technology, Log Miner.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage Area Networks (SAN) / Network Attached Storage (NAS).
• Used oracle configuration assistants like Database Configuration Assistant (DBCA) for creating databases, Database Upgrade Assistant (DBUA) for upgrading databases and Network Configuration Assistant (NETCA) for creating a Listener, TNS names to establish a Client-Server environment.
• Experience as On-Call 24x7 production DBA support, application/development DBA.
• SQL script creation and tuning.
• Implemented RMAN backups through TIVOLI.
• Generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH) and Automatic Database Diagnostic Monitor (ADDM) reports.
• Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM) .
• Excellent Communication skills, co-ordination and Communication with system administrators, business data analysts and development teams.
• Experience in Installation of Oracle Real Application Cluster (RAC) with ASM and manage RAC instances using CRSCTL and SRVCTL Utility.
• Configured multiple database instances using ASM instance.
• RAC Installation and Maintenance, setting up and configuring Data-guard, performing all kinds of Backups and Recoveries, Cloning databases.
• Extensive knowledge in Database Backup and Recovery concepts using RMAN utilities (scheduling full/incremental/cumulative backups, hot/cold backups writing/editing UNIX Shell Scripts for RMAN). Also used the Merge backup for backing terabyte databases. Issues with block change tracking & also flash recovery area.
• Hands on experience in Oracle 10g/11g/12c RAC implementation & administration (Oracle Cluster-ware setup and configuration, RAC Installation using ASM, Grid Installation.), Patching, RAC Backup.
• Providing DBA support to multiple Cluster, Non Cluster and ASM Database in production, development and Testing Servers in UNIX, AIX & Windows Environments.
• Upgrade of 10g R2 RAC to 11g R2 RAC.
• Add or Remove Node from RAC. Handy in Migrating Single Instance databases to RAC Environment.
• Hands on experience in Installing Golden-gate Replication, tools in golden gate log dump, defend for troubleshooting issues in environment.
• Installation, Configuration and Maintenance of Logical/Physical standby databases in Dataguard.
• Implemented Dataguard with maximum availability, protection and performance configurations and worked with Dataguard Fail over and Switch over cases.
• Database replication using snapshots, materialized views, import/export and advanced replication methods like Oracle Goldengate.
• Resolving the issues in conflicts between the target and source database in Goldengate. Strong troubleshooting skills in oracle Golden gate.

TECHNICAL SKILLS:

Database: Oracle 12c, 11gR2, Oracle 11gR1, Oracle 10gR2, Oracle 9i

Oracle Products: Real Application Cluster, Golden Gate, Data guard, Import and Export, Data pumps, Oracle Wallet Management, Automatic Storage Management, Recovery Manager, Oracle10g/11g/12c (Grid Control), Oracle Real Application Cluster, RMAN, Transparent Data Encryption

Operating System: Oracle Linux, HP UNIX 11i, Red Hat Enterprise Linux (RHEL), Sun Solaris, Windows XP/2003/2008, AIX 6.1

Languages: SQL, PL/SQL

Tools: & Utilities: SQL Trace and SQL tuning Advisory, SQL* plus, ADDM, DBCA, Log Miner, BMC Remedy, TKPROF, AWR, ASH, Toad, Putty, ERWIN, ETL tool

WORK EXPERIENCE:

Confidential, Houston, TX

Sr. Oracle DBA

Responsibilities:

• Implemented Oracle Database 11gR2 node Real Application Cluster (RAC) using Oracle Cluster-ware on Unix and Installed RAC on Linux.
• Installed and Configured Oracle 11g databases on AIX 6.1 and RHEL 6.X.
• Worked on large databases size greater than 12TB.
• Involved in designing of Disaster Recovery using Data Guard and High Availability using 11gRAC.
• Achieved High Availability, Data protection and Maximum performance by maintaining both Physical and Logical Standby databases.
• Installed 7 standalone servers on ASM and maintained DR databases on it.
• Performed various tasks on ASM, creating a disk group, adding a disk to disk group, making disk Online and Offline and troubleshooting issues in ASM environment.
• Installed Golden gate on source and target side for Replication and implemented load balancing topology using Golden Gate.
• Configured Golden Gate Parameter files for Extract and Replica process for replication.
• Tuned Golden Gate environment using different parameters and involved in trouble shooting.
• Performed automated backups and scheduling using scripting.
• Configured RMAN and registered databases in Catalog server.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Extensive use of Oracle Data Pumps Exports/Imports utility for moving data among the servers.
• Generated AWR reports, ADDM reports for fine performance tuning and worked closed with PL/SQL developers to tune TOP SQL running queries in databases.
• Used Invisible Indexes, and turn off indexes temporarily to check how queries perform without them.
• Performed large batch jobs, and tuning of SQL queries and database systems.
• Worked on Building schemas , cursors, developed Stored procedures and database triggers in PL/SQL.
• Performed Quick System Review by using Education Performance Index (EPI), System Performance Index (SPI), Memory Performance Index (MPI). Disk Performance Index (DPI). And calculated the Total Performance Index (TPI).
• Created User accounts, Roles and granting required access permissions and privileges.
• Written Stored Procedures and Triggers for database maintenance and management using PL/SQL, UNIX Shell Scripts for backups.

Environment: Oracle 9i, 10g, 11g, HP-Unix, Sun Solaris, Linux, RMAN, DBCA, GOLDENGATE, Dataguard, EXPLAIN PLAN, Cloning, OEM, STATSPACK, TKPROF and putty.

Confidential, Houston

Oracle DBA

Responsibilities:

• Configured Oracle Data guard for Oracle Disaster recovery.
• Monitored Data Guard environment using different views for proper log sync.
• 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.
• 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.
• Created User accounts, Roles and granting required access permissions and privileges to the database based on the applications they are accessing.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Implemented advanced features of Oracle 11g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
• Worked with Data pump to take the logical backups of databases.
• Experienced in performing Point in time recovery using RMAN.
• Involved in designing logical and physical data models using Erwin.
• Created indexes to facilitate easy user interface implementation and tuning.
• Rebuilded Indexes when fragmentation occurred.
• Worked on Databases through Business Intelligence tool.

Environment: Oracle 11g/10g, Red Hat Enterprise Linux 4.x and 5.x, AIX 5.2, Windows 2003/2008, OEM, Oracle RAC, Data-Guard, TOAD, Erwin, STATSPACK, EXPLAIN PLAN.

Confidential, Utah

Oracle DBA

Responsibilities:

• Involved in 24X7 on-call supporting team.
• Proficient in i nstallation and creation of Oracle 9i, 10g databases in development, Production and QA environments including configuration, backup & performance tuning.
• Refresh/Cloning of the databases from Production to the Test and Development environments.
• Upgraded database from Oracle 9i to Oracle 10g.
• Installation and Configuration of DG, ASM, OCFS in RAC environment.
• Database Migration from production to test and development environments is done through Cloning, Export and Import.
• Applied CPU, One-off patches using Opatch utility, RDBMS patch set Upgrade (PSU).
• Worked with Oracle Data Pump which provides high speed, parallel, bulk data and metadata movement of Oracle database contents.
• Used Oracle 10g grid control utility.
• Used Model mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Planned and implemented Backup & Recovery using RMAN. Implemented Cold Backup and Hot Backup depending on the requirement.
• Refreshed development and test databases from production using Logical Backups (Export and Import).
• Extensive Performance tuning for optimized results using tools like EXPLAIN PLAN, SQL*Trace and TKPROF , AWR, STATSPACK .
• Daily Health Check Up of the Database using ADDM with the help of AWR report.
• Written SQL, PL/SQL scripts and Shell scripting to monitor table space and extent growth. Space Management, which includes table space creation, adding new data files.
• Maintaining Database Security by Creating Roles, Privileges, Quotas, and Passwords.
• Troubleshooting and Technical Support on Oracle Database & Oracle Applications and Network Administration using TAR, SAR and RDA.
• Recovery of Database (Recovering from Media Failure, recovering tables dropped accidentally, recovering data files, Recovering from Block Corruption).
• Configured TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.

Environment: Oracle 9i/10g, RHEL, HP UX, SQL, PLSQL, UNIX Shell Scripting, RMAN, Oracle 10g Grid control, Data Guard, SQL*Loader, EXP, IMP, TOAD, Datapump, SQL developer, TKPROF, EXPLAIN PLAN, AWR, STATSPACK, ADDM, ASH.

Confidential

Oracle DBA

Responsibilities:

• Provided DBA Services to improve their performance of databases i.e. supported company that works with Oracle on a highly OLTP and DW environment.
• Setup Disaster Recovery solutions (Dataguard), Tuning Code, Resolved bottleneck problems.
• Applied Patches, Backup and recovery (with RMAN and Shell Scripts) over high volume Terabyte Databases.
• Worked with team to Install and configure Oracle RAC.
• Helped other team to migrate from Oracle 10g to Oracle 11gr1.
• Installed standalone servers on ASM 11g, worked on creating disk groups, partitioning raw-devices.
• Installed and configured Oracle databases on severs RHEL.5.5 and RHEL 5.8.
• Installed & managed 10g OEM grid monitoring solution and deployed agents.
• Performed Logical backup using and full/partial export/import and Data Pump.
• Responsible in configuring and backing up database using RMAN, Hot backups, Cold backups and Logical backups.
• Created bit-map Indexes for data warehouse databases. Configured Physical and Logical Standby database for reporting environment.
• Implemented database refresh with the hot backup using full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Proactively managed the databases; set up notifications, alarms using shell scripts for managing any exceptions in day to day management of the database.
• Efficient in using the Oracle Tools like SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN.
• Managing table spaces, user profiles, indexes, storage parameter’s. -- Develop table structures, PL*SQL stored procedures and database triggers to implement.
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin r7.1.
• Clear documentation was prepared on all the processes like program specification, bugs fixing log & change requests for future reference.

Environment: Oracle 10g/11g, SQL*Loader, Erwin, Oracle Enterprise Manager Database Control, RDBMS, TOAD, PL/SQL, Shell Scripting, ASM, Data guard.