Intermediate PostgreSQL Database Administrator at Hire Resolve

Role Overview

• We are seeking a skilled PostgreSQL Database Administrator to manage and optimize enterprise-grade database environments supporting mission-critical systems. This role focuses on database performance, reliability, scalability, and cross-platform migration initiatives within complex production environments.
• You will collaborate closely with development, DevOps, and infrastructure teams while contributing to modernization and optimization projects involving PostgreSQL ecosystems.

Key Responsibilities

• Administer, monitor, and maintain PostgreSQL database environments (community and enterprise editions).
• Design and implement database architecture, replication strategies, high availability configurations, and backup/recovery solutions.
• Conduct performance tuning, query optimization, and in-depth troubleshooting across large-scale production environments.
• Support and execute Oracle-to-PostgreSQL migration initiatives, ensuring cross-platform compatibility and performance integrity.
• Collaborate with DevOps and infrastructure teams to integrate databases into CI/CD and production pipelines.
• Implement database security standards, role-based access controls, and compliance best practices.
• Provide L1–L3 database support to internal stakeholders and clients.
• Maintain technical documentation and contribute to knowledge-sharing initiatives.
• Participate in after-hours support rotations when required.
• Contribute to technical solution design during client engagements where database expertise is required.

Minimum Requirements

• 5–8 years’ hands-on Database Administration experience.
• Minimum 3+ years focused specifically on PostgreSQL.
• Experience working with enterprise PostgreSQL platforms.
• Strong experience in performance tuning, replication (streaming and logical), and backup/recovery strategies.
• Solid Linux command-line proficiency and scripting capability (Bash or similar).
• Exposure to Oracle Database environments is advantageous.