PROFESSIONAL SUMMARY:

Confidential is an accomplished Database Administrator and IT security expert with over 8 years of experience, and extensive knowledge and proficiency in database design, monitoring & tuning, migration, ppgrades, backup & recovery, cloning, replication, and security implementations. I am also proficient in an assortment of technologies including Oracle 10g, 11g, 12c, and 18c, MySQL and MS SQL Server. I also possess exceptional written, verbal, analytical, and organizational abilities. Proven leader with motivational management style, a solid reputation for building and retaining highly motivated teams, and development of innovative solutions. An energetic achiever who can successfully manage multiple priorities and perform tremendously under pressure.

AREAS OF SKILLFULNESS

• Installation, Configuration, Capacity Planning
• Transparent Data Encryption (TDE)
• Oracle Golden Gate & Data Pump
• Backup & Recovery, Upgrades & Migration
• Oracle Data Guard
• Database Security & Patching
• Oracle Data Guard & Data Pump
• Bash/Unix Shell Scripting & Automation
• Performance Monitoring & Tuning
• Oracle ASM & Grid Control

TECHNICAL SKILLS AND TOOLS:

• Installation, configuration and update of Oracle 11g, 12c, & 18c using OUI, DBCA, DBUA
• Monitoring and performance tuning using OEM Console, Toad, SQL Developer, Grid Control, TKProf, Explain Plan, Statspack/AWR, ADRCI, ADDM, DRA, Dbms monitor
• Work with various operating systems such as MS Windows Servers (2008, 20012,2014), UNIX (Solaris 8/9/10), LINUX (Red Hat, Ubuntu, Centos)
• ETL tools: SQL*Loader, Informatica 9.1, Ab initio 3.1.5.3, IBM data stage 11.5
• Backup & Recovery using RMAN
• MS SQL Server Management Studio
• SQL, PL/SQL, UNIX Shell Scripting
• Oracle ASM (clusters) and RAC configuration and administration
• Oracle Golden Gate (Data Replication)
• Database security, Oracle APEX, JIRA
• Oracle Data Guard installation/administration for high availability and Disaster Recovery (DR)
• Database migration using Exp/Imp/Datapump and SQL Loader

EXPERIENCE:

Oracle Database Administrator

Confidential, Washington, DC

Responsibilities:

• Revamped and implemented a backup strategy following company SLA; execution of backup schedule for both physical and logical backups using RMAN and DATAPUMP utilities respectively. I also used block change tracking (BCT) which reduced backup time from 8hrs down to 45mins.
• Experience with providing and maintaining high availability and disaster recovery using ORACLE DATA GUARD.
• Providing on - going performance monitoring and debugging, resulting in a major reduction in downtown due to these issues.
• Provide day-to-day support of Oracle 12.2.0.1 databases as part of a database team.
• Configuring/installing and/or ppgrading production and non-production databases to 11.2.0.4, and some to 12.2.0.1, on Linux (RHEL 7.5) using OFA, DBCA, DBUA, and OUI.
• Analyzing the database performance and performed database performance tuning.
• Enhancing database performance, performed restores, handled performance tuning and conduct regular system backups.
• Provide deployment and design assistance to development and other application support teams.
• Diagnosing and tuning database performance.
• Analyzing the database performance and performing database performance tuning.
• Maintaining database security policy and installation, using passwords, privileges and user profiles, Used Oracle Transparent Data Encryption to encrypt columns, tables and Tablespaces, I also implemented the “triple A” (AAA) and database auditing policies as well as data redaction.
• Monitoring and troubleshooting database performance using OEM, AWR, ADDM, ASH, Explain Plan, and TOAD.
• Performing other security related tasks including Transparent Data Encryption (TDE).
• Implementing security policy enhancement through roles, profiles, privileges and password policies per business requirements.
• Shared responsibility for administration of Hadoop & Hive.
• Cloning schemas, objects and databases on new server using exports from 10g database and imported in 11g using data pump.
• Capable of processing large sets of structured, semi-structured and unstructured data and supporting systems application architecture.
• Managed and reviewed Hadoop log files.
• Lead planning, configure and deployment of security patching of applications and databases.
• Performing backup and recovery procedures using RMAN and Data Pump utility for Oracle databases.
• Work with deployment teams and 3rd party vendors throughout the development life cycle regarding optimal use of database resources and features.
• Analyzing the database performance and performing database performance tuning.
• Upgrading databases from 10g to 11g and 11g to 12c. Appling PSU (Patch Set Update) and bug fix patch.
• Manage and administer JIRA/Confluence/BitBucket add-ons, plugins, and extensions.
• Implementing, tuning and maintaining Oracle database using OEM.
• Excellent knowledge of SDLC and experience working with Agile teams.
• 2+ years’ experience in JIRA & Confluence administration involving creation and management of custom, complex projects, workflows, security schemes, custom fields, dashboards and reports configurations.
• Provide APEX guidance and support to technical staff on application maintenance and SDLC process.
• Support APEX applications and conduct performance tuning for PLSQL.
• Two years’ experience installing, configuring, testing Hadoop ecosystem components.
• Contribute with database designs and assist in increasing response time for APEX reports.
• Developing Standard Operating Procedures (SOPs) for data extraction, outage reports with supporting resolutions, preventative maintenance documentation and weekly activity report.
• Apply Oracle’s quarterly Critical Patch Update (CPU/PSU application) using Opatch utility to install, test, and deploy patches to all databases instances.
• Participating in the 24/7 on-call DBA rotation schedule.
• Installation, upgrading, configuration, and troubleshooting Golden Gate 12c software.
• Configure Golden Gate High Availability using Oracle DBFS and Active DataGuard.
• Perform database tuning by reviewing AWR & ADDM reports, implementing SQL profiles and baselines, designing table and index partitioning and coalescing of database objects for faster query performance. Include memory, I/O, contention, and SQL statement tuning.
• Install and configured MySQL on Linux and Windows environments.
• Managing, troubleshooting and resolving oracle database and application issues.
• Create scripts and schedule backups in Cron for RMAN database backups and recoveries.
• Implement database security using Oracle's Transparent Data Encryption.

