We’re seeking a Database Performance Engineer to join our Engineering Infrastructure team at Seamless.
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- Own the health, performance, and reliability of our PostgreSQL and OpenSearch environments in production.
- Design, manage, and validate backup and recovery processes, including routine backup monitoring, restore testing, and disaster recovery readiness.
- Analyze and optimize slow queries, indexing strategies, and execution plans across both PostgreSQL and OpenSearch.
- Improve database performance for large-scale datasets (1TB+), with a focus on latency, throughput, storage efficiency, and stability.
- Lead data modeling and schema design decisions to support scalable application growth and reporting needs.
- Design and optimize indexing, partitioning, and data access patterns for high-volume workloads.
- Partner with engineering to improve how applications interact with PostgreSQL and OpenSearch, including query design and performance best practices.
- Monitor database health and proactively address issues related to replication, storage growth, resource utilization, and query performance.
- Troubleshoot production incidents involving database performance, search performance, and data integrity, and drive root cause resolution.
- Recommend and implement improvements to architecture, tooling, and processes that increase scalability and reduce operational risk.
Skillset
- Strong hands-on experience managing PostgreSQL in production environments.
- Experience with OpenSearch or Elasticsearch in production, including query tuning and index optimization.
- Deep experience with query optimization, execution plan analysis, and performance tuning for large datasets.
- Strong understanding of data modeling, schema design, and indexing strategies.
- Experience supporting databases with high data volume and growth, ideally in environments with datasets of 1TB+.
- Comfortable working closely with software engineers to improve application-level data access and query efficiency.
- 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).
Since 2015, Seamless.AI has helped sales teams maximize revenue with the world’s first real-time B2B search engine. As one of Ohio’s fastest-growing companies, we’ve earned top industry accolades, including G2’s 2025 Best Software Products (#1 Highest Satisfaction Product), Purpose Jobs’ 2024 Best Places to Work, and LinkedIn’s Top 50 Tech Startups (2020, 2022, 2023). We are committed to a diverse, inclusive workplace and do not discriminate based on race, religion, gender, sexual orientation, age, or other protected statuses. Visa sponsorship is not available; applicants must be authorized to work in the U.S.
Top Skills
Similar Jobs
What you need to know about the Chicago Tech Scene
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
