Senior SQL Server / SSIS Developer – PowerShell & Active Directory – Raleigh NC

Tech Mirrors; Raleigh (NC); On-site; USD 83,000 - 124,000; Full time

Job summary

Tech Mirrors in Raleigh, NC is seeking a Senior SQL Server / SSIS Developer to design, develop, and deploy ETL pipelines. You will write complex T-SQL, optimize queries, and automate tasks with PowerShell while integrating authentication and access checks through Active Directory.

The role emphasizes data integrity, security, and collaboration with infrastructure, application, and security teams. Onsite contract position with focus on performance tuning.

Qualifications

• Bachelor’s degree in CS or related field required.
• 5–7+ years in SQL Server development and SSIS.
• Proficient in T-SQL with optimization skills.
• Solid PowerShell scripting experience.
• Working knowledge of Active Directory and LDAP.
• Experience with scheduling, error handling, ETL best practices.

Responsibilities

• Design, develop, and deploy SSIS packages for ETL workflows.
• Write and optimize complex T-SQL queries, stored procedures, and views.
• Develop and maintain PowerShell scripts for automation.
• Integrate data processes with Active Directory for auth and provisioning.
• Troubleshoot SSIS packages, SQL jobs, and automation scripts.
• Ensure data integrity, security, and regulatory compliance.
• Collaborate with infrastructure, application, and security teams.
• Monitor and tune database performance and long-running queries.

Skills

SSIS

T-SQL

PowerShell

Active Directory

ETL

SQL Server

Education

Bachelor's degree in Computer Science or related field

Tools

Azure DevOps

Git

Job description

Position: Senior SQL Server / SSIS Developer – PowerShell & Active Directory

Location: Raleigh NC (Onsite) –Locals ONLY

Duration: 6+ Months Contract

Job Description

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

• 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.

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) Experience Required: 8-10

Education:At least a bachelor’s degree (or equivalent experience) in Computer Science, Software/Electronics Engineering, Information Systems, or closely related field is required.