Mayo Clinic is looking for a IT Tech Specialist I 100% Remote 1 year contract.

Job Location:  Off-Site (MN), Technology Drive Center, 3434 Technology Drive NW Rochester, Minnesota 55902

Virtual interviews. The position sits remotely.

Core hours are 8 AM - 5PM.

Pay Range: $376hr daily rate ($37hr) W2

Submit DOB of last 4 of SSN.

Interview Notes: This is for the Harwick project. This person will manage the servers the application database warehouse sits on.

Candidate must have MS SQL Server. Large multiple database administration. Must understand ETL code and processes, data marts, OLAP Cubes, Business Object Universes, and .Net applications.

Please refer to the job description attached.

Job 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.

Basic Qualifications:

A bachelor’s degree and at least 3 years of professional technical experience in database design, development, implementation, and support; or an associate’s degree and at least 5 years of professional technical experience in database design, development, implementation, and support; or at least 7 years of professional technical experience in database design, development, implementation, and support.

Other Qualifications:

A bachelor’s degree in Computer Science or related field is preferred.  Demonstrated experience providing comprehensive database support is required.  Direct experience working with recent versions of SQL Server is preferred.  Experience supporting large SQL Server data warehousing production environment with rigorous service level agreements is preferred.  Strong problem solving, teamwork, customer service, and communication skills are required.

Hi Team,

Mayo Clinic is looking for a IT Tech Specialist I 100% Remote 1 year contract.

Job Location:  Off-Site (MN), Technology Drive Center, 3434 Technology Drive NW Rochester, Minnesota 55902

Virtual interviews. The position sits remotely. 

Core hours are 8 AM - 5PM.

Pay Range: $400hr daily rate ($50hr) W2

Submit DOB of last 4 of SSN.

Interview Notes: This is for the Harwick project. This person will manage the servers the application database warehouse sits on. 
Candidate must have MS SQL Server. Large multiple database administration. Must understand ETL code and processes, data marts, OLAP Cubes, Business Object Universes, and .Net applications. 

Please refer to the job description attached. 

Job 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.

Basic Qualifications:
A bachelor’s degree and at least 3 years of professional technical experience in database design, development, implementation, and support; or an associate’s degree and at least 5 years of professional technical experience in database design, development, implementation, and support; or at least 7 years of professional technical experience in database design, development, implementation, and support.

Other Qualifications:
A bachelor’s degree in Computer Science or related field is preferred.  Demonstrated experience providing comprehensive database support is required.  Direct experience working with recent versions of SQL Server is preferred.  Experience supporting large SQL Server data warehousing production environment with rigorous service level agreements is preferred.  Strong problem solving, teamwork, customer service, and communication skills are required.

Required Skills:  
CUSTOMER SERVICE
DATA INTEGRATION
DATA WAREHOUSE
Additional Skills: 
DATA WAREHOUSING
DATABASE
DATABASE DESIGN
ERP
ETL
FILE MANAGEMENT
INTEGRATION
MIGRATIONS
OPERATIONS
ORACLE
PROBLEM SOLVING
PRODUCTION ENVIRONMENT
SECURITY ADMINISTRATION
SELF-DIRECTED
SERVICE LEVEL AGREEMENTS
SQL
SQL SERVER
.NET
CUSTOMER SERVICE ORIENTED
DATABASES
DTD
INTEGRATOR
MICROSOFT SQL SERVER
MS SQL SERVER
OLAP
ONLINE ANALYTICAL PROCESSING
OPERATIONAL DATA STORE