Senior SQL Server Architect & High Availability Lead

MedRisk LLC; United States; In loco; USD 120.000 - 140.000; Tempo pieno

Descrizione del lavoro

MedRisk LLC in CA, US seeks a Sr Database Administrator to lead enterprise SQL Server environments, ensuring high availability, performance, security, and lifecycle management. Mentors DBAs and partners with engineering for platform standards and migrations.

The role covers capacity planning, disaster recovery, and complex upgrades, with on-call responsibilities and collaboration across teams. Strong T-SQL, HA/DR, and cloud experience are required.

Competenze

• 8+ years' experience administering Microsoft SQL Server in a production enterprise environment.
• Expert-level knowledge of SQL Server 2017/2019/2022/2025, including major upgrades.
• Proficient in T-SQL query optimization and performance tuning.
• Proven design of high availability and disaster recovery architectures (Always On, clustering, log shipping).
• Strong knowledge of RDBMS principles, schema design, normalization, and index strategy.
• Experience with cloud-hosted SQL Server environments (Azure SQL, AWS RDS) preferred.
• Familiarity with HIPAA and security/compliance frameworks is preferred.
• Automation/scripting experience (PowerShell, dbatools) for routine ops.
• Demonstrated technical leadership and mentoring of DBAs.
• Excellent communication and ability to manage multiple priorities.

Mansioni

• Architect, implement, and maintain highly available, secure SQL Server environments.
• Own the organization's HA and DR strategy, including regular DR testing.
• Lead capacity planning and performance initiatives; resolve performance issues.
• Establish and enforce database standards, security, monitoring, and change management.
• Serve as escalation point for critical incidents; perform root cause analysis.
• Lead upgrades, consolidations, and cloud migrations (Azure SQL).
• Evaluate, recommend, and implement database technologies and automation (PowerShell, dbatools).
• Own database security and compliance posture, including access controls and encryption.
• Mentor DBAs and provide technical leadership across the team.
• Collaborate on database design reviews and T-SQL tuning; manage vendor relationships.

Conoscenze

SQL Server administration

T-SQL performance tuning

High availability & DR

Cloud migrations (Azure SQL / AWS RDS)

Mentoring DBAs

Leadership & project coordination

Security & HIPAA compliance

Automation (PowerShell, dbatools)

Vendor management

On-call support

Strumenti

PowerShell

dbatools

SSMS (SQL Server Management Studio)

RedGate SQL Monitor

Descrizione del lavoro

MedRisk LLC in CA, US seeks a Sr Database Administrator to lead enterprise SQL Server environments, ensuring high availability, performance, security, and lifecycle management. Mentors DBAs and partners with engineering for platform standards and migrations.

The role covers capacity planning, disaster recovery, and complex upgrades, with on-call responsibilities and collaboration across teams. Strong T-SQL, HA/DR, and cloud experience are required.