Company Description
MSRcosmos is an IT Services subsidiary of the MSRcosmos Group,
A U.S.-based multinational conglomerate. MSRcosmos Group focused on diverse ventures ranging from IT services to real estate and education. Together, both companies believe that business success and serving humanity are symbiotic and strive to excel at both.
Job Description
Job Title: Senior SQL Server Database Engineer – Independent consultants only
Location: Minneapolis, MN - Remote
Type: Fulltime
No CPT/OPT candidates
Primary 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.
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.
Desired:
• 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.
Additional Information
All your information will be kept confidential according to EEO guidelines.
