PostgreSQL Database Administrator

This is a remote position.

Job Summary:

We are seeking a skilled and experiencedPostgreSQL Database Administratorto join our team. The ideal candidate will be responsible for ensuring the performance, availability, security, and reliability of our PostgreSQL database environments. You will play a key role in architecture design, system tuning, data replication, and support for mission-critical systems. MySQL DBA Experience is strong plus.

Key Responsibilities:

• Monitor and maintain PostgreSQL database systems, ensuring high availability and performance.

• Manage database backup, restore, archiving, and disaster recovery procedures.

• Perform database upgrades, patching, and version control with thorough testing.

• Design and implement database architecture, schema, indexing strategies, and replication setups.

• Develop and maintain stored procedures, functions, and performance-optimized SQL queries.

• Identify and resolve performance bottlenecks, including query tuning and system-level optimizations.

• Support developers with database integration, schema changes, and data migrations.

• Define and enforce database security, access control, and compliance best practices.

• Participate in On-Call rotations for critical support and incident resolution.

• Collaborate with DevOps and infrastructure teams for automation and monitoring solutions.

Requirements:

• Minimum5 years of experienceadministering enterprise-scale PostgreSQL environments.

• In-depth knowledge of PostgreSQL internals, configuration, performance tuning, and replication (e.g., logical, streaming).

• Strong experience with backup and recovery tools (e.g., pgBackRest, WAL-G) and high availability configurations.

• Proven skills in SQL and PL/pgSQL development, including stored procedures and triggers.

• Familiarity with monitoring tools (e.g., pg_stat_statements, Prometheus, Grafana).

• Experience with Linux/Unix systems administration as it pertains to PostgreSQL.

• Ability to work independently, prioritize tasks, and “own” technical challenges and solutions.

• Strong analytical, problem-solving, and communication skills.

• Knowledge of cloud-based PostgreSQL services (e.g., AWS RDS, Azure Database for PostgreSQL) is a plus.

• MySQL DBA Experience is a Big plus.