Database Administrator (EDB Postgres)

Job Summary:

We are looking for a highly skilled Database Administrator (DBA) with expertise in EDB Postgres to manage and optimize our database infrastructure. The DBA will be responsible for database security, performance tuning, scalability, and ensuring high availability. Additionally, the DBA will collaborate with DevOps and development teams to integrate database operations within CI/CD pipelines, automate database processes, and maintain a secure, efficient data environment.

Key Responsibilities:

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.

Required Qualifications & Skills:

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.