Software Engineer, Database Performance

Agiloft

full-time

Posted on: 8/27/2025

Location: 🇺🇸 United States

✨ AI Apply

SeniorLead

AWSCloudDynamoDBEC2GrafanaHibernateJavaMySQLNoSQLPostgresPrometheusPythonSQL

About the role

Work with cross-functional agile team members throughout the software development lifecycle to conceptualize, ideate, prototype, build, monitor and maintain a high-quality foundational data layer for the platform architecture
Analyze and optimize queries, indexes, and schema design for database use, including PostgreSQL, MySQL, DynamoDB and vector databases
Design and implement caching, sharding, and partitioning strategies for high-volume data workloads.
Partner with backend engineers (Python, Java) to design efficient data models and reduce costly query patterns
Monitor and troubleshoot database performance, reliability, and availability issues
Drive large-scale schema migrations and data refactoring with minimal downtime
Implement load testing, benchmarking, and stress testing strategies
Collaborate with DevOps to optimize database deployment, scaling, and failover strategies on AWS (RDS Aurora EC2, S3, CloudWatch)
Guide engineering teams in writing performance-conscious SQL and ORM queries
Stay ahead of emerging database technologies and recommend solutions that improve scalability and cost efficiency
Other duties as assigned

Bachelor's degree in Computer Science, Information Technology, or related field (or equivalent experience)
Minimum of 7 years of professional experience as software engineer or data architect
Experience building modern, cloud-native, multi-tenant applications using cloud hosted databases
Experience with multi-database architectures, including relational, NoSQL, and vector databases
Proven experience tuning database performance for high-volume, low-latency applications
Proficiency in building data centric applications and tools in Python and Java
Interest in building enterprise software with deep customer empathy, taking pride in contributing to a world class end-to-end user experience
Strong problem-solving, collaboration, teamwork and communication skills
Eagerness to learn and adapt to new technologies and tools
Deep understanding of: SQL databases, query optimization, and database indexing
Techniques and tooling for monitoring and improving database performance
Change management methodologies for incremental enhancement and change of data schemas, including versioning and rollback
Version control systems (Git)
CI/CD tools such as GitHub Actions or similar
Cloud platforms (AWS preferred)
Familiarity with observability tools (Prometheus, Grafana)
Modern software development lifecycle on an agile product team environment