Postgresql Dba
Resume:
Richard Ngwese
**** ******* *****, ****** ** ****2
***************@*****.***
PROFESSIONAL SUMMARY
Hardworking, detailed-oriented, time conscious, proactive experienced database administrator with over (5+) years of experience in PostgreSQL engine both on-premise and on AWS in database design, installation, configuration, backup and recovery, security, migration, performance tuning and query optimization. In addition, I have experience in managing and supporting PostgreSQL 9X to 13X in development, test, and production environments. I have strong communication skills with team members, Developers, system Engineers and Devops to realize project goals.
Work Experience
Database Administrator
Mironkloud Tech, Mclean, VA 07/2018 – 03/2022
•Analyzes and determines informational needs and elements, data relationships and attributes, proposed manipulation, data flow and storage requirements, and data output and reporting capabilities for complex databases. Recommends and implements course of action based on analyses databases within the organization.
•Configure, install, and maintaining all development, staging and production PostgreSQL
•Serve as part of the Database Support Team in developing and implementing next generation database systems architecture
•Search for, identify, and correct data access performance and content quality issues
•Assist in troubleshooting and resolving database problems within our environment
•Proactive managing standby replication methodologies like Streaming replication and hot standby for disaster recovery
•Reviews database design and integration of systems and makes recommendations regarding enhancements and/or improvements.
•Implement and monitor replication for high availability and disaster recovery scenarios with principles and practices, planning, testing
•Performing routine tasks like schema management, database sizing, slow/long running queries, hung jobs, and maintaining privileges.
•Monitor and manage database indexes usage and tune them where appropriate for optimal performance
•Installing and configuring Nagios check PostgreSQL plugins for Monitoring PostgreSQL instances effectively.
•Proactive in updating the latest security patches to database, which are provided by PostgreSQL open-source community
•Responsible for all backup, recovery, and upgrading of all the PostgreSQL databases.
•Maintain custom vacuum strategies at table and database level
•Monitor the bloat repot on every table and perform maintenance with minimal downtime.
•Administer and optimize AWS solutions and troubleshoot issues including AWS, EC2, and VPC.
•Collaborating directly with software development teams and software engineers from other parts of RDS and AWS to solve technical, process, align on architectural investments and broader directions.
•creating, managing, and maintaining (upgrades, patches) on AWS environments
Database Administrator
Campaign Monitor 12/2016 - 07/2018
•Administration, management, and monitoring of all Postgres database systems
•Help support proper backup and disaster recovery procedures
•Good understanding of Database Architecture, Performance tuning of databases,
•Pro-actively Identify bottlenecks and resolve them quickly
•Created databases and objects with the necessary privileges
•Analyzed root causes of issues, troubleshoot queries with response timing
•Monitored regularly checking PostgreSQL alert logs in the production and make necessary actions to rectify them.
•supported 24/7 on-call rotation regarding databases issues and got the resolved.
•Optimize performace by setting up maintenance activitities such as running normal vacuum and vucuum full along alter statements to get databases on geat performance.
•Great skills at analyzing quueries using explain and explain anaylze plan to help guide querry planner on executing queries with better performance.
•Perform all backup, recovery for all the PostgreSQL databases and consistent.
•Install and monitor PostgreSQL database using the standard monitoring tools like Nagios etc.
•Upgraded from 9X to 13X using upgrade tool and Logical replication with no downtime
•Proactive monitoring of Postgres databases for performance and scalability
•Managed and Monitored tablespaces, data files, redo logs and database objects
•Database administration and technical support for production database environments, including performance and tuning
•Performed Logical and physical backup and recovery with of all databases in PostgreSQL
•Implemented Streaming Replication for high availability solutions.
•Managed and Monitored tablespaces, data files, redo logs and database objects.
•Used Pgbench tool to do Performance testing on a system setup.
Education
Bachelor's Degree in Computer Science University of Buea 2014
Professional Skills
•Strong communication and planning skills with demonstrated ability to interface with multiple levels in the organization
•Demonstrates excellent communication and organizational and follow up skills
•Demonstrate strong collaboration skills
•Highly accountable, strong team player with excellent analytical skills, detail oriented to process and quality
•Experience working with performance modeling and benchmarking skills and relational databases
•Proven problem-solving skills are required
•High ability to work under high stressful situations.
Contact this candidate