HCL Technologies Ltd. Boone , IL

Posted 4 weeks ago

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

    1. Evaluate performance characteristics of Microsoft SQL Server 20192) Evaluate compatibility of existing code with the new version of Microsoft SQL Server 20193) Coordinate with Load Test teams around evaluation of performance characteristics between 2017 and 2019 versions4) Analyze, remediate/tune for any coding problems (ex. resolve deprecated features, regressive performance) using the new version of Microsoft SQL Server 2019We need a contractor to assist us with this effort, conducting these tasks

  • 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.

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION


HCL Technologies Ltd.