{"schemaVersion":"jobsearcher.job.v1","id":"9c39320dfa4a92164e7fdec6","url":"https://jobsearcher.com/jobs/9c39320dfa4a92164e7fdec6","canonicalUrl":"https://jobsearcher.com/jobs/9c39320dfa4a92164e7fdec6","title":"Backend Engineer (Python) with MySQL + AWS RDS","description":"No compatible source was found for this media.Video failed to load.Backend Engineer (Python) with MySQL + AWS RDS**Full-time availability required: 9am to 5pm PST**We need 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.This is for someone who has owned database performance in production and can partner closely with product engineering teams on efficient data access patterns.ResponsibilitiesWrite, review, and optimize complex SQL queries (MySQL) for high-traffic production workloadsDiagnose slow queries using EXPLAIN/ANALYZE, index strategies, query rewrites, and schema adjustmentsImplement preventative solutions (query patterns, guardrails, limits, caching strategies where appropriate) to reduce latency and loadPartner with product engineering teams to design efficient data access patterns and avoid N+1 and other performance anti-patternsBuild 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 plansQualificationsStrong backend experience with Python in production systemsDeep hands‐on experience with MySQL query optimization and indexing in real‐world workloadsProduction 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 improvementsComfortable shipping operational tooling with safe rollout practices and documentationNice to haveExperience with ORM performance tuning (e.g., SQLAlchemy, Django ORM) and query profilingFamiliarity with caching and data access strategies (Redis, request‐level caching, batching)Experience with migration tooling and online schema change approachesFamiliarity with load testing and query benchmarkingAdditional NotesTo be considered, you must complete a live coding interview.**All answers must be in English.**FAQs:What's the next step? If successful, you'll have one more interview before receiving a job offer if you're a good fit.What happens after submission? We'll review your application within 2-3 business days and contact you if you qualify for the next stage.When would I start? As soon as possible, with flexibility to accommodate your circumstances.How long does it take? About 5-10 minutes to complete.","company":"Odesaco","rawCompany":"odesaco","city":"Florida","state":"NY","isRemote":false,"isActive":false,"createdAt":"2026-10-08T13:42:26.619Z","occupations":[{"code":"15-1252.00","title":"Software Developers","slug":"software-developers"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"}],"industries":[{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"},{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Backend Engineer (Python) with MySQL + AWS RDS","description":"No compatible source was found for this media.Video failed to load.Backend Engineer (Python) with MySQL + AWS RDS**Full-time availability required: 9am to 5pm PST**We need 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.This is for someone who has owned database performance in production and can partner closely with product engineering teams on efficient data access patterns.ResponsibilitiesWrite, review, and optimize complex SQL queries (MySQL) for high-traffic production workloadsDiagnose slow queries using EXPLAIN/ANALYZE, index strategies, query rewrites, and schema adjustmentsImplement preventative solutions (query patterns, guardrails, limits, caching strategies where appropriate) to reduce latency and loadPartner with product engineering teams to design efficient data access patterns and avoid N+1 and other performance anti-patternsBuild 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 plansQualificationsStrong backend experience with Python in production systemsDeep hands‐on experience with MySQL query optimization and indexing in real‐world workloadsProduction 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 improvementsComfortable shipping operational tooling with safe rollout practices and documentationNice to haveExperience with ORM performance tuning (e.g., SQLAlchemy, Django ORM) and query profilingFamiliarity with caching and data access strategies (Redis, request‐level caching, batching)Experience with migration tooling and online schema change approachesFamiliarity with load testing and query benchmarkingAdditional NotesTo be considered, you must complete a live coding interview.**All answers must be in English.**FAQs:What's the next step? If successful, you'll have one more interview before receiving a job offer if you're a good fit.What happens after submission? We'll review your application within 2-3 business days and contact you if you qualify for the next stage.When would I start? As soon as possible, with flexibility to accommodate your circumstances.How long does it take? About 5-10 minutes to complete.","datePosted":"2026-10-08T13:42:26.619Z","dateModified":"2026-10-08T13:42:26.619Z","hiringOrganization":{"@type":"Organization","name":"Odesaco","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Florida","addressRegion":"NY","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"9c39320dfa4a92164e7fdec6"},"url":"https://jobsearcher.com/jobs/9c39320dfa4a92164e7fdec6"}}