Postgres Database Administrator, SME

Job description

Overview The Postgres Database Administrator will lead the design, management, and optimization of Postgres database systems, ensuring their performance, reliability, and security in support of mission-critical applications. This role will play a key role in providing database expertise for development, operations, and modernization initiatives, working collaboratively with cross-functional teams to deliver robust database solutions. This position aligns with Cayuse’s core values of Innovation, Excellence, Collaboration, Adaptability, and Integrity by fostering technical solutions that meet customer needs, promoting teamwork, and prioritizing quality in deliverables. Responsibilities: - Serve as the "PostgreSQL Subject Matter Expert", providing architectural guidance and best practices. - Install, configure, upgrade, and maintain PostgreSQL database clusters (including HA/DR setups). - Design and implement high availability and disaster recovery solutions (streaming replication, logical replication, failover). - Perform performance tuning, query optimization, and capacity planning. - Manage database security, including roles, permissions, encryption, and auditing. - Support backup...