Database Administrator (EDB Postgres)
Prime Gate
Employer Active
Posted on 30 Mar
Send me Jobs like this
Nationality
Any Nationality
Gender
Not Mentioned
Vacancy
1 Vacancy
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
- DBA
- Datawarehousing (IT Software)
Keywords
- Database Administrator (EDB Postgres)
Disclaimer: Naukrigulf.com is only a platform to bring jobseekers & employers together. Applicants are advised to research the bonafides of the prospective employer independently. We do NOT endorse any requests for money payments and strictly advice against sharing personal or bank related information. We also recommend you visit Security Advice for more information. If you suspect any fraud or malpractice, email us at abuse@naukrigulf.com