Postgresql / Oracle / SQL Server Database Administrator
Resume:
Christian Diffo
****.********@*****.***
LinkedIn Profile: https://www.linkedin.com/in/kiampi-christian-7670111b0
PROFESSIONAL SUMMARY
With 8 years’ experience in Database Administration, I have worked on very large production databases, performing various DBA roles across a multitude of platforms (LINUX, Solaris, UNIX, and Windows) in production, development and testing environments. Strong collaborator and team player. Good in analytical problem-solving and the ability to work in versatile environments. Experienced in PostgreSQL Enterprise Edition version 9.6 to 12, Oracle 10g, 11g, 12c, Multi-tenancy, Data Guard, Golden gate, RAC databases, OEM, Oracle installation, CPU patches, database Upgrades, Migration, Backup, Recovery, troubleshooting, security, Streaming Replication, Logical Replication.
PROFESSIONAL SUMMARY:
Implemented High Availability solution with PostgreSQL like Streaming Replication with EFM 3.9
Configured Logical Replication to Higher Versions
Performed Point in time Recovery
Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases 9.6, 10, 11 and 12.
Experience with MySQL, PERCONA, MONGODB.
Install and configured and troubleshoot Ansible
Expert with NoSQL
Managed and Administer Postgresql on AWS RDS
Managed Jenkins nodes and instances
Experienced in migrating from Oracle to PostgreSQL with MTK.
Experienced in migrating from on Premise Postgresql, Oracle and MySQL Databases to Amazon Aurora, RDS database.
Plans and coordinates the administration of PostgreSQL databases to ensure accurate, appropriate, and effective use of data, including database definition, structure, documentation, long - range requirements, and operational guidelines.
Performs quality control audits to ensure accuracy, completeness, and proper usage of data in tables and various support tools, such as database dictionaries.
Reviews database design and integration of systems, and makes recommendations regarding enhancements and/or improvements.
Establish and maintain security and integrity controls.
Experience supporting a mission-critical database environment with 24x7 On-Call Support including weekends.
Provides appropriate consulting, interfacing, and standards relating to database management, and monitors transaction activity and utilization.
Prepares and/or reviews activity, progress, and performance reports.
Plans and configures the physical database environment. Evaluates and recommends the purchase and utilization of technologies such as DMBS/s, servers, extract and conditioning tools, metadata management, security tools and archival and recovery tools and data access.
Develops project plans for implementing database environments. Provides input to technical projects and oversees the tactical aspects of all database related tasks.
Diagnoses, resolves and implements preventive measures to prevent problems for availability, recoverability and performance of all supported database environments.
Recommends and oversees implementation of database level configuration changes to optimize performance. Ensures maintenance of physical integrity of all production databases.
Develop SQL reports that meet client expectations for the application (used by custom application).
Tuning autovacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples.
Ensure night corn jobs for backups, re-Indexing & vacuuming & materialized views executed properly on 24/7 high availability Postgres production and development databases.
Take backups with pg_dump, pg_dumpall, pg_basebackup, BART.
Contributed to decreasing need for downtime by developing and improving procedures for automated monitoring and proactive intervention.
Studied and stayed current on features and functionality of PostgreSQL.
Proactive managing standby replication methodologies like Streaming replication and hot standby for disaster recovery.
Scheduling daily Point in time recovery (PITR) to the development environment for proper product testing.
Configuring log analyzation tools like pgbadger etc.
Studied and stayed current on features and functionality of PostgreSQL.
Implemented High Availability solutions with Oracle 11g RAC, Oracle Data Guard
Proficiency with Installation and maintenance of the replication tool Golden Gate by creating extract process, extract pump, and replicate.
Experience in Performance Monitoring and Tuning of Database, Application, Rollback segments, using STATSPACK, Explain plan, SQL Trace, TKPROF, AWR, Self-developed scripts, Oracle Enterprise Manager, Spotlight on Oracle, Toad.
Extensive Experience with RMAN Backups, Hot Backups and Logical Backups including full, Incremental and Cumulative while Automating routine DBA tasks like database backup and db stats by using Grid control /Crontab.
Extensively implemented Data pump, conventional Export/Import (Oracle 11g, 10g) for migration.
Built new 11g - 12c Databases from scratch on RHEL, OEL and Windows platforms from planning, testing through Release Management to validation.
Worked closely with support teams including Developers, SAs, Network, Backup, Storage and security
Collaborate with my Oracle support by submitting Oracle SRs to resolve critical database issues
Manage the Space and Storage of the Databases through various Shell Scripts scheduled in the cronjob periodically at regular intervals
Write Shell Scripts that automate the Import of Reports to PostgreSQL and MSSQL Databases.
Created RAC Database on Test Hosts, refreshed them with the latest snapshot of data from Prod Environment
Added and relocated the OCR Mirror and Voting Disks to existing RAC Setups to prevent Single Point of failure and scheduled & tested their physical and logical backups
ALLY FINANCIAL - DETROIT, MI
August 2017 – July 2020
PostgreSQL/Oracle Database Administrator
High Avalability
Migration
BACKUP
MONITORING
AUTOMATION
Streaming Replication
Logical Replication
EFM,
Pgbouncer & pgpool
MTK,
SCT & DMS,
EDB Portal
BART,
pg_dump,
pg_dumpall,
pg_basebackup
PEM
PGBAGER
PGDASH
ANSIBLE
Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases 9.6, 10, 11 and 12.
Plans and coordinates the administration of PostgreSQL databases to ensure accurate, appropriate, and effective use of data, including database definition, structure, documentation, long - range requirements, and operational guidelines.
Migrated from Oracle to PostgreSQL with MTK, EDB Portal.
Migrated from On-Premise Oracle to Amazon Aurora RDS database with SCT and DMS.
Migrated from On-Premise PostgreSQL to Amazon Aurora RDS database.
Migrated from MySQL to Amazon Aurora RDS database.
Managed databases on Amazon RDS
Managed and Administer Postgresql on AWS
Create EC2 instances
creating and Configuring DB instances
maintained the instance
backing up and restoring
exporting snapshots to Amazon S3
Monitored the DB instance
Upgrading
importing data into PostgreSQL on Amazon
Refreshed the Development, test and UAT environments with production data.
Active participant in discussions related to Backup Strategy, DR architecture. Maintained, patched, and upgraded servers as required.
Patch, Upgrade and keep the PostgreSQL DBs current. Develop and enhance scripts to automate and execute various DBA tasks.
Planning, deploying RDBMS Upgrades/Patches and performing other weekend maintenance activities as a part of On Call support.
Experience with AWS Redshift.
Establish and maintain security and integrity controls.
Perform quality control audits to ensure accuracy, completeness, and proper usage of data in tables and various support tools, such as database dictionaries.
Schedule and Ensure night cron jobs for backups, re-Indexing & vacuuming & refreshing materialized views executed properly on 24/7 high availability PostgreSQL production and development databases.
Tuning auto vacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples to optimize performance.
Expertise in Analyzing data Quality checks using shell scripts. Upgrading, installing, and configuring PostgreSQL servers.
Implemented Disaster Recovery and High Availability solution with PostgreSQL like Streaming Replication (1 Master 2 Slaves) with EFM for automatic failover.
Configured Logical Replication for real time replication.
Configured PgBouncer for Connection Pooling.
Take backups with pg_dump, pg_dumpall, pg_basebackup and BART for incremental Backup.
Scheduling daily Point in time recovery (PITR) to the development environment for proper product testing.
Providing support for various projects and ongoing issue in Development, Testing and PROD environment including Database upgrade, Application patches and DR Solutions.
Responsible for all backup, recovery, and upgrading of all of the PostgreSQL databases.
Support developers for efficient SQL query and Identifying long running queries and optimizing. Setup/Maintenance of Test/Development/UAT Servers setup.
Prepares and/or reviews activity, progress, and performance reports.
Responsible for monitoring environments using monitoring tool PEM,Nagios, Check Postgres.pl, pgBadger.
Proactively identify, troubleshoot and resolve live database systems issues. Knowledge in database design including logical and physical design.
Identifying and resolving incidents and address to user problems/concerns. Troubleshooting database issues.
Monitoring table and database growth.
Monitoring of system logs, OS logs, database logs, trace files, database alert files to detect and troubleshoot runtime problems.
Decreasing need for downtime by developing and improving procedures for automated monitoring and proactive intervention.
Reviews database design and integration of systems, and makes recommendations regarding enhancements and/or improvements.
Assist engineering team in the design of appropriate DB Schema and indexing strategy for performance and scalability
Attend bi-weekly/monthly meetings to understand business needs and provide suggestions for enhancement
Managed performance of team members, training and development planning.
Installation, configuration, Maintenance and Support of Oracle 11g and 12c (Multitenant and NON-CDB) Databases.
Upgraded the RAC and standalone databases from 11g (11.2.0.2, 11.2.0.3 and 11.2.0.4) and to 12c as part of performance improvement by utilizing the new features.
Set up of RMAN Catalog databases and registering target Databases with the Catalog.
Applied the Cluster ware (GI), Database (RDBMS) Patches i.e PSU patches and one-off patches (for Bug resolution) using Opatch.
Efficient in capacity planning
Implemented Oracle Dataguard and Standby databases, for real-time replication and disaster recovery
Performed Dataguard management operations locally or remotely through the Dataguard’s broker's easy-to-use interfaces GUI, and DGMGRL.
Refreshing Dev and Test instances with data from Production on a regular basis.
Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab
Installed and configured Oracle 11g database on a test server using Oracle standard procedures (SOP) and OFA, for performance testing and future production implementation.
Implemented and managed optimum physical database design (table spaces, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture (OFA)
Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups.
Performed database replication through Golden Gate
Used SRVCTL commands for Real Application Cluster (RAC) Databases
Monitoring the DB growth every month in DWH databases and planning to implement the table partitioning for better performance.
Migration from Oracle on premise to AWS Postgres and RDS.
Worked with MSSQL Management studio to manage sql server databases.
Attend bi-weekly/monthy meetings to understand business needs and provide suggestions for enhancement
Performing monthly and annual performance reports (AWR) for trend analysis and capacity planning.
Supported development teams by providing SQL statement tuning and optimizing ETL procedures, removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.
NEW BREED LOGISTICS - GREENSBORO, NC
March 2012 – May 2017
PostgreSQL/Oracle /MySQL Database Administrator
High Avalability
Migration
BACKUP
MONITORING
AUTOMATION
Streaming Replication
Logical Replication
EFM,
Pgbouncer & pgpool
MTK,
SCT & DMS,
EDB Portal
BART,
pg_dump,
pg_dumpall,
pg_basebackup
PEM
PGBAGER
PGDASH
ANSIBLE
Installing and Configuring PostgreSQL from source or packages on Linux machines.
Experience designing database structures, indexes, views, partitioning. Implementing backup and recovery.
Install and configured and troubleshoot Ansible
Expert with NoSQL
Experienced in administering and maintaining medium enterprise database servers on Linux servers.
Responsible for issue resolutions participates in meetings and presentation.
Participating in daily meetings to discuss about the new database design, modeling and creation.
Managed Jenkins nodes and instances
CI/CD pipeline setup
Controlling migrations of Shema, database through the development life cycle.
Setup and maintenance of Postgres master-slave clusters utilizing streaming replication with EFM for automatic failover
Cross-datacenter disaster recovery and backup architecture
Performing schema management, database sizing, maintaining privileges.
Data migration while upgrading database versions ranging from 9.6 up to 12.
Extensive experience with hot Standby (PostgreSQL 9.6 and greater).
Fixing the memory issues and suggesting the best practices.
Responsible for monitoring environments using monitoring tool PEM, Nagios,Check Postgres.pl, custom scripts and other supporting tools like pgBadger.
Performance monitoring and optimization.
Experienced in migrating from Oracle to PostgreSQL with MTK.
Experienced in migrating from on premise Oracle to Amazon Aurora, RDS database.
Experienced in migrating from on premise PostgreSQL to Amazon Aurora RDS database.
Experienced in migrating from MySQL to Amazon Aurora RDS database.
Managed databases on Amazon RDS
Installing and configuring Object level replication (Logical Replication).
Installing and configuring connection pooling tools like Pgbouncer and pgpool etc.
Configuring log analyzation tools like pgfouine and pgbadger etc.
Scheduled maintenance activities to vacuum, analyze to improve the query response time.
Maintaining custom vacuum strategies at table and DB level, Query optimization and troubleshooting.
Troubleshoots problems regarding the databases.
Close collaboration with engineering on schema additions and updates.
Implemented and utilized different backup tools such as mysqldump, Percona Xtrabackup and MySQL Enterprise backup based on company standards or client's needs.
Implemented and successfully tested Database Mirroring and Log Shipping in Oracle Server environments Proactive Performance Monitoring and Tuning
Expert level experience in Oracle RAC implementation & administration using Oracle Cluster-ware, (Oracle Cluster ware setup and configuration, RAC installation, Configuration and Patching, RAC Backup and Recovery)
Configured Automatic Storage Management (ASM) to fulfil storage needs. Experience in Implementing, configuring, trouble shooting, switchover, failover of Physical Standby Data Guard on 11g and 12c
Configured DataGuard for Disaster Recover and Golden Gate for real time Replication.
Used ADDM (Automatic Database Diagnostic Monitor), AWR (Automatic Workload Repository), and ASH (Active Session History) for analyzing the database performance and tuning.
Check the Accuracy of the Data being updated and ensure Perfect Reporting and Verify the Data Accuracy through various SQL Queries.
Having Experience working on Data center servers and handling greater than 1.5 TB databases.
Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization.
Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 11gR2.
Design and implement standard and advanced security enhancement and monitoring policies using transparent Data Encryption (TDE) and Fine grain auditing (FGA) also Managed Users, passwords and account lockouts.
Automated monitoring the databases, performance parameters, backup and recovery activities by running Cron jobs and customized various Unix Shell Scripts in sending Email for ORA- errors, reports for Quick Morning Check (QMC)
Worked with a team for installation and maintenance of ORACLE 11g RAC, ASM database for high availability.
Also Performed activities on ASM, creating disk group with different Redundancy Levels/using Fail group, adding a disk to a disk group, making disks online/offline and mount/dismount disk groups as SYSASM
Implemented proactive monitoring using Tuning Pack with Diagnostics Pack, and STATSPACK, SQL Trace, TKPROF, and EXPLAIN PLAN
Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines (Stored procedures), Statistics.
Applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using Opatch, runinstaller and sometimes utilized metalink for opening tickets, downloading and applying patches.
Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 10g, 11g, 12c)
Ran scripts to check the status of databases such as growing table sizes.
Supported off-hour on call support for database related issues.
Was responsible for network configuration that involved in a Client-Server environment using TNS names, LISTENER, Net Configuration Assistant and other configuration files.
Technical Skills:
Postgresql Databases Community and Enterprise Edition 9.6 to 11.8
Oracle Databases (RDBMS) - Oracle 10G (10.2.0.5), Oracle 11G (11.2.0.2, 11.2.0.3, and 11.2.0.4) and Oracle 12C (12.1.0.2 and 12.2.0.1)
Operating Systems - HP-UX, Sun Solaris OS (5.1, 5.2, 5.3, 5.9, 5,10, 6.1), Redhat Enterprise Linux, Oracle Enterprise Linux, Windows 2008 and 2012 R2ERP - Oracle E-Business Suit 11.5.10.2, 12.0.6, 12.1.1, 12.1.3, 12.2.2, 12.2.4 and 12.2.5
Database Utilities –
POSTGRESQL: pg_pool, pg_dump, pg_dumpall, pg_basebackup, pg_restore, pg_bouncer, pg_pool, BART,
ORACLE: OEM 12c & OEM 13c Cloud Control, Exp/Imp, Data Pump, DBCA. DBUA, OUI, RMAN, Goldengate Monitor, DGMGRL, GGSCI
Tools - Putty, Toad, SQL Developer, SQL*Plus, SQL*Loader, WinSCP, pgadmin, pgbader, PEM
CERTIFICATIONS: OCA, OCI, AWS Solutions Architech
EDUCATION
University of Yaounde 1, Cameroon. 2005 - 2008
BS in Computer Science
Contact this candidate