Breakthrough

Description: Why Mayo Clinic
Mayo Clinic is the nation's best hospital (U.S. News & World Report, 2021-2022) and ranked #1 in more specialties than any other care provider. We have a vast array of opportunities ranging from Nursing, Clinical, to Finance, IT, Administrative, Research and Support Services to name a few. Across all locations, you’ll find career opportunities that support diversity, equity and inclusion. At Mayo Clinic, we invest in you with opportunities for growth and development and our benefits and compensation package are highly competitive. We invite you to be a part of our team where you’ll discover a culture of teamwork, professionalism, mutual respect, and most importantly, a life-changing career!

Mayo Clinic offers a variety of employee benefits. For additional information please visit Mayo Clinic Benefits. Eligibility may vary.

Position description
The ODS Services unit within the Data Delivery Services section has an opening for a Data Warehouse DBA to provide support for the Administrative Data Warehouse (ADW). The ADW contains INFOR ERP data and related ancillary system data and is used for a wide variety of enterprise wide operational and strategic reporting and analytical purposes. The ADW is a large Microsoft SQL Server environment comprised of multiple database servers and databases, ETL code and processes, data marts, OLAP cubes, Business Objects universes, and .Net applications. Responsibilities of this position include working with a team of DBAs, data integration specialists, and data delivery specialists in the ongoing development, implementation, and support of the existing SQL Server data warehouse. This also includes efforts related to the ongoing Harwick project to transition to Oracle ERP. The successful candidate will support custom data driven processes that control database backup and recovery operations, optimizations, ETL, and data presentation. The individual will also be responsible for schema migrations, database space and file management, performance monitoring and tuning, database security administration, database refreshes, and job automation. Participation in a formal 24x7 oncall rotation is required. The successful candidate must commit to meeting challenging deadlines and priorities, including working off-hours occasionally as needed, must function as part of a highly skilled technical team, be self-directed, and must exercise sound judgment when making decisions that could have large impacts on rigorous service level requirements.

Qualifications
Bachelor's degree and 5 years' experience including 3 years' of demonstrated technical experience and 1 year of demonstrated leadership experience; Or, Associate's degree and 9 years' experience including 3 years' of demonstrated technical experience.

Authorization to work and remain in the United States, without necessity for Mayo Clinic sponsorship now, or in the future (for example, be a U.S. Citizen, national, or permanent resident, refugee, or asylee). Also, Mayo Clinic does not participate in the F-1 STEM OPT extension program.

Additional qualifications
Capable of moving among work areas and willing to do so. Demonstrated project and deliverable consistency through repeatable and reliable performance. Proven evidence of project management skills. Demonstrated oral and written communication, organization, problem solving, and facilitation skills. Evidence of mastery level expertise in one computing technology. Demonstrated ability in solving complex technical problems with multiple computing technologies. Experience working in healthcare technology. Exposure to managing both custom developed and vendor-supplied applications. Master’s degree in applicable field preferred.

• Technical experience in database design, development, implementation, and support is preferred.
• Direct experience working with recent versions of SQL Server and supporting large SQL Server data warehousing production environment with rigorous service level agreements is preferred.

Exemption status
Exempt

Compensation Detail
$102,211.20 - $152,464.00/ year

Benefits eligible
Yes

Schedule
Full Time

Hours / Pay period
80

Schedule details
M-F 8am - 5pm with rotational 24x7 on call

Weekend schedule
24x7 rotational on-call

Remote
Yes

International Assignment
No

Site description
Mayo Clinic is located in the heart of downtown Rochester, Minnesota, a vibrant, friendly city that provides a highly livable environment for more than 34,000 Mayo staff and students. The city is consistently ranked among the best places to live in the United States because of its affordable cost of living, healthy lifestyle, excellent school systems and exceptionally high quality of life.

Recruiter
Miranda Grabner

EOE
As an Affirmative Action and Equal Opportunity Employer Mayo Clinic is committed to creating an inclusive environment that values the diversity of its employees and does not discriminate against any employee or candidate. Women, minorities, veterans, people from the LGBTQ communities and people with disabilities are strongly encouraged to apply to join our teams. Reasonable accommodations to access job openings or to apply for a job are available.