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.
