About the job Senior Specialist – System Management
Location: Pune
Experience: 7–11 Years
Employment Type: Permanent
Openings: 1
About the Role
We are looking for an experienced SQL Database Administrator (DBA) with strong expertise in Microsoft SQL Server administration, database management, and performance optimization. The candidate will be responsible for maintaining database availability, security, performance, and reliability while supporting enterprise production environments.
Job Description
The role involves installing, configuring, upgrading, and maintaining Microsoft SQL Server instances, ensuring database health and optimal performance. The candidate will manage database backups, recovery, disaster recovery planning, and high-availability solutions.
The position also requires working knowledge of Windows Server administration, infrastructure integration, and automation using PowerShell and T-SQL. The candidate will collaborate with infrastructure and application teams to support database migrations, production releases, troubleshooting, and operational improvements.
Key Responsibilities
- Install, configure, upgrade, and patch Microsoft SQL Server instances.
- Monitor database health and optimize queries, indexes, and server performance.
- Manage database backups, restores, disaster recovery, and recovery testing.
- Implement and maintain high-availability solutions, including Always On Availability Groups and failover clustering.
- Administer database security, access controls, encryption, and auditing.
- Support Windows Server environments, including services, storage, permissions, and performance troubleshooting.
- Automate database maintenance, deployments, monitoring, and reporting using PowerShell, T-SQL, and SQL Server Agent.
- Handle database migrations, production changes, documentation, and root cause analysis.
Required Skills
- Microsoft SQL Server Administration
- SQL Server architecture and database management.
- SQL query optimization, execution plans, indexing, and performance tuning.
- Always On Availability Groups, failover clustering, replication, and log shipping.
- Database backup strategies, point-in-time recovery, and disaster recovery.
- Windows Server administration and troubleshooting.
- PowerShell scripting and automation.
- SQL Server monitoring tools, Extended Events, and Dynamic Management Views (DMVs).
Mandatory Skills
- MS SQL DB Administration
- MS SQL Server
- MySQL DBA
Candidate Profile
The ideal candidate should have substantial hands-on experience in database administration, particularly with Microsoft SQL Server, database performance tuning, and high-availability solutions. Strong troubleshooting, automation, communication, and documentation skills are essential, along with the ability to collaborate with infrastructure and application teams.
A Bachelor's degree in Computer Science, Information Technology, or equivalent practical experience is expected.
Benefits Package
- Competitive salary and benefits package.
- Opportunities for professional growth and development.
- A collaborative and inclusive work environment.
- The opportunity to work on exciting and challenging projects with leading clients.