155 applicants

Company

State of Minnesota · 5 hours ago

Data Warehouse Server Administrator - ITS4

Saint Paul, MN

Full-time

Remote

Mid Level

$36.52/hr - $60.24/hr

4+ years exp

Maximize your interview chances

Government Administration

No H1B

Insider Connection @State of Minnesota

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Maintain and optimize the hardware supporting the Data Warehouse.

Test, upgrade, and create macros to support Teradata and Linux hardware.

Provide essential technical assistance to foster optimum server performance and security.

Ensure a seamless transition of ongoing maintenance and technical expertise to business staff by providing optimized hardware and software solutions.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Linux administrationNetworking fundamentalsSQL DDLSQL DMLData warehouse solutionsConfiguration management toolsTeradataETL processesCustomer service skills

Required

Position requires a minimum of four (4) years of experience Implementing database, data warehouse, and/or business intelligence (BI) solutions in an enterprise environment.

Experience in Linux system administration (Ubuntu, Redhat).

Strong knowledge of networking fundamentals (TCP/IP, DNS, HTTP, SSH, VPN).

SQL experience in Data Definition Language (DDL) and Data Manipulation Language (DML).

Optimizing data schema and architecture for best performance.

Ability to deliver effective verbal or written messages that facilitate a mutual understanding on both parties.

Customer service skills that include active listening, empathy, and problem-solving.

Preferred

Two years or more experience with Linux server management.

Two years or more experience with Teradata.

Two years or more experience using SQL (Structured Query Language).

A high degree of creative analytic and problem-solving skills.

Knowledge of health care claims and/or public assistance program eligibility data content and structures.

Experience with modernizing Extract, Transform, Load (ETL) processes – Application Programming Interface (API) and Microsoft Sql Server Integration Services (SSIS).

Good communication skills, with ability to communicate with both technical and non-technical staff.

Benefits

Paid vacation and sick leave

12 paid holidays each year

Low-cost medical, dental, vision, and prescription drug plans

Fertility care, including IVF

Diabetes care

Dental and orthodontic care for adults and children

6 weeks paid leave for parents of newborn or newly adopted children

Pension plan that provides income when you retire (after working at least three years)

Employer paid life insurance to provide support for your family in the event of death

Short-term and long-term disability insurance that can provide income if you are unable to work due to illness or injury

Tax-free expense accounts for health, dental, and dependent care

Resources that provide support and promote physical, emotional, social, and financial well-being

Training, classes, and professional development

Tuition reimbursement

Federal Public Service Loan Forgiveness Program (Some positions may qualify for the Public Service Loan Forgiveness Program. For more information, visit the Federal Student Aid website at studentaid.gov)

Employee Assistance Program (EAP) for work/life support

A voluntary confidential program that helps employees and their families with life challenges that may impact overall health, personal well-being, or job performance

Common sources of stress can be addressed through the EAP: mental health, relationship challenges (personal and work), grief and loss, finances, and legal issues

Daily Living/Convenience Services: Chore services, home repair, trip planning, child/elder care