Data Manager

MARCELIUS ATANGA

PROFILE SUMMARY

*years IT experience

Oracle DBA

Postgres DBA

SQL Server

AWS

MongoDB

Backup and recovery

Replication

Vacuum

Dataguard

RAC

Migrate.Oracle.postgres

Golden Gates

Performance tuning

Cloning

Shell scripting

Data modeling

Installation-upgrade-patching

Data security

Bash Scripting

ETL

Ansible and docker

SSMS

EDUCATION

Master’s Degree in Biostatistics, Hasselt, Belgium, 2013

Bachelor’s Degree in Mathematics /computer science Buea, Cameroon, 2005

Oracle Database 12C

SQL Fundamentals

DBA SKILLS

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

Operating Systems: Linux, Centos7, Windows HP-UX, AIX, RHEL

Tuning Tools: PgHero, KPROF, EXPLAIN PLAN, AWR, and ADDM, clustercontrol

Languages: SQL, PL/PGSQL, R, PERL, SAS

Utilities: RMAN, OEM, PgSQL*Loader, EXP, IMP, Data pump, TOAD, Oracle SQL Developer PgAdmin, PgAgent, Crontab, PgBadger, PgBouncer, PgDump, PgDumpAll, Pgbackrest.

Cell: 302-***-****

Email: *******@*****.**

Skype: Marx407

Visa: Green Card

Oracle/SQL-server/Postgres Database Administrator

PROFESSIONAL SUMMARY

Extensively used Database Administrative tools like: SSMS SSIS, SSRS, SSAS, Spotlight, SolarWinds, Enterprise Manager (PEM and OEM), SQL-Loader, PgAdmin, Postgres SQL*PLUS, SQL*DEVELOPER, TOAD for tuning and monitoring purposes.

Production support, database management and performance tuning

Worked on different Sql-server database versions (2012, 2014, 2016, 2017, and 2019)

Good experience in installation and Configuration.

Create and manage databases on Azure, AWS- EC2 and RDS, and manage S3 and EBS storage

Data warehouse for data consolidation OLAP and BI,ETL

Data modeling using Erwin

worked as a team member for 24*7 support with on call rotation in PROD, QAT and DEV environments

Good experience in applying Critical Patch Update(CPU) for security and Patch Set Update(PSU) for security and bug fixes using OPatch utility.

Migrated databases ranging from 200GB to 2TB to different platforms using SSMS, SCT-DMS, Migration Tool Kit

Participated in Strategic Planning, Logical and Physical Data Modeling & Application Tuning.

Excellent in Hot/Cold Backup with or without catalog, full backup, incremental, cumulative backups, Recovery and Cloning of databases using RMAN.

Extensive knowledge with OLTP and OLAP systems.

Manage application such as Enterprise Business Siute..EBS

Data loading using external tables, SQL*LOADER, PgSQL*Loader, Logical and physical backups using full export, Pgdump, PgDumpall and DATAPUMP.

Configured Master-Slave replication and monitored on-going replication

Installed, configured and maintained Goldengate on Oracle 11g, 12c for disaster recovery and data protection purpose

Ansible and Terraform for automation of scripts across servers

Enforced Security Administration, system monitoring by adding and removing users, configuring quotas, auditing, TDE, network and database encryption.

Migrations from SQL Server databases (2008, 2012,2016, 2019) to Azure.

Perform Installations, Upgrades, Patching

Disaster recovery: SQL Recovery Tool, Backup and Restore, Fail-over clustering, Log shipping, Database replication, Always on and Availability groups.

High Availability-, SQL Server: (Azure).

