What are the responsibilities and job description for the Database Developer position at Pioneer Consulting Services LLC?
Job Details
Job Title: Database Developer
Location: Lenexa, KS - Onsite
Duration: Long Term Contract
Work Mode: Onsite
Job Description:
The Data Platforms team within the Data, CRM & Integration department urgently seeks a skilled Database Developer to join our client’s office. This is a 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.
Must-Haves
- 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.
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).
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.