Job Title: PostgreSQL Database Administrator(Postgres, MongoDB, Neo4j)
Location: Richardson, TX (Hybrid Opportunity)
Employment Type: Longterm contract.
The ideal candidate should have strong hands-on expertise in PostgreSQL query development, optimization, and performance tuning. They should be proficient in writing complex SQL queries, analyzing execution plans using EXPLAIN and EXPLAIN ANALYZE, designing and optimizing indexes, and troubleshooting slow-running queries to improve database performance and efficiency.
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, MongoDB, and Neo4j 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 (hands on experince), MongoDB(hands on experince), and Neo4j (hands on or understanding).
- 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.
- Familiarity with database monitoring and alerting tools (e.g., pgAdmin, MongoDB Ops Manager, Neo4j Bloom, Prometheus, Grafana).
- Strong knowledge of Linux/Unix environments for database management.
- Experience with cloud-based managed databases (AWS RDS, Azure CosmosDB, Google Cloud Platform) is a plus.
- Excellent communication and problem-solving skills.
