Database Administrator (EDB Postgres)

Job Description Roles & Responsibilities 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. Desired Candidate Profile 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. Company Industry IT - Software Services Department / Functional Area DBADatawarehousing (IT Software) Keywords Database Administrator (EDB Postgres) Get real-time job updates only on our App