BRUNO AKA MBAH

Database Administrator

adkq4n@r.postjobfree.com

202-***-****

SUMMARY SKILLS

Certified Database Administrator with over 7years of hands-on experience in database administration and architecture supporting varieties of database engine such as Oracle, PostgreSQL, and MS SQL Server. Some responsibilities include Installation and Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning and refreshes, Replication, Database Security, Memory Management, Performance Monitoring and Tuning. HA solution involving RAC, Data Guard, Cloud Control, Goldengate, Postgres Streaming Replication, SQL Server Failover Cluster and SQL Server log shipping. I have worked on Oracle, 18c 12c, 11g, 10g versions running on different OS platforms. Support production, test, UAT across a full System Development Life Cycle.’ EDUCATION

Bachelor of Science in ECONOMICS (BSc)

CERTIFICATIONS

Oracle Certified Associate, Database 12c Administrator (OCA)

CompTIA Security + ce Certification

Oracle Database 12c, Advanced Administration (OCP)

Oracle Cloud Infrastructure 2019 Architect Professional

Oracle Autonomous Database Cloud 2019 Specialist

Oracle Cloud Infrastructure 2019 Architect Associate

AWS Certified Solutions Architect-Associate

Oracle Database 12c: SQL Fundamentals

HIGHLIGTS

installed, configured, and managed PostgreSQL servers and worked recently with PostgreSQL Version 9.x, 10.x, 11.x and 12.x Community and Enterprise editions and system design.

Used the Enterprise DB Migration Toolkit (MTK), Ora2pg, AWS Data Migration Service (DMS) & Schema Conversion Tool (SCT) to Migrate data/databases across different database engines (Oracle to PostgreSQL) on-premises and AWS cloud.

Architect the PostgreSQL environment to support application requirements including the use of read replicas, number of connections, managing concurrency etc.

Administrate and Manage PostgreSQL Database environment including tuning, clustering, troubleshooting.

Oracle Software Installation and creation of databases and database objects

Excellent experience in managing large-scale OLTP databases of 20+TB size in HA and DR setup.

BRUNO AKA MBAH

2

Managed more than 10TB Oracle 11g & 12c databases in Data warehousing environment.

Starting/Shutting down the RAC databases and Creating and Relocating RAC database services to instances.

Lead efforts to develop and improve procedures for automated monitoring and proactive intervention, reducing any unplanned downtime.

Experience on Oracle 12c/11g/ASM/RAC and upgradation of standalone databases to 11g RAC environment.

Performed Migration and Upgradation of databases from 9i,10g to higher versions 11g,12c.18c

Strong skills in SQL, PL/SQL, Perl, and Linux shell scripting.

Implement, configure, and troubleshoot database instances, replication, backup, partitions, storage, and access. Set user privileges within and outside the database environment.

Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.

Switchover and Failover RAC database with Data guard Broker.

Implementation of RAC using ASM on 3 Nodes.

Proficient in Installation and configuration of oracle Golden Gate for real time data replication.

Experience in administering Golden Gate to support data replication in the Oracle database environment.

Apply PSU patch on standalone as well as rolling patch on RAC databases with no down time.

Monitoring the Database health check and growth with script.

Experience migration/consolidation of databases using Oracle 12c multitenant.

Designed and implemented Oracle Real Application Clusters (RAC) on Linux.

Experience in conversion of Single Node instance to multimode RAC with ASM and adding instance to existing RAC.

Planned disaster recovery scenarios with different recovery procedures and methods like Data Guard & Standby Database.

Provided valuable inputs for various performance tuning issues.

Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK

(perfstat), SQL*Trace, TKPROF, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory and OEM Grid. AWR and Cluster Interconnect Tuning (RAC)

Executed and implemented user helpdesk tickets of various issues via REMEDY database from creating user accounts, read-only accounts on a database & table down to assisting them with logging into the database. Experienced in using 10g features like 10g RMAN, Data pump Flash-Back Recovery

Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.

