ob Title: SQL Developer
Job Location: Elk Grove, IL
Job Duration: Long Term
JOB DESCRIPTION:
EXPERIENCE
10-12 years of experience in a SQL Development, Deployment, Migration and version Upgrades.
Communication and Problem Solving Skills
Interact with customers in a polite, clear and concise manner over the phone, email and chat.
The ability to ask questions that will allow for accurate troubleshooting and problem-solving.
Understand common troubleshooting methods.
Attention to detail and strong interpersonal skills and able to work in fast, paced, high volume environment
Working with clients to identify the existing problems and provide suitable solutions.
TECHNICAL SKILLS
Strong Hands-on experience on MSSQL Server
Demonstrates advanced knowledge and skills in developing data components using: SQL Server T/SQL, SQL stored procedures, views, cursors, complex queries, SSIS and SQL agent jobs.
Creating database triggers, procs, functions and SSIS packages for automation, e.g., automatic email notifications and scheduling jobs
Determines database structural requirements by analyzing, reviewing client requirements and mapping with the existing system.
Extensive Experience in Database Design, Development, Business Intelligence Solutions and Support of Microsoft SQL Server 2016/2014/2012/2008R2/2008
Performance tuning and Optimization using SQL Profiler
RESPONSIBILTIES:
Experience in working with Global teams is a must
Previous experience with upgrades of multi product/module software platforms
Experience working in an onshore offshore model with teams from different time zones and cultures
Experience in leading the offshore team from the client site.
Understanding transition process to offshore team from the client site.
Develops/Enhance database solutions and support coding utilities, responding to user questions, and resolving problems
Strong attention to detail, excellent time management and organizational skills
Experience in Leading L2 & L3 teams
Experience in Creating Test scenarios for the identified problems
Ability to communicate complex ideas verbally and through documentation
Excellent written and verbal skills
Experience of Agile and Scrum methodologies.
Additional Information
All your information will be kept confidential according to EEO guidelines.
Skills Required
- 10-12 years of experience in SQL development, deployment, migration and version upgrades
- Strong hands-on experience with Microsoft SQL Server (MSSQL)
- Advanced T-SQL development including stored procedures, views, cursors and complex queries
- Experience developing SSIS packages and SQL Agent jobs for automation and scheduling
- Experience creating database triggers, functions and stored procedures
- Extensive experience in database design, development and BI solutions across SQL Server 2016/2014/2012/2008R2/2008
- Performance tuning and optimization using SQL Profiler
- Experience working with global teams and in an onshore-offshore model
- Experience leading offshore teams from the client site and understanding transition processes
- Experience leading L2 and L3 support teams
- Experience with upgrades of multi-product/module software platforms
- Ability to create test scenarios, troubleshoot, document solutions and communicate complex ideas clearly
- Experience with Agile and Scrum methodologies
What We Do
Techno Consulting is a leading information technology and services firm specializing in IT consulting, app development, UX design, and cloud services. They deliver custom software and ready-to-use solutions, building tailored systems and multi-industry products to help organizations operate with confidence. Their expertise also encompasses IT recruiting and RPO services, providing scalable digital solutions and high-quality software development across a wide range of industries.
