SUMMARY:

• Highly talented and technical Oracle Database Administrator with over 5 years of experience in Oracle Database software installation, patch and upgrade to development, test and production servers as well as developing database structure, implementing applications to enhance system and ensure security.
• Ensure business continuity through oversight of data backup and recovery and providing periodic maintenance, patches, and upgrades to enhance information systems and optimize performance tuning.
• Skilled in maintaining Data Guard environment, managing many schemas, space management, optimization and development of complex queries as well as working on various Oracle versions like 10g, 11g R2, and 12c databases and documentation in heterogeneous environment with platforms such as Solaris, AIX, UNIX, Linux, HP and Windows.
• Experienced in Database Cloning and Refreshing pre - prod/Dev databases with prod and pre-prod data.
• Technical proficiency in the installation, Upgrade, Configuration and Troubleshooting of Golden Gate 11g/12c software as well as configuration of Golden Gate Classic and Integrated components for Active-Passive and Active-Active.
• Installed and configured EM Central Grid control (OEM Grid) to administer and manage large number of databases and enterprise wide targets.
• Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
• Proficient in migrating database from Non-ASM to ASM and Non-RAC to RAC with experience in Multitenant Databases (Oracle 12c Container and pluggable databases)
• Hand on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature.
• Excellent knowledge in Hot/Cold Backup, Recovery, Cloning of databases using RMAN, VERITAS Net Backup and Experienced in Linux and Solaris using 11g network configuration (NETCA) Listeners, PL/SQL,UNIX Shell Programming.
• Expertise in maintaining Database Security using auditing as well as performing Data Migrations.
• Performed Upgrade and Migration of Oracle databases from oracle 10g to 11g & 12c.
• Successful application of PSU/CPU Patches, ASM Patches, and Grid Infrastructure Patches, Online Patches, one-off Patches and rolling patches.
• Implemented Data pump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database as well as implementing Oracle's Transportable Tablespace (TTS) feature using Data pump
• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.
• Clusters (RAC) and Automatic Storage Management (ASM) and Data guard and Streams.
• Strong Knowledge and expertise in creating Users, Public Synonyms, materialized views, Database Links, roles, profiles, privileges, Audit Triggers and assigning roles to users.
• Excellent knowledge in Hot/Cold Backup, Recovery, Cloning of databases using RMAN, VERITAS Net Backup and Experienced in Linux and Solaris using 11g network configuration (NETCA) Listeners, PL/SQL,UNIX Shell Programming.
• Installed RAC 11g on 3 node cluster for large production system and migrated the legacy system from Non-RAC environment to RAC 11g cluster database.

TECHNICAL SKILLS:

Operating Systems: LINUX, SOLARIS, MS-DOS, NT, Windows Advanced Servers 2000/2003

RDBMS: Oracle 11gR2, 10gR2 RAC

Oracle Database Tools: SQL*Loader, TKPROF, Toad, OEM, SQL Developer, Grid Control

Tools: Export/Import, RMAN, Data Pump, Winscp3, ERWIN.

Languages: C, C++, JAVA, UNIX shell scripts, PL/SQL, Perl

Web Tools: HTML and XML, SQL NET, ODBC, TCP/IP

PROFESSIONAL EXPERIENCE:

Oracle DBA

Confidential, Montgomery, AL

Responsibilities:

• Responsible for the administration of over 100 databases of Oracle 10g/11gR2 on Linux REHL, HP-UX. Worked as per ITSM/Remedy Incident ticket/Critical Response Time (CRT) call.
• Perform RAC- Administration/Trouble-shooting of 3 Node cluster on Oracle 10g/11G R2 and configure Grid Infrastructure SCAN Listeners on 11gR2. Migrate OCR files to ASM. Trouble-shoot Resource related issues. Cluster-wide Resource management such as create resource plan, Service configuration, parallel instance group, Application Isolation. Stress testing, benchmarking of clustered database.
• Managed ASM storage. ASM cloning. Prepare/Add/remove ASM disks. Tuning of I/O on ASM based databases. Troubleshoot ASM crashes & memory problem.
• Configured Golden Gate Classic and Integrated components for Active-Passive and Active-Active
• Perform incremental backups using Recovery Manager (RMAN) while creating recovery catalog and performing complete and incomplete recovery using RMAN.
• Audit database performance using ADDM reports, AWR snapshot and diagnostic SQL scripts.
• Effectively utilize explain plan and stats pack/TKPROF utility to Improve response time of query.
• Develop, modify and optimize very complex queries to data retrieval using Explain Plan, SQL Trace, TKPROF, parallel processing and partitioning techniques.
• Closely monitor the CPU, memory usage, I/O contention on servers using top, iostat, SAR, glance, vmstat etc.
• Perform Data Refresh/Cloning from Production environment to setup QA/ DEV using RMAN Duplicate.
• Ensure optimal performance by using AWR, ADDM, SQL Tuning/Access Advisors, SQL Performance Analyzer, Database Replay, SQL Plan Management, SQL Tuning (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.
• Manage performance Tuning of Oracle Database Objects using tools like EXPLAIN PLAN, AWR, ADDM SQL*TRACE, TKPROF, STATSPACK for optimized results
• Successfully configure and implement Oracle for high availability, in addition to installation and configuration of Oracle OEM (Oracle Enterprise Manager) Grid Control.
• Utilize Oracle Streams to perform schema, Table level Replication, and implementation of downstream capture at the destination database using Oracle Streams.
• Extensively implement Data pump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
• Laid hands on new tools and experienced features like Data Replay, Log Miner and Flashback data Archive, Schema Management, Data guard and RMAN in Oracle 11g.
• Configure Repository and clients for GRID Control and also implemented DB Control for some databases.

Environment: RHEL 5.X, 6.X; Windows NT 2000/2003; Oracle 10g, 11g, 12c

Oracle DBA

Confidential, Seattle, WA

Responsibilities:

• Utilized technical skills to install, configure, and maintain Oracle 10g and 11 g R2 on Linux and Upgraded from Oracle 10g to 11g.
• Managed export and import of database objects in order to copy them from one database to another & for backup the tables.
• Regularly monitor CPU usage, I/O contention, memory paging and identify the resource and performance bottleneck and reorganization for ensuring performance.
• Gathered performance statistics using Stats pack/AWR (Automatic Workload Repository) and analyzing by ADDM (Automatic Database Diagnostic Monitor)
• Rebuilt or analyzed indexes as per the fragmentation level and minimize the performance issues.
• Setup data guard, create physical-standby database using hot backup while troubleshoot errors on standby.
• Import and export used for load data into users on daily bases. Import schemas as part of recovery process in times of logical corruption.
• Performed tuning of instance, database with help of system views and init parameters. Partition of tables, indexes to improving performance. Used partition pruning, wise-join.
• Audited database objects for DML operation with User management including, crate/alter users, Grant roles, and assign resource profile.
• Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4 and 11.2.0.3.
• Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups
• Successfully configured the automated alerts for the production servers, which alerts DBA with the alert log errors and proactively space related errors.
• Participated in De fragmenting data blocks of table spaces for optimized performance.
• Automated Database refresh from the Host system to Oracle using, SQL and PL*SQL procedures.
• Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 10g R2.
• Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.
• Constantly monitored the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
• Utilized SQLTRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.

Environment: RHEL 5.X; Windows NT 2000/2003; Oracle 10g, 11g