We provide IT Staff Augmentation Services!

Senior Oracle Database Administrator Resume

Ogden, UT

SUMMARY

  • I am an accomplished and certified Database Administrator who possesses exceptional written, verbal, analytical and organizational abilities.
  • In addition to that, I am a proactive IT security expert with over 8 years of experience with a broad knowledge and proficiency in Backup and Recovery, Security Implementations, Database Design, Performance Monitoring and Tuning, Migration, Upgrades, Cloning, and Replication.
  • Equally, I am proficient in an assortment of technologies including Oracle 10g, 11g 12c, 19c MySQL and MS SQL Server.
  • I am a proven leader with motivational management style, a solid reputation for building and retaining highly motivated teams and development of innovative solutions, with a strong aptitude to analyze and resolve problems.
  • I am an achiever who successfully manages multiple priorities and perform tremendously well under any condition, even when working under pressure.

TECHNICAL SKILLS

Databases: Oracle 10g, 11g, 12c, 19c

Database tools: SQL*Plus, SQL Loader, Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Log miner, Statspack/AWR, DBCA, DBUA, ADDM.

Operating System: LINUX (red heart) 7.2, UNIX (Solaris 8/9/10, AIX, HP - UX), Windows

PROFESSIONAL EXPERIENCE

Confidential, Ogden, UT

Senior Oracle Database Administrator

Responsibilities:

  • Current Secret clearance from the Department of Defense.
  • Maintain IAT Level II compliance for Department of Defense Directive 8570.
  • Implement DoD/DISA Security Technical Implementation Guide STIG requirements across multiple different Oracle database environments with all environments passing approval process.
  • Installed and configured EM Central Grid control (OEM Grid) to administer and manage large number of databases and ENTERPRISE - WIDE targets.
  • Upgrade OEM 13.3 to 13.4
  • Table refreshes and schema refreshes using Data pump, expdp and impdp.
  • Have done MIGRATION, which I also Manage end-to-end complex data migration, conversion and data modeling
  • Have done TTS (Transportable Table Space) from source Database to Target
  • Database refreshes using expdp, impdp, RMAN Duplicate and cloning.
  • Experienced in cloning the databases using HOT and COLD backups.
  • Have Use ZDLRA (Zero Data Loss Recovery Appliance) for my backup and recovery processes
  • Used RMAN Duplicate and HOT/COLD backups to migrate the data from 11.2.0.1 to 11.2.0.3.
  • Replication of data in heterogeneous data environments using Oracle Golden Gate
  • Created a stand by database by using RMAN Duplicate in order to reduce the down time for the PROD database during the migration process.
  • Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
  • Upgrade older Oracle 10g environment to Oracle 11g R2, and to 12c.19c
  • Performed backup and recovery via Recovery Manager RMAN, RMAN Catalog, and Oracle Data-pump to include automating all backup systems and maintain all System's Operating Procedures SOP for all ATIA related databases.
  • Implement shell scripting with CRON jobs, along with write PL/SQL procedures that are called in Oracle's job scheduler to automate database maintenance task.
  • Control access permissions and privileges.
  • Implement all current Oracle Critical Patch Updates CPUs .
  • Write database documentation, data standards, procedures and definitions.

Confidential, Burbank, CA

Senior Database Administrator

Responsibilities:

  • Rewrote and implements 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.
  • Deployed Database security policies and installation, using passwords, privileges and user profiles, Used Oracle Transparent Data Encryption to encrypt columns, tables and Tablespaces, I also implement the “triple A” (AAA) and database auditing policies as well as data redaction.
  • 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.
  • Cloned databases using RMAN and DATAPUMP utilities for all database sizes.
  • Extensively used AWR, ADDM, ASH, and Explain plan for periodic Performance tuning.
  • Monitored AWR, ADDM, ASH, Alert log, dynamic performance views, DBMS STATS, Trace Files, System Event Logs for unusual events & took appropriate action according to company policies of incident reports.
  • Experienced migrating database objects from development through test & into production environments.
  • Capacity planning (support 3 tier architecture, planning of tables, indexes, tablespaces and databases) to allow for growth potential and analyze data growth trends for capacity and resources.
  • Installed and administered Physical Standby Database for single and multiple instances to achieve high availability and DR solution (DATA GUARD).
  • Capacity planning to meet the demands of the dynamic aspects of storage & memory for the databases.
  • Built, deployed and managed processes on AWS secure and reliable network
  • Leveraged amazon cloud based services to provide flexible virtual infrastructure to users
  • Implemented table and index partitioning so as to Minimize DB time, increase disk load balancing, improve query speed and enable faster parallel query.

Confidential, Atlanta, GA

Oracle Database Administrator

Responsibilities:

  • Implemented a backup and recovery policy under tight SLA times using RMAN and Data Pump.
  • 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 using the Oracle Data Pump and DBUA utilities respectively. Currently testing 18c
  • Installed and configured software for Oracle 10g, 11g, 12c 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.
  • Experienced migrating database objects from development through test and into production environments.
  • Maintained 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.
  • 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).

Confidential, Washington DC

Oracle Database Administrator

Responsibilities:

  • 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.
  • Exposed to MongoDB to provide high availability with replica sets. Which consisted of two or more copies of the data.
  • 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).

Hire Now