PostgreSQL DBA Architect presso Likewize

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, pg_stat_statements, 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.