Database Developer SSIS / SQL (W2)

Job Description :

Role : Database Developer

Location : Lenexa, KS

The Data Platforms team within the Data, CRM & Integration department urgently seeks a skilled Database Developer to join our client's Lenexa office. This 3 6-month contract role, with potential for extension, focuses on maintaining and enhancing critical data systems. The ideal candidate will have 7+ years of experience and must work on-site in Lenexa.

Key Responsibilities :

Develop, maintain, and enhance SSIS jobs and SQL stored procedures.

Manage and update database schemas for on-premises SQL Server Data Warehouse and Azure-based Data Marts.

Monitor overnight jobs, troubleshoot, and resolve issues promptly.

Perform DBA tasks, including performance management, patching, and application upgrades for the Data Warehouse and OLTP SQL Server databases.

Optionally, contribute to SSRS Reports and Power BI development (preferred but not required).

Core Requirements :

7+ years of experience as a Database Developer.

Expertise in Microsoft SQL Server, SSIS, and SQL.

Experience maintaining database schemas and monitoring data processes.

Strong problem-solving skills and ability to work on-site in Lenexa.

DBA experience with SQL Server performance management, patching, and upgrades.

Familiarity with SSRS Reports and Power BI (optional).

• Deep SSIS experience (hands-on ETL build + production troubleshooting of inherited code).
• Strong T-SQL for ETL purposes (SPs, views, debugging data issues).
• Production problem-solving mindset; can diagnose file / ingest / timing / data quality issues quickly.
• Comfortable with SQL Agent job orchestration and job failure triage.
• On-site in Lenexa (local or able to relocate immediately ). Overnight on-call every other week for troubleshooting.
• Communication : Can clarify requirements with managers, ask the right questions, and give crisp status.
• Production DBA experience with database backups & recovery, performance tuning, monitoring, and some basic knowledge of infrastructure operations related to a DBA function such as storage and networking.