Backend Engineer (Python) — MySQL & AWS RDS Optimization

Odesa.co; Town of Florida, Northern (NY, KY); Hybrid; USD 120,000 - 160,000; Full time

Job summary

Odesa.co is seeking a Backend Engineer (Python) skilled in MySQL performance and AWS RDS operations. You’ll write and optimize SQL for high-traffic workloads, diagnose slow queries, and implement guardrails to reduce latency.

You’ll partner with product teams to design efficient data access patterns and build tooling for database operations. Responsibilities include monitoring, alerting, and supporting incident response for database performance, with a focus on production reliability and

Qualifications

• Strong backend experience with Python in production systems.
• Deep hands-on MySQL query optimization and indexing in real-world workloads.
• Production experience operating AWS RDS for MySQL (parameter groups, storage/IO considerations, backups).
• 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 documentation.

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 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.

Skills

Python

MySQL

AWS RDS

Performance tuning

Monitoring

Communication

CI/CD

Job description

Odesa.co is seeking a Backend Engineer (Python) skilled in MySQL performance and AWS RDS operations. You’ll write and optimize SQL for high-traffic workloads, diagnose slow queries, and implement guardrails to reduce latency.

You’ll partner with product teams to design efficient data access patterns and build tooling for database operations. Responsibilities include monitoring, alerting, and supporting incident response for database performance, with a focus on production reliability and