The Sr. Software Engineer - SQL will be responsible for SQL development in SQL server. This is an individual contributor role and will work with other Developers and Product Managers throughout the software development lifecycle, including unit testing. You will be guided in Agile frameworks and popular coding languages to fulfil our business needs.

Key Responsibilities

Communicate with the business teams and clients for requirements.
Guide junior team members in day-to-day activities.
Design and develop technicalsolutions.
Estimate, plan and schedule deliveries.
Troubleshoot production issues with minimalsupport.
Manage deployments and releases.
Source code configuration and management.
Analyse and mitigate risks.
Report accurate status to all stakeholders.

Requirements

The candidate should have completed B.E. / BTech / B.C.A. / M.E. / MTech /, M.C.A /M.C.M from a recognized institute.
Should have 5 to 8 years experience in software development using MS SQL Server.
Primary skills of SQL Server 2016 and above.
Ability to interpret requirements and write SQL scripts.
Know all features of SQL Server2016 Stored Procedure, SQL Jobs, Functions and Triggers.
Good understanding on databasemigration from different sources to MS SQL server.
Good knowledge on DDL/DML/DCL queries, query tuning& performance optimization.
Knowledge of SSIS is mandatory.
Good interpersonal skills to interact with all level of people of the organization.
Candidate should be willing to work in rotational shifts.
Knowledge on Microsoft Azure Data factory, Postgres database is a plus.

Technical Competencies

SSMS, SQL profiler, Tuning Advisor
SSRS, SSIS
JIRA, Azure DO, SVN, CI CD, GIT HUB, Any AI Tool knowledge is plus

Functional Competencies

Excellent written and verbal communication skills.
Ability to work effectively in a team.
Experience in Agile methodology and Sprints preferable.
Ability to interact with Business Team and understand requirements.