Database Administrator; EDB Postgres

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 Dev Ops and development teams to integrate database operations within CI/CD pipelines, automate database processes, and maintain a secure, efficient data environment.

• 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.
• 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.
• 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.
• Security & Compliance
• Enforce database security policies, including TLS/SSL encryption and access control.
• Implement audit logging and compliance measures for GDPR, ISO, and SOC
  2.
• Ensure secrets management (credentials, API keys) is handled securely using Vault, AWS Secrets Manager, or Kubernetes Secrets.
• CI/CD & Dev Ops Collaboration
• Work with Dev Ops 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.
• 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.

• Experience:
  
  5+ years as a Database Administrator (DBA) specializing in EDB Postgres or Postgre
  
  SQL.
• 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.
• Dev Ops & 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.

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

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