MS SQL Database Admin

Location- Bangalore Only

Exp-9-13 Only

JOB DESCRIPTION-

This role involves managing and optimizing MS SQL Server databases, ensuring high availability, and providing 24x7 support for critical systems. Key skills include SQL Server administration, .NET/C# coding, PowerShell scripting, and cloud management (Azure/AWS).

Primary Skills:

• MS SQL Server Administration (9-13 Year of Experience Mandatory)
• .NET and C# coding
• PowerShell scripting
• T-SQL coding
• Cloud management (Azure and AWS)
• Project management and planning
• Multi-project management and prioritization
• High Availability (HA) and Disaster Recovery (DR) for SQL Server
• Backup, restore, and recovery models

Secondary Skills:

• Azure/AWS knowledge
• Experience with scripting languages like C# and VB
• SSIS/SSRS, PowerBI

Experience:

9-13 years in MS SQL Server Administration

Experience in project management and planning

Ability to work rotational shifts and night shifts as per ROTA demands

Real-time issue analysis and resolution

Multi-tasking and context-switching between different activities and teams

Role and Responsibilities:

• Review and assess overall database configuration, including Always ON, disk space, memory allocation, and backup strategies.
• Ensure proper configuration of backup time, location, retention policies, and validate the backup strategy aligns with Recovery Time Objectives (RTO) and Recovery Point Objectives (RPO).
• Analyze indexing strategies, identifying unused, clustered, or composite indexes, and propose optimizations based on application workload (read-heavy vs. write-heavy).
• Identify and resolve indexing issues, such as missing indexes on primary and foreign keys, and optimize database performance through query refinements.
• Identify and mitigate single points of failure, ensuring reliable crossover mechanisms between master and standby nodes for high availability.
• Conduct performance reviews to identify and address query and database bottlenecks, especially related to read/write operations.
• Perform detailed reviews of database schemas, entity-relationship diagrams (ERD), and version control for schema changes.
• Ensure that all database keys (primary, foreign) are in place, and review query execution plans for optimization opportunities.
• Analyze database performance metrics, including throughput, query execution time, concurrency, and overall resource utilization.
• Provide ongoing monitoring and reporting to senior leadership on database health and performance.
• Ensure comprehensive backup and recovery plans are in place and perform regular recovery drills to verify backup integrity.
• Confirm backup SLAs are documented, and that backups are regularly tested by restoring them to a test server.
• Provide 24x7 support for critical production systems