Database Administrator (PostgreSQL & Graph DB)

Role Summary

We are looking for an experienced Database Administrator (DBA) to manage, maintain, and optimize our database infrastructure with a strong focus on High Availability (HA), performance, and scalability. The role requires expertise in PostgreSQL and Graph Databases (Neo4j), ensuring data integrity, reliability, and efficient data operations across distributed systems.

Key Responsibilities

Database Administration

1. Install, configure, and maintain PostgreSQL and Neo4j databases in production environments

2. Perform database upgrades, patching, and migrations with minimal downtime

3. Monitor database performance, identify bottlenecks, and implement performance tuning

4. Design, implement, and manage High Availability (HA) and Disaster Recovery (DR) solutions

5. Configure and maintain replication (streaming/logical), clustering, and failover mechanisms

6. Ensure systems meet defined RPO (Recovery Point Objective) and RTO (Recovery Time Objective)

7. Conduct regular backup, restore testing, and DR drills

Performance & Optimization

1. Optimize queries, indexing strategies, and database parameters

2. Troubleshoot and resolve database performance issues

Graph Database Management (Neo4j)

1. Administer Neo4j clusters, ensuring high availability and fault tolerance

2. Support graph data modeling and Cypher query optimization

3. Monitor and tune graph database performance

Security Compliance and Automation/DevOps

1. Implement and enforce database security best practices (authentication, authorization, encryption)

2. Perform regular audits and vulnerability assessments

3. Automate database deployments and configurations using tools like Ansible, Terraform, or scripting

4. Collaborate with DevOps teams for CI/CD integration

5. Work with containerized environments (Docker/Kubernetes)

Monitoring & Troubleshooting

1. Implement monitoring using tools like Prometheus, Grafana, ELK stack

2. Provide 24/7 support and incident resolution for critical database issues

3. Root cause analysis and preventive measures for recurring incidents

Required Skills & Qualifications

Technical Skills

1. Strong hands-on experience with PostgreSQL (8+ years preferred)

2. Experience with Neo4j or other graph databases is preferred.

3. Proven expertise in High Availability architectures and clustering

4. Familiarity with Linux/Unix systems administration

5. Experience with cloud platforms (AWS, Azure, or GCP)