FRANKLIN LEKE
HAMILTON,ON
Summary
Database professional with extensive experience in database management and optimization. Proven ability to enhance system performance and ensure data security. Known for strong collaborative skills and adaptability to evolving project needs, leveraging deep knowledge of PostgreSQL database design, installation, configuration, performance tuning, data backup processes and recovery.
Strong communication skills with a passion for continuous learning, improving and contribution.
Overview
4
4
years of professional experience
1
1
Certification
Work History
PostgreSQL DBA
Campaign Monitor
05.2022 - Current
- Company Overview: Campaign Monitor is a global technology company that provides an email marketing platform
- The database team is responsible for activities related to the design, development, implementation and production support
- We align with the infrastructure and development teams to create, test and implement architectural and schema changes across large datasets
- Configure, install, and maintaining all development, QA, staging and production PostgreSQL databases within the organization
- Perform all backup, recovery for all of the PostgreSQL databases and consistent
- Monitor databases to optimize database performance and diagnose any issues
- Develop, implement, maintain policies and procedures and document database architecture to ensure the security and integrity of the databases
- Implement data models, database designs, data access, table maintenance and code changes together with our development team
- Implement and monitor replication for high availability and disaster recovery scenarios with principles and practices, planning, testing
- Monitor and manage database indexes usage and tune them where appropriate for optimal performance
- Automate the configuration management of database and big data systems
- Performing routine tasks like schema management, database sizing, slow/long running queries, hung jobs and maintaining privileges
- Install and monitor PostgreSQL database using the standard monitoring tools like Nagios etc
- Daily log analysis using pgbadger tool and query tuning
- Maintain custom vacuum strategies at table and db level
- Monitor the bloat report on every table and perform maintenance with minimal downtime
- Perform minor and major level upgrades using minimal down by prior testing in test boxes with accurate time notifications
- Campaign Monitor is a global technology company that provides an email marketing platform
- The database team is responsible for activities related to the design, development, implementation and production support
- We align with the infrastructure and development teams to create, test and implement architectural and schema changes across large datasets
PostgreSQL DBA
Adria Solutions
03.2021 - 02.2022
- Company Overview: The company had 25 servers and more than 300 databases in production, stage and development environments
- The DBA work consisted of installation, migration and upgrade of PostgreSQL servers
- The database team is responsible for implementing the deployment request for production
- I was actively involved in all database activities and provided 24/7 availability to application Team
- Created databases and objects with the necessary privileges
- Monitored and Increased database volume when needed
- Analyzed root causes of issues, troubleshoot queries with response timing
- Performed Logical and physical backup and recovery with of all databases in PostgreSQL
- Created, Automated and scheduled backup, monitor jobs
- Implemented Disaster recovery with Point in time recovery in PostgreSQL
- Refreshed database and DB objects from Production to Testing and Testing to Production
- Tuned queries running commands like explain and explain analyze for performance improvements
- Monitored regularly checking PostgreSQL alert logs in the production and make necessary actions to rectify them
- Upgraded from 9.3 to 9.4, 9.6,10 using upgrade tool and Logical replication with no downtime
- Installed and managed databases with tools like pgadmin, Putty, Barman and Repmgr
- 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
- The company had 25 servers and more than 300 databases in production, stage and development environments
- The DBA work consisted of installation, migration and upgrade of PostgreSQL servers
- The database team is responsible for implementing the deployment request for production
- I was actively involved in all database activities and provided 24/7 availability to application Team
Education
Associate of Applied Science - Engineering
University of Buea
Cameroon06-2010
Skills
- Problem-solving skills
- Detail oriented
- Communication skills
- Analytical skills
- Backup and recovery
- Database management
- Database monitoring
- Database troubleshooting
- Database administration
- Data migration
- Relational database management
Certification
- Microsoft Certified Solutions Associate (MCSA)
- AWS Solutions Architect Associate
- Cisco Certified Network Associate (CCNA)
Community Service
Science tutor for elementary to high school students,
Soccer coach for youth.
Languages
English
Native or Bilingual
French
Professional Working
Timeline
PostgreSQL DBA
Campaign Monitor
05.2022 - Current
PostgreSQL DBA
Adria Solutions
03.2021 - 02.2022
- Microsoft Certified Solutions Associate (MCSA)
- AWS Solutions Architect Associate
- Cisco Certified Network Associate (CCNA)
Associate of Applied Science - Engineering
University of Buea
Similar Profiles
Disha SoniDisha Soni
Sales Executive at Class MonitorSales Executive at Class Monitor
GOODNESS ALEXGOODNESS ALEX
IT Support Engineer at Monitor Healthcare LimitedIT Support Engineer at Monitor Healthcare Limited
Jen YuanJen Yuan
Strategy Consultant at Monitor DeloitteStrategy Consultant at Monitor Deloitte