SQL Developer

ReqRoute,Inc; Raleigh (NC); On-site; USD 90,000 - 130,000; Full time

Job summary

ReqRoute,Inc in Raleigh, NC is seeking a SQL Server developer with 5-7+ years of experience to design, develop, and maintain ETL processes using SSIS, T-SQL, and PowerShell.

The role emphasizes data integrity, security, and collaboration with infrastructure, application, and security teams, with on-site requirements.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field.
• 5-7+ years of experience in SQL Server development and SSIS.
• Proficiency in T-SQL, including query optimization and stored procedures.
• Solid experience in writing and maintaining PowerShell scripts.
• Working knowledge of Active Directory, including user/group management and LDAP queries.
• Experience with job scheduling, error handling, and ETL best practices.

Responsibilities

• Design, develop, and deploy SSIS packages for ETL workflows and data integration.
• Write and optimize complex T-SQL queries, stored procedures, functions, and views.
• Develop and maintain PowerShell scripts to automate database tasks, file transfers, user provisioning, and system maintenance.
• Integrate data processes with Active Directory for authentication, group membership checks, and access management. Troubleshoot and resolve issues with SSIS packages, SQL Server jobs, and automation scripts.
• Ensure data integrity, security, and compliance with enterprise policies.
• Collaborate with cross-functional teams including infrastructure, application, and security teams.
• Monitor and tune database performance; analyze and optimize long-running queries and jobs.

Skills

SQL Server

SSIS

T-SQL

PowerShell

Active Directory

ETL

Education

Bachelor's degree in Computer Science/Information Systems or related field

Tools

Azure DevOps

Git

Job description

Job Description: Local to Raleigh NC only!

Experience Required: 8-10

Role Descriptions:

Key Responsibilities:

• Design, develop, and deploy SSIS packages for ETL workflows and data integration.
• Write and optimize complex T-SQL queries, stored procedures, functions, and views.
• Develop and maintain PowerShell scripts to automate database tasks, file transfers, user provisioning, and system maintenance.
• Integrate data processes with Active Directory for authentication, group membership checks, and access management. Troubleshoot and resolve issues with SSIS packages, SQL Server jobs, and automation scripts.
• Ensure data integrity, security, and compliance with enterprise policies.
• Collaborate with cross-functional teams including infrastructure, application, and security teams.
• Monitor and tune database performance; analyze and optimize long-running queries and jobs.

Required Qualifications:

• Bachelors degree in Computer Science, Information Systems, or related field.
• 5-7+ years of experience in SQL Server development and SSIS.
• Proficiency in T-SQL, including query optimization and stored procedures.
• Solid experience in writing and maintaining PowerShell scripts.
• Working knowledge of Active Directory, including user/group management and LDAP queries.
• Experience with job scheduling, error handling, and ETL best practices.

Preferred Skills:

• Familiarity with SSRS or ETL solutions.
• Experience with access provisioning or Active Directory automation via PowerShell.
• Understanding of DevOps tools (e.g., Azure DevOps, Git) and Agile methodologies.

Desirable Skills:

• API Programming

Keyword: ~Java springboot Developer~

Skills: PL/SQL~SQL Server 2012 Integration Services (SSIS)