Duties & Responsibilities
Core Database Administration
- Install, configure, upgrade, and maintain SQL Server databases across onprem and Azure SQL Managed Instance environments.
- Perform advanced performance troubleshooting using execution plans, DMVs, waits & queues, indexing strategies, and engine level diagnostics.
- Manage robust backup/restore processes, disaster recovery plans, and ensure data integrity.
- Create, maintain, and optimize database objects (schemas, tables, indexes, stored procedures, views, functions, partitions).
High Availability / Replication / Cloud
- Configure and maintain, Always On Availability Groups, Log Shipping, Replication, and Azure SQL Managed Instance high availability features.
- Support database migrations, cloud modernization, and hybrid SQL environments.
Debugging, Troubleshooting & Production Support
- Provide 24/7 production support for mission critical systems and resolve incidents with urgency and precision.
- Troubleshoot complex SQL performance issues: blocking, deadlocks, memory contention, I/O bottlenecks, SQL Agent failures, ETL job failures, and corruption-related issues.
- Collaborate with application, infrastructure, and DevOps teams to diagnose cross layer issues.
ETL, Automation & Scripting
- Support, debug, and optimize ETL packages (SSIS, ADF pipelines) and data integration processes.
- Automate administrative tasks using TSQL, PowerShell, SQL Agent jobs or other scripting tools.
Operational Excellence
- Conduct capacity planning, storage forecasting, and proactive monitoring to prevent downtime.
- Maintain comprehensive documentation for configurations, processes, and operational procedures.
- Participate in an on call rotation and provide after hours and weekend support when required.
Management Responsibilities
- Foster a culture of solution-orientation and ownership, avoiding bottlenecks.
Requirements
Basic Qualifications
- Bachelor's degree in Computer Science, Information Technology, or related field.
- 710 years of hands on experience as a SQL Server Database Administrator.
- Deep understanding of SQL Server internals (optimizer behavior, locking/latching, tempdb, memory management, indexing strategy).
- Strong debugging and problem solving skills in high pressure production environments.
- Hands on experience working with Azure SQL Managed Instance and hybrid SQL server environments.
- Solid experience supporting ETL processes using SSIS or Azure Data Factory.
- Proficiency in Management Studio (SSMS), TSQL scripting, and writing optimized queries.
- Experience with performance tuning, query optimization, index/maintenance strategies, and storage related analysis.
- Knowledge of Windows Server administration and PowerShell scripting for automation.
- Strong understanding of database security, role management, encryption, and access control.
- Strong experience handling production support, including urgent issue response and severity level incident management.
- Willingness to support on-call rotation and provide off-hours support.
- Excellent communication, analytical thinking, and ability to collaborate across teams.
Preferred Qualifications
- Microsoft Certified (DP-300) or similar certification.
- Familiarity with data warehousing concepts and tools (e.g., Snowflake)
- Exposure to DevOps practices and CI/CD pipelines.
