Senior SQL Server / SSIS Developer - PowerShell & Active Directory - Raleigh NC
Raleigh, NC • On-site
$90 - $120/hr
Other
This job posting has expired and is no longer accepting applications. Check out similar jobs
Job description
Position:Senior SQL Server / SSIS Developer – PowerShell & Active Directory
#J-18808-LjbffrLocation: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.
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.
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.
Most Popular Senior SQL Server Developer Job Categories
Sql Server Developer
Ms Sql Server Developer
Senior Sql Developer
Senior Sql Database Developer
Sql Server Database Developer
Sr Sql Developer
Sql Server Bi Developer
Sql Server Consultant
Sql Server Dba Developer
Sql Server Architect
Other Helpful Pages Related To Senior SQL Server / SSIS Developer - PowerShell & Active Directory - Raleigh NC
Remote Sql Server Developer Career Research
Frequently asked questions
Q: What skills or qualities help someone succeed as a Senior SQL Server Developer?
A: To succeed as a Senior SQL Server Developer, key technical skills include expertise in database design, query optimization, and performance tuning, as well as proficiency in SQL Server development tools and languages such as T-SQL and PowerShell. Additionally, strong soft skills like effective communication, problem-solving, and leadership abilities are crucial for mentoring junior developers, collaborating with cross-functional teams, and driving project success. By combining these technical and soft skills, a Senior SQL Server Developer can drive business value, lead high-performing teams, and advance their career through strategic decision-making and technical innovation.
Q: What is the career path for a Senior SQL Server Developer?
A: A Senior SQL Server Developer typically progresses through a career path that includes entry-level roles such as Junior Database Developer or SQL Server Developer, followed by mid-level positions like Database Analyst or Senior Database Developer, and ultimately reaches senior roles like Lead Database Developer or Enterprise Database Architect. Key opportunities for skill development and growth in this role include mastering advanced SQL Server features, learning data warehousing and business intelligence tools, and developing expertise in cloud-based database platforms like Azure SQL Database. Long-term career prospects for Senior SQL Server Developers may include transitioning into leadership roles, pursuing specialized certifications like Microsoft Certified: Azure Database Administrator Associate, or exploring adjacent fields like data science or IT management.
