POSTGRESQL DBA REQUIREMENTS
· -5+ years of DBA experience, including at least 3 with PostgreSQL-specific DBA experience
· -Experience managing databases with sizes of 3T or over
· -Experience managing multiple OLTP databases
· -Solid knowledge and working experience with Linux command
· -Basic understanding of Git and CI/CD in database DDL/DML change deployment
· -Good communication skills
Bonus skills:
· -Cloud experience – AWS RDS/DMS (preferred, Azure, or GCP
· -Terraform experience
· -Healthcare IT industry experience
?
POSTGRESQL DBA RESPONSIBILITIES
- Maintain all development, QA, staging and production PostgreSQL database within organization
- Responsible for backup, recovery, and upgrading all PostgreSQL databases
- Monitor database to optimize database performance and diagnose issues
- Develop, implement, maintain policies and procedures, and document database architecture to ensure security and integrity of the databases
- Implement data models, database design, data access, table maintenance and code changes together with our development team
- Monitor code migration and database change management through various stages of the development cycle.
- Provide 2nd and 3rd level 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 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 and partitioning for optimal performance
- Perform schema management, database sizing, and maintain privileges
- Install and monitor PostgreSQL database using standard monitoring tools
- Analyze daily logs usage and query tuning
- Maintain custom vacuum strategies at table and database level
- Monitor database growth for every month in data warehouse databases and implement table partitioning for better performance
Department: Preferred Vendors
This is a contract position