Database Performance Engineer - Remote US
27 days ago
Columbus
Job DescriptionThe Opportunity 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. Responsibilities • 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. Skillset • 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.Education & Requirements, • 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.