Job Description: (Posting).
We need Sr. SQL Engineering contractor to assist with our MS SQL Server 2019 upgrade
Our department been tasked with working on these additional needs
Dry run upgrade of multiple databases from version 2017 to version 2019 (MDSCommonDb, FTSDocument, Correspondence, DataAccessRM, DocumentPlatformDb, MDSCommonDb, MDSCommonDb_DW, MDSCommonDb_DWPSA) Identification of problematic code leveraging deprecated features, leveraging the Microsoft SQL Server 2019 Database Migration Assistant Identification of poorly performing stored procedures Analyzing performance characteristics of those poorly performing stored procedures Providing specific recommendations and demonstrating POC code that clearly demonstrate performance improvements for those poorly performing stored procedures Create and sequence scripts to deploy the POC to one or more databases Review Load Test results and evaluate results (possibly re-iterating steps above, depending on results)Required Skills
Experience upgrading from Microsoft SQL Server 2017 to Microsoft SQL Server 2019 Experience using the Microsoft SQL Server 2019 Database Migration Assistant Experience remediating poor performance under Microsoft SQL Server 2019 Experience analyzing SQL query plans Experience conducting index and stored procedure tuning; ability to re-write stored procedures for improved performance Ability to work independently, as well as coordinate with offshore (IST time zone) and onshore teams Excellent documentation skills Excellent communication skills Understanding of Microsoft SQL Server database settings and server-wide settings, such as database compatibility level, MAXDOP, threshold for parallelism and the like Nice to have, but not required: experience evaluating before-and-after extended events files for performance Nice to have, but not required: experience with PowerShell (1.) To be responsible for providing technical guidance or solutions (2.) To develop and guide the team members in enhancing their technical capabilities and increasing productivity (3.) TO ensure process compliance in the assigned module, and participate in technical discussionsorreview. (4.) To prepare and submit status reports for minimizing exposure and risks on the project or closure of escalations.
HCL Technologies Ltd.