JOHN DITAH

214-***-****

adjuap@r.postjobfree.com

Clarkston Georgia

www.linkedin.com/in/ditah-john

PROFESSIONAL SUMMARY

Mr. John is a Certified Oracle 12c Database Administrator with more than 8+ years of solid Oracle database administration skills and experiences in health-care and financial enterprise environments (DB size from 100GB to 27TB) across multiple industries including design, troubleshooting, development, implementation, migration, upgrading, maintenance of RAC, ASM, Data Guard, GoldenGate and production support of complex database applications and huge data warehouse system.

EDUCATION $ CERTIFICATIONS

Bachelor’s Degree in Mathematics / Computer Science, University of Buea, Cameroon

Oracle Database 12c: SQL Fundamentals, Oracle University

Oracle Certified Associate, OCA, Oracle University

Scrum Master Certified, International Scrum Institute

TECHNICAL SKILLS $ TOOLS

Operating Systems: Linux RHAT, MS Windows, AIX, Sun Solaris

RDBMS: Oracle (10g, 11g, 12c, 18c & 19c), MS SQL Server, MYSQL, DB2, PostgreSQL.

Tools & Utilities: ASM, Data Guard, Grid Control (OEM), GoldenGate, AWS, Tkprof, Statspack, AWR, ADDM, ASSM, Oracle SQL Developer, TOAD, RMAN, Export/Import, DataPump (expdp/impdp), SQL Loader, Transportation Tablespaces, SQL*Loader, logdump, Defgen, Foglight monitoring tool.

Programming Languages: SQL, PL/SQL, Shell Scripting, Python, HTML, CSS, Java

ETL & Reporting Tools: Informatica, Talnd, Oracle Data Integrator (ODI)

Backup Tolls: Veritas NetBackup, NetApp, TSM Backup, EMC Backup

PROFESSIONAL SUMMARY

Ally Bank, Remote 04/2020 – Present

Oracle DBA / GoldenGate Administrator

Responsible for installing, upgrading, patching and configuring the Oracle environment.

Monitored alerts and supported RAC, non-RAC, Data Guard databases on Unix, Linux servers using Oracle OEM

Provide advanced technical support to enterprise DBA team on Oracle database related technologies such as Exadata, Golden Gate, Streams, RAC, upgrades, migration, Performance Tuning, Backup and Recovery, RMAN, Partitioning, Oracle Enterprise Manager, SQL, PL/SQL, Code review and optimization, Materialized views, Flashback, troubleshooting, Data pump, RDBMS security, VLDB, optimize server resource utilization etc.

Excellent knowledge of database administration and configuration and experience with Oracle database 19c

Upgraded from Oracle 12c to 19c, tested its efficiency which offered new functions in almost all areas of the database such as multitenancy, In-memory, Json, support automatic indexing, hybrid partitioned tables, security and performance enhancements and zero-downtime Oracle Grid Infrastructure patching.

Involved in creating UNIX Shell Scripting, Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.

Writing shell scripts for hot backup and setting up cron jobs to automate backup procedures, cleaning up of archives.

Good experience in analyzing AWR, ASH & ADDM reports to find out performance bottlenecks and Extensively used AWR SQL Report to find out the execution plan changes, the plan performance and identifying the better execution plan for SQLs

Extensively used SQL Tuning Advisor to find out the possible recommendations and fixes for bad execution plan, better indexes, and any other additional recommendations for SQLs

Implemented Oracle high availability solution using oracle RAC, Physical Standby and GoldenGate.

Good knowledge in administering databases in EXADATA environment

Manage all aspects of the OGG design, implement and support in development, UAT and production environments. Identify and resolve OGG problems occurring in all database environments including performance related issues.

Troubleshooting typical OGG technical problems such as unique key violation / long transaction ABEND by using GGSCI / Log dump / discard file analysis etc.

Texas Health Presbyterian Hospital, Allen, TX 10/2016 – 04/2020

Oracle Database Administrator