BRUNO AKA MBAH

3

Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Data pump Export/Import (Oracle 11g, 10g,12C) allowing users to quickly move a user Tablespace across Oracle databases.

Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Data pump, conventional Export/Import of Oracle 11g, 10g.

Extensively implemented Data pump, conventional Export/Import (Oracle 12c, 11g, 10g) for migration and logical backup of database.

Tablespace & Data file creation and Maintenance by Adding and Resizing data file if needed.

Excessive Experience with ensuring HIPAA Guidelines.

Responsible for database maintenance, backups, recovery, patching, upgrades and performance tuning, user access control.

UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.

Documentation (Deployments, SOP, Addendum, patch tracking, internal audits, capacity planning, status updates,

build procedures etc)

PROFESSIONAL SUMMARY

ALLY FINANCIAL - DETROIT, MI

August 2016 – 02/2021

Database Engineer

Capacity planning: Allocate system storage and plan future storage requirements.

installed, configured, and managed PostgreSQL servers and worked recently with PostgreSQL Version 10.x, 11.x and 12.x Community and Enterprise editions.

Used the Enterprise DB Migration Toolkit (MTK), Ora2pg, AWS Data Migration Service

(DMS) & Schema Conversion Tool (SCT) to Migrate data/databases across different database engines (Oracle to PostgreSQL) on-premises and AWS cloud.

Configured and proactively managed Streaming Replication (including cascading replication) between Master and two slaves on a PostgreSQL Server for disaster recovery, high availability and load balancing solutions.

Configure EnterpriseDB Failover Manager (EFM) on a PostgreSQL server to monitor streaming replication and automate failover for Application continuity.

Monitored and tuned PostgreSQL servers using PgBouncer & Pgpool to manage application connection pooling, pgBadger for log analysis and generating reports, pgDash,pgHero, pg_top

& pg_activity for real time PostgreSQL DB monitoring, PG_STAT_ACTIVITY, PG_STAT_STATEMENTS, PG_STAT_USER_TABLES, PGTune, pgstattuple, EXPLAIN ANALYZE, REINDEXING, PARTITIONS etc for better performance.

Backup PostgreSQL databases using pg_basebackup for physical backups (Compressed gzip backups) and pgBackRest & BART for incremental and differential backups as well as pg_dump and pg_dumpall for logical backups.

BRUNO AKA MBAH

4

Performed Complete and PITT recovery on PostgreSQL clusters based on pre-defined Service Level Agreement (SLA) using pg_restore and psql

Installation of oracle 11g, 12c databases in production, development and test environments depending on project requirements.

Oracle HA Stack: Install, Configure, Setup, Maintain and Support Oracle 11gR1, 11gR2, 12c RAC, Physical and Logical Standby database for Test, Development and Production for various home-developed applications.

Upgrade DBs from 11.2.0.4 to 12.1. Using DBUA with minimal down by prior testing in test boxes with accurate time notifications.

Experience in designing and configuring high-availability systems using Data Guard with physical standby effectively configured and used Data Guard Broker utility.

Plan and implement backup and recovery strategy and write scripts to do nightly RMAN backup using crontab.

Installed, patched, and managed Oracle Database versions 11g, 12c, 18c on Red Hat Linux

(OEL 5.7)

Involved in 24x7 on-call support for 30 databases ranging from 100MB to 20TB.

Responsible for 3node production 10g, 11g and 12c RAC databases using Oracle 12c Cloud Control for Alert Monitoring and Notification

Responsible for Setting up a unidirectional replication on oracle 11g databases using Goldengate.

Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment.

Responsible for setting and managing USER MANAGEMENT, SPACE MANAGEMENT Granting required privileges to users.

Proactively identify, troubleshoot, and resolve live database systems issues using AWR, ASH, ADDM, TKPROF, SQL TRACE

Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.

