Responsibilities :-

-Adhering to SLAs

-Mentoring / Training Team Members

-Handling tickets / requests

-Perform root cause analysis

-Troubleshooting technical issues

-Handling/Responding to Alerts

-Defining processes and ensuring that the processes are adhered to

-Oversees and is responsible for successful completion of Installation, configuration and migration

-Ensure maximum uptime according to the SLA

- Understanding of Multi-geo support environment

-Responsible for building / maintaining a test environment

-Responsible for strategizing a backup plan and test plan for failure scenario

-Improves and maintains customer and employee satisfaction

-Suggests new technologies and design changes

-Monitoring and maintaining SLA requirements by the team members

- Planning Backup/Restoration Strategy for 24x7 operation support

-Suggesting patches/upgrades to maintain security level

-Testing / Auditing/processes as required from time to time

-Identify Skill gaps and plan for training / knowledge updating

- DMZ Environment Overview
- Managing databases in cloud enivonment

Technical Requirements

- Evaluate the Database Server Hardware.
- Define/Recommend/Maintain Database Standards and Architecture including SQL2016/2017/2019/2022/2025
- Recommend Server H/W, SQL Server Editions for a new Build





-Knowledge of SQL Current features like CDC ,UCP,Data Collector,Change Tracking,PBM
- Expert in Database Design.
- Research and Recommend Patch management for database/instance and Impact Analysis.

-Initiate need and Impact Analysis for Database Migration/Upgrade-(inplace,side by side,Rolling)/Run DMA reports

-Knowledge of Monitoring Tools,Alerts thresholds

- Technical Consultation.
- Vendor Support and Interaction
- Advance Database Performance tuning (Perfmon, Profiler,Database Tuning Wizard,DMV'S etc.)
- Recommend and Review Backup and Recovery Strategies including thirdy party backup tools like Netbackup
- Knowledge on feature of MS SQL Server (Policy Based Management, Resource Governor, etc.)
- Having experience of DR Solution/Implementation/Execution through various synch methods.
- Designing strategy towards Capacity Management for DB tracks.
- Designing SQL Server Security (Encryption,Server hardening,Auditing,SOX compliance)
- High Availability Features (Failover Clustering, Database Mirroring, Log Shipping, Replication,Always ON)
- Administering SSRS, SSIS and SSAS components
- Skills on managing databases or instances in cloud
- Responsible for Design/build/troubleshooting a cloud PAAS/IAAS database solution

-Knowledge of Hypervisor basedSQL Environments

📌 SQL Database Administration (Chennai)
🏢 HCLTech
📍 Chennai