Database Developer- Postgres & SQL

Job Details:

We are looking for an experienced Database Administrator (DBA) with deep expertise in Postgres, MongoDB, and Neo4j. The role requires strong skills in query optimization, troubleshooting, performance tuning, and database administration to ensure high performance, security, and availability of critical databases.

Responsibilities:

• Administer, monitor, and maintain Postgres databases in production and non-production environments.
• Perform query optimization, indexing, and performance tuning for high-volume transactional and analytical workloads.
• Troubleshoot and resolve database-related incidents such as slow queries, deadlocks, replication lags, and clustering issues.
• Implement and manage backup, restore, and disaster recovery strategies.
• Ensure database security, access control, and compliance with organizational standards.
• Conduct capacity planning, performance benchmarking, and storage management.
• Automate DBA tasks using scripting (Shell/Python) and implement monitoring solutions.
• Work closely with development and infrastructure teams to support database design, schema optimization, and deployment.
• Provide 24x7 support for critical production systems as needed.

Expectations

• 6+ years of DBA experience with Postgres and SQL
• Strong expertise in query optimization, performance tuning, and root cause troubleshooting.
• Hands-on experience with replication, sharding, clustering, partitioning, and high-availability setups.
• Proficiency in backup/recovery tools and disaster recovery planning.
• Strong knowledge of Linux/Unix environments for database management.
• Experience with cloud-based managed databases (AWS RDS, Azure CosmosDB, GCP) is a plus.
• Excellent communication and problem-solving skills.