Senior Database Reliability Engineer II

Summary

Join Aya Healthcare as a Senior Database Reliability Engineer II and contribute to enhancing the performance, scalability, and reliability of large-scale database infrastructure primarily hosted on Azure.

Requirements

• 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

Responsibilities

• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• 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
• Offer expertise in managing NoSQL platforms, focusing on scaling, tuning, and maintenance
• Lead projects involving the integration of NoSQL solutions into existing infrastructure

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

Benefits

• 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
• 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