SUMMARY

• He is an accomplished, Certified ORACLE Database Administrator, and IT security expert with over7 years of experience with extensive expertise and dexterity in Monitoring & Tuning, Migration, Security Implementation, Cloning, Backup & Recovery, Replication, and Database Design. He is also proficient in various technologies such as Oracle 10g, 11g, 12c, SQL loader, My SQL, and MS SQL server.
• He also poses verbal, written, analytical and organizational abilities. With Motivational Management style, known for building and retaining highly motivated teams and expansion of innovative solutions.
• A dynamic affluent person who can gracefully manage multiple priorities and perform extraordinary under pressure.

AREAS OF EXPERTISE

• Installation, configuration, capacity planning
• Performance Monitoring & Tuning
• Backup & Recovery, Upgrades & Migration
• Database Security & Patching
• Oracle ASM & Grid Control
• Oracle Data guard
• Oracle Golden Gate
• Bash/Unix shell scripting & Automation
• Database Cloning
• Transparent Data Encryption (TDE)

PROFESSIONAL EXPERIENCE

Confidential, Tallahasse, FL

Oracle Database Administrator

Responsibilities:

• Support multiple databases running Oracle 11g and 12c on Linux platforms in all environments in multiple data centers.
• Designed backup strategies following company service - level agreement; execution of backup schedule for both physical and logical backups using RMAN and DATAPUMP utilities respectively. Used block change tracking (BCT), reducing backup time from 5hrs down to 45mins. Resolved space issues with backup optimization, reducing storage costs by 20%.
• Database migration from 10g to 11g and upgrade to 12c using the Oracle Datapump and DBUA respectively. Cloned databases for testing using RMAN and DATAPUMP utilities for all database sizes.
• Applied Oracle’s quarterly Critical Patch Update(CPU/PSU application) using Opatch utility to install, test, and deploy patches to all database instances.
• Installed and configured software for Oracle 11g, 12c on both Windows and UNIX platforms using Oracle Optimal Flexible Architecture. Also installed, administered and maintained SQL Server Instances 2008 and 2012.
• Performing Database Refresh from production to test and development environments using RMAN Duplicate.
• Proactively monitor the database systems to ensure secure services with minimum downtime.
• Constructed database security policy using passwords, privileges, user profiles, Transparent Data Encryption to encrypt tables and Tablespaces; implemented auditing policies as well as data redaction and data masking.
• Installed and administered Physical Standby databases to achieve high availability and disaster recovery solutions (DATA GUARD).
• Supported daily administration, monitoring, tuning, and troubleshooting on single instance on UNIX/Linux, Windows server 2008 and 2012 (Database sizes range 100GB to 35TB).
• Monitored AWR, ADDM, ASH, Alert log, dynamic performance views, DBMS STATS, Trace files, System Event Logs for unusual events and took appropriate action according to company policies of incident reports.
• Implemented table and index partitioning and materialized views to minimize DB time, increase disk load balancing, improve query speed and enable faster parallel query.
• Capacity planning to meet the demands of the dynamic aspects of storage and memory for the databases.
• Generated shell scripts with developers to automate maintenance and backup jobs.
• Maintaining highly reliable 24x7x365 Linux production servers for AWS EC2 instances.
• Reconciled functional and technical problems through research and training workshops, achieving a 65% increase in satisfaction rate of database end users and supervised the coaching of junior DBAs.
• Part of the support team for 24/7 on-call production support.
• Generating Standard operating procedures (SOPs)

Confidential

Oracle Database Administrator

Responsibilities:

• General database administration task like installation of Oracle 10g and 11g, creation of users and roles Implemented a backup and recovery strategy policy under tight SLA times using RMAN and Datapump
• Supported daily administration, monitoring, tuning, and troubleshooting on Unix/Linux on a Microsoft server 2008, 2012. managing tablespaces, and ensuring database functionality.
• Highly skilled in SQL, Sqlplus including DML,DDL, and writing quieres.
• System Development Life Cycle (SDLC) methodology for designing, analysis, development and implementation.
• Specialize in one way and multi way replication between oracle DBs using Golden Gate and Oracle Streams
• Designed and implemented the ETL utilizing PL/SQL and Talend Administration Suite.
• Used range, hash and composite table partitioning which greatly decreased the DB time and SQL Execution time. Also performed instance tuning by changing init.ora parameters and managed region parameters such as shared pool size and db cache size with the use of AMM and ASMM.
• Managed database security by creating, assigning appropriate roles and privileges to users depending on the user activity, auditing, and performing other security related tasks including Transparent Data Encryption.
• Configured Oracle tools like SQL*Net to access the database across the network
• Expert in working with PL/SQL including Procedures, Functions, Cursors and Triggers.
• Applied Oracle's quarterly Critical Patch Update (CPU/ PSU application) using Opatch utility to installtest, and deploy patches to all database instances
• Experience working on ORACLE EXADATA Machine X4-2 for the extreme performance of the database
• Performing Database maintenance and upgrades which include patching, cloning and migration.
• Created and managed pluggable databases in the multitenant container database of the Oracle 12c architecture
• Experience migrating database objects from development through test and into production environments
• Configure and manage Cloud Watch alarms to monitor resources in AWS for Disk, Memory, and CPU utilization.
• Tuning poor running SQLs using the EXPLAIN PLAN, HINTS and SQL Tuning Advisor.
• Capacity planning (supported 3 tier architecture, planning of tables, indexes, tablespaces and databases) to allow for growth potential and analyze data growth trends for capacity and resources.