Snowrelic Inc ยท 3 months ago
Database Developer SSIS/SQL (W2)
Snowrelic Inc is seeking a skilled Database Developer to join their Data Platforms team in Lenexa, KS. This role focuses on maintaining and enhancing critical data systems, including developing SSIS jobs and managing SQL Server databases.
Cloud ComputingInformation TechnologySoftware Engineering
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)
Qualification
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
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
Preferred
Familiarity with SSRS Reports and Power BI
Company
Snowrelic Inc
Snowrelic Inc was founded by technology professionals with a vision to provide quality and cost-effective Modern IT solutions.
H1B Sponsorship
Snowrelic Inc has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (2)
2024 (5)
2023 (10)
2022 (3)
Funding
Current Stage
Early StageCompany data provided by crunchbase