SME - Oracle Administration,PostgreSQL,MYSQL, MS SQL
India
Apply now
Job Description
SME - Oracle Administration,PostgreSQL,MYSQL, MS SQL
Nagpur, Maharashtra

Job Summary

We are seeking an experienced and highly skilled Senior MS SQL Server Database Administrator (L3) to oversee, maintain, and optimize our enterprise database infrastructure. In this role, you will manage the full SQL Server hierarchy, drive critical migration and upgrade initiatives, and ensure high availability. Additionally, you will leverage L2-level expertise in SSIS, SSRS, Power BI, and SSAS to support our data integration and reporting ecosystems, alongside managing critical infrastructure-related SQL jobs and SCCM data pipelines. Senior MS SQL Server Database Administrator (DBA) – Level 3\\\\r\\\\nJob Overview\\\\r\\\\nWe are seeking an experienced and highly skilled Senior MS SQL Server Database Administrator (L3) to oversee, maintain, and optimize our enterprise database infrastructure. In this role, you will manage the full SQL Server hierarchy, drive critical migration and upgrade initiatives, and ensure high availability.\\\\r\\\\nAdditionally, you will leverage L2-level expertise in SSIS, SSRS, Power BI, and SSAS to support our data integration and reporting ecosystems, alongside managing critical infrastructure-related SQL jobs and SCCM data pipelines.\\\\r\\\\nCore Responsibilities\\\\r\\\\n1. Database Infrastructure & Architecture (L3 Focus)\\\\r\\\\n• SQL Server Hierarchy Management: Design, configure, maintain, and optimize complex SQL Server environments across production, staging, and development zones.\\\\r\\\\n• Migrations & Upgrades: Lead and execute seamless database migrations, version upgrades, and patch management (Cumulative Updates/Service Packs) with minimal downtime.• High Availability & Disaster Recovery (HADR): Implement and manage AlwaysOn Availability Groups, Failover Cluster Instances (FCI), log shipping, and replication.• Infrastructure & SCCM Integration: Manage and troubleshoot specialized SQL jobs tied to core infrastructure health and SCCM (System Center Configuration Manager) data repositories.• Performance Tuning: Proactively monitor, diagnose, and resolve complex performance bottlenecks (indexing, query tuning, locking/blocking, and resource contention).2. Data Integration & ETL (L2 Focus)• SSIS Packages Management: Deploy, configure, monitor, and troubleshoot SQL Server Integration Services (SSIS) packages.• ETL Maintenance: Maintain and optimize existing ETL workflows, ensuring data integrity and scheduling efficiency.3. Business Intelligence & Reporting• Reporting Services: Administer and maintain SSRS (SQL Server Reporting Services) environments, including report deployment and security configuration.\\\\r\\\\n• Power BI Ecosystem: Support and manage Power BI gateways, data refreshes, and workspace environments for enterprise reporting.• Analysis Services: Provide operational support for SSAS (SQL Server Analysis Services) tabular and multidimensional models.4. Database Development Support (L2 Focus)• Query Writing & Analysis: Demonstrate solid L2 proficiency in writing, reviewing, and optimizing T-SQL queries, stored procedures, views, and functions to assist development teams and troubleshoot issues.                            Required Skills & QualificationsTechnical Competencies• SQL Server Administration: 6+ years of hands-on experience as a SQL Server DBA handling large-scale enterprise environments (SQL Server 2016 through recent versions).• Advanced DBA Skills: Deep expertise in backup/recovery strategies, SQL Server security, policy management, and advanced troubleshooting.• BI Stack: Solid, practical knowledge (L2 level) of SSIS, SSRS, and SSAS.• Modern Analytics: Experience supporting Power BI infrastructure and report deployment.• T-SQL Proficiency: Strong ability to write and analyze complex SQL queries and scripts for automation and data validation.Inf

Key Responsibilities

Database Infrastructure & Architecture (L3 Focus) • SQL Server Hierarchy Management: Design, configure, maintain, and optimize complex SQL Server environments across production, staging, and development zones. • Migrations & Upgrades: Lead and execute seamless database migrations, version upgrades, and patch management (Cumulative Updates/Service Packs) with minimal downtime. • High Availability & Disaster Recovery (HADR): Implement and manage AlwaysOn Availability Groups, Failover Cluster Instances (FCI), log shipping, and replication. • Infrastructure & SCCM Integration: Manage and troubleshoot specialized SQL jobs tied to core infrastructure health and SCCM (System Center Configuration Manager) data repositories. • Performance Tuning: Proactively monitor, diagnose, and resolve complex performance bottlenecks (indexing, query tuning, locking/blocking, and resource contention).

Skill Requirements

SQL Server Administration: 6+ years of hands-on experience as a SQL Server DBA handling large-scale enterprise environments (SQL Server 2016 through recent versions). • Advanced DBA Skills: Deep expertise in backup/recovery strategies, SQL Server security, policy management, and advanced troubleshooting. • BI Stack: Solid, practical knowledge (L2 level) of SSIS, SSRS, and SSAS. • Modern Analytics: Experience supporting Power BI infrastructure and report deployment. • T-SQL Proficiency: Strong ability to write and analyze complex SQL queries and scripts for automation and data validation. • Infrastructure Knowledge: Familiarity with Windows Server administration, Active Directory, storage systems (SAN/NAS), and SCCM architecture.

Other Requirements

Query Writing & Analysis: Demonstrate solid L2 proficiency in writing, reviewing, and optimizing T-SQL queries, stored procedures, views, and functions to assist development teams and troubleshoot issues.
Apply now
Information at a Glance

Why HCLTech?

At HCLTech, you'll supercharge your potential. You'll find your career. And you'll find your spark. All at a place that knows that helping its customers stay on top starts by putting its people first.

HCLTech is a global technology company, home to more than 226,300 people across 60 countries, delivering industry-leading capabilities centered around digital, engineering, cloud and AI, powered by a broad portfolio of technology services and products. We work with clients across all major verticals, providing industry solutions for Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services. Consolidated revenues as of 12 months ending December 2025 totaled $14.5 billion.
23 Benefits At HCLTech, we believe in empowering our employees with comprehensive benefits that support their professional growth and enhance their well-being. When you sign up for a career with us, you gain access to: https://rmkcdn.successfactors.com/147eb21f/a701dca9-f32d-4fc9-9447-6.svg Industry-benchmarked compensation https://rmkcdn.successfactors.com/147eb21f/b0c54381-ddcc-4a33-9b35-9.svg Best-in-class healthcare benefits https://rmkcdn.successfactors.com/147eb21f/b73027be-7aae-4d36-a090-4.svg Personal time off https://rmkcdn.successfactors.com/147eb21f/d5b4fdfd-2e99-4e26-9878-9.svg Maternity and paternity benefits https://rmkcdn.successfactors.com/147eb21f/3d42b0fc-4652-435a-9ece-c.svg Access to skills / higher education programs/resources https://rmkcdn.successfactors.com/147eb21f/aeddeaf2-9e25-4584-ad11-d.svg Discounts on products and services via Benefit Box https://rmkcdn.successfactors.com/147eb21f/a9609a3b-2700-4b3c-9d90-a.svg Participate in CSR programs and live life with a purpose https://rmkcdn.successfactors.com/147eb21f/c6e33851-710f-4634-bd69-f.svg Opportunities to grow and advance your career Note: The benefits listed above vary depending on the nature of your employment and the country where you work. Some benefits may be available in some countries but not in all.