Database Administrator (PostgreSQL & Graph DB)

Job Title: Database Administrator (PostgreSQL & Graph DB)

Experience Required: 8 10 years

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)