Description

You will manage the installation, maintenance, and performance of SQL Server environments across all levels of support.

Responsibilities

• Monitor SQL Server health, including connectivity, CPU, memory, and disk space utilization.
• Manage backup strategies, including full, differential, and log backups, and implement maintenance plans for integrity checks and index rebuilds.
• Execute database migrations, upgrades, patching, and high availability/disaster recovery configurations.
• Troubleshoot locking, deadlocks, and blocking issues to maintain high OLTP availability.
• Perform performance tuning through index optimization, stored procedure tuning, and T-SQL code reviews.
• Automate administrative tasks using PowerShell scripts, stored procedures, and triggers.
• Respond to P1 and P2 incidents by joining bridge calls and conducting root cause analysis (RCA).
• Manage database object deployments across Integration, QA, UAT, and Production environments.

Required Skills

• 6+ years of experience in MSSQL administration.
• Proficiency in SQL Server installation, configuration, and patching.
• Experience configuring High Availability and Disaster Recovery solutions.
• Strong T-SQL skills for writing complex queries, views, and triggers.
• Hands-on experience with PowerShell scripting for task automation.
• Ability to perform capacity planning and physical database architecture design.
• Experience managing database schema changes and controlled development environments.
• Proven track record of resolving production incidents and performing root cause analysis.
• Any Graduate degree.

Key Skills

Education

Any Gradute