SUMMARY

• Highly seasoned and accomplished Database Administrator and IT expert with over 8 years of experience through extensive knowledge and proficiency in database design, monitoring & performance tuning, migration, upgrades, backup & recovery, cloning, replication, and security implementations of Oracle RDBMS.
• I am also skilled with an assortment of technologies including Oracle 10g, 11g, 12c, and MS SQL Server and MySQL.
• I possess exceptional analytical, verbal, written and organizational abilities. I’m a proven team player with motivational style, a solid reputation for building and retaining highly motivated teams and development of innovative solutions.
• I am an achiever who can successfully manage multiple priorities and perform extensively under pressure.
• I’m a proactive learner willing to update my skills with new technologies in other to improve my productivity in the workplace.
• My passion for this industry and the work I do drives me to deliver high quality work daily.

AREAS OF EXPERTISE

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

TECHNICAL SKILLS

• Installation, configuration and update of Oracle 11g and 12c using OUI, DBCA, DBUA,
• Monitoring and performance tuning using OEM, TOAD, SQL Developer, Explain Plan, AWR, ADRCI, ADDM.
• Work with various operating systems like MS Windows Servers, UNIX, LINUX.
• Database migration using Data pump.
• Backup & Recovery using RMAN
• SQL, PL/SQL, UNIX Shell Scripting
• Database security (TDE)
• Oracle Data Guard administration for High availability and disaster recovery.
• MS SQL Server Management Studio
• Implementing Database Security using TDE

PROFESSIONAL EXPERIENCE

Confidential

Senior Oracle Database Administrator

Responsibilities:

• Constructing database security policy using passwords, privileges, user profiles, Transparent Data Encryption (TDE) to encrypt tables and tablespaces; implemented auditing policies as well as data redaction and data masking.
• Working knowledge of DISA STIGS in other to enforce security and availability of Databases.
• Designing backup strategies following company SLA; execution of backup schedule for both physical and logical backups using RMAN and DATAPUMP utilities respectively. I used block change tracking (BCT), reducing backup time from 5 hours down to 45 minutes. Resolved space issues with backup optimization, reducing storage costs by 20%.
• Supporting daily administration, monitoring, tuning, and troubleshooting of Databases (300GB to 49TB).
• Monitoring AWR, ASH, Alert log, DBMS STATS and Trace Files and for unusual events and using the ADDM to analyze this report snapshots.
• Cloning schemas, objects and databases on new server using exports from 11g database and imported in 12c using DATA PUMP.
• Applied Oracle's quarterly Critical Patch Update (CPU/ PSU application) using Opatch utility to install, test, and deploy patches to all database instances
• Implementing, tuning and maintaining Oracle database using OEM.
• Capacity planning to meet the demands of the dynamic aspects of storage and memory for the databases.
• Reconciled functional and technical problems through research and training workshops, achieving a 65% increase in satisfaction rate of database end users.
• Developed Standard Operating Procedures (SOPs) and scripts to automate daily task and operations.

Confidential

Database Administrator / Developer

Responsibilities:

• Created, administered & maintained SQL Server Databases in development, test and production environments using SQL Server Management Studio.
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, backup verification on MSSQL Server using SQL Server Management Studio.
• Installed and configured Oracle 10g, 11g servers and created databases in Linux environments.
• Researched, tested, and made recommendations of data validation tools.
• Established and implemented backup/recovery and patch scheduling as well as exported and imported databases frequently into the development and test environments and for archiving purposes.
• Generated shell scripts with developers to automate maintenance and backup jobs.
• Part of a team that conducted a database migration from 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.
• Worked in a cross functional team that oversaw the Oracle RAC installation & configuration for Linux environments.
• Administering Physical and Standby databases for high availability and disaster recovery solution DATA GUARD
• Knowledge in working with PL/SQL including Procedures, Functions, Cursors and Triggers.
• Created, tracked, and closed service tickets using REMEDY ticketing system and developed a defect prevention process including but not limited to root cause analysis and corrective action.
• Controlled all databases with high alertness to ensure peak performance, stability and reliability and availability.
• Configure and manage ASM instances on Oracle 11g and 12c.
• Resolved locking issues, inconsistencies and assisted in batch processes.
• Assisted developers with SQL code troubleshooting as well as tweaked applications, procedures and SQL when necessary.
• Developed RMAN backup and recovery strategies and procedures
• Performed database patching for bug fixes, and mitigate security vulnerabilities
• Test recovery and support continuity of operations procedures.
• Performed user administration.
• Performed all aspect of database operations and maintenance.
• 24/7 remote support and on call rotation.

Confidential

Junior DBA

Responsibilities:

• An active member of a team that championed database migration from 10g to 11g using the Oracle Data Pump and DBUA utilities respectively.
• Performed database Refreshes from production environments using Data Pump IMP/EXP utility to QA and Development environments.
• System Development Life Cycle (SDLC) methodology for designing, analysis, development & implementation.
• Implementing table and index partitioning and materialized views to minimize DB time, increase disk load balancing, improve query speed and enable faster parallel query.
• Installed and configured software for Oracle 10g, 11g, on both Windows and LINUX platforms. Installed, Administered and Maintained SQL Servers (2012 and 2014).
• Implemented a backup strategy following company SLA, execution of backup schedule for both physical and logical backups using RMAN and DATAPUMP utilities respectively.
• Monitoring AWR, ASH and Explain plan for performance tuning.
• Managed database security by creating, assigning appropriate roles & privileges to users depending on user activity, auditing, & performing other security related tasks including Transparent Data Encryption (TDE).