More than 6 years of diverse experience in administration of Relational Databases . Extensive technical skills and understanding of PostgreSQL, MS SQL Server Databases in the cloud and on-prem. Strong collaborator and team player with excellent communication skills and expertise in analytical problem-solving. Key participant in daily meetings to discuss about the new database maintenance strategies, Backups and creation. Installing and configuring open source and enterprise databases systems. Experience designing database structures, indexes, views, partitioning. Installing and configuring multiple PostgreSQL utilities e.g. EFM, pgbouncer, pgpool, pgbadger, pg_backrest, pg_repack etc. Installing and configuring MS SQL Server 2017, 2019 & 2021 (standard and enterprise editions), PostgreSQL 10.x, 11.x, 12.x, 13.x &14.x on AWS RDS and EC2. Installed, configured, upgraded, migrated (as necessary) and maintain several instances. Troubleshoot replication, corruption issues and fix as appropriate. Extensive work experience on production databases.
Skills
PostgreSQL, EDB Postgres, RDS Postgres, MS SQL SERVER, MYSQL,.
University of DoualaDouala, Cameroon, Expected in 08/2014 – –Bachelor of Science:Computer Science - GPA:
Work History
Cognizant Technology Solutions - Cloud Database Administrator (PostgreSQL, MS SQL) Mckinney, TX, 07/2022 - Current
Taking Backup of PostgreSQL Databases running on AWS RDS using pg_dump, AWS Lambda & AWX Backup.
Configured MS SQL Server Option group called "Native-backup-restore" to backup MS SQL databases running on AWS RDS. and store in S3 bucket.
Working in collaboration with the SRE Team for database monitoring,
Monitored my databases using Dynatrace, Performance Insights, Enhanced monitoring, CloudWacth and Dynatrace.
Compared 2 different schemas and two different databases to find the missing tables using Pg_Admin.
Installing and configuring PostgreSQL & MS SQL Databases running on AWS RDS, on-premises.
Configuration of pgbadger to analyze the results of load testings in order to address database issues.
Stand up a production database with a snapshot of the staging environment, shared from a different AWS account.
Modification of the RDS databases to enable more features like performance insights, enhanced monitoring, delete protection etc.
Upgraded multiple PostgreSQL databases from 10.x to 12 and 13.x
Homogenous migration of PostgreQL databases from on-prem to AWS RDS using pg_dump, pg_restore and psql.
Assisting deployment teams by running database scripts (MDL, DDL, TCL etc.), by taking a backup of specific database or table as recommended on the Jira Tickets.
Assisting deployment team with issues related to backup and restore etc.
Worked with DEVOPS Team to address the database readiness after a new deployment.
Troubleshooted staging & production databases and resolved issues with corruptions, queries and Database latency;
memory management, thread and tasks managements, buffer management;
Configuration of PostgreSQL & MS SQL SERVER Parameter group to address specifics database problem based on the result of our investigations
Proposed to the DBA a maintenance plan strategy to resolve database issues, specially for some critical production databases.
Configured pg_cron to automate our db maintenance tasks like VACUUM ANALYZE, REINDEX, CLUSTER.
Resolved issues with cache missed, bloat, temp_files, deadlocks, locks, frequent checkpoints, index corruption, latency due to the table size, full storage, extension not present in rsd.allow_extensions, high CPU usage etc.
Configured pg_repack for full database vacuum with minimum downtime.
Scheduled SQL agents to resolve issues with fragmentation & kill sleeping processes on MS SQL SERVER databases
Used basics Kubernetes commands to find information as per business requirement.
Providing response for all system / database issues on 24 x 7 schedule responding to critical events and situations outside normal work hours
Monitored the database for Index, partitioning Memory and I/O utilization,
Connect to my RDS MS SQL SERVER using MS SQL Management studio;
Used EXPLAIN and EXPLAIN ANALYZE to identify and fine tune SQL queries for performance improvements;
Switched the Database from Production to Testing and Testing to Production;
Prepared technical interview questions to interview with few candidates for the position of Database administrator;
Familiarity with Parameter store, Route 53, EBS, LastPass etc.
The Active Network - PostgreSQL Database Administrator Remote, DE, 02/2019 - 05/2022
Create IAM user accounts and role-based policies for access to AWS Postgres on Both RDS and EC2 Instances, Compared custom and default parameters group
Defined AWS Security Groups which acted as virtual firewalls that controlled the traffic allowed to reach one or more AWS EC2 instances;
Manage the Space and Storage of Databases through various Shell Scripts scheduled in the crontab periodically in regular intervals;
Performed database Refreshes and monitored replication delays;
Highly experienced in Configuration, Implementation and Maintenance of Log Shipping;
Created new cluster and upgraded the cluster to another PostgreSQL sever;
Database secutity with Row level security, search path, pg_hba.conf and postgresql.conf
Installed and configured MTK for migration from Oracle to postgresql and EDB advance server;
Maintained postgresql with PgAdmin 4, Psq;
Created tablespace, databases, indexes, moving data, granting of necessary privileges in posgresql and EDB advance server from 9.6 to 12.x.
Performed backup, restore, and created databases using PgAdmin 4, pg_dump and pg_basebackup, pg_backrest.
Created Tablespaces, Schemas, Users, profiles and implementing various adjustments in postgresql.conf file and granting users and application access through pg_hba.conf file etc;
Tuning autovacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples.
Provided response for all system / database issues on 24 x 7 schedule responding to critical events and situations outside normal work hours;
Worked with development and operations teams to tune production queries for optimal performance;
Proactive managing standby replication methodologies like Streaming replication and hot standby for disaster recovery;
Configuring monitoring tools for better performance like PEM, CloudWatch, Performance Insight, Postgresql logs.
Proactive in updating the latest security patches to database, which are provided by PostgreSQL open-source community;
Configured and Database installation creating tables, schemas;
Monitored the database for Index, partitioning Memory and I/O utilization
Configured Enterprise Failover Manager for fast database failover, and integrate that with pg_pool-II for connection pooling and load balancing to resolve issues with locks and deadlocks.
Implemented cascading replication for our databases running on EC2.
Used EXPLAIN and EXPLAIN ANALYZE to identify and fine tune sql queries for performance improvements.
CVS Pharmacy - Database Administrator City, STATE, 02/2018 - 01/2019
Maintained detailed technical documentation of database architecture and modeling as per business requirements;
Provided technical assistance for preparation of shell scripts for tasks automation;
Conducted complete analysis of database capacity and performance requirements;
Implemented procedures for analysis, consolidation and tuning of
databases for efficiency;
Implemented a database replication, replication monitoring
configured pg_bouncer for load connection pooling
Upgraded databases from 9.6 to 10.x and 11.x using pg_upgrade
Performed database maintenance tasks like vacuum, analyze, vacuum full, reindex, cluster, create index etc.
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
How this resume score could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