Oracle Database Administrator

Confidential, Owings, MD

Responsibilities:

• Identified root cause of Oracle errors and provided solutions to resolve errors.
• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
• Database tables design/maintenance using ORACLE partition technologies.
• Experience working on ORACLE EXADATA Machine X4-2 for the extreme performance of the database.
• Configured and supported Websphere 6.0,7.1 servers On AIX, Suse Linux and deployed multiple portals.
• Provided deployment and design assistance to development and other application support teams.
• Worked with developers during deployment and testing teams, regression testing, performance testing.
• Configuration and deployment of Iplanet, Apache, IBM http, Tomcat and SunOne servers and deployed apps and maintained clustered applications.
• Configuring/installing and/or upgrading production and non-production databases to 11.2.0.4, and some to 12.2.0.1, on Linux (RHEL 7.5) using OFA, DBCA, DBUA, and OUI.
• Created and managed pluggable databases in the multitenant container database of the Oracle 12c architecture.
• Applied Oracle’s quarterly Critical Patch Update (CPU/PSU application) using Opatch utility to install, test, and deploy patches to all databases instances.
• Lead planning, configured and deployment of security patching of applications and databases.
• Excellent knowledge of SDLC and experience working with Agile teams.
• Provided on-going performance monitoring and debugging, resulting in a major reduction in downtown due to these issues.
• 2+ years’ experience in JIRA & Confluence administration involving creation and management of custom, complex projects, workflows, security schemes, custom fields, dashboards and reports configurations.
• Supported daily administration, monitoring, tuning and troubleshooting on single instance on Unix/Linux, Windows server 2008 and 2012 ( Database sizes ranging from 100GB to 59TB).
• Implemented a backup and recovery policy under tight SLA times using RMAN and DataPump.
• System Development Life Cycle (SDLC) methodology for designing, analysis, development & implementation.
• Championed database migration from 10g to 11g and database upgrade from 11g to 12c to 13c using the Oracle DataPump and DBUA utilities respectively, while concurrently testing 18c.
• Installed and configured software for Oracle 10g, 11g, 12c, 13c on both Windows and LINUX platforms using Oracle OFA. Also installed, administered and maintained SQL Server Instances 2008 and 2012.
• 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.
• Experience migrating database objects from development through test and into production environments.
• Maintaining Database security policy and installation, using passwords, privileges and user profiles. Used Oracle Transparent Data Encryption to encrypt columns, tables and Tablespaces. I also implemented the “triple A” (AAA) and database auditing policies as well as data redaction.
• Created databases from Entity Relational Diagrams (ERD) in Forward Engineering using the Oracle SQL Developer to OFA Institution and finally to DB launch.
• Installed and administered GOLDEN GATE in a unidirectional, bidirectional, and broadcast configuration to mainly replicate data and ensure high availability in a heterogenous environment. Also worked with EXADATA machines for high performance and availability.
• Configured Oracle tools like SQL*Net to access the database across the network.
• Configured and managed ASM instances on Oracle 11g, 12c, & 13c.
• Worked in a cross functional team that oversaw the Oracle RAC installation & configuration for Linux environments.
• 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 the Oracle Golden Gate software on Unix/Linux platform for both Unidirectional and Bidirectional replication.
• Supported daily administration, monitoring, tuning, and troubleshooting on single instance on UNIX/Linux, Windows server 2008 and 20012 (Database sizes range 100GB to 21TB).
• Experience working on ORACLE EXADATA Machine X4-2 for the extreme performance of the database.

Database Administrator

Confidential, Silver Spring, MD

Responsibilities:

• Installed and configured Oracle 10g, 11g servers, and created databases in Linux environments.
• Researched, tested, and made recommendations of data validation tools.
• Enhanced database performance, performed restores, handled performance tuning and conducted regular system backups.
• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
• Established and implemented backup/recovery and patch scheduling, as well as exported and imported into the development/test environments, and for archiving purposes.
• 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 to ensure peak performance, stability and reliability and availability.
• Resolved locking issues, inconsistencies, and assisted in batch processes.
• Assisted developers with SQL code troubleshooting, as well as tuned applications, procedures, and SQL when necessary.
• Developed RMAN backup and recovery strategies and procedures.
• Performed database patching for bug fixes to mitigate security vulnerabilities.
• Test recovery and support continuity of operations procedures.
• Performed user administration.
• Performed all aspect of database operations and maintenance (O&M).
• 24x7 remote support and on call rotation.