Sr. Database Reliability Engineer III

Join Aya Healthcare, winner of multiple Top Workplace awards!

Aya Healthcare is seeking an expert-level Senior Database Reliability Engineer III to join our Database Reliability Engineering team, focusing on enhancing the performance, scalability, and reliability of our large-scale database infrastructure primarily hosted on Azure.

This position is pivotal in driving strategic initiatives for database reliability, performance optimization, and architectural transformation across our SaaS platform. The ideal candidate will possess deep expertise in managing complex MS SQL, NoSQL, and open-source SQL environments such as MySQL and PostgreSQL. They will lead large-scale data warehouse/ lake solutions, mentor junior engineers, and drive proactive database performance initiatives. A proactive leader with a strong architectural mindset and extensive experience with Databricks, Snowflake, or similar platforms is highly preferred. 

Who We Are: 

We’re a $10+ billion, rapidly growing workforce solutions provider in the healthcare industry. We deliver tech-enabled services that help healthcare organizations meet and manage their contingent labor needs. We build and manage tech-enabled marketplaces for national and local healthcare talent and deliver contingent labor management solutions through our proprietary software platform.

At Aya, we’re obsessed with creating exceptional experiences for our clients, clinicians and employees. In fact, we put employee satisfaction above all else. Our team members are responsible for incomparable customer experience and we know that happy employees are critical to maintaining happy clients. We foster an entrepreneurial, high-energy, low-bureaucracy culture and value innovative thinking and creative problem solving. We embrace diversity in thought and backgrounds unified by a commitment to high achievement. When you join Aya, you’ll be surrounded by teammates who care about you as an individual and leaders who will help you grow both personally and professionally.

Responsibilities: 

• Strategic Performance Tuning & Optimization: 
  • Lead the strategic optimization of database performance, including advanced query optimization, execution plan analysis, and resolving complex performance bottlenecks across MS SQL, MySQL, and PostgreSQL environments. 
  • Develop and enforce best practices for SQL coding and database design to prevent sub-optimal queries and enhance overall system performance. 
  • Drive performance improvement initiatives across multiple database platforms, providing technical guidance to junior engineers. 
• Advanced Index Management & Resource Optimization: 
  • Architect and implement advanced indexing strategies, including clustered, non-clustered, filtered, and full-text indexing tailored to complex workloads. 
  • Optimize database resources (memory, CPU, and I/O) in alignment with performance goals and scalability requirements. 
  • Collaborate with infrastructure teams to ensure optimal hardware and storage configurations, supporting peak performance and resource efficiency. 
• Proactive Performance Monitoring & Incident Leadership: 
  • Use advanced tools such as SQL Profiler, Extended Events, SQL Sentry, and open-source monitoring solutions to identify performance issues and proactively implement corrective measures. 
  • Design custom monitoring dashboards that provide real-time insights into critical performance metrics, enabling rapid detection and response to issues. 
  • Lead high-severity incident response, conduct in-depth root cause analysis, and drive strategic initiatives to mitigate future risks. 
• Complex Lock and Concurrency Management: 
  • Architect solutions to minimize lock contention and manage concurrency in high-throughput environments, ensuring smooth transaction processing across SQL and NoSQL platforms. 
  • Implement advanced isolation levels and concurrency control mechanisms tailored to specific application needs. 
  • Provide expert guidance on designing and implementing workload management strategies to reduce transactional conflicts. 
• Architectural Database Configuration & Maintenance: 
  • Review and optimize complex database configurations, including file placements, growth strategies, and