SQL Server / SSIS Developer

Thunderhawk Technology Partners LLC
  • Raleigh, NC
  • Quick Apply
11 days ago

Job Description

Title: SQL Server / SSIS Developer
Location: Raleigh, NC (Local Candidates Only; Relocation or Non-local will not be considered)
Duration: Long Term


Job Summary
We are seeking an experienced SQL Server / SSIS Developer with strong expertise in SSIS, T-SQL, PowerShell scripting, and Active Directory integration. The ideal candidate will be responsible for designing and supporting enterprise ETL solutions, database development, automation, and system integration while ensuring high performance, security, and data integrity.
Key Responsibilities
  • Design, develop, deploy, and maintain SSIS packages for enterprise ETL and data integration processes.
  • Write, optimize, and troubleshoot complex T-SQL queries, stored procedures, functions, and views.
  • Develop and maintain PowerShell scripts for automation, file transfers, database administration, and user provisioning.
  • Integrate applications and data workflows with Active Directory (AD) for authentication, authorization, and access management.
  • Monitor and optimize SQL Server performance, including query tuning and job optimization.
  • Troubleshoot issues related to SSIS packages, SQL Server jobs, and automation processes.
  • Ensure compliance with enterprise security, governance, and data quality standards.
  • Collaborate with infrastructure, security, and application teams to deliver scalable solutions.
  • Support deployment, maintenance, and continuous improvement of database and ETL environments.
Required Skills
  • 8+ years of experience in SQL Server Development and SSIS.
  • Strong expertise in T-SQL, query optimization, stored procedures, functions, and views.
  • Hands-on experience with SQL Server Integration Services (SSIS).
  • Strong PowerShell scripting experience for automation and administration tasks.
  • Experience with Active Directory, LDAP queries, and user/group management.
  • Knowledge of ETL design, job scheduling, monitoring, and error handling best practices.
  • Strong troubleshooting, analytical, and problem-solving skills.
Preferred Skills
  • Experience with SSRS and enterprise reporting solutions.
  • Active Directory automation and access provisioning experience.
  • Exposure to Azure DevOps, Git, CI/CD, and Agile methodologies.
  • Experience with enterprise data integration and workflow automation.
Nice to Have
  • API integration experience.
  • Knowledge of DevOps practices and cloud-based database solutions.
  • Experience supporting large-scale enterprise data environments.

Numbers & Facts

LocationRaleigh, NC

Skills

  • Access Authorizationunmatched
  • Administrative Skillsunmatched
  • Agile Programming Methodologiesunmatched
  • Analysis Skillsunmatched
  • Application Programming Interface (API)unmatched
  • Applications Securityunmatched
  • Authenticationunmatched
  • Automationunmatched
  • Automation System Developmentunmatched
  • Best Practicesunmatched
  • Cloud Computingunmatched
  • Continuous Deployment/Deliveryunmatched
  • Continuous Improvementunmatched
  • Continuous Integrationunmatched
  • Data Qualityunmatched
  • Database Administrationunmatched
  • Database Extract Transform and Load (ETL)unmatched
  • Database Programmingunmatched
  • DevOpsunmatched
  • Enterprise Data Integrationunmatched
  • Enterprise Protectionunmatched
  • Error Handlingunmatched
  • Gitunmatched
  • Identify Issuesunmatched
  • LDAP (Lightweight Directory Access Protocol)unmatched
  • Maintain Complianceunmatched
  • Microsoft Active Directoryunmatched
  • Microsoft SQL Serverunmatched
  • Microsoft Transact-SQL (T-SQL)unmatched
  • Microsoft Windows Azureunmatched
  • Performance Managementunmatched
  • Performance Tuning/Optimizationunmatched
  • Problem Solving Skillsunmatched
  • Quality Metricsunmatched
  • Query Optimizationunmatched
  • SQL Server Integration Services (SSIS)unmatched
  • SQL Server Reporting Services (SSRS)unmatched
  • Scripting (Scripting Languages)unmatched
  • Security Complianceunmatched
  • Server Programming/Applicationsunmatched
  • Stored Proceduresunmatched
  • System Integration (SI)unmatched
  • Team Lead/Managerunmatched
  • Windows PowerShellunmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder