Senior SQL Server/SSIS Dev — PowerShell & AD Pro

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

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.