Job Description
Position Type: Hybrid
We are looking for an experienced PostgreSQL DBA with strong skills in database administration, data modeling, database design, and performance tuning. The candidate will be responsible for managing PostgreSQL databases, ensuring high availability, security, backup and recovery, and optimizing database performance.
The role also involves Specification-Driven Development, using approved technical specifications and AI-assisted tools to generate database scripts, migrations, documentation, and automated tests with minimal manual coding.
Key Responsibilities
- Design and maintain PostgreSQL database schemas, tables, indexes, views, and stored procedures.
- Create conceptual, logical, and physical data models based on business requirements.
- Install, configure, upgrade, patch, and administer PostgreSQL databases.
- Perform database performance tuning and query optimization.
- Manage database backup, recovery, and high-availability processes.
- Handle database security, user roles, permissions, encryption, and auditing.
- Plan and execute database migrations with minimal downtime.
- Use specification-driven and AI-assisted tools to generate SQL scripts, database objects, and automated tests.
- Review AI-generated database scripts to ensure accuracy, security, and performance.
- Troubleshoot database issues, participate in incident management, and perform root-cause analysis.
- Maintain database documentation and follow enterprise database standards.
Must-Have Skills
- Strong hands-on PostgreSQL database administration experience.
- 5+ years of DBA or database platform experience.
- Strong SQL and PL/pgSQL skills.
- Database design, data modeling, and schema development.
- PostgreSQL performance tuning and query optimization.
- Backup, recovery, and point-in-time recovery (PITR).
- Specification-Driven Development experience.
- Database security, access management, and administration.
- Database migration and version control experience.
Good-to-Have Skills
- AWS RDS or Azure Database for PostgreSQL.
- High Availability (HA) and disaster recovery solutions.
- Docker and Kubernetes.
- Infrastructure as Code (IaC).
- AI-assisted development tools.
- PostgreSQL or cloud database certifications.
Qualifications
- Bachelor's degree in Computer Science, IT, Engineering, or equivalent experience.
- 5+ years of relevant PostgreSQL DBA or database platform experience.