PostgreSQL DBA ()

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