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
Jersey, NJ
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
Bloomington, IL
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
McLean, VA
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