Senior SQL Server Database Engineer

Summary

Join MSRcosmos, an IT services subsidiary of a U.S.-based multinational conglomerate, as a Senior SQL Server Database Engineer. This full-time, remote position in Minneapolis, MN, is open to independent consultants only. You will develop complex T-SQL stored procedures and queries, manage and enhance ETL solutions using Microsoft SQL Server, and build and support SSIS-based ETL solutions. The role requires strong collaboration with a team of Database Engineers and a focus on performance and reliability. You will be responsible for unit testing, documentation, and providing excellent support for delivered data solutions. No CPT/OPT candidates will be considered.

Requirements

• Robust Transact-SQL development experience, with the ability to tune, re-write or create from scratch complex queries, stored procedures, functions, triggers, views, etc
• Strong SQL Server Integration Services (SSIS) development skills, with a keen understanding of package design, logging, orchestration, etc
• Advanced experience managing and tuning SQL Server performance. A mindset for improving ETL reliability and reliability, as well as performance monitoring, testing and tuning
• Proficiency with database/server performance analysis tools such as Profiler, Performance Monitor, etc
• Focused on delivering results; passionate about writing high-performance, reliable, scalable and maintainable code
• Accurately defines problems, collects data, establishes facts and draws valid conclusions
• Enjoys refining and automating routine, labor-intensive processes
• Collaborates with application developers and other team members to provide database modeling and design that fits very tightly with all tiers of the application
• Excels in a rapid-iteration environment with short turnaround times
• Deals positively with high levels of uncertainty, ambiguity and shifting priorities
• Strong work ethic; accepts a variety of tasks and pitches in where needed, including after-hours, on-call support
• Leads by example, motivating others to consistently perform at their best

Responsibilities

• Develop complex T-SQL stored procedures and other queries, leveraging a strong understanding of real estate data and large-scale databases
• Manage and enhance ETL solutions using Microsoft SQL Server that precisely and efficiently meet business requirements and align with large, complex real estate data sets
• Build and support SSIS-based ETL solutions that are reliable, restart able, performant, accurate, easily managed and monitored, and efficiently use server resources
• Apply a performance mindset to every new and existing function. Integrate deep instrumentation in every feature, to aid in troubleshooting and performance monitoring
• Produce high-quality, properly functioning deliverables within specified deadlines
• Work collaboratively with a team of Database Engineers to transform requirements into solutions that meet business objectives efficiently and effectively
• Estimate tasks with granularity and accuracy. Clearly communicate and document progress on work items
• Perform unit testing and write documentation to improve maintainability and knowledge transfer
• Provide excellent support for delivered data solutions and help support other teams/departments when needed: end-to-end problem resolution

Preferred Qualifications

• Experience with Visual Studio/GIT or similar source control repository
• Experience with database performance monitoring tools such as SolarWinds Database Performance Analyzer (DPA/Ignite), QueryStore, etc