Senior database engineer responsible for installing, configuring, maintaining, and tuning MS SQL Server instances; implementing HA/DR (clustering, mirroring, log shipping, AlwaysOn, replication); troubleshooting performance and deadlocks; managing Azure databases; running proactive health checks and migrations; and supporting BI components (SSIS/SSRS/SSAS) with PowerShell and T-SQL scripting.
"Job Description - Database track Engineer Operational Role: • Experience in installation and configuration of MS SQL Server 2012/2014/2016/2017/2019 versions, upgrades, maintenance plans etc. • Experience in applying necessary SQL Server service packs and CUs / Hot fixes / Security updates • Preparing DR strategies and implementing DR practice tests for mission critical databases to build DR availability confidence • Good knowledge on maintaining databases in Azure • Experience in identifying blockings, deadlocks, index fragmentation, High CPU usage queries. • Good knowledge of using DMV’s and DBCC commands for troubleshooting. • Experience in Configuring Transactional Replication setup, maintenance, and troubleshooting • Experience in HA concepts likes clustering, database mirroring, Log shipping, replication and AlwaysOn • Performing database refreshes between various DB environments • Capacity management which includes planning and recommend the application owners to archive the historical data / data file movement to improve the storage capacity • Standardize SQL Server environment by designing guidelines for SQL Server installation, configuration, storage specifications, CPU, Memory, account, and security to follow best practices and standards • Performance and Tuning, Query optimization using SQL profiler, DTA, Perfmon, DMVs, DBCC and SSMS Proactive health checks • Experience in Business Intelligence components like SSIS, SSRS and SSAS • Responsibility for the success of Migration of databases, SSRS & SSAS • Good technical knowledge on BI Components • knowledge on PowerShell scripting & T-SQL scripting • Good knowledge on Stored procedure, Triggers, functions & join"
Hexaware Technologies Chennai, Tamil Nadu, IND Office
MCN Nagar Ext, MCN Nagar Extension, Thoraipakkam, Chennai, Tamil Nadu, India, 600097
Similar Jobs
Cloud • Information Technology • Productivity • Software • Automation
The Marketing Program Manager will build and execute a marketing plan for India, drive demand, manage budgets, and support global marketing initiatives while engaging with partners and stakeholders.
Top Skills:
MarketoMS OfficeSfdc (Salesforce)
Cloud • Information Technology • Productivity • Software • Automation
Technical leader designing and implementing scalable, fault-tolerant backend microservices and Agentic AI systems. Leads architecture, cloud infrastructure, data strategies, incident response, testing, and mentorship to deliver production-grade high-throughput solutions.
Top Skills:
Agentic AiAnsibleAWSAzureChaos EngineeringCi/CdCloudFormationContainersDistributed CachingDjangoEksEvent StreamingFastapiFlaskGCPJavaKubernetesLlmsMessage QueuesNoSQLOpensearchPrompt EngineeringPythonRagSlisSlosSpring BootSQLTerraformVector Databases
Artificial Intelligence • Big Data • Cloud • Information Technology • Software • Big Data Analytics • Automation
The Benefits Advisor manages the administration of employee benefits across EMEA, overseeing enrollments, compliance, vendor coordination, and financial reconciliation while ensuring high-quality service and operational control.
Top Skills:
Ai-Enabled ToolsHrisExcelMS OfficePower BISap Successfactors
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
