Key Responsibilities
- Administer and operate Microsoft SQL Server instances supporting a data warehouse workload (OLAP/ETL/BI-heavy patterns).
- Administer and operate SSAS (Multidimensional) and SSIS production and non‑production environments, including deployments, upgrades, patching and capacity planning.
- Own performance optimization end-to-end: query tuning, indexing strategy, statistics maintenance, execution plan analysis, and workload management.
- Manage SQL Server security: logins/users/roles, least-privilege access, encryption where applicable, auditing, and compliance controls.
- Set up and maintain monitoring/alerting for performance, capacity, failures, and data/log growth; create actionable runbooks.
- Manage capacity planning: CPU/memory/storage sizing, tempdb configuration, file placement, and growth strategies.
- Support ETL/ELT and reporting workloads by collaborating with Data Engineers/Analysts to improve SQL patterns and data model access.
- Own operational discipline: incident triage, root-cause analysis, postmortems, and continuous improvement.
- Design disaster-recovery playbooks and inspect/test them quarterly.
- Conduct learn sessions to upskill developers on query optimization and best practices on SQL Server.
- Hold regular meetings with business analysts about SQL queries writing habits to avoid.
Required Qualifications
- Deep, hands-on experience administering Microsoft SQL Server in production (data warehouse or similarly critical workloads).
- Deep knowledge of T-SQL, including performance considerations (set-based logic, window functions, temp tables vs table variables, transaction scope, isolation levels).
- Proven experience with performance troubleshooting and tuning:
- execution plan analysis
- indexing strategy (clustered/nonclustered, filtered indexes, columnstore where appropriate)
- statistics maintenance
- blocking/deadlock resolution
- IO and tempdb bottleneck diagnosis
- Strong Windows Server knowledge relevant to SQL Server operations (services, permissions, storage, networking basics, event logs, patching).
Nice-to-Have Qualifications
- Experience operating SQL Server workloads in Azure (e.g., Azure SQL Managed Instance, SQL Server on Azure VMs, storage considerations, monitoring, identity integration).
Additional Skills We Consider Important for This Role
- Security mindset: understanding of least privilege, separation of duties, and practical auditing/monitoring.
- Operational reliability: monitoring-first approach, clear runbooks, predictable change management, and ownership during incidents.
- Communication skills: can explain root causes and trade-offs clearly to technical and non-technical stakeholders.
- Documentation discipline: maintains configuration baselines, maintenance schedules, and operational procedures.
