SME - Oracle Administration,PostgreSQL,MYSQL, MS SQL (IN)
HCLTech
HCLTech
Seeking an expert L3 Database Engineer with extensive experience in Microsoft SQL Server to ensure the optimal performance, security, and reliability of our production database systems. This role serves as the primary technical escalation point, tackling complex SQL Server challenges, leading root cause analysis, developing high availability and disaster recovery strategies, and championing automation for continuous improvement. Collaboration with junior DBAs, application, infrastructure, security, and cloud teams is key to maintaining scalable and compliant database environments.
Focus areas include advanced incident and problem resolution for critical database issues, performance tuning through query optimization, and robust high availability and disaster recovery solutions. You will also be involved in installation, upgrades, patching, migrations, and ensuring stringent security and compliance standards are met. Automation, monitoring, and continuous improvement initiatives are central to this position, alongside detailed documentation and mentoring of junior team members.
- Serve as the ultimate technical escalation point for intricate SQL Server issues identified by L1 and L2 teams. - Lead the resolution of critical incidents, including database outages, corruption, failover failures, and significant performance degradation. - Conduct deep-dive root cause analysis using advanced tools and document permanent solutions. - Own and resolve recurring database problems, ensuring their complete closure. - Manage and escalate product defect issues with Microsoft Premier/Unified Support. - Participate in an on-call rotation for critical after-hours support. - Analyze and optimize slow queries, stored procedures, and workloads using various performance tools. - Address and resolve blocking, deadlocks, parameter sniffing, and performance bottlenecks. - Develop and maintain effective indexing and statistics strategies. - Tune instance-level configurations for optimal performance. - Review and recommend optimizations for T-SQL code from development teams. - Establish performance baselines and implement proactive alerting mechanisms. - Design, implement, and support Always On Availability Groups, Failover Cluster Instances, log shipping, and replication. - Troubleshoot synchronization issues, listener problems, and cluster failures. - Define and manage backup and restore strategies to meet RPO and RTO objectives. - Plan and execute DR drills, failover tests, and restore validations. - Maintain up-to-date DR runbooks and recovery procedures. - Build and configure SQL Server instances to established standards. - Plan and execute version upgrades and patching with minimal downtime. - Lead database migrations, including on-premises to Azure and AWS cloud platforms. - Review and approve database changes through the change management process. - Manage user access and permissions based on least-privilege principles. - Implement encryption and data protection features. - Configure SQL Server Audit and support internal/external audits. - Remediate security vulnerabilities and conduct access reviews. - Automate health checks, backups, patching, and reporting using scripting languages. - Configure and fine-tune monitoring and alerting systems. - Support database CI/CD pipelines using relevant tools. - Identify opportunities for improvement to reduce incidents and manual effort. - Create and maintain comprehensive documentation, SOPs, and knowledge base articles. - Mentor L1 and L2 DBAs, conduct knowledge transfer sessions. - Communicate RCA reports, health checks, and improvement proposals to stakeholders.
- Extensive, expert-level experience with Microsoft SQL Server (2016/2017/2019/2022) administration. - Advanced proficiency in T-SQL, stored procedures, functions, triggers, and dynamic SQL. - Deep understanding and practical experience with performance tuning tools, including execution plans, DMVs, Query Store, and Extended Events. - Proven expertise in designing, implementing, and troubleshooting High Availability and Disaster Recovery solutions such as Always On AGs, FCI/WSFC, log shipping, and replication. - Strong experience with cloud database platforms like Azure SQL Database, Azure SQL Managed Instance, SQL Server on Azure VMs, and AWS RDS for SQL Server. - Advanced skills in automation and scripting using PowerShell, dbatools, and SQL Server Agent. - In-depth knowledge of security features including TDE, Always Encrypted, SQL Server Audit, Row-Level Security, and Microsoft Entra ID authentication. - Experience with monitoring tools such as SolarWinds DPA, Redgate SQL Monitor, SCOM, and Azure Monitor. - Intermediate administration experience with BI platforms like SSIS, SSRS, and SSAS. - Familiarity with PostgreSQL, MySQL, or Oracle databases is a plus. - Experience with DevOps tools like Git, Azure DevOps, SSDT/DACPAC, and ITSM tools like ServiceNow is beneficial. - Relevant certifications, such as Microsoft Certified: Azure Database Administrator Associate (DP-300), are preferred.
HCLTech
IT Consulting