SQL Developer

ReqRoute View all jobs

Raleigh, NC, United States

2 days ago

Apply on www.careerjet.com

Prepare application

Role details

Contract type

Temporary to permanent

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

5 years minimum

Compensation

$104,000.0 - $110,240.0

Working hours

Regular working hours

Job source

www.careerjet.com

Tech stack

Active Directory Application Programming Interfaces (APIs) Agile Methodology Automation of Tests Microsoft Azure Information Systems Computer Programming Databases Data Integration Data Integrity Extract Transform Load (ETL) DevOps

+17 more

Job Scheduling Lightweight Directory Access Protocols (LDAP) Microsoft SQL Server Windows PowerShell Query Optimization SQL Stored Procedures PL-SQL SQL Databases SQL Server Reporting Services SQL Server Integration Services Systems Integration Transact-SQL User Provisioning Software Spring-boot Database Performance Git Information Technology

Job description

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.

Requirements

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)