SQL DBA

Springbokit; United States; On-site; USD 110,000 - 150,000; Full time

Job summary

Springbokit is seeking an Advanced Database Administrator to care for SQL Server environments, including VM-hosted and cloud deployments, Cosmos DB, and migrations toward PaaS/SaaS. You will support deployments, maintain high availability, and ensure secure access to production data.

The role requires 3+ years in SQL Server performance tuning, HA configurations, and backups, plus experience with Azure SQL and Cosmos DB. Strong collaboration with developers and operations teams is essential.

Qualifications

• 3+ years of experience diagnosing and resolving SQL Server performance issues, including blocking and locking.
• 3+ years of experience troubleshooting SQL Server high-availability scenarios involving clustering, Always On technologies, and SQL replication.
• 3+ years of experience managing SQL Server Agent jobs, including backups and index maintenance.
• 1+ years of experience administering SQL Server on Azure Virtual Machines.
• 1+ years of experience administering and supporting Azure Cosmos DB, Azure SQL Database, and Azure SQL Managed Instance.
• 1+ years of experience managing SQL Server environments with PowerShell.
• Solid understanding of high-availability and data-movement technologies and DR concepts like RPO/RTO.

Responsibilities

• Maintain, monitor, and administer SQL Server databases across all environments.
• Diagnose and resolve availability issues involving clustering, Always On, and replication.
• Investigate and correct performance, locking, and blocking problems in SQL Server databases and VMs.
• Observe database behavior, implement performance improvements, and keep databases efficient.
• Move VM-based SQL Server workloads to PaaS/SaaS targets (Managed Instance, Azure SQL Database, etc.).
• Automate recurring tasks and alert responses using PowerShell, T-SQL, or .NET.
• Review query plans and guide developers on sound database coding practices.
• Provide on-call coverage for critical production systems as scheduled.
• Support SSIS packages and data import/export processes.
• Coordinate with vendors and contribute to ISO-compliant security and quality procedures.

Skills

SQL Server performance tuning

High availability/Always On

SQL Server maintenance

Azure SQL/VM administration

Cosmos DB administration

PowerShell automation

Disaster recovery concepts

Job description

The Advanced Database Administrator is responsible for the ongoing care and reliability of our client’s SQL Server environments and related data platforms (including both virtual-machine-hosted and cloud-native deployments), Azure Cosmos DB, and the progressive migration of infrastructure-as-a-service workloads toward platform-as-a-service and software-as-a-service offerings. The role also includes assisting application teams during deployments and helping sustain high availability across the client’s production application landscape. Our client maintains multiple large-scale web applications, and the database team supports a large number of individual SQL Server databases in production.

Primary Duties & Responsibilities:

• Maintain, monitor, and administer SQL Server databases across all application environments.
• Diagnose and resolve availability issues involving Windows Server clustering, SQL Server on virtual machines, Azure SQL Managed Instance, Always On readable secondaries, Always On Availability Groups, SQL Server replication, and SQL failover groups.
• Investigate and correct performance, locking, and blocking problems within SQL Server databases, tempdb, and supporting virtual machines.
• Continuously observe database behavior, implement performance improvements, and keep databases operating at efficient levels.
• Address both proactive and reactive performance and capacity concerns, including index management, SQL trace analysis, Extended Events, auditing, and alerting.
• Administer SQL Server Agent jobs and related Windows scheduled tasks.
• Configure, monitor, and support Database Mail end to end.
• Execute controlled upgrades and migrations for infrastructure-as-a-service SQL Server instances.
• Move virtual-machine-based SQL Server workloads to platform-as-a-service and software-as-a-service targets (Managed Instance, Azure SQL Database, and similar services).
• Automate recurring operational tasks and alert responses using PowerShell, T-SQL, .NET, or other appropriate tools.
• Review query execution plans and guide developers on sound database coding practices.
• Work collaboratively with development, quality assurance, business stakeholders, and, when appropriate, end customers.
• Identify and implement improvements that increase reliability, performance, and overall system capability.
• Control data access and strengthen the security posture of SQL Server databases and other critical client data.
• Assist team members with Integration Services (SSIS) packages and related data import/export processes.
• Use approved AI-assisted tools and automation effectively to improve efficiency in day-to-day work and across relevant stages of the software development life cycle (requirements, design, development, testing, deployment, and operations).
• Maintain, monitor, and administer Cosmos DB across environments.
• Monitor Azure SQL resource consumption and recommend optimizations that balance performance, availability, and cost.
• Proactively identify opportunities for continuous improvement and bring forward practical ideas.
• Support other Technical Operations team members in sustaining application and website availability, including assistance with Windows Server, IIS, and system patching when required.
• Provide on-call coverage for critical production systems on a 24/7 basis when scheduled.
• Perform scheduled maintenance windows and support after-hours release deployments.
• Coordinate with third-party vendors (hosting providers, cloud providers, and similar partners).
• Contribute to the client’s Continual Improvement Program so that activities remain consistent with ISO 9001 and ISO 27001 expectations, including adherence to quality procedures and quality-management and information-security objectives.
• Report any security-related issues, incidents, or situations that may present a risk, in accordance with organizational policy.

Knowledge and Skills:

• 3+ years of experience diagnosing and resolving SQL Server performance issues, including blocking and locking.
• 3+ years of experience troubleshooting SQL Server high-availability scenarios involving clustering, Always On technologies, and SQL replication.
• 3+ years of experience managing SQL Server Agent jobs, including routine database maintenance such as backups and index maintenance.
• 1+ years of experience administering SQL Server on Azure Virtual Machines.
• 1+ years of experience administering and supporting Azure Cosmos DB, Azure SQL Database, and Azure SQL Managed Instance, with attention to reliability, performance, and security.
• 1+ years of experience managing SQL Server environments with PowerShell.
• Solid understanding of high-availability and data-movement technologies (Always On Availability Groups, Change Data Capture, SQL Replication, SQL Clustering) and disaster-recovery concepts such as RPO and RTO.