REPLICATION: SQL Server : ( Native SQL Server Replication (Snapshot replication, Transactional replication, Peer-to-peer replication), Qlik Replicate.

Performance Tuning (Partitioning, indexing, T-SQL, query optimization, Server tuning)

Speaks English, French and Dutch. A very good team player with advanced analytical skills, self-motivated, dedicated in any work environment and excellent in documentation.

PROFESSIONAL EXPERIENCE

SUNTRUST BANK - TAMPA, FL FEB 2017 –PRESENT

Oracle/Postgres DATABASE ADMINISTRATOR

MicroSoft SQL-Server

Involved in Installing/configuring MS Server 2016,2017 and Azure 2019.

Data Design and Development on Microsoft SQL Server 2012/2008R2/2008/2005/2000, T-SQL,

Experience with High Availability and Disaster Recovery solutions for SQL Server

Experience working with Windows Server, including Active Directory and proper disk configuration for SQL Server

Troubleshooting, SSIS/DTS Package Configuration, SSRS, SSAS and Data-warehousing.

Create DTS packages and jobs to monitor, backup, import/export data and data warehouse extracts

Proficient in developing Continuous Integration/ Delivery pipelines

Manage and monitor databases and queried using Sql workbench.

Specific hands on experience include administering large and complex Databases, Database Design, Normalization, Replication, Log Shipping, Full text indexing, and Database Application Development using varied development tools.

Hot and Cold Backups, Disaster Recovery Planning, Security Management, Managing server and clients, T-SQL, Pl/pgsql, Stored Procedures, Functions and Cursors and Triggers etc.

Experience with High Availability and Disaster Recovery solutions for SQL Server.

Create and maintain fully CI/CD Pipelines for code deployments using PowerShell.

Knowledgeable in setting up TDE for critical database and database tables for security reasons.

Providing database security administration such as User ID’s, Passwords, roles, etc

Manage and maintain logical database structures, physical structures, data, file systems, disk sub-systems, accounts/passwords, logical and physical backups, and database tuning

Perform DBA tasks to install, configure, test, maintain, backup, recover, patch, and upgrade

Tune, administer, and maintain SQL Server instance according to set standards

Develop and document procedures for backup and recovery of SQL Server database environments.

Performing BASIC TASKS on OBJECTS such as, creating roles, granting privileges, creating tables.

Experience with using SQL Profiler, Extended Event Sessions and Database Tuning Advisor in troubleshooting and tuning database and queries related issues.

Working knowledge on HA and Always on clustering. Creating and deploying always on AG groups on brand new VMs in a cluster setup and troubleshooting related issues that may arise in case of poor data synchronization or listener related issues.

Implementing the use of indexes, and primary & foreign key constraints as required

Providing PRODUCTION SUPPORT based on a ticketing system.

Assisted in defining and implementing MAINTAINANCE PLAN for the database systems.

High Availability (always on, log shipping, clustering)

Data Warehousing (SSRS, SSIR, SSAS)

ORACLE

Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.

Administered and monitored over 150 databases both on 10g/11g on prod/test/dev environments.

Administering Oracle Databases 10g/11g of sizes ranging from 100GB to 5TB.

Data warehouse solution for large databases for data consolidation, intended for OLAP and BI,ETL, using tools such as ERWIN, INFORMATICA, SQL-LOADER

Migrated databases from File-system to Automatic Storage Management (ASM).

Up-gradation of single instance databases from 10.2.0.4 to 11.2.0.3 on Linux.

Responsible for using Flashback query mechanism along with automatic undo management.

Automating Alerts, using SQL to set thresholds and triggers.

Installed 12C grid control and Used Oracle Enterprise Manager Grid control 11g/12c for monitoring databases.

Programming in shell to create shell scripts that automate the database backups and maintenance.

Involved in Mass Agent Deployment using Oracle Enterprise Manager 12c.

Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.

Applied Bug fixes patches, Quarterly Security Patches for RAC and non-RAC servers for issues when upgrading, DR switchover testing.

Reconfigured the OCR, public and private interconnects, modifying the VIPs and the subnet masks for 2, 3, 4 Node RAC Clusters and Upgraded single instance 9i/10g databases to 11gR2 RAC.

Setup, reconfigured and monitored 2, 3 Node RAC Primary to 2, 3 Node RAC Dataguard for DR.

Tested the Dataguard (DR) SWITCHOVER of RAC to RAC Dataguard as part of the migration.

Created new databases/instances on 12c/11g RAC and single instances using customized scripts, DBCA.

Handled all daily DBA activities and excellent experience with SQL scripting, PL/SQL coding, stored procedures, functions, packages, triggers to enforce the referential integrity constraints.

Performance monitoring and Database/Instance/ clustered Application tuning using Dictionary views, AWR (Statspack), ADDM, ASM reports, OEM Grid Control, tuned SGA/PGA parameters, initialization parameters and reorganized physical objects (tables & indexes) and tablespaces to improve the performance.

Redesigned table and index partitioning strategies, using HINTS to improve the query performance.

Developed, modified and optimized very complex queries to data retrieval using Explain Plan, SQL Trace, TKPROF, parallel processing and partitioning techniques.

POSTGRESQL

Implementing Best Practices for migration Oracle to PostgreSQL

Design and implement disaster recovery for the PostgreSQL Database.

Patch, Upgrade and keep the PostgreSQL DBs current. Develop and enhance scripts to automate and execute various DBA tasks.

Configuring and fixing the Issues with Pgadmin-III client application. Responsible for monitoring environments using monitoring tool viz. Nagios, Check_Postgres.pl, pgOn, custom scripts and other supporting tools like pgBadger and tailnmail.

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

PostgreSQL Installation, Configuration, Migration, Upgrades and Patches. Server versions ranged from PostgreSQL 8.2 to 9.5.

Disaster recovery planning or Emergency Recoveries and Ensuring Recoverability of Databases.

Optimize postgresql.conf for performance improvement. Review all PostgreSQL logs for problems.

Experience working on POC of 12c new features like Redaction policy, adaptive query optimization, multiple indexes on single column, Restore table through RMAN.

Installed and set up High Availability Oracle Golden Gate (OGG) systems on Oracle 11g and 12c environments. Upgraded Oracle Golden Gate (OGG) systems from 11g to 12c.

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

Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN.

Data warehouse for data consolidation OLAP and BI,ETL, ERWIN, INFORMATICA, SNOWFLAKE.

Installing databases preferably on-premise and Cloud PostgreSQL

Designing/developing/maintaining database schemas

CALPINE CORP - HOUSTON, TX Jan 2015 – Jan 2017

Oracle/Postgres Database Administrator

Created tablespaces, tables, indexes, set privileges and user logins on PostgreSQL and oracle databases.

Perform maintenance activities like checking auto vacuum jobs, and customized vacuum on certain tables.

Configured PgBouncer for connection pooling

Configured PgBadger for generating statistical reports

Supported Oracle DB backups (online/offline), logical backups and UNIX scripts, created clone databases, performed DBA day-to-day activities

Implemented shell-scripts for automation of day to day activities.

Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both OEM (client), Oracle 10g database control & SQL*Plus, as well as pre-developed UNIX shell scripts.

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

Backed up and recovered/Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2 and 11g.

Backup Oracle DBA for two major projects involving periodic administration, troubleshooting & tuning of 10 Oracle databases (10g & 11g single instances running on both IBM AIX 5.3, SunOS 5.8 & HP-UX B.11.11.

Installing databases preferably on-premise and Cloud PostgreSQL

Designing/developing/maintaining database schemas

Converting database schemas from on-premise Oracle databases to PostgreSQL database structures.

Writing data conversion scripts from on-premise Oracle databases to PostgreSQL database structures/stored procedures

Care Heath - Edison, NJ

Mar 2013 – Jan 2015

Oracle Database Administrator

Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.

Oracle Production Support Database Administrator

Administered and monitored over 150 databases both on 10g/11g on prod/test/dev environments.

Administering Oracle Databases 10g/11g of sizes ranging from 100GB to 5TB.

Migrated databases from File-system to Automatic Storage Management (ASM).

Involved in migrating applications from Solaris 10g/11g to Linux 11.2.0.3 using Transportable Tablespace, RMAN Convert.

Up-gradation of single instance databases from 10.2.0.4 to 11.2.0.3 on

Installed 12C grid control and Used Oracle Enterprise Manager Grid control 11g/12c for monitoring databases.

Programming in shell to create shell scripts that automate the database backups and maintenance.

University of Antwerp- Antwerpen

Mar 2011– Jan 2013

Statistical consultancy and BI

Statistical analysis, data management

Statistical reporting, and presentation.

Data Modelling, mathematical Modelling

Study design and mentorship and external client consultation

Contact this candidate