Senior SQL Server Database Engineer â Independent consultants only
Senior SQL Server Database Engineer â Independent consultants only
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
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.
Remote Work :
Yes
Employment Type :
Full-time
Employment Type
Remote
