Job Description

We are seeking a skilled PostgreSQL Database Administrator (DBA) with 3-6 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 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.