Senior Database Consultant

About the role

We are seeking a seasoned Senior Database Consultant to lead end‑to‑end design, consolidation, and optimization of mission‑critical SQL Server environments. This remote position supports our Data Engineering department and requires deep expertise in high‑availability, performance tuning, and data warehousing.

Key responsibilities

• Audit and map cross‑database dependencies, unify schemas, resolve collation mismatches, and execute minimal‑downtime migrations using CDC, SSIS, bcp and Azure Data Factory.
• Optimize OLTP performance by implementing RCSI/SI, managing blocking/deadlocks, designing enterprise‑wide indexing strategies, and tuning tempdb, MAXDOP and Resource Governor.
• Design OLAP and data‑warehouse solutions, including columnstore indexes, star/snowflake schemas, and SSAS/Power BI models on Azure Synapse or MS Fabric.
• Implement HA/DR architectures with Always On Availability Groups, WSFC, log shipping, and automated backup/restore processes, conducting regular failover and recovery drills.

Required profile

• 10+ years of enterprise SQL Server DBA/architecture experience handling databases >1 TB and high‑concurrency OLTP workloads.
• Proven track record leading large‑scale consolidation projects and managing Always On AGs/WSFC across SQL Server 2012‑2022.

Required skills

• SQL Server (advanced T‑SQL, Query Store, Extended Events, DMVs)
• SSIS, ELT pipelines, bcp, PolyBase, Azure Data Factory
• Azure SQL Managed Instance, Azure Synapse, MS Fabric, Power BI
• Windows Server administration, PowerShell, Active Directory, SAN/NAS storage
• Redgate SQL Toolbelt, SolarWinds DPA, Ola Hallengren scripts

What we offer

• Paid Time‑Off (annual, sick, personal)
• Maternity and paternity leaves per company policy
• Medical and life insurance
• Fuel allowance and company transportation as per policy
• Recognition programs and collaborative team culture