Vitalis Nkongban

adwm2f@r.postjobfree.com

240-***-****

Professional Summary:

•7 years of experience working as PostgreSQL Database Administrator performing core DBA duties including all basic database administration skills of physical structure, SQL & SQL applications, database administration, web connectivity, and overall architecture and database analysis on Linux, and Unix environment.

•Use tools like pgAdmin, MobaXterm to connect to PostgreSQL servers toperform basic administrative task like create new tables, insert data into databases, updating data.

•Hands on experience working with various technologies such as Linux/Unix (Redhat/Centos 6, 7 and 8), OpenSUSE, PostgreSQL 9.5, 9.6, 10, 11, 12 and 13, AWS RDS for PostgreSQL and Amazon Aurora.

•Hands on experience with migrating PostgreSQL databases on premises to AWS (EC2, RDS using AWS DMS (Data Migration Service) and Schema Conversion tool with continuous replication Change Data Capture (CDC)

Technical Skills:

•Linux/Unix (Redhat/Centos 6,7 and 8), OpenSUSE

• PostgreSQL 9.5, 9.6, 10, 11., AWS RDS for PostgreSQL and Amazon Aurora

•PostGIS.

Education:

•Bachelor’s Degree in Computer Science - University of Buea, Cameroon in 2010

Certifications:

•RHCSA 7

•AWS Solutions Architect Associate

•PostgreSQL 11 Associate Certification (Community Edition)

•AWS Database Specially Certification (In Progress)

Core Competencies:

•Problem-solving skills

•Detail oriented

•Good Communication skills

•Analytical thinking

•Organization

•Troubleshooting

•Performance tuning and PostgreSQL optimization

•Good customer service

•Good Team player

•Take initiatives

Professional Experience

Cognizant Technology Solutions (12 August 2021 to present)

Senior PostgreSQL Database Administrator

Installation, configuration, and administration of Postgres 11 databases on Unix based systems (RHEL 8).

Implement Replication Manager (repmgr ver-5) for high availability and Disaster Recovery (DR).

Automation of refreshes of the test and development environments.

Performance tuning of PostgreSQL databases for maximum performance of the application.

Hardening security in PostgreSQL clusters at the pg_hba.conf and at database level by granted only minimum privileges needed for a user to perform tasks .

Experience executing a large-scale database upgrade and planning database migration steps.

Extensive knowledge of database administration and relational databases

Migrate PostGIS databases from old server running PG 9.6 and GostGIS-2.1.4 to PostgreSQL 11 and PostGIS-3.0.1.

Configure Pg_pool II for for connection pooling and as Load Balancer.

Experience monitoring database performance and other server matrics (CPU, Memory, Disk space, long running queries) using told like pgAmin, Foflight, Nagios.

Use custom scripts to monitor CPU usage, disk space, Postmaster, Replication and send send out email notifications to Team when even any of the metrics are above the threshold value.

Monitor application related ETL jobs and data replication activities

Tune database queries using Explain and Explain analyze on the queries.

Manually refresh Test/Dev environments with data from Prod and vice versa using pg_dump and pg_dumpall.

Manage users by creating roles and assigning privileges and then assigning these roles to users.

Bayer U.S. LCC Pharmaceutical and Radiology, PA (11/2017 – 05/2021)

PostgreSQL Database Infrastructure

•Install and configure both enterprise edition of PostgreSQL and open-source PostgreSQL.

•Create a PostgreSQL database instance on AWS.

•Configure the parameter groups on amazon RDS.

•Create virtual private cloud(VPC) for security.

•Create subnets within the same VPC over different AZ

•Create AWS S3 buckets which serve as data lakes and storage

•Create read only replicas in different availability zones and regions for failover and load balancing.

•Experience configuring AWS CloudWatch, Performance insight, enhance monitoring to monitor application/database Logs for better understanding of the environment.

•Set auto scaling on read replicas based on number of connection or CPU usage.

•Create S3 bucket & folders, adding IAM Roles to it to have the required access, for Data integrity and secure transaction.

•Configure AWS lambda function to take regular snapshot and store in S3 buckets

•Migrate PostgreSQL databases on premises to AWS (EC2, RDS) using AWS DMS (Data Migration Service) and update migrated databases using CDC (Change Data Capture)

•Migrate Oracle databases on premises to AWS (EC2, RDS) using AWS DMS and AWS Schema Conversion Tool (SCT)

•Maintain on-going replication from source to target keeping them in sync for data integrity.

•Create an EC2 instance on AWS.

•Configure PgAdmin to monitor PostgreSQL databases instance on AWS.

•Test, monitor, upgrade, and tune new and existing PostgreSQL databases on Linux and windows.

•Create databases, schemas, tables, users/roles, tablespaces.

•Install and configure connection pooling tool like pgbouncer.

•Configure streaming and logical replication for high availability (HA).

•Installed and setup repmgr for high availability solutions with a witness for automatic failover.

•Install and configure PostgreSQL monitoring tools like PEM and PgAdmin.

•Identify, troubleshoot, and tune active database system hardware issues for better performance, optimized queries by creating indexes whenever its necessary, reindexing for unused indexes.

•Performed logical and physical Backup of Databases using Pgdump, Pgdumpall, pgbasebackup and pgbackrest for scheduled weekly and daily backups.

•Test backups to confirm if they are restorable to assure data available.

•Implement and test disaster recovery (DR) strategies and practices of production environment.

•Ability to work under pressure, thrive in a fast-paced and prioritize deadlines to meet customers’ needs.

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

•Upgrade PostgreSQL database from 11 to 12 using pg_dumpall, pg_dump, logical replication and pgupgrade utility.

•Provide 24/7 production support to the team on critical events and situations outside normal work hours.

•Work together with development, application, and operation teams to tune production queries for optimal performance.

•Carry out table partitioning to increase performance using range partitioning method.

•Configuring log analyzation tools like pgbadger.

•Setup maintenance plan vacuuming, database sizing, maintaining least privileges, and logging.

•Tuning auto vacuum parameters to ensure up to date table stats & reclaim space consumed by dead tuples Use python to perform basic administrative task like connecting to database, create new tables, insert data into databases, updating data.

•Run EXPLAIN ANALYZE to identify performance issues.

•Intensive use of top command to diagnose database issues

•Prepares and/or reviews activity, progress, and performance reports

• Write basic bash script to automate and monitor routine backups, vacuum, disk space, CPU usage, and send out email notifications.

•Install PostgreSQL using Yum repository and from source code.

•Configure pg_repack to vacuum and repack databases, schema and tables with putting exclusive locks.

•Perform in-place upgrade from one PostgreSQL version to another using pg_upgrade utility.

•Studied and stayed current on features and functionality of PostgreSQL.

•Set up Streaming Replication (asynchronous, synchronous and delayed replication) within same data center and between two data centers for disaster recovery and High availability.

Center for Nutrition Policy and promotion (CNPP), Alexandra VA (05/2014 – 05/2017)

PostgreSQL Database/ Linux Administrator

•Grant security permission to users on databases, schemas, and tables.

•Detect & diagnosed system problems like CPU, memory, disk space, I/O and other resource contention issues.

•Used Ansible for Orchestration, Configuration Management, Application deployment, Provisioning, Continuous Delivery, Security and Compliance.

•Configure, assign privileges to users, auditing to ensure security and integrity of the databases.

•Perform backups and point-in- time recovery using a tool like pgbackrest and pg_basebackup.

•Moved databases from Production to Testing and Testing to Production with pg_dump.

•Performed routine tasks like monitoring the database for Index, partitioning Memory, and I/O utilization.

•Used tools like CloudWatch, CloudTrail, Nagios, SNS, SQS, SES for effective management and monitoring our applications for zero downtime, CPU Utilization, Memory, storage capacity and when there is a performance bottle-neck in an infrastructure

•Monitoring the production PostgreSQL alert logs for database errors.

•Check Alert Log errors and make necessary actions to rectify them.

•Limiting the memory space and granting the necessary roles.

•Controlled client connectivity using pg_hba.conf files.

•Upgraded from 9.3 to 9.4, 9.6,10 and changing environmental variables.

•Creating new clusters and upgrade from one cluster to another.

•Installed and working with tools like Putty, Mobaxterm, WinSCP, filezella, Sql workbench, screen.

•Implement disaster recovery solutions and high availability by setting up a streaming replication for Point in time recovery strategy.

•Managing tablespaces, data files, redo logs and database objects.

•Monitor PostgreSQL Performance load testing on lower environment before moving databases to production servers.

•Creation of Clone Database for Development/Testing Environments.

•Worked as team member to provide 24x7 on-call production database support to ensure a proactive problem recognition and resolution.

•Used Ansible to Manage IT Infrastructures, install Packages and applications, update local &remote Host, connect to providers platform to effect changes, making changes on backend applications and websites of our customers via the Ansible Tower-Web UI (Restful APIs).

•Experience in System Administration, Installation, Upgrading, Patching using RedHat statelite, Configuration, and Troubleshooting.

•Intensive use of Secure file transfer protocols (SFTP) for file transfer from source to destination.

•Experience working with TCP/IP file transfer protocol

•Configuration of LVM (Logical Volume Manager) to manage volume group, logical and physical partitions.

•Allocated additional disk to LINUX Servers using fdisk utility.

•Utilized Confluence for technical documentation and training materials for purposes of sharing technical knowledge among Team members.

•Establish and maintain good communication with customers and end user especially educating customers to make good use of the application.

•Configure hostnames/domain name, static IP address.

•Create users/roles account and assign permissions on files, directories, databases, schemas, and directories.

•Used Ansible to install packages, applications, deployment, configuration management, automate software and upgrade the systems in the environment to latest version.

•Ability to handle multiple projects and communicate effectively, document the steps used to accomplish a task.

•Maintain and Deploy Redhat systems to provide optimum functionality for daily operations.

•Perform maintenance of file systems, create cron jobs for periodic processes like backups.

•Maintained System Security and ensured systems are up to date with current patches and backups/restores were completed without flaw.

•Coordinated and/or undertake troubleshooting of Linux Virtual systems, software, Network, hardware, and resolution of related user problems.

•Involve in complete Administration tasks on Redhat Linux 6,7 and document as per internal protocol.

Contact this candidate