Oracle Database Administrator

ac2ts3@r.postjobfree.com 256-***-****

Professional Skills

I have Over 6 years’ of extensive experience as an Oracle Database Administrator. I have worked on Oracle 12c, 11g, and 10g versions involving project support, production support, installations, configurations, upgrades, patches, migration, backup and recovery, performance tuning, cloning, space management and security.

Proficient in delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, 11g OEM Grid monitoring custom scripts troubleshooting oracle databases using SQL trace utilities.

Good knowledge v$ performance views and command line skills to identify information about sessions, wait events, system performance etc

Involved in tuning applications for optimal response time using SQL /Optimizer Trace at various levels and events, Explain Plan, TKprof, and also identifying the poor SQL's, histograms, row chaining & row migrations and tune accordingly.

Used SQL Tuning Advisor, SQL Profiles, SQL Monitoring, SQL Access Advisor, SQL Baselines tools and utilities.

Excellent Experience in installing and maintaining Oracle Dataguard to implement physical Standby Databases for Disaster Recovery.

Created Physical Standby databases using RMAN with zero downtime, performed Failover and Switchover using Data Guard Broker and manually as and when required.

Worked extensively with Physical Standby database, troubleshooting, switchover and switchback with Physical standby setup.

Excellent Experience in Golden Gate bidirectional/unidirectional configuration and management

Hands on experience in Oracle 10g/11g RAC implementation & administration (Oracle Cluster ware setup and configuration, RAC installation using ASM, Grid Installation)

Experience with RAC Clusterware administration, Configuration and Patching Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.

Extensive experience designing and implementing backup and recovery strategy for databases using Recovery Manager (RMAN), traditional Export/ Import, Export/Import Datapump as well as conventional Hot/Cold Backups.

Implemented various backup strategies for Large / Medium sized databases using RMAN

Worked extensively on Cloning /Duplicate of databases using RMAN.

Experience with various database Backup and Recovery methods like PITR, TSPITR, Export/Import and Flashback Technologies.

Applied Patches, Critical Patch Update/Patch Set update and One-off Patches using OPatch. Experience in patching RAC databases in rolling fashion to maintain high availability.

Experience in tuning database and memory components for optimal performance using AWR, ADDM and ASH reports.

Experience in using 11g features Flash-Back Recovery, Data Pump, AWR, ASM, ADDM, ASH, Recycle Bin, 11g&12c Grid Monitoring.

Skilled in cross platform migrations from Windows to Linux, Solaris to Linux.

Strong Knowledge of 11g advanced features like ASM, AWR, ADDM and FLASHBACK.

Hands on experience with logical backups, Hot/Cold backups, Recovery, and cloning of databases using (RMAN) Recovery Manager.

Disk Space Management involving managing archives, space allocation to various tablespaces and also capacity planning for new applications.

Expertise in Configuring RMAN with Catalog /Nocatalog and worked on Point-In-Time Recovery and flashback.

Plugging the tablespace between different platforms using Cross platform transportable tablespace Utility.

Collecting performance statistics using Statspack/AWR (Automatic Workload Repository) and ADDM (Automatic Database Diagnostic Monitor).

Used TKPROF utility and Explain Plan for tuning SQL queries.

Experience in regular DBA activities such as Upgrades, Patches, TAR support, Cloning, Backups and Recovery Manager, Performance Tuning, Capacity Planning and documentation

Memory tuning by using ASMM (Automatic shared Memory Management). Sort area size, Buffer cache, Shared pool size, Different pools like Recycle pool, Keep pool.

Rebuilding of Indexes for better performance, User Management, Tablespace management, maintenance of Oracle Database.

Experience in Monitoring and Tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.

Expertise in loading data from flat files using external tables, SQL* Loader.

Experienced in Installation of high availability RAC environment 2 node cluster and upgraded standalone databases to 11g RAC environment.

Migrated databases from Non-ASM file system to ASM file system using RMAN.

Upgrading and Migration of Oracle database to higher version and other platforms using manual method and traditional Export/Import, datapump & Transportable Tablespace (TTS).

Experience in coding SQL, PL/SQL package, function, stored procedure, triggers, and Materialized view for Oracle database.

Experience with SQL, PL/SQL, UNIX Scripting.

Excellent analytical, problem solving, communication and interpersonal skills.

PLUS, after my Bachelors in LAW prior to becoming a DBA, I practiced in a law firm as a trainee attorney where I learned and mastered excellent communication, listening, documentation and leadership skills which I apply adequately in my job environment.

Technical Proficiencies

OPERATING SYSTEMS: Red Hat Linux RHEL 5.x and Windows XP

RDBMS: Oracle 12c/11g/10g

LANGUAGES: SQL, PL/SQL, UNIX Shell Scripting, bash and Perl Scripting

SOFTWARE/ APPLICATIONS/

