Track Lead - AzureMSSQL DBA, Microsoft Azure

Experience: 12 to Not Available years

Location: Chennai, India

Skills: Microsoft SQL Server, Azure database technologies, Microsoft Certified: Azure Database Administrator Associate, Microsoft Certified: Azure Solutions Architect Expert, REDIS database technologies, Proficient in managing REDIS database, REDIS cluster monitoring tool, Database Server Hardware, Database Standards and Architecture, Patch management, Database Migration, Technical Consultation, High availability, Replication technologies, Failover, Security requirements for REDIS databases, Backup and Recovery Strategies, Microsoft SQL Server (MSSQL) administration, Azure IaaS & PaaS services, Azure Virtual Machines, Azure SQL Database, Azure SQL Managed Instance, High Availability (HA), Disaster Recovery (DR), Always On Availability Groups, Failover Cluster Instances (FCI), Log Shipping, Replication, Azure Backup, Azure Site Recovery (ASR), Performance tuning, Query optimization, Database monitoring tools, Azure Monitor, Log Analytics, SQL Profiler, DMVs, Database architecture and standards, TDE (Transparent Data Encryption), Always Encrypted, Role-based access control (RBAC), PowerShell, T-SQL scripts, Azure Automation

Job Summary
Azure MSSQL DBA L3 Job Description
Experience: -12+ years of hands-on experience working on Microsoft SQL Server and Azure database technologies.
Strong experience in leading database operations teams and managing enterprise-scale environments.
Certification: -Microsoft Certified: Azure Database Administrator Associate [Essential]
Microsoft Certified: Azure Solutions Architect Expert [Desired]

Responsibilities:
- Adhering to SLAs and ensuring timely delivery of database services.
- Leading and mentoring the DBA team; providing technical guidance and training.
- Handling tickets, service requests, and escalations across Azure and on-prem environments.
- Performing root cause analysis (RCA) for critical incidents.
- Troubleshooting database and platform-related technical issues.
- Creating and maintaining SOPs/MOPs and ensuring process adherence.
- Overseeing successful completion of all database-related activities.
- Ensuring database standards, governance, and compliance are maintained.
- Designing and validating backup and disaster recovery (DR) strategies.
- Driving customer satisfaction through proactive support and improvements.
- Identifying gaps and suggesting improvements and current technologies.
- Monitoring SLA adherence and team performance.
- Identifying skill gaps and planning training/upskilling initiatives.
- Managing P1/P2 escalations and coordinating with L3/customer teams.

REDIS L3 Job Description
Experience: -12+ year of hands-on experience working on REDIS database technologies.




Certification: -Professional Certified [Essential]

Key Responsibilities
- REDIS L3
- Adhering to SLAs.
- Mentoring / Training Team Members.
- Handling tickets / requests.
- Perform root cause analysis.
- Troubleshooting technical issues.
- Defining processes [SOP/MOP's] and ensuring that the processes are adhered to.
- Oversees and is responsible for successful completion of database tasks.
- Responsible for maintaining customer database standards.
- Responsible for strategizing a backup plan and test plan for failure scenario.
- Improves and maintains customer satisfaction.
- Suggests Database workplace Gaps, Improvements and new technologies.
- Monitoring and maintaining SLA requirements by the team members.
- Identify Skill gaps and plan for training / knowledge updating.

Skill Requirements
Technical Requirements (REDIS)
- Proficient in managing REDIS database / Cluster - installation, configuration, upgrade, patching, maintenance, security, sysadmin functions and administration.
- Knowledge of REDIS cluster monitoring tool - Managing, Configuring, setting up alerts and troubleshooting
- Evaluate the Database Server Hardware
- Define/Recommend/Maintain Database Standards and Architecture
- Recommend Server H/W, REDIS Server Editions for a new Build.
- Research and Recommend Patch management for database/instance and Impact Analysis.
- Initiate need and Impact Analysis for Database Migration/Upgrade
- Technical Consultation to L2/L3 and Customer
- Vendor Support and Interaction
- Monitor and optimize REDIS database performance and capacity planning.
- Troubleshoot database issues, maintain database systems availability and scalability.
- Create and maintain REDIS databases required for development, testing, Integration, QA and production usage.
- Performs the capacity planning required to create and maintain the databases.
- The DBA should work closely with Server, Backup and storage administrator to meet Backup, Hardware, Storage and Operating system requirements.
- The DBA should work closely customer to understand the requirements and standards.
- Perform ongoing analysis and tuning of the REDIS database.
- Install new versions of the REDIS database and its features and any other tools that access the REDIS database.
- Application code promotion and migrations of programs, database changes,



reference data changes and menu changes through the development life cycle if applicable
- Performs database re-organizations as required to assist performance and ensure maximum uptime of the database.
- Troubleshoots with problems regarding the databases, replication and database related Tools.
- Good knowledge of physical database design and responsible for the physical database design
- Ability to perform database and operating system performance monitoring and the necessary adjustments.
- Excellent skill in High availability, replication technologies and failover
- Implement and enforce security requirements for REDIS databases.
- Recommend and Review Backup and Recovery Strategies.
- Provides technical support to application development teams.
- Having experience of DR Solution/Implementation/Execution through various sync methods.
- Designing strategy towards Capacity Management for DB tracks
- Designing REDIS Server Security (Server hardening, Auditing, compliance)
- Good knowledge of the Unix operating system(s)
- Weekly review of incidents/tickets
- Weekly review of CHGs completed/Canceled.
- Weekly review of recommendations made to the DBs
- Automate routine DB jobs.
- Optimize day-today DB activities.
- Documentation and DB procedures write-up.
- Knowledge of other Databases is added advantage.

Other Requirements
Technical Requirements (MSSQL)
- Strong expertise in Microsoft SQL Server (MSSQL) administration (2012–2022 versions).
- Hands-on experience with Azure IaaS & PaaS services, including:
- Azure Virtual Machines (SQL on IaaS)
- Azure SQL Database
- Azure SQL Managed Instance
- Proficient in installation, configuration, patching, upgrade, and maintenance of MSSQL environments.
- Experience in High Availability (HA) & Disaster Recovery (DR):
- Always On Availability Groups
- Failover Cluster Instances (FCI)
- Log Shipping, Replication
- Knowledge of Azure Backup, Azure Site Recovery (ASR), and DR drills.
- Strong expertise in performance tuning and query optimization.
- Experience with database monitoring tools (Azure Monitor, Log Analytics, SQL Profiler, DMVs).
- Ability to design, implement, and maintain database architecture and standards.
- Hands-on with security implementation:
- TDE (Transparent Data Encryption)
- Always Encrypted
- Role-based access control (RBAC
- Experience in capacity planning, storage management, and performance management.
- Proficiency in automation using PowerShell, T-SQL scripts, or Azure Automation.
- Ability to perform database migrations (on-prem → Azure, cross-platform migrations).
- Experience in backup and recovery strategy design and validation.
- Knowledge of Redis is an added advantage.

📌 Track Lead AzureMSSQL DBA, Microsoft Azure (Chennai)
🏢 HCL Technologies
📍 Chennai