IT-Data Base Admin 2

Position Title: SQL Database Administrator 2

Position Reports to: Director of Infrastructure & Technology Operations (ITO)

Hybrid: (2) Days in office / (3) days remote

Job Summary:

SQL Database Administrator 2 serves as a technical resource for Quadax's Microsoft SQL Server platforms and related data services. Responsible for the design, administration, security, performance, availability, and recoverability of the Company's database environments supporting mission-critical healthcare revenue cycle management applications and third-party vendor solutions.

This role, as part of ITO, partners closely with Application Development, DevOps, Security, and business stakeholders to ensure highly available, secure, scalable, and well-governed database services. Serves as the primary escalation point for complex database issues, leads database modernization initiatives, and drives continuous improvement through automation, standardization, and operational excellence.

All activities will be performed in accordance with established IT governance, security, compliance, and Change Management policies.

SQL Platform Administration & Architecture

• Administration, configuration, maintenance, patching, upgrade, and lifecycle management of enterprise Microsoft SQL Server and Azure SQL environments.
• Design, implement, and support High Availability and Disaster Recovery (HA/DR) solutions including Windows and SQL Server Failover Clustering, replication, and backup/recovery architectures.
• Enforce SQL Server standards, operational procedures, and platform governance.
• Evaluate emerging SQL Server and Azure database technologies and develop strategic recommendations for adoption.
• Participate in infrastructure modernization initiatives, migrations, server consolidations, and cloud integration projects.

Performance Tuning & Capacity Planning

• Identifies SQL performance tuning and optimization opportunities across databases, queries, storage, memory, and compute resources.
• Analyze execution plans, indexing strategies, blocking, deadlocks, waits, and resource consumption to identify and resolve system bottlenecks.
• Develop proactive capacity planning processes and forecast future database growth and infrastructure requirements.
• Monitor key performance indicators and provide actionable recommendations to leadership.
• Responsible for SQL landscape in Azure and treating as an extension of on-prem infrastructure.

Business Continuity & Disaster Recovery

• Own and maintain database recovery strategies, documentation, testing procedures, and operational runbooks.
• Performs periodic recovery and disaster recovery exercises to validate recovery objectives and ensure operational readiness.
• Ensure SQL environments meet defined Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO).
• Participate in incident response activities and lead database recovery efforts during major outages.

Application Development Partnership

• Collaborate with App/Dev teams on physical and logical database design, schema optimization, indexing strategies, stored procedures, triggers, and query development.
• Provide technical guidance for various SQL Server technologies.
• Participate in application architecture reviews to ensure scalability, performance, security, and supportability.

Security, Compliance & Governance

• Administer database security in accordance with industry’s best practices and organizational security requirements.
• Manage authentication, authorization, encryption, auditing, certificates, service accounts, and Kerberos delegation.
• Support security reviews, vulnerability remediation efforts, compliance audits, and risk assessments.
• Maintain least privilege access controls and database security standards.

Automation & Operational Excellence

• Develop and maintain PowerShell and automation solutions to reduce manual effort and operational risk.
• Create and maintain comprehensive documentation, standards, operational procedures, system recovery runbooks, and knowledge base articles.
• Drive process improvements and operational efficiencies across database administration activities.
• Establish monitoring standards, alerting thresholds, and operational health metrics.

Operational Support

• Provide after-hours support for critical production systems as needed.
• Lead technical response efforts during major database-related incidents.
• Support business-critical systems operating in a 24x7 production environment.
• Participate, as needed, in monthly maintenance windows (3rd Sunday of each month) to ensure SQL is properly patched and maintained.

Preferred Qualifications

• Bachelor’s degree in information technology, Computer Science, or equivalent experience preferred.
• 5-7+ years of Microsoft SQL Server administration experience in enterprise production environments.
• 5-7+ years of experience supporting highly available SQL Server environments.
• Experience with:
• SQL Server 2019 and 2025
• Windows/SQL Server Failover Clustering
• SQL Server backup and recovery
• Performance monitoring and optimization
• SQL Server security administration
• Experience supporting 24x7 business-critical database platforms.
• Experience with PowerShell scripting and administrative automation.
• Strong understanding of:
• Windows Server administration
• Enterprise storage systems
• VMware virtualization
• Networking fundamentals
• Disaster recovery planning
• Excellent analytical, troubleshooting, written, and verbal communication skills.
• Experience with Azure SQL Database, Azure Managed Instance, Azure Storage, and hybrid cloud architectures.
• Experience with enterprise backup and recovery platforms such as Veeam.
• Experience with Pure Storage and/or other enterprise storage architectures.
• Familiarity with monitoring platforms such as Dynatrace.
• Microsoft SQL Server, Azure Database Administrator Associate, or related certifications.

Success Factors

The successful DBA 2 will:

• Serve as the technical owner of Quadax's SQL Server platform.
• Maintain secure, highly available, and recoverable database services supporting critical business operations.
• Successfully lead SQL Server upgrades, migrations, and modernization initiatives.
• Improve operational efficiency through automation and process standardization.
• Maintain accurate documentation and recovery procedures.
• Identify and proactively address performance, capacity, availability, and security risks before they impact operations.