Installed, designed and configured software for Oracle 10g, 11g, 12c, 18c and 19c on both LINUX and Windows platforms using Oracle DBCA, OUI, and OFA. Also Installed, Administered and Maintained SQL Server Instances. (Installing SQL Server 2008, 2012, 2014 and 2016).

Championed database migration from 11g to 12c and database upgrade from 12c to 19c using the Oracle Datapump and DBUA respectively.

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

Supported daily administration, monitoring and tuning, and troubleshooting on single instance on UNIX/Linux, Windows server 2012 and 2014.

Involved in creating UNIX Shell Scripting. Defragmentation of tables, partitioning, compressing and indexes for improved performance and efficiency. Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.

Monitoring and performance tuning using OEM Console.

Deployed Database security policy and installation, using passwords, privileges in user profiles, created roles, resource and security profiles well as granting and revoking of privileges.

Applied Oracle's quarterly Critical Patch Update (CPU / PSU application) using Opatch utility to install, test, and deploy patches to all database instances.

Used Oracle Transparent Data Encryption to encrypt tables and Tablespaces, I also implemented the “triple A” (AAA) and database auditing policies.

Installed and administered Oracle Physical Standby Database for single and multiple instances to achieve high availability and DR solution (DATA GUARD).

Performed database migration from on-premise to AWS Cloud using DMS

Used scripts in monitoring tablespaces threshold, password expiration and Automation using PYTHON and Bash/Unix Shell scripting.

Installed and configured the Oracle Golden Gate software on Unix/Linux platform for both Unidirectional and Bidirectional replication.

Upgrade Oracle GoldenGate from 11gR2 to 12c. Implement OGG 12c new features in mission-critical production environments

Configure and manage ASM instances on Oracle 11g and 12c.

Worked in a cross functional development team that oversaw the Oracle RAC installation and configuration for Linux environments.

Fixed various database performance issues using Automatic Workload Repository (AWR), Automatic Database Diagnostics Monitor (ADDM), and Active Session History (ASH).

Extensively used SQL Tuning Advisor to find out the possible recommendations and fixes for bad execution plan, better indexes, and any other additional recommendations for SQLs

Fidelity Investments, Middleton, WI 11/2012 – 09/2016

Oracle Database Administrator

Created databases from Entity Relational Diagrams (ERD) in Forward Engineering using the Oracle SQL Developer to OFA Institution and finally to DB launch.

Engineering and administration of Oracle stand alone and RAC clustered (11g, 12c) database environments.

Maintenance of production database and development database which includes table space management, user creation, and privileges, roles. Support RMAN backup and recovery including physical backups and logical backups by using data pump (Export/Import) tool. Extensively develop and maintain Bash shell and Perl scripts.

Installed, Administered and Maintained MYSQL Server Instances.

Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle; and database Normalization.

Monitored AWR, ADDM, and Alert log, dynamic performance views, DBMS_STATST race Files, System Event Logs for unusual events and took appropriate action according to company policies of incident reports.

Used range, hash and composite table partitioning which greatly decreased the DB_time. Also performed instance tuning by changing init.ora parameters and managed region parameters such as shared_pool_size and db_cache_size.

Configured Oracle tools like SQL*Net to access the database across the network and extensive NoSQL Data Extract using MarkLogic.

Experience in monitoring oracle instances and maintaining databases performance using OEM (Oracle Enterprise Manager 12c).

Configured Oracle Wallet and used Transparent Database Encryption (TDE) to encrypt tablespaces to meet client’s data security norms.

Applied Oracle's quarterly Critical Patch Update (CPU / PSU application) using Opatch utility to install, test, and deploy patches to all database instances.

Created and managed pluggable databases in the multitenant container database of the Oracle 12c architecture.

Configure and manage CloudWatch alarms to monitor resources in AWS for Disk, Memory, and CPU utilization.

Managed ASM storage disk groups like adding/dropping/managing disk groups Configured and replicated databases using in Golden Gate for e-Commerce applications

Based on client requirement automated database refresh process which needs to be done every night using exports & imports to refresh the DEV databases

Contact this candidate