Database Performance Engineer

• Design, implement, and optimize SQL queries, stored procedures, and indexes to achieve low-latency performance
• Fine-tune PostgreSQL configurations for maximum throughput and minimal resource utilization
• Collaborate with backend and infrastructure engineers to diagnose and resolve performance issues
• Manage and optimize large-scale database clusters, including replication, sharding, and partitioning
• Ensure database uptime, backup, recovery, and disaster recovery objectives (RTO/RPO) are consistently met
• Set up and monitor performance metrics, alerts, and dashboards (e.g., using pg_stat_statements, Prometheus, Grafana)
• Conduct capacity planning and load testing to prepare for traffic spikes and data growth
• Partner with Security and Compliance teams to ensure database access, data encryption, and retention policies meet regulatory standards
• Develop and maintain documentation for database configurations, maintenance routines, and operational procedures
• Support query performance reviews and educate developers on best practices for writing efficient SQL
• Optimize integrations between relational (PostgreSQL) and document-based (OpenSearch, Elasticsearch, MongoDB) systems
• Participate in incident response and postmortem analysis to continuously improve reliability

• 5+ years of experience as a Database Engineer, Database Administrator (DBA), or Performance Engineer working on PostgreSQL in production
• Deep understanding of query planning, indexing strategies, and PostgreSQL internals
• Experience with OpenSearch, Elasticsearch, or other document-based databases (preferred)
• Strong knowledge of SQL optimization, database partitioning, replication, and caching strategies
• Hands-on experience with performance profiling, benchmarking tools, and observability stacks
• Proficiency in scripting or automation tools (Python, Bash, Ansible, Terraform)
• Familiarity with cloud-based database services (AWS RDS, Aurora, or GCP Cloud SQL)
• Solid understanding of data security, compliance, and access control principles
• Excellent problem-solving skills and ability to work in fast-paced, cross-functional environments
• Bachelor's degree in Computer Science, Engineering, or a related field (or equivalent practical experience)
• Proven experience managing and optimizing large-scale production databases
• Strong collaboration skills with Engineering, DevOps, and Security teams
• U.S. work authorization required (Visa Sponsorship not included)

Experience with OpenSearch, Elasticsearch, or other document-based databases