We are seeking a highly skilled Software Engineer to own and support all SQL, Kafka, and AMQ鈥憆elated responsibilities within our engineering ecosystem. This role is ideal for someone who thrives in data鈥慸riven environments, understands distributed messaging systems, and can deliver reliable, scalable data solutions across the organization.
Responsibilities:
- Design, write, and optimize complex SQL queries, stored procedures, and database schemas to support application and analytics needs.
- Monitor database performance, identify bottlenecks, and implement tuning strategies (indexes, query restructuring, partitioning).
- Ensure data integrity, consistency, and security across all SQL鈥憆elated operations, including backups, migration scripts, and auditing.
- Build, maintain, and scale Kafka topics, partitions, schemas, and consumer/producer configurations.
- Develop and optimize Kafka producers and consumers, ensuring reliable, high鈥憈hroughput, low鈥憀atency streaming pipelines.
- Implement monitoring, alerting, and troubleshooting for Kafka clusters, including lag analysis and message flow diagnostics.
- Manage and configure AMQ messaging components (queues, topics, durable subscriptions) to support asynchronous workflows.
- Develop and maintain message producers/consumers for AMQ, ensuring resilient delivery, retry logic, and error鈥慼andling patterns.
- Oversee reliability, observability, and fault鈥憈olerance of all messaging systems (Kafka and AMQ), including failover, scaling, and disaster recovery considerations.
- Collaborate with cross鈥慺unctional teams to design event鈥慸riven architectures, ensure proper data contracts, and integrate SQL/Kafka/AMQ components into larger platform services.
This is a hybrid position. Expectation of days in the office will be confirmed by your Hiring Manager.