COLINS CHI TANGIE

(Oracle Certified Associate **c)

(Microsoft SQL Server Administration)

(AWS Cloud Practitioner)

Tel: 202-***-**** Email: adc7m8@r.postjobfree.com

PROFESSIONAL SUMMARY

An accomplished Database Administrator and IT security expert with over 8 years of experience with extensive knowledge and proficiency in database design, monitoring & tuning, Migration, Upgrades, Backup & Recovery, Cloning, Replication, and Security Implementations. Proficient in an assortment of technologies including Oracle 10g, 11g and 12c, MySQL and MS SQL Server. Possesses 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. Great communication skills and can speak both English and French.

TECHNICAL SKILLS AND TOOLS

Oracle Data guard

Oracle ASM & Grid control

Oracle Golden Gate

Database Security & Patching

Backup & Recovery using RMAN

SQL, PL/SQL, UNIX Shell Scripting

Performance Monitoring & Tuning

Database security

Bash/Unix Shell scripting & Automation

MS Windows Servers

LINUX (Red Hat, Ubuntu, Centos)

Database migration using Exp/Imp

Datapump, and SQL Loader

OEM Console, Toad, SQL Developer, Grid Control

AWR, ADRCI, ADDM, DRA

Installation, configuration, patching & update of Oracle 11g, 12c, 18c and 19c

12c OUI, DBCA, DBUA

Oracle ASM (clusters) and RAC

MS SQL Server Management Studio

Oracle Data Guard installation

High availability and Disaster Recovery

Installation, configuration, capacity planning

Hardware and software maintenance

Oracle Exadata administration

MSSQL Server Databases administration

MySQL (Installation and administration of MySQL 5.6/5.7/8.0, backup and recovery, storage engines, monitoring and upgrade).

Oracle Golden Gate (Data Replication and integration)

IAM administration

Software testing

Microsoft Office (Word, Excel, Powerpoint, Access).

EDUCATION AND CERTIFICATIONS

Oracle Certified Associate 12c

Oracle University

MSc. in Technology, 2015

Ghent University

Bachelor of Science, 2010

University of Buea

PROFESSIONAL EXPERIENCE

Transamerica, MD

Senior Oracle/Microsoft SQL Server Database Administrator

01 / 2016 – Present

Installed and configured software for Oracle 10g, 11g, 12c on both Windows and UNIX platforms using Oracle OFA. Also Installed, Administered and Maintained SQL Server Instances 2008 and 2012

Championed database migration from 10g to 11g and database upgrade from 11g to 12c 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, tuning, and troubleshooting on single instance on UNIX/Linux, Windows server 2008 and 20012 (Database sizes range 100GB to 21TB)

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

Performed disk partitioning to improve performance, mirroring, stripping, clustering.

Capacity planning to meet the demands of the dynamic aspects of storage and memory for the databases

Deployed 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

Cloned databases using RMAN and DATAPUMP utilities for all database sizes

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

Performed database Refreshes from production environments

Wrote simple PL/SQL and powershell scripts for database tasks automation

Maintaining highly reliable 24x7x365 Linux production servers for AWS EC2 instances.

Part of the on-call production support team for 24/7 on-call production support.

Deployed and implemented Oracle Grid Control, 10g and 11g, to monitor all databases.

Wrote scripts for different database tasks.

Managed Oracle RAC for high availability

Configured and managed Data Guard for disaster recovery, data protection and high availability. Performed Data Guard failover as required for maintenance. This is done by coordinating with application owners and sys admins to when the failover can be performed.

Performed data and metadata migration to newly installed servers using Data Pump Expdp/Impdp.

Cloned production databases for testing, development using RMAN.

Used OEM (12c) for monitoring Oracle instances and maintaining database performance.

Designed and administered data warehousing and Business Intelligence platforms

Software Installation, patching and upgrade of MSSQL database server and databases.

Developed a backup strategy for our MSSQL Server databases and administered these databases using tools like SS management studio, SS DCA.

Working knowledge of Microsoft SSIS, SSAS, ETL, SSRS

Bio Scientific, Austin Texas Oracle Database Administrator 11/ 2014 – 11/2015

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

System Development Life Cycle (SDLC) methodology for designing, analysis, development and implementation.

Designed and implemented the ETL utilizing PL/SQL and Talend Administration Suite.

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.

Managed database security by creating, assigning appropriate roles and privileges to users depending on the user activity, auditing, and performing other security related tasks including Transparent Data Encryption.

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.

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

Expert in working with PL/SQL including Procedures, Functions, Cursors and Triggers.

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

Administration of Oracle single instance and RAC clustered database environments including 11g and 12c

Managed Oracle database systems including software installations, configurations, management, version upgrades and patches.

Responsible for database backups, designs, development, testing, performance tuning and database and system security through unique database roles and object permissions, resized database files to decrease cloning, backup and restoring time.

PharmaFluidics, Ghent, Belgium

Junior Oracle Database Administrator 11/ 2010 – 11/2014

Performed database logical backups using Data pump.

Oracle installations, upgrades, instance configuration, maintenance and troubleshooting.

Partitioning tables by determining the suitable methodology to improve performance and manageability.

Performance tuning and Monitoring using Grid Control database and managing instances using OEM

Worked with developers on constructing effective PL/SQL programs and packages

Cloned, patched and implemented upgrades and migrations

Performed Point-in-time recovery as well as cancel based recovery

Created and administered privileges, roles and profiles

Managed database auditing

Implemented Oracle Database advanced security practices such as Virtual Database Privacy, TDE and Data Masking

SQL tuning and database performance tuning using explain plan and SQL tuning advisor.

Used statistics generated by AWR, ASH, ADDM reports to monitor and tune the database.

Planned and scheduled backups and restore strategy, performed logical as well as physical backups.

Established automation of repetitive processes to minimize errors using scripts and OEM.

References: Available on request.

Contact this candidate