Backend Engineer (Python) with MySQL + AWS

QIT Software is looking for a backend engineer who is strong in MySQL performance and operational excellence on AWS RDS. This role is focused on writing and optimizing SQL, preventing slow queries before they impact customers, and building reliable tooling and monitoring for database operations.

Details:
- Schedule: Full-time, remote
- Client: USA
- Duration: long-term
- Tech stack: Python, MySQL, AWS, etc.
- Timezone: 8 hours overlap with PST

Requirements:

- Strong backend experience with Python in production systems
- Deep hands-on experience with MySQL query optimization and indexing in real-world workloads
- Production experience operating AWS RDS for MySQL (parameter groups, storage/IO considerations, backups, read replicas)
- Proven ability to troubleshoot performance issues (locks, long-running transactions, connection saturation, IO bottlenecks)
- Experience implementing monitoring and alerting (CloudWatch, Performance Insights, or equivalent)
- Ability to communicate clearly with product engineers and propose practical, measurable improvements
- Comfortable shipping operational tooling with safe rollout practices and documentatio

 

Responsibilities:

- Write, review, and optimize complex SQL queries (MySQL) for high-traffic production workloads
- Diagnose slow queries using EXPLAIN/ANALYZE, index strategies, query rewrites, and schema adjustments
- Implement preventative solutions (query patterns, guardrails, limits, caching strategies where appropriate) to reduce latency and load
- Partner with product engineering teams to design efficient data access patterns and avoid N+1 and other performance anti-patterns
- Build internal tools for database operations (migrations support, safe query tooling, job automation, runbooks)
- Set up and improve database monitoring and alerting for AWS RDS (performance, replication/IO, connections, locks, storage)
- Support incident response related to database performance and reliability, including postmortems and remediation plans

Hiring process:
1 - Pre-screen (up to 30 mins), 2 - Application (Q&A + Brief video introduction (up to 2 minutes)), 3- Technical Interview (live coding up to 1 hour), 4 - Team fit interview with Co-founder

Required languages

English B2 - Upper Intermediate
Published 14 January
62 views
ยท
20 applications
100% read
ยท
63% responded
Last responded 20 minutes ago
To apply for this and other jobs on Djinni login or signup.
Loading...