Refreshing Dev and Test instances with data from Production on a regular basis.

Setup notifications (various levels for Cluster activities, tablespace utilizations, Listener alerts) using OEM.

Efficient in using ASM for creating disk groups, adding additional storage (DISKS) and troubleshooting ASM issues.

Monitoring and troubleshooting the gaps between source and target databases configured with golden gate.

Successfully migrated 12c Non CDB databases to pluggable databases.

Created Oracle Wallets and implemented Tablespace level TDE security.

Successfully installed Oracle Real Application Cluster (RAC) including Grid infrastructure

(Clusterware and ASM) and Oracle rdbms software on 3 nodes RAC architecture in development and UAT running oracle.

BRUNO AKA MBAH

5

Creating database link between two databases to access the table data from one local database to remote database using distributed database feature.

Planned database backups (operating system, full/partial backups, and export/import) using various types of backups and designed the backup methodology for the organization.

Performed other Oracle DBA responsibilities performance tuning, monitoring tablespaces, monitoring users, etc. as well as much problem solving.

Written SQL scripts to create database objects like tables, views, and sequences.

Created procedures and functions using PL/SQL.

Developing and debugging PL/SQL stored procedures LIBERTY MUTUAL - DOVER, NH

May 2013– August 2016

Production Support Database Administrator

have worked on Microsoft SQL Server 2008 & 2012 Enterprise editions

Installed and used SQL Server Management Studio (SSMS) to create and managed SQL Server databases.

Used SQL Server Profiler for tracing and troubleshooting MS SQL server performance related issues.

installed, configured, and managed PostgreSQL servers and worked recently with PostgreSQL Version 9.x, 10.x, 11.x and Community and Enterprise editions

Administrate and Manage PostgreSQL Database environment including tuning, clustering, troubleshooting.

Setup data guard create physical-standby database using hot backup. Troubleshoot errors on standby. Manually register archive logs.

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, stored procedures, functions, packages, triggers to enforce the referential integrity constraints.

Monitored different databases and application servers using Oracle Enterprise Manager (OEM)

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

Applying PSU and CPU Patches for bug fixes and security

Tested the Data guard (DR) SWITCHOVER from Primary to Standby.

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

Monitoring the CPU, memory usage, I/O contention on servers using top, iostat, sar, glance, vmstat etc.

BRUNO AKA MBAH

6

Designed daily, weekly Backup and Recovery procedures for production, non- production databases using RMAN backups taking periodic Complete, cumulative, and differential Incremental Backups.

Wrote shell scripts to automate backup using crontab.

Participated in the installation and configuration of Golden Gate technology in a uni-directional topology for real time replication and integration.

Data Refresh/Cloning from Production environment to setup QA/ DEV using RMAN Duplicate.

Export/Import, Data pump, Transportable tablespaces to migrate databases from one database to another.

Prepared technical documents and knowledge transfer on project to the new team members.

Interfacing with Oracle Corporation for technical support. TECHNICAL SUMMARY

Operating Systems

Sun Solaris 2.5, 2.6, 8, 9,10. Linux red hat 6.7,

Windows Server 2008, 2012 R2

RDBMS

Oracle 10g, 11g, 12c 18c. PostgreSQL 9x,10x,11x. SQL Server, 2012, 2014, 2016

Languages SQL, PL/SQL, UNIX Shell Scripting,

Tools

ORACLE: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM Toad, Putty, WinSCP, OEM, VNC, TEAM VIEWER.

POSTGRESQL: PG ADMIN, MTK, BART, PG_STATS, PG_POOL, PG_UPGRADE, VACUUMING, PG_BADGER. VMware apache, PHP Database Utilities

SQL*Plus, Oracle Enterprise Manager, ASM, Transportable Tablespaces, SQL*Loader, RMAN, Data Pump, Export, Import. Expdp/Impdp, Triggers, Recovery Catalog.

Contact this candidate