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. You’ll work closely with engineering, product, and DevOps teams to ensure seamless data flow, sub-second query times, and high availability across our PostgreSQL and OpenSearch clusters.

Your work will have a direct impact on system performance, customer experience, and operational efficiency as you identify, resolve, and prevent bottlenecks in mission-critical data environments.

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