Job Url: https://www.remoterocketship.com/company/agiloft/jobs/software-engineer-database-performance-united-states-remote Job Description: Agiloft Website LinkedIn All Job Openings Agiloft is a leading provider of enterprise contract lifecycle management (CLM) solutions designed to streamline and enhance the contracting process. Their Data-first Agreement Platform is a force multiplier that helps organizations reach agreements quickly and collaboratively, leveraging data to operate smarter and more transparently. Agiloft's offerings include integration hubs and an AI platform tailored for business services, healthcare, legal professionals, and procurement. With a high customer retention rate and recognition as a leader in the Gartner Magic Quadrant for CLM, Agiloft is known for its user-friendly no-code interface and robust service and support. The company emphasizes direct relationships and trust, promising to help clients 'Agree and Thrive. Contract Management β€’ Customer Support β€’ BPM β€’ CLM β€’ Automation 201 - 500 employees Founded 1991 🏒 Enterprise ☁️ SaaS πŸ€– Artificial Intelligence πŸ’° $45M Private Equity Round on 2020-08 Software Engineer, Database Performance 18 hours ago πŸ‡ΊπŸ‡Έ United States – Remote ⏰ Full Time 🟠 Senior πŸ”΄ Lead πŸ§‘β€πŸ’» Full-stack Engineer πŸ¦… H1B Visa Sponsor AWS Cloud DynamoDB EC2 Grafana Hibernate Java MySQL NoSQL Postgres Prometheus Python SQL Apply Now Receive Emails with Similar Jobs Report problem πŸ“‹ Description β€’ 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 πŸ–οΈ Benefits β€’ floating holidays β€’ a quarterly, no-questions-asked wellness day β€’ multiple Employee Resource Groups (ERGs)