Sign up with

Already have an account? Log in here

Need some help?
Talk to us at +91 7670800001

Database Track Sr.Engineer at HEXAWARE

, , India -

Full Time

Start Date

Immediate

Expiry Date

03 Sep, 26

Salary

0.0

Posted On

05 Jun, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

MS SQL Server, Azure, Database Administration, Disaster Recovery, Performance Tuning, Transactional Replication, High Availability, AlwaysOn, SSIS, SSRS, SSAS, PowerShell, T-SQL, Query Optimization, Capacity Management, Database Migration

Industry

IT Services and IT Consulting

Description

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

Responsibilities

Responsible for the installation, configuration, and maintenance of MS SQL Server environments and Azure databases. The role involves managing high availability, disaster recovery strategies, and the migration of BI components.