SQL Database Administration

HCLTech; Chennai District; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

HCLTech is seeking an experienced SQL Server DBA to design, implement, and optimize database solutions for multi-geo cloud environments. You will lead backup strategies, security hardening, and HA configurations, ensuring 24x7 uptime and compliance with SOX where applicable.

This role requires deep knowledge of SQL Server features (Policy Based Management, Resource Governor, Data Collector) and experience with migration/upgrade planning, performance tuning, and DR testing.

Qualifications

• Experience in database design and architecture.
• Upgrade and migration planning experience.
• Ability to define backup and disaster recovery strategies.
• Knowledge of SQL Server security and auditing.
• Experience with 24x7 operations and SLA adherence.
• Ability to monitor and optimize performance.

Responsibilities

• Define processes and ensure adherence.
• Oversee installation, configuration and migration.
• Ensure maximum uptime according to the SLA.
• Plan backup and test plans for failures.
• Monitor SLA requirements and vendor support.
• Suggest patches and upgrades to maintain security.
• Test/audit and identify skill gaps for training.
• Manage databases in cloud environments.

Skills

Database admin

SQL Server

Performance tuning

Backup & recovery

DR strategies

Cloud DB

Security hardening

HA configurations

Education

Bachelor's degree in Computer Science or related field

Tools

SQL Server

NetBackup

PerfMon/Profiler

SSAS/SSIS/SSRS

DMV Queries

Cloud databases

Job description

• 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
• Managing databases in cloud enivonment

Technical Requirements

• Evaluate the Database Server Hardware.
• Define/Recommend/Maintain Database Standards and Architecture including SQL2016/2017/2022/2025
• Recommend Server H/W, SQL Server Editions for a new Build
• Knowledge of SQL New 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