T-SQL Developer

T-SQL Developer

ParadigmIT | Hyderabad, TG, IN

Posted a month ago

Apply Now

Description

Experience: 3 to 7 Years

Shift Timings:- 01.00 PM to 10.00 PM (Monday to Friday) - Hybrid Model


Mandatory Skills:

  • Strong Proficiency with T-SQL.
  • Experience with MS SQL Server relational database.
  • Experience in writing complex T-SQL queries, Custom Stored Procedures, Indexes, and Functions as per the client's requirements.
  • Good Knowledge and working experience in Performance Tuning.
  • Design, create, and implement database system objects based on the end user's requirements.

Desired Skills:

  • Good knowledge in SQL Server 2008, 2008 R2, 2012, 2014,2016 and 2019
  • Good Knowledge in Dynamic SQL.
  • Good experience in writing the custom scripts in a generic way.
  • Good experience in writing the code from the scratch based on the business requirement.
  • Strong knowledge in Debugging Techniques.
  • Able to understand the business functionality of code which was previously developed.
  • Need to understand the business requirement from the speciation document.
  • Good understanding of background process functionality.
  • Good knowledge and hands-on experience in tuning the Database at the Memory level, able to tweak SQL queries.
  • Good understanding of the SQL Server architecture
  • Should have good administrative knowledge of Windows OS.
  • Familiar with using most of the options available in Profiler
  • Good written and verbal communication.

Roles & Responsibilities:

  • Develop, implement and optimize stored procedures and functions using T-SQL.
  • Interacting with Internal Leads and other stakeholders to understand and define the key problems, requirements, workflows, and define solutions.
  • Responsible for Bug investigation and solving as per the client requirement.
  • Proactive to manage/update all the internal tools like Zendesk, Jira, PMO, etc.,
  • Working closely with PMs, ICs to Develop and Implement the user requirements with 100% quality.
  • Understanding the Business requirement from the specification document
  • Performing the unit testing and Adhoc testing
  • Able to do the Regression testing between the old and new versions.
  • Able to check in the developed code into Github