Agiloft

Software Engineer, Database Performance

Agiloft

full-time

Posted on:

Origin:  • 🇺🇸 United States

Visit company website
✨ AI Apply
Manual Apply

Job Level

SeniorLead

Tech Stack

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

Requirements

  • 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