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 Pune, Mahārāshtra, IND Office
North Block, Plot No. 19, Rajiv Gandhi InfoTech Park, MIDC - SEZ, Phase 3, Hinjawadi, Pune, Maharastra, India, 411057
Similar Jobs
.jpeg)
Artificial Intelligence • Hardware • Information Technology • Machine Learning
The QMS Manager will oversee quality management system development, execution, and maintenance for process improvement toward zero defects while also mentoring the team and liaising with customers and internal departments.
Top Skills:
Aiag 5 Core ToolsControl PlansFmeaPpapQms StandardsSpc
Big Data • Food • Hardware • Machine Learning • Retail • Automation • Manufacturing
Provide day-to-day support and administration for INFOR Time & Attendance, assist with configuration, testing, data migration, and training. Serve as first-line support for users, manage integrations to payroll/HRIS, run reports, and support project coordination and vendor governance to ensure timely system rollouts and compliance.
Top Skills:
Hcm IntegrationHrisInfor HcmInfor Time & AttendanceExcelMs WordMvs (Master Rotation And Auto Assignment)PayrollReporting ToolsWorkday
Artificial Intelligence • Fintech • Hardware • Information Technology • Sales • Software • Transportation
Own and roadmap fleet management product experiences for dispatchers, operators, and drivers. Translate customer pain into web and mobile workflows, define metrics, run betas, work with data scientists to build AI features from sensor data, and collaborate cross-functionally while gathering field feedback.
Top Skills:
AIAutomotive SystemsIndustrial IotSQLTelematics
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.
