Senior SQL Developer

Explorance

Location

Chennai | India

Job description

Implementation of robust Stored Procedures.
Implementation of highly scalable Data Access Layers.
Maintain SQL scripts, indexes, and complex queries for data analysis and extraction
Maintain and create SSIS Packages.
Building secure and reusable code and libraries.
Translation of requirements and technical analysis into visual elements or back-end features.
Validation and correction of upstream technical design.
Understanding of fundamental design principles behind a scalable application.
Ability to implement automated unit testing.
Data migration, transformation, and scripting.
Write technical design and partial architectures.
Responsible for effective code review.
Troubleshooting and product bug correction.
Responsible for some feature demos.
Estimation of features and tasks.
Follow and participate to Explorance development standards and guidelines
Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations
Create and maintain data extractions, transformations - ETL
Understanding of fundamental design principles behind a scalable application.
Write technical design and partial architectures.
Troubleshooting production issues and bug correction.
Follow and participate in Explorance development standards and guidelines

Skills and Requirements:

Server-side languages like C#, ASP.NET Core
Strong Microsoft SQL Server development skillset
Knowledge of Graph SQL
Web server technologies like IIS, Node.js
5+ years of MS SQL Server development
Experience using MS BI tools like SSIS and knowledge of Data warehouse design.
Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
Azure SQL experience
Web Application architecture fundamentals
Excellent written and verbal communication
Flexible, team player, get-it-done personality
Ability to work in a rapidly changing environment
Ability to multi-task and context-switch effectively between different activities and teams
Passion for technology and problem-solving

Other Requirements:

Only apply if you are a Chennai (or surroundings) resident that is interested in being part of a vibrant and highly engaged at-the-office culture.

Job tags

Salary