PostgreSQL Administrator/DBA

Position:

Location:

Job Brief:

We are seeking expertise in managing, maintaining, and optimizing production-class databases for high-performance applications.

The ideal candidate will have a deep understanding of database best practices, high availability (HA) setups, and managing heavily utilized production environments.

This role requires a proactive individual who can ensure the database infrastructure is reliable, scalable, and secure while working closely with developers, system architects, and other stakeholders.

Key Responsibilities:

Install, configure, upgrade, and maintain PostgreSQL databases in production and development environments.

Ensure optimal database performance through monitoring, troubleshooting, and fine-tuning.

Manage database capacity planning, including growth projections and storage optimization.

Design, implement, and maintain HA solutions such as replication, clustering, and failover mechanisms.

Develop and test disaster recovery plans to ensure minimal downtime and data loss.

Perform query tuning and indexing to optimize application performance.

Analyze and resolve bottlenecks in data access or processing.

Implement and enforce database security best practices, including user access controls and encryption.

Conduct regular audits to ensure compliance with organizational and regulatory requirements.

Set up monitoring systems to track database health, performance, and anomalies.

Automate routine tasks like backups, data migrations, and maintenance jobs using scripts or tools.

Work closely with development teams to understand data requirements and recommend best practices for schema design.

Document database architectures, processes, and procedures.

Experience & Qualifications

8+ years managing production PostgreSQL databases.

PostgreSQL Certified Professional (or equivalent).

MySQL, MongoDB, or Oracle.

CI/CD pipelines

Hadoop, Spark, or Kafka.

Strong problem-solving skills and detail oriented.

Excellent communication and collaboration skills.

Ability to work under pressure and meet deadlines.

Proactive and self-motivated.

Responsibilities

high availability (HA) architectures (e.g., streaming replication, Patroni, etc.).

Proficiency in database performance tuning, query optimization, and indexing strategies.

database security principles and implementation

pgBackRest, Barman

Familiarity with monitoring tools like pgAdmin, Prometheus, Grafana, or similar.

writing advanced SQL queries, stored procedures, and triggers

Python,

Linux systems

Familiarity with containerized environments (e.g., Docker, Kubernetes) and cloud database solutions (e.g., AWS RDS, Azure PostgreSQL).