Sr. Database Reliability Engineer II

Join Aya Healthcare, winner of multiple Top Workplace awards!

Aya Healthcare is seeking a highly skilled Senior Database Reliability Engineer II to join our Data Reliability Engineering team, which is focused on enhancing the performance, scalability, and reliability of our large-scale database infrastructure primarily hosted on Azure.

This role will involve a deep engagement in database performance tuning, reliability engineering, and architectural guidance, supporting our mission-critical SaaS applications. The ideal candidate will have extensive experience in MS SQL, NoSQL, and complex data warehouse and data lake environments with demonstrated ability to lead complex database reliability initiatives and collaborate effectively across multidisciplinary teams. Experience with modern data warehouse and data lake solutions such as Databricks or Snowflake 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: 

• Performance Tuning & Optimization:
  • Conduct comprehensive performance tuning for MS SQL environments, focusing on query optimization and execution plan analysis.
  • Diagnose and resolve query timeouts, deadlocks, and transactional conflicts.
  • Implement best practices for SQL coding to enhance query performance and prevent sub-optimal executions.
• Index Management & Resource Optimization:
  • Review and adjust index strategies, including clustered, non-clustered, and full-text indexing, based on usage statistics and performance needs.
  • Monitor and optimize resource usage, including memory, CPU, and I/O, ensuring efficient database operation.
  • Work closely with infrastructure teams to align hardware and storage configurations with database performance requirements.
• Performance Monitoring & Incident Management:
  • Utilize advanced monitoring tools such as SQL Profiler, Performance Monitor, and SQL Sentry to diagnose performance issues and optimize database operations.
  • Customize real-time monitoring dashboards and set up automated alerts for potential performance degradations, ensuring rapid response and minimal downtime.
  • Lead incident response efforts, performing root cause analysis and implementing corrective actions to prevent future occurrences.
• Lock and Concurrency Management:
  • Design and implement strategies to minimize lock contention and manage concurrency, enhancing transaction flows in high-volume environments.
  • Apply appropriate isolation levels based on workload requirements, balancing data integrity and performance.
• Database Configuration & Maintenance:
  • Regularly review and optimize database configurations, including file placements, growth settings, and recovery models, to align with performance goals.
  • Monitor and manage tempDB usage to prevent bottlenecks and ensure smooth database operation.
  • Conduct regular performance audits, collaborating with development, infrastructure, and QA teams to execute load and stress tests.
• Database Sustainability & Reliability Engineering: