Database Administrator (EDB Postgres)

Prime Gate

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.