Database Administrator - PostgreSQL

This position leads the design, implementation, maintenance and support of database environments.  This role includes the development and design of database strategies, monitoring and improving database performance and capacity, and planning for future expansion requirements for the most complex projects, working independently. This position requires the necessary skills to coordinate and support other database administrators as senior database administrators are expected to mentor, coach, and train less senior team members.

• Manage PostgreSQL database design and architecture, infrastructure, high availability (HA), security, performance monitoring/alerting, and routine maintenance (tuning, backup, replication, recovery).
• Understand application data storage requirements and associated business logic.
• Design and create database schemas, tables, indexes, and other objects to optimize query performance.
• Evaluate and recommend deployment options for Aurora (AWS PostgreSQL) and/or open-source PostgreSQL on AWS and on-premises.
• Deploy and maintain PostgreSQL databases using containerization/automation tools (e.g., Terraform, Ansible, Rancher, Kubernetes).
• Ensure scalability and maintainability aligned with future growth and data retention needs; define/configure for both AWS and on-prem environments.
• Collaborate closely with stakeholders; communicate effectively (written and oral).
• Lead projects and contribute as a self-starter/team player; solve problems proactively.
• Apply basic project management skills (create/read/update/follow plans).