Database Developer SSIS​/SQL; W2

1 month ago Be among the first 25 applicants

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.

• 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).

• 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.

• Mid-Senior level

• Contract

• Information Technology

• IT Services and IT Consulting

Lenexa, KS $85,000.00-$