The PostgreSQL DBA Architect is responsible for designing, implementing, and maintaining robust PostgreSQL database solutions that meet enterprise-level performance, scalability, and security requirements. This role combines deep technical expertise with architectural vision, ensuring optimal data availability, disaster recovery, and integration with application and cloud ecosystems. It is a hands-on role requiring strong administration, optimization, and troubleshooting skills alongside architectural leadership.

Must Have

• Design and architect PostgreSQL database systems for high availability, performance, and scalability.
• Define database standards, schema design principles, and best practices for indexing and partitioning.
• Plan and implement replication, sharding, and failover strategies.
• Install, configure, and upgrade PostgreSQL servers and extensions.
• Manage roles, users, privileges, and security policies.
• Implement automated backup, recovery, and disaster recovery procedures.
• Monitor database health using tools like pgAdmin, pg_stat_statements, Prometheus, Grafana, or pgbouncer.
• Perform performance tuning, query optimization, and resource utilization monitoring.
• Deploy and manage PostgreSQL on AWS RDS, Aurora, Azure PostgreSQL.
• Integrate PostgreSQL into CI/CD pipelines using tools like Jenkins, GitLab, or Terraform.
• Automate database provisioning and configuration through Infrastructure as Code (IaC).
• Implement data encryption (at rest and in transit), auditing, and monitoring for compliance.
• Ensure adherence to regulatory standards (SOC, ISO27001, etc.).
• Collaborate with application developers and data engineers for schema optimization and SQL tuning.
• Lead database modernization initiatives, including migrations from MSSQL Server /MySQL to PostgreSQL.
• Provide technical mentorship to DBAs and development teams.
• Create and maintain detailed architecture and operational documentation.
• Bachelor’s or Master’s degree in Computer Science, Information Technology, or related field.
• 10+ years of overall DBA experience, with at least 6+ years focused on PostgreSQL.
• Proven experience in PostgreSQL architecture, administration, and performance tuning.
• Expertise in logical and physical replication, connection pooling, and high availability (Patroni, repmgr, or Pacemaker).
• Hands-on experience with PostgreSQL on cloud platforms (AWS).
• Strong scripting skills in Python, Bash, or PowerShell for automation.
• Solid understanding of database internals, query planner, and indexing strategies.
• Experience in database migration, upgrade, and version management.
• Experience in DynamoDB configuration and JSON Scripts.

Good to Have

• Knowledge of containerized environments (Docker, Kubernetes).
• Exposure to NoSQL databases (DynamoDB, Redshift).
• Certifications such as EDB PostgreSQL DBA, AWS Database Specialty.

Job Description:

Job Title: PostgreSQL DBA Architect

Job Summary:

The PostgreSQL DBA Architect is responsible for designing, implementing, and maintaining robust PostgreSQL database solutions that meet enterprise-level performance, scalability, and security requirements. The role combines deep technical expertise with architectural vision, ensuring optimal data availability, disaster recovery, and integration with application and cloud ecosystems.

This is a hands-on role, requiring strong administration, optimization, and troubleshooting skills alongside architectural leadership.

Key Responsibilities:

Database Architecture & Design

• Design and architect PostgreSQL database systems for high availability, performance, and scalability.
• Define database standards, schema design principles, and best practices for indexing and partitioning.
• Plan and implement replication, sharding, and failover strategies.
• Develop and maintain database capacity and scalability plans.

Administration & Operations

• Install, configure, and upgrade PostgreSQL servers and extensions.
• Manage roles, users, privileges, and security policies.
• Implement automated backup, recovery, and disaster recovery procedures.
• Monitor database health using tools like pgAdmin, pgstatstatements, Prometheus, Grafana, or pgbouncer.
• Perform performance tuning, query optimization, and resource utilization monitoring.

Cloud & DevOps Integration

• Deploy and manage PostgreSQL on AWS RDS, Aurora, Azure PostgreSQL.
• Integrate PostgreSQL into CI/CD pipelines using tools like Jenkins, GitLab, or Terraform.
• Automate database provisioning and configuration through Infrastructure as Code (IaC).

Security & Compliance

• Implement data encryption (at rest and in transit), auditing, and monitoring for compliance.
• Ensure adherence to regulatory standards (SOC, ISO27001, etc.).

Collaboration & Leadership

• Collaborate with application developers and data engineers for schema optimization and SQL tuning.
• Lead database modernization initiatives, including migrations from MSSQL Server /MySQL to PostgreSQL.
• Provide technical mentorship to DBAs and development teams.
• Create and maintain detailed architecture and operational documentation.

Required Qualifications:

• Bachelor’s or Master’s degree in Computer Science, Information Technology, or related field.
• 10+ years of overall DBA experience, with at least 6+ years focused on PostgreSQL.
• Proven experience in PostgreSQL architecture, administration, and performance tuning.
• Expertise in logical and physical replication, connection pooling, and high availability (Patroni, repmgr, or Pacemaker).
• Hands-on experience with PostgreSQL on cloud platforms (AWS).
• Strong scripting skills in Python, Bash, or PowerShell for automation.
• Solid understanding of database internals, query planner, and indexing strategies.
• Experience in database migration, upgrade, and version management.
• Experience in DynamoDB configuration and JSON Scripts.

Preferred Skills:

• Knowledge of containerized environments (Docker, Kubernetes).
• Exposure to NoSQL databases (DynamoDB, Redshift) is a plus.
• Certifications such as EDB PostgreSQL DBA, AWS Database Specialty.

Are you ready to join Likewize?

At Likewize, we are trusted by many of the world’s biggest brands to look after their customers tech. When their tech goes wrong we make it right.

We offer device protection insurance programs, repair services, upgrade and recommence solutions and also premium tech support.

The tech industry moves fast - but so do we. Innovation and disruption are in our DNA, so we are always challenging convention and looking for ways to do things better, quicker and making everything easier for our customers.

Doing that successfully takes trust, teamwork and a knack for making the complicated simple. We’re looking for creative, quick and relentless talent to join the team. Are you one of us?