Postgres Database Administrator

We are seeking a skilled PostgreSQL Database Administrator (DBA) with 36 years of experience to manage, maintain, and optimize our database systems. The ideal candidate will have hands-on expertise in PostgreSQL administration, database performance tuning, and backup strategies, along with working knowledge of AWS database services (such as RDS, EC2, S3, and CloudWatch). You will be responsible for ensuring database availability, security, and performance in both on-premise and cloud environments.

Key Responsibilities

Database Administration

• Install, configure, and upgrade PostgreSQL database servers and related tools.
• Manage database schemas, tables, indexes, constraints, and relationships.
• Perform routine database maintenance, including vacuuming, reindexing, and statistics updates.
• Manage database replication (streaming or logical), clustering, and failover setups.
• Implement and manage database backup and recovery procedures using tools like pg_dump, pg_basebackup, and WAL archiving.
• Monitor database health, query performance, and storage utilization.
• Troubleshoot database errors, crashes, and performance bottlenecks.

Performance Tuning and Optimization

• Analyze slow queries and optimize SQL statements and indexes.
• Perform regular health checks, query plan analysis, and database tuning.
• Configure PostgreSQL parameters (e.g., shared buffers, work_mem, autovacuum) for optimal performance.

Security and Compliance

• Implement and maintain user access control and role-based permissions.
• Ensure database security through encryption, SSL, and audit trails.
• Perform regular database patching and version upgrades to maintain compliance.
• AWS Cloud Database Operations
• Deploy and manage PostgreSQL databases on AWS services such as Amazon RDS, Aurora PostgreSQL, or EC2.
• Configure automated backups, snapshots, and monitoring via CloudWatch.
• Manage parameter groups, security groups, and IAM roles for database access.
• Support DR (Disaster Recovery) planning and cross-region replication.

Maintenance and Automation

• Automate repetitive DBA tasks using scripts (Python, Bash, or SQL).
• Schedule and monitor maintenance tasks such as backups, reindexing, and vacuuming.
• Support CI/CD pipelines for database schema deployment.
• Collaborate with development teams for schema design and data model optimization.

Monitoring and Reporting

• Set up and maintain monitoring tools (e.g., pgAdmin, Prometheus + Grafana, AWS CloudWatch, or Datadog).
• Generate performance reports and provide insights to improve database efficiency.

Required Skills and Qualifications

• Bachelor’s degree in computer science, Information Technology, or related field.
• 3–4 years of experience as a PostgreSQL DBA in production environments.
• Strong understanding of PostgreSQL internals, performance tuning, and SQL optimization.
• Experience with AWS cloud services related to database hosting and management.
• Proficiency with Linux/Unix environments and shell scripting.
• Hands-on experience with backup and recovery strategies, replication, and clustering.
• Familiarity with monitoring tools (e.g., CloudWatch, pg_stat_statements, or similar).
• Strong troubleshooting and analytical skills.

Preferred Qualifications

• Certification in AWS (e.g., AWS Certified Database – Specialty or AWS Solutions Architect Associate).
• Experience with automation tools (Terraform, Ansible) for database provisioning.
• Exposure to other database platforms (MySQL, MongoDB) is a plus.
• Understanding of DevOps pipelines and CI/CD integration with databases.

Soft Skills

• Excellent communication and documentation skills.
• Strong problem-solving and analytical mindset.
• Ability to work independently and collaborate in a cross-functional team environment.
• Commitment to continuous learning and staying updated with PostgreSQL and AWS trends.