SQL Developer

SmartRecruiters, Inc.; Elk Grove Village (IL); On-site; USD 90,000 - 135,000; Full time

Job summary

SmartRecruiters, Inc. is seeking a senior SQL professional with extensive experience in development, deployment, migration, and upgrades. You will collaborate with global teams across time zones to design robust data solutions and automate processes using MSSQL Server, SSIS, and related tools.

You will drive complex database projects, mentor L2/L3 teams, and coordinate offshore/onshore transitions while delivering high-quality results in a fast-paced environment.

Qualifications

• 10-12 years of experience in SQL development, deployment, migration, and upgrades.
• Strong communication and problem-solving abilities.
• Experience collaborating with global teams and offshore/onshore models.

Responsibilities

• Work with global teams across time zones.
• Lead upgrades of multi-product software platforms.
• Operate in an onshore/offshore model with diverse cultures.
• Lead offshore team from the client site.
• Facilitate transition processes to offshore teams.
• Develop/Enhance database solutions and support utilities.
• Maintain strong time management and organizational skills.
• Lead L2 & L3 support teams.
• Create test scenarios for identified problems.
• Communicate complex ideas clearly in documentation and speech.

Skills

SQL development

Communication skills

Problem solving

Customer interaction

Attention to detail

Team leadership

Agile/Scrum knowledge

Tools

MSSQL Server

SQL Server T-SQL

SSIS

SQL Agent

Job description

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.