Subject Matter Expert (Support&Ops) (IN)

HCLTech

10+ yrs India Full Time Hybrid (office + remote)
HCLTech logo
Posted : today
Actively hiring

Job description

We are seeking an experienced Senior Database Administrator (Level 3 Support) with a specialization in Microsoft SQL Server. This role is crucial for managing, optimizing, and troubleshooting our SQL Server environments across development, test, UAT, and production stages.

Your responsibilities will include ensuring high availability, implementing robust disaster recovery solutions, and leading complex projects such as migrations and upgrades. You will also be instrumental in performance tuning, security compliance, and capacity planning to maintain optimal database operations.

Responsibilities

Administer and maintain Microsoft SQL Server databases, including installation, configuration, patching, and upgrades. Ensure database availability, integrity, security, and optimal performance through proactive monitoring and tuning. Implement and manage high availability and disaster recovery solutions like Always On Availability Groups, FCI, Replication, and Log Shipping. Configure and monitor backup strategies, performing regular restore tests to meet RTO/RPO objectives. Enforce database security best practices, manage access controls, and ensure compliance with security standards. Handle critical production incidents, conduct root cause analysis, and provide permanent solutions. Lead database migration projects, execute upgrades, and plan consolidation initiatives. Develop T-SQL and PowerShell scripts to automate routine DBA tasks. Create and maintain operational documentation and collaborate effectively with cross-functional teams, adhering to ITIL processes.

Qualifications

Proven experience of 10+ years as a Microsoft SQL Server DBA. Expertise in SQL Server 2012 through 2022, including Always On Availability Groups, performance tuning, backup/recovery, and replication. Proficiency in T-SQL and PowerShell scripting for automation. Solid understanding of database security, auditing, and troubleshooting methodologies. Experience with monitoring tools and basic to intermediate Windows Server administration. Strong analytical, problem-solving, and communication skills are essential. Ability to work under pressure and collaborate effectively within a team environment.

Essential Skills

Microsoft SQL Server 2012/2014/2016/2017/2019/2022SQL Server Always on Availability GroupsPerformance Tuning and Query OptimizationBackup & RecoveryReplicationLog ShippingClusteringSQL Server AgentT-SQL ScriptingPowerShell ScriptingDatabase Security and AuditingTroubleshooting and Root Cause AnalysisMonitoring ToolsWindows Server Administration

Good to Have

Azure SQL Database / Managed InstanceDBA AutomationCloud Migration ProjectsITIL ProcessesCIS Benchmark Implementation

Highlights

  • Actively hiring

More Details

RoleSubject Matter Expert (Support&Ops) (IN)
Employment TypeFull Time, Hybrid (office + remote)

About the Company

HCLTech logo

HCLTech

IT Consulting

Subject Matter Expert (Support&Ops) (IN) at HCLTech | SkillMX | SkillMX