Database Performance Engineer - Remote US

5+ years of experience as a Database Engineer, 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. Bachelor’s degree in Computer Science, Engineering, or related field (or equivalent practical experience). Proven experience managing and optimizing large-scale production databases. Strong collaboration skills.

Design, implement, and optimize SQL queries, stored procedures, and indexes. Fine-tune PostgreSQL configurations. Collaborate to diagnose and resolve performance issues. Manage and optimize large-scale database clusters. Ensure database uptime, backup, recovery, and disaster recovery objectives. Set up and monitor performance metrics, alerts, and dashboards. Conduct capacity planning and load testing. Partner with Security and Compliance teams. Develop and maintain documentation. Support query performance reviews and educate developers. Optimize integrations between relational (PostgreSQL) and document-based systems (OpenSearch, Elasticsearch, MongoDB). Participate in incident response and postmortem analysis.