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

This role may be part of an on call rotation. 

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:
    • Design multi-node configurations for high availability and disaster recovery, ensuring seamless failover processes.
    • Implement and maintain robust backup strategies, including full, differential, and transactional log backups, to meet RTO and RPO objectives.
    • Leverage automation to improve productivity, optimize performance, and quickly adapt to dynamic changes in database usage.
  • Capacity Planning & Collaboration:
    • Collaborate with cloud architecture, infrastructure, engineering, and product teams to forecast future database needs and plan capacity accordingly.
    • Analyze historical data to establish database growth trends and guide future scaling strategies.
    • Serve as the primary liaison between database and application development teams, ensuring alignment on performance and reliability objectives.
  • Database Administration & Security:
    • Plan and execute database migrations and upgrades with minimal downtime, ensuring system continuity.
    • Establish, review, and enforce security protocols, including user access control, data encryption, and compliance with industry standards.
    • Conduct regular patching cycles and maintain up-to-date database systems.
  • Documentation & Training:
    • Maintain comprehensive documentation of database architectures, recovery procedures, and performance tuning strategies.
    • Provide detailed performance reports to management, articulating key findings and recommending solutions for improvement.
    • Mentor junior engineers, conduct workshops, and promote best practices within the team.
  • Cross-Training & Knowledge Sharing:
    • Lead training sessions for junior team members and other stakeholders, fostering a collaborative and knowledge-sharing environment.
    • Stay updated on evolving database technologies through workshops, webinars, and conferences, adapting to the latest industry standards.
  • Database Design & Deployment Guidance:
    • Provide performance-focused feedback during the software development life cycle to ensure optimal database design and integration.
    • Engage with developers during code reviews to promote efficient database interaction and best practices.
  • NoSQL Database Maintenance:
    • Offer expertise in managing NoSQL platforms, focusing on scaling, tuning, and maintenance.
    • Lead projects involving the integration of NoSQL solutions into existing infrastructure.

Required Qualifications:

  • Bachelor’s degree in Computer Science, Information Technology, a related field, or equivalent work experience. 
  • 10+ years of hands-on experience managing MS SQL databases in large-scale environments. 
  • 5+ years of experience supporting MS SQL in Azure Cloud environments. 
  • 5+ years of experience of MySQL experience
  • Proficiency in query optimization, execution plan analysis, and performance troubleshooting. 
  • Demonstrated experience in setting up and managing high availability (HA) and disaster recovery (DR) solutions for MS SQL. 
  • Strong familiarity with MS SQL tools like SQL Profiler, Performance Monitor, and Execution Plans. 
  • Solid understanding of NoSQL database architectures and principles. 

Preferred Qualifications:

  • MS SQL Server certifications (e.g., MCSE: Data Management and Analytics). 
  • Experience supporting multiple database technologies as part of a Database Reliability Engineering team. 
  • Proven experience with large-scale data warehouse/data lake solutions such as Databricks, Snowflake, or similar platforms. 
  • Previous leadership or mentorship experience with junior DBAs or database engineers. 
  • Proficiency in scripting languages like PowerShell, Python, or Bash for automating database maintenance tasks. 
  • Experience with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS). 
  • Familiarity with .NET and Entity Framework interactions with MS SQL Server. 
  • Proven ability to handle critical incidents with minimal disruption. 

What We Offer:

  • Free premium medical, dental, life and vision insurance   
  • Generous 401(k) match   
  • Aya also offers other benefits to those that are eligible and where required by applicable law, including reimbursements and discretionary bonuses   
  • Aya provides paid sick leave in accordance with all applicable state, federal, and local laws. Aya’s general sick leave policy is that employees accrue one hour of paid sick leave for every 30 hours worked. However, to the extent any provisions of the statement above conflict with any applicable paid sick leave laws, the applicable paid sick leave laws are controlling   
  • Celebrations! We hit our goals and reward ourselves.    
  • Company-sponsored virtual events, happy hours and team-building activities are always on the horizon — plus, you get a special treat on your birthday!  
  • Unlimited DTO — we believe in time off!   
  • Virtual yoga, meditation or boot camp classes offered daily   

Compensation: Aya reasonably anticipates the pay scale for this position to an annual salary of $190,000 to $205,000.

The pay scale for this position may vary if applicant possesses experience outside of what Aya reasonably anticipates for this position. Bonuses are subject to the role and your manager’s discretion.   

Aya is an Equal Opportunity Employer (EEO), including Disability / Vets, and welcomes all to apply. Please click here for our EEO policy. 

Apply for this Job

* Required
resume chosen  
Dropbox
(File types: pdf, doc, docx, txt, rtf)
Cancel
cover_letter chosen  
Dropbox
(File types: pdf, doc, docx, txt, rtf)
Cancel

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in Aya Healthcare’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Voluntary Self-Identification of Disability

Form CC-305
Page 1 of 1
OMB Control Number 1250-0005
Expires 04/30/2026

Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.

Enter the verification code sent to to confirm you are not a robot, then submit your application.

This application was flagged as potential bot traffic. To resubmit your application, turn off any VPNs, clear the browser's cache and cookies, or try another browser. If you still can't submit it, contact our support team through the help center.