TERENCE AYUK

Database Administrator

Tel: 773-***-****

Email : addhqf@r.postjobfree.com:addhqf@r.postjobfree.com

SUMMARY OF QUALIFICATION

Database Administrator with 6 Years of experience in Database Management. Providing 24x7 productions and development support with Full responsibility and expertise in database administration, Installation, Performance Tuning, backup, recovery, security, optimization, Upgrade, Patching, Troubleshooting, Data migration from Oracle to PostgreSQL (ETL) and Exadata databases. Worked on PostgreSQL version 9, 10, and 11. Tuning index, partition, design, and maintenance. Knowledge in RAC Installation, Configuration and Tuning. Implemented Data Guard for disaster recovery and Golden Gate for Data replication. Good Communication and cooperation skills with an aptitude to learn quickly, Proactive, easily work with team and under pressure.

TECHNICAL SKILLS

Data Utilities

SQL*Plus, RMAN, ASM, Transportable

Tablespaces, Export, Import SQL*Loader, Data Pump

RDBMS

Oracle (10g, 11g, 12c, 18c, 19c), AWS and PostgreSQL 9, 10 and 11, Exadata, SQL Server

Applications

Oracle E-Business Suite 11.5.10, PeopleSoft, HR, FN, CRM

Tools

TKPROF, EXPLAIN PLAN, AWR, ASH, ADDM, Toad, Putty, WinSCP, OEM 13C,

Languages

PL/SQL, Shell Scripting

Operating System

Unix, (Linux Red Hat 7.4, AIX, Sun Solaris, Windows and HP

EDUCATION

University of Dschang, Cameroon

BSc History 2010

Certifications

Oracle Autonomous Database Cloud 2019

Oracle Cloud Infrastructure 2019 Architect Associate

Oracle Certified Associate (OCA) 12c

AWS Certified Solutions Architect-Associate

SQL Fundamentals

PROFESSIONAL EXPERIENCE

Newedge - Chicago, IL February 2017 – Present

Database Administrator

Responsible in Monitoring and Troubleshooting of Database Replication issues using Golden Gate, dealt with conflict resolution and performance issues.

Provides direction to team members as assigned by the Manager

Ensure and report ongoing progress to leadership, system owners and peers regarding health of the environment and status of the testing

Recovering Golden Gate corruptions and managing host/cluster maintenance mode blackouts.

Performed advanced “data only” clone of Oracle E-Business Suite test environment.

Implemented Initial Data Load, Batch/Online replication, Security in Golden Gate.

Resolved/Diagnose Node Eviction issues.

Implemented Oracle database 12C RAC databases using Oracle Clusterware for achieving high Availability.

Installation, maintenance and tuning of Oracle 11g RAC databases including ASM and CRS.

Implemented Active Data guard, creating both Logical and Physical Standby databases in 10g, 11g RAC & 12C environment for the Production databases.

Experience working on POC of 12cef13654r4 new features like Redaction policy,

adaptive query optimization, multiple indexes on single column, Restore table through RMAN.

Strong experience in Performing schema management, database sizing, maintaining privileges. Data migration while upgrading database versions ranging from 8.2 to 9.5.

Extensive experience with Warm Standby (PostgreSQL 8.x and earlier), and Hot Standby (PostgreSQL 9.x and greater)

I Have the ability to do performance tuning / index maintenance including backing up and restoring Postgres databases.

Implemented ASM on RAC and stand-alone databases and Applying PSU Patch and Migration of non ASM database to ASM database, and proficiency in using ASMCMD and ASMLIB.

Installation/Upgrade and cloning of technology stack for Oracle Applications/E-Business Suite (Installed on multiple platforms)

Designing and Managing of PostgreSQL database Schemas and experience in security access control.

Able to resolve the performance issue in database 12c using automatic big data caching, full database caching and In-Memory Aggregation features.

Provide database cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature.

Led a team that Configured Oracle Data guard for Oracle Disaster Recovery and Performed switchover/switchback from primary database to standby database for testing purpose for the application teams when required.

Have implemented different type of standby databases supported by Data Guard, logical standby and physical standby databases in 11gR2 on two node RAC

Migration from Oracle to PostgreSQL on/premise using the MTK tool kid

Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup and Comm vault.

Configured and managed Data Guard extensively for Production databases of sizes ranging from 50GB to 5TB.

Experiencing in Installing OEM 12c and 13c Cloud Control and upgrading the 11g management agents to 12c agents.

Cloning/duplicate of database with RMAN and user-managed (hot/cold) backups.

Developed RMAN Backup strategies for cloning the test databases with the production environment and worked on RMAN active-duplicate.

Successful Migration of databases to 12C from Oracle 10g&11g.

Also worked on Network data encryption to improve the security and, also implemented SSL wallet to secure the connections.

Redefinition of tables using DBMS_REDEFINITION, partitioning the tables in the production, re-defining the columns data types, and moving the LOBS to different tablespace

Partitioned tables Maintenance, adding new partitions, exchanging one-year old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.

Experience with Logical backups EXPDP/IMPDP and extensively used for Re-hosting the application using Golden Gate and worked with conventional EXP/IMP for migrating data from 9i to 10G.

Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS_JOBS, DBMS_SCHEDULER, Crontab and $UNIVERSE.

Handled Chained Rows and Row migration and solved the database performance issues.

Experienced with ASM, adding, deleting disks to the disk group.

Supported development teams for all the database related issues and handled the critical issues like network failures and ASM DISK group errors and node failures in the RAC cluster.

Successful Integration of Exadata Monitoring into our existing IT monitoring Framework

Implemented Best practice for migration E-Business Suite and regular database to Oracle Exadata

Generated Statspack/AWR reports using OEM 12C from Oracle 11g database and analyze the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth.

Responsible for all backup and recovery of PostgreSQL databases.

Responsible for configuring, Staging PostgreSQL databases within the organization.

Successful Migration from Oracle to AWS rds.

Experience in Upgrade and Migration from oracle 18c to 19c

Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries

Recovering Golden Gate Corruptions and managing host/cluster maintenance mode blackouts.

Hands- on Experience implementing and administering RDS and AWS

Weis Market Inc - Sunbury, PA February 2014 – January 2017

Database Administrator

Running scripts and monitoring the load process to avoid any issues in ETL jobs running for a long duration.

Continuously manage performance Tuning through trending analysis and work with development teams on identifying tuning opportunities.

Installe and configure E-Business Suite R12 (EBS) application on 2 Node Linux platform

I Monitored Database growth and provide Database capacity planning for applications expansion or necessary re-organization of tables and indexes as and when required.

Performing Database Administration activities like space management, user and roles administration, schema management, checking alert log of all the databases. Install Oracle 11g and 12c on multiple platforms.

Implemented and maintained Oracle 11g Data Guard /standby databases for switch-over and fail-over purposes. Created, relocated and removed Services as needed in an Oracle RAC configuration

Knowledge of Microsoft SQL Server technology and how to administer, create, upgrade, maintain and customize manually and using SQL Queries.

Performed up-gradation of 11g to 12c.

Performed traditional Cold backup in appropriate environments via OS commands as well as logical exports.

Performed day to day administrative tasks of Golden Gate environment for data replication and analytical purposes, replicating over 75 tables from source to target.

Using list partitions for large tables and bitmap indexes for the OLAP databases.

Responsible for configuring, integrating, and maintaining all Development, Staging and Production PostgreSQL databases within the organization.

Responsible for all backup, recovery, and upgrading of all the PostgreSQL databases. Monitoring databases to optimize database performance and diagnosing any issues in Data Guard environment.

Performance Health checking and Troubleshooting SQL Server with performance issues.

Develop, implement, maintain policies and procedures and document database architecture to ensure the security and integrity of the databases.

Remote administration and support of Oracle production and development Databases on major Operating Systems with sizes up to 11 TB.

Experience in Identifying performance bottlenecks on high volume transaction systems.

Analyze SQL statements and design indexes to improve response of queries.

Experience in Installation of Oracle Databases 9i, 10g, 11g, 12c, 18c and 19c versions.

Experience in the Upgrade of Oracle Databases in patch set Level and in version Level (9i to 10g), (10g to 11g) and (11g to 12c).

Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, Patch sets as per the Oracle recommendations.

Adding and removing nodes to existing RAC configurations.

Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN (full and incremental)

Configured Data Guard Architecture in a maximum performance mode both in production and lower environment

Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, data pump export/import.

Involved in each phase of life cycle (SDLC) including requirement gathering, technical design, development, system integration phase, quality assurance phase, development and production support activities.

Developed database monitoring/health check alert scripts for database uptime/downtime status, and sizing issues using grid control (OEM) and extensively used Oracle Enterprise Manager to do the daily tasks regarding performance and maintenance.

Troubleshoot Golden Gate errors by analyzing error reports and error logs

Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) /Network Attached Storage (NAS).

Implementation of Flashback Technology, Log Miner, Automatic Database Diagnostic Manager (ADDM).

Proficient in Database Design (Physical and Logical Database Design) and Normalization.

Expert experience in Hot and Cold Backup and Recovery, cloning of databases using RMAN, Veritas Net Backup and IBM Tivoli Storage Manager (TSM).

Used EXPDP & IMPDP to take backup at database level or tablespace level also, to accomplish table level and full database de-fragmentation.

Experience in Extracting, Transforming and Loading (ETL) data using SQL loader utility.

Automated many common tasks using crontab including Backups, exports and imports.

Monitor database systems and provide technical support for database system issues and application performance enhancement/ improvement using both Oracle 10g Grid Control & SQL*Plus, as well as UNIX shell scripts.

Contact this candidate