Employee Navigator is seeking a Mid to Senior Level SQL Server DBA and Developer to manage, tune, and optimize their SQL Server infrastructure, which is critical for their growing SaaS insurance & HR technology platform. The role will also contribute to modernizing the infrastructure, including upgrades, automation, and performance scaling.
Requirements
- 6–10 years of experience as a SQL Server DBA and Developer in a production environment.
- Strong T-SQL development, troubleshooting, and performance tuning skills.
- Experience with SQL Server 2016 or later, including AOAG configuration and support.
- Hands-on expertise in query optimization, indexing strategies, execution plan analysis, and code review.
- Familiarity with sp_whoisactive, Idera SQL Diagnostic Manager, SQL Sentry Plan Explorer, Extended Events, Ola Hallengren Maintenance Scripts.
- Understanding of Azure Cloud, Azure VMs, Managed Instances, and Azure SQL Databases.
- Exposure to Git-based workflows and DevOps collaboration practices.
Responsibilities
- Manage and maintain SQL Server databases (2016, 2019, 2022) across multiple shards and environments (Development, QA, Staging, Production).
- Configure, monitor, and support Always On Availability Groups (AOAG) and Windows Server Failover Clustering (WSFC) for high availability and disaster recovery.
- Monitor performance and identify bottlenecks using tools like Idera, Extended Events, WorkloadTools, Query Store, and wait statistics.
- Hands-on experience with performance tuning, indexing strategies, and execution plan analysis.
- Collaborate with developers to review SQL code, enforce best practices, and eliminate issues like parameter sniffing and implicit conversions.
- Automate recurring tasks and deployments using t-sql, PowerShell, dbatools, and Infrastructure-as-Code tools such as Terraform or Ansible.
- Participate in the SQL Server 2022 upgrade initiative by validating workloads and optimizing compatibility levels.
Other
- You take ownership of tasks, communicate effectively, and work collaboratively with developers and infrastructure teams.
- Excellent written and verbal communication skills.
- Detail-oriented and reliable - ensures correctness, consistency, and documentation discipline in all deployments and data fixes.
- Breaks down complex problems logically and communicates solutions clearly.
- Collaborative and humble - works effectively across teams, listens actively, shares credit, and learns from feedback.
