John-Louis Talambong
Washington,DC
Summary
7+ years senior DBA having knowledge and ability to perform all of the basic database management skills of data administration, and overall architecture and database analysis.
Overview
8
8
years of professional experience
Work History
Sr. PostgreSQL Database Administrator
VELEX
Frisco, TX
01.2018 - Current
- Maintained detailed technical documentation of database
- Database architecture and modeling as per business requirements
- Provided technical assistance for preparation of shell scripts for task automation
- Conducted complete analysis of database capacity and performance requirements
- Implemented procedures for analysis, consolidation and tuning of databases for efficiency
- Experience in migrating on-premises databases to PostgreSQL databases on AWS EC2, RDS
- Worked on AWS PostgreSQL databases for App migration into private cloud
- Worked on AWS Database Migration Services for migrating data to RDS
- Supported Main DBA functions in RDS and documenting in confluence page
- Hands on experience in encrypting data using AWS Key Management Service (KMS)
- Database monitoring and maintenance activities which include checking alert logs, space management, undo management, gathering database statistics, database locking issues, scheduling of jobs, creation of users, schemas, table spaces and other database objects
- Involved in 24x7 support for mission critical applications
- Configured and installed, involved using AWS services such as EC2,RDS CloudWatch
- Architecting new DBA solutions in AWS
- Worked on integrating KMS to AWS CloudTrail to monitor logs used by keys for compliance Databases Experience using PEM, AWS CloudWatch, Ansible for database installation and monitoring Created new cluster and upgraded the cluster to another PostgreSQL sever
- Configured Postgres Community version & EDB Advanced severs, Streaming Replication and Pgpool for load balancing
- Managing the monitoring tools for better performance like PgBadger, PEM
- Experience in upgrading and migrating various versions of PostgreSQL database on different platforms
- Responsible for all backup, recovery of PostgreSQL databases using BART and pg_dump
- Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization
- Implement, configure, and troubleshoot database instances, replication, backup, partitions, storage, and access
- Set user privileges within and outside the database environment Migration of data from reports generated by various vendors into PostgreSQL Databases using PostgreSQL Export/Import Procedures
- Manage the Space and Storage of the Databases through various Shell Scripts scheduled in the corncob periodically in regular intervals
- Experience Migrating data from Oracle to PostgreSQL using enterprise Database tools such as AWS DMS
- Extensively investigated and followed-up with application teams, and proposed solutions to resolve slowness and performance issues
- Assist engineering team in the design of appropriate DB Schema and indexing strategy for performance and scalability
- Experience supporting a mission-critical database environment with 24x7 On-Call Support including weekends
- Identifying and resolving incidents and address to user problems/concerns
- Trouble shooting database issues
- Support developers for efficient SQL query and identifying long running queries and optimizing
- Setup/Maintenance of Test/Development/UAT Servers setup.
PostgreSQL Database Administrator
KANEXA
Wayne, PA
03.2015 - 12.2017
- Created and dropped schemas and users in PostgreSQL
- Develop SQL reports that meet client expectations for the application (used by custom application)
- 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
- Monitoring of system logs, OS logs, database logs, trace files, database alert files to detect and troubleshoot runtime problems
- Planning, deploying RDBMS Upgrades/Patches and performing other weekend maintenance activities as a part of On Call support
- Active participant in discussions related to Backup Strategy, DC/DR architecture
- Maintained, patched, and upgraded servers as required
- Expertise in Analyzing data Quality checks using shell scripts
- Upgrading, installing, and configuring PostgreSQL servers
- PostgreSQL Installation, Configuration, Migration, Upgrades and Patches
- Server versions ranged from PostgreSQL 8.2 to 9.5
- Disaster recovery planning or Emergency Recoveries and Ensuring Recoverability of Databases
- Optimize postgresql.conf for performance improvement
- Review all PostgreSQL logs for problems
- Ensure night corn jobs for backups, re-Indexing & vacuuming & materialized views executed properly on 24/7 high availability Postgres production and development databases
- Responsible for all backup, recovery, and upgrading of all of the PostgreSQL databases
- Monitoring databases to optimize database performance and diagnosing 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
- Experience in code migration, database change management through various stages of development life cycle
- Providing response for all system / database issues on 24 x 7 schedule responding to critical events and situations outside normal work hours
- Work with development and operations teams to tune production queries for optimal performance
- Implement and monitor replication for high availability and disaster recovery scenarios
- Review new database schema changes
- Monitor and manage database indexes for optimal performance
- Studied and stayed current on features and functionality of PostgreSQL
- Proactive managing standby replication methodologies like Streaming replication and hot standby for disaster recovery
- Scheduling quarterly Point in time recovery (PITR) testing to the development environment for proper product testing
- Configuring log analyzation tools like pgbadger etc
- Proactive in updating the latest security patches to database, which are provided by PostgreSQL open- source community
- Configured Logical and physical backup and recovery of all databases in PostgreSQL
- Configured and Database installation creating tables, schemas, roles
- Performed Backup and Point in time recovery in PostgreSQL
- Switched the Database from Production to Testing and Testing to Production
- Created Database Links from Testing to Production databases
- Monitored the database for Index, partitioning Memory and I/O utilization
- Used EXPLAIN and EXPLAIN ANALYZE to identify and fine tune sql queries for performance improvements
Education
Associate degree - chemical Engineering
Montgomery College
Bachelor’s Degree - Chemical engineering
University of Maryland
and 12 Certified Associate - undefined
Skills
- Configuring Postgresql Streaming Replication and Pgpool for load balancing
- Managing the monitoring tools for better performance like PgBadger, EDB Postgres Enterprise Manager
- Experience in upgrading and migrating various versions of PostgreSQL database on different platforms
- Responsible for the implementation, design, and optimization of various database environments ranging from small business databases to large enterprise databases
- Worked on complete SDLC Expertise involves in performance tuning, production support, installation, migration, monitoring and optimization of databases
- Skilled at analyzing pg_stat_activity, pg_stat_statement, pg_views, PEM reports, and pgbadger report in order to troubleshoot performance issues
Timeline
Sr. PostgreSQL Database Administrator
VELEX
01.2018 - Current
PostgreSQL Database Administrator
KANEXA
03.2015 - 12.2017
Associate degree - chemical Engineering
Montgomery College
Bachelor’s Degree - Chemical engineering
University of Maryland
and 12 Certified Associate - undefined
Similar Profiles
Jamie RiveraJamie Rivera
Tower Technician at VelexTower Technician at Velex
Joan Andres RamirezJoan Andres Ramirez
Tower Climber Tech 3 at VelexTower Climber Tech 3 at Velex
Julio Perez OteroJulio Perez Otero
Construction Manager / Senior Foreman at VelexConstruction Manager / Senior Foreman at Velex
Ryan WitherspoonRyan Witherspoon
Field Engineer at VelexField Engineer at Velex
Sabrina JacobsSabrina Jacobs
General Utility Worker at Aramark Food and BeverageGeneral Utility Worker at Aramark Food and Beverage