Your Name
Summary
Having 7+ Years of experience as Senior PostgreSql Database Administrator involved in backup and recovery methodologies, monitoring database performance.. Etc. Having support & troubleshooting experience in 24x7 environments. Experience in Remote PostgreSQL Server setup, Database design and Architect.
Overview
10
10
years of professional experience
Work History
PostgreSQL DBA
HCL TECHNOLOGIES
04.2020 - Current
- Responsible for all backup, recovery, and upgrading of PostgreSQL databases
- Monitoring databases to optimize database performance and diagnosing any issues
- Performs quality control audits to ensure accuracy, completeness, and proper usage of data in tables and various support tools, such as database dictionaries
- Scheduling daily Point in time recovery (PITR) to the development environment for proper product testing
- 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
- Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases
- Tuning autovacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples
- 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
- Configuring log analyzation tools like pgbadger
- Proactive in updating the latest security patches to database, which are provided by PostgreSQL open source community
PostgreSQL DBA
State Farm Insurance
12.2017 - 04.2020
- Ability to proactively identify, troubleshoot and resolve live database systems issues
- Knowledge of disaster recovery principles and practices, including planning, testing, backup/restore
- Hands-on experience on database administration, backup recovery and troubleshooting in co-location environments
- Ability to thrive in a fast-paced, deadline-sensitive environment
- Responsible for all backup, recovery, and upgrading of all of the PostgreSQL databases
- Cross platform migration from oracle to postgreSQL
- Work with development and operations teams to tune production queries for optimal performance
- Implement and monitor replication for high availability and disaster recovery scenarios
- Monitor and manage database indexes for optimal performance
- Daily log analysis using pgbadger tool and query tuning
- Maintaining custom vacuum strategies at table and db level
- Monitoring the DB growth for every month in DWH databases and planning to implement the table partitioning for better performance
- Monitoring the bloat repot on every table and performing maintenance with minimal downtime
- Performing major level upgrades using minimal down by prior testing in test boxes with accurate time notifications
PostgreSQL DBA
PRAGMATICS, INC
10.2014 - 12.2017
- Installing and Configuring PostgreSQL from source or packages on Linux machines
- Proficient in writing UNIX Shell scripts to automate business process and daily backups
- Experience designing database structures, indexes, views, partitioning
- Implementing backup and recovery (Logical and Online)
- Setup and maintenance of postgreSQL master-slave clusters utilizing streaming replication
- Cross-datacenter disaster recovery and backup architecture
- Data migration while upgrading database versions
- Performance monitoring and optimization
- Removing the Index bloat Concurrently to improve the performance
- Scheduled maintenance activities to vacuum, analyze to improve the query response time
- Query optimization and troubleshooting
- 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
- Establish and maintain security and integrity controls
- 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
Education
Bachelor of Science - Computer Science
University of Yaounde
Yaounde, Cameroon09.2010
Skills
- TECHNICAL SKILLS:
- RDBMS: PostgreSQL from 9x to 12x
- Languages: Shell scripting, PL/PGSQL
- Operating Systems: Linux, Unix, Windows, Centos
- Replications: Binary and Object level replications
- Backups: Logical and Physical backups
- High Availability: WarmStandby, Hotstandby, Streaming replication
Timeline
PostgreSQL DBA
HCL TECHNOLOGIES
04.2020 - Current
PostgreSQL DBA
State Farm Insurance
12.2017 - 04.2020
PostgreSQL DBA
PRAGMATICS, INC
10.2014 - 12.2017
Bachelor of Science - Computer Science
University of Yaounde