Database Administrator (EDB Postgres)

Job Summary

1. Database Administration & Management

• Install, configure, and maintain EDB Postgres databases across Dev, QA, Staging, and Production environments.
• Ensure high availability (HA) and disaster recovery (DR) solutions are in place.
• Implement role-based access control (RBAC), encryption, and audit logging for security.
• Maintain database documentation, including architecture diagrams, processes, and best practices.

2. Performance Tuning & Optimization

• Monitor and optimize database performance by improving query execution, indexing, caching, and partitioning.
• Identify bottlenecks and resolve performance issues in coordination with developers and system administrators.
• Ensure query optimization and schema design follow best practices for efficiency.

3. Backup & Disaster Recovery

• Implement automated backup and recovery strategies using pgBackRest, Barman, or WAL archiving.
• Perform periodic disaster recovery drills to validate backup integrity.
• Ensure data replication and failover mechanisms are tested and functional.

4. Security & Compliance

• Enforce database security policies, including TLS/SSL encryption and access control.
• Implement audit logging and compliance measures for GDPR, ISO, and SOC2.
• Ensure secrets management (credentials, API keys) is handled securely using Vault, AWS Secrets Manager, or Kubernetes Secrets.

5. CI/CD & DevOps Collaboration

• Work with DevOps teams to integrate database deployments into CI/CD pipelines.
• Support database schema migrations using tools like Flyway, Liquibase, or Alembic.
• Automate database provisioning with Terraform, Ansible, or Helm charts for Kubernetes.
• Ensure database backups and rollbacks are automatically tested in CI/CD environments.
• Monitor performance and query execution in pre-production environments to prevent deployment failures.

6. Monitoring & Observability

• Set up and manage database monitoring tools such as Prometheus, Grafana, Zabbix, or EDB Enterprise Manager.
• Implement alerting mechanisms for replication failures, slow queries, or high resource usage.
• Analyze logs and system metrics to proactively prevent failures and performance degradation.

Technical Skills

• Experience: 5+ years as a Database Administrator (DBA) specializing in EDB Postgres or PostgreSQL.
• Database Management: Expertise in installation, configuration, and maintenance of databases.
• Performance Optimization: Strong knowledge of query optimization, indexing, caching, and partitioning.
• High Availability & Replication: Experience with EDB Replication Server, Streaming Replication, Logical Replication.
• Backup & Disaster Recovery: Proficiency in pgBackRest, Barman, WAL archiving techniques.
• Security & Compliance: Experience with database hardening, access control, and encryption.
• Scripting & Automation: Strong scripting skills in Bash, Python, or SQL for automating database tasks.
• DevOps & CI/CD: Understanding of database automation, schema migrations, and versioning within CI/CD pipelines.
• Monitoring & Logging: Hands-on experience with Prometheus, Grafana, ELK Stack, or EDB Enterprise Manager.

Soft Skills

• Problem-Solving: Strong analytical and troubleshooting skills.
• Collaboration: Ability to work closely with developers, DevOps, and security teams.
• Communication: Clear and concise communication for documentation and team coordination.
• Adaptability: Ability to work in a fast-paced, agile environment.

Preferred Qualifications

• Certifications: EDB Postgres Advanced Server Certification or equivalent PostgreSQL certifications.
• Cloud Experience: Familiarity with Google Cloud, AWS RDS for PostgreSQL, or Azure Database for PostgreSQL.
• ETL & Data Processing: Experience with Apache Airflow, Talend, or similar ETL tools.