Senior SQL Server DBA/Engineer responsible for installation, configuration, maintenance, HA/DR design and testing, performance tuning, replication, migrations, capacity planning, and supporting BI components (SSIS/SSRS/SSAS). Uses DMVs/DBCC, SQL Profiler, DTA, Perfmon, SSMS, PowerShell, and T-SQL for troubleshooting and optimization.
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
Artificial Intelligence • Productivity • Software • Automation
We are seeking a Mid-level or Senior DevOps Engineer to design, implement, and improve CI/CD systems, ensure reliable software delivery, and collaborate across teams to enhance system performance and maintainability.
Top Skills:
Ai ToolsArgocdCi/CdGithub ActionsGitlab CiKubernetesLlms
Artificial Intelligence • Consumer Web • Digital Media • Information Technology • Social Impact • Software
As the Lead Product Designer for Discover, you'll design AI-driven experiences for a two-sided marketplace while mentoring the design team and owning the product design direction.
Top Skills:
Ai-Assisted Prototyping Tools (CursorClaude CodeFigmaLovable)V0
Artificial Intelligence • Cloud • Computer Vision • Hardware • Internet of Things • Software
The role involves developing executive-level relationships, managing end-to-end customer engagement, and demonstrating effective solution-based sales processes in complex sales campaigns with enterprise customers.
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.
