Database Performance Engineer - Remote US

We're seeking a Database Performance Engineer to join our Engineering Infrastructure team at Seamless.AI. In this role, you'll be responsible for optimizing database performance, scalability, reliability, and compliance across our high-traffic data systems.

Requirements

• 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.

Benefits

• Competitive salary
• Excellent benefits package
• Opportunities for professional growth and development
• Collaborative and dynamic work environment
• Access to cutting-edge technology and tools