TOOLS: SQL Developer, DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, Sql Navigator, TOAD, Data Pump (expdp,impdp),SRVCTL,SQL*Plus

TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM

Education

BACHELORS DEGREE in LAW.

Work Experience

NFP - Austin, TX March 2015 – Present

Oracle Database Administrator

DBA supporting three major projects from Development to Production via Tech-Test environments, involving daily configuration, administration all running on Red Hat Linux 5.3. Database sizes range from 100GB to 4TB (in ODS & EDW environments).

Table refreshes and schema refreshes using Datapump, expdp and impdp.

Database refreshes using expdp, impdp, RMAN Duplicate and cloning.

Experienced in cloning the databases using HOT and COLD backups.

Used RMAN Duplicate and HOT/COLD backups to migrate the data from 11.2.0.1 to 11.2.0.3.

Configured deployed and administered 2 node RAC clusters on Redhat Enterprise Linux 5.0.

Extensively involved in performance tuning of applications, SQL queries and databases using Explain Plan, ADDM and AWR reports.

Installation and configuration and administration of Oracle Golden Gate

Replication of data in heterogeneous data environments using Oracle Golden Gate

Created a standby database by using RMAN Duplicate in order to reduce the down time for the PROD database during migration process.

Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups with Export/Import Data pump utilities.

Installation of oracle enterprise manager 12c, oracle management repository and deployed agents

Designed, developed, and implemented database security management, backup/recovery strategy, monitoring methods, and performance tuning. Provided technical support for all application administrators and users.

Applied critical patches to Oracle databases and application servers.

Installed Oracle Cluster ware Software to set up 2-nodes in a production environment.

Manage agents using emctl utility and creating incident rules in enterprise manager 12c

Configuring administration groups, and creating template collections in OEM 12c Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).

Hands on experience of database Backups and Recovery strategies using RMAN, Export Import Utility (Classical & Data Pump) and Transportable Table spaces.

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.

Responsible for capacity planning, database security, recovery planning and installing patches

Configured and implemented different types of Advanced Replication Models of distributed databases.

Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC).

Provided valuable inputs for various performance tuning issues. Explored 12c features by doing POC, including multi-tenant features

SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.

Implemented Dataguard, creating both logical physical standby/snapshot databases in 10g and 11g RAC environment for production database.

Work closely with Systems Analysts, Systems Engineers/Admins & Application Developers through the SDLC from Development to Production, via Tech-Test in Needs Assessment, Requirements Gathering (Server hardware/OS specifications for Oracle Installs), Database Designing (Physical & Logical) and Implementation, database user creation and database access both at role & table levels, as well as final Project Performance Assessment/Evaluation.

Create database Objects, Tablespaces, Schemas as needed.

Schema migrations from Development to Production via Tech Test environments.

Database refresh from Production to Tech Test as needed.

Tools Used: Linux, HP-UX, SQL, PLSQL, SQL Developer, Toad, Oracle 10g/11g, RMAN, Oracle RAC, DATAPUMP, DATAGUARD, ASM

Estes-Express - Richmond, VA Jun 2012 – Feb 2015

Oracle Database Administrator

Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 11gR2.

Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN.

Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.

Configuration changes using Autoconfig.

Pre-patch analysis for the patches and document preparation with pre and post patch steps.

Applying patches (Maintenance Pack, Interoperability patch, RUP, Family Pack).

Creating Application Users, Profiles, Responsibilities, Menus, Functions for the user.

Validating and creating grants & synonyms on Apps schemas, performed Jar file/forms generation as a post patch step, relinking the Oracle Apps programs.

Performing tracing for various use sessions and for various Concurrent programs.

Monitoring Alert log and trace files for errors.

Performing cloning of Production database to Test environment to provide user live data for testing purposes.

Managing OLTP databases RAC and Non-RAC having 24*7 activities, handled all the aspects of databases including administration, tuning, backup and recovery in Production, Test and Development environments.

Providing the Database dumps and schema level dumps to DEV and TEST database environments.

Performing re-org of the schema/tables and data archiving at regular interval of times.

Planning Backup/Restorations Strategy, Planning and Scheduling Backup and taking backup of database using RMAN.

Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.

Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.

Maintained the data integrity and security using integrity constraints and database triggers.

Provided 24X7 support for all the production and development databases.

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”.

Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.

Successfully upgraded the databases from 11g to non CDB 12c.

Successfully migrated 12c Non CDB databases to pluggable databases.

Created Oracle Wallets and implemented Tablespace level TDE security.

Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.

Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.

Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.

Successfully performed data replication using Materialized views and Oracle Streams in Oracle 10gR2.

Applied patches 10.2.0.2 and 10.2.0.3, 10.2.0.4.

Tools Used: Oracle 10.2.0.1, HP-UX 11, Sun Solaris 10.0, Oracle Streams, RMAN, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Contact this candidate