First seen by Alion on Nov 19, 2026.
Job Description - Database Administrator (MS SQL)
Role:
Database Administrator - MS SQL
Job Summary:
We are looking for an experienced MS SQL Database Administrator responsible for managing, maintaining, securing, and optimizing SQL Server databases across on-premises and hybrid environments. The role involves ensuring database availability, performance, security, backup and recovery, and supporting database-related deployments in collaboration with application and DevOps teams.
Key Responsibilities:
- Administer, maintain, and optimize MS SQL Server instances across on-premises and hybrid environments, ensuring high availability and database reliability.
- Design, implement, and manage database backup, recovery, replication, and disaster recovery strategies in line with business requirements and SLAs.
- Monitor database performance using Dynamic Management Views (DMVs), SQL Profiler, and custom scripts to identify and resolve performance bottlenecks.
- Perform query optimization, indexing, and performance tuning to improve database efficiency and reduce latency.
- Manage database security, including user access, permissions, roles, and auditing, in accordance with organizational security policies.
- Automate routine database administration tasks, including scheduled jobs, alerts, and maintenance activities using T-SQL, PowerShell, and SQL Server Agent.
- Collaborate with DevOps and application teams to support database deployments, schema changes, database migrations, and CI/CD processes.
- Monitor database health and proactively troubleshoot database-related issues to maintain optimal performance and availability.
Mandatory Skills & Qualifications:
- Strong hands-on experience with Microsoft SQL Server database administration.
- Proficiency in T-SQL, including writing and optimizing SQL queries and scripts.
- Experience with SQL Server Agent for job scheduling and automation.
- Hands-on knowledge of database backup, restoration, and recovery processes.
- Strong understanding of database performance monitoring and tuning.
- Experience with PowerShell scripting for database administration and automation.
- Practical experience using DMVs and SQL Profiler for troubleshooting and performance analysis.
- Good understanding of database security, access management, and maintenance activities.
Good to Have:
- Experience with Always On Availability Groups.
- Exposure to Azure SQL Database and cloud-based database environments.
- Understanding of CI/CD practices for database deployments.
- Experience working in hybrid database environments.
Screening Questions:
1.
2.
3.
4.
Skills
SQL Server, T-SQL, PowerShell, Performance Tuning, Troubleshooting, Security, Azure SQL, DBA, DB, DBMS

