Senior Systems Engineer

HighCloud Solutions; Lansing (MI); Hybrid; USD 80,000 - 100,000; Full time

Job summary

A data solutions provider seeks a platform administrator for the Enterprise Data Warehouse (EDW) in Lansing, MI. This hybrid role requires at least 3 years of experience with Teradata tools, performance tuning, and scripting in BASH, Perl, and Python. The administrator will manage multiple platforms, coordinate strategies with agencies, and ensure optimal performance across the system. An understanding of cloud computing and network fundamentals, especially MS Azure, is highly valued. Join a dynamic team dedicated to enhancing data services for executive branch agencies.

Qualifications

• 3+ years of experience with upgrades, provisioning, and software maintenance.
• Experience with Teradata workload management and performance tuning.
• Knowledge in cloud computing and networking, preferably MS Azure.

Responsibilities

• Serve as platform administrator for the Enterprise Data Warehouse (EDW).
• Coordinate long-term EDW strategies with clients and management.
• Define technical planning and implementation for EDW services.

Skills

BASH scripting

Perl scripting

Python scripting

Teradata workload management

Performance tuning

ETL

Cloud computing fundamentals

Networking

Statistics

Security plans

Tools

Teradata Tools and Utilities (TTU)

MS Azure

Job description

Location: Lansing, MI (Hybrid Locals Only)

Duration: 12 Months

The state maintains an enterprise data warehouse built on the Teradata ecosystem. Below is a list of services; however, this list is not exhaustive.

3+ years required for each of the below:

• Upgrades, provisioning, software maintenance, scripting - BASH, Perl, Python, Glink
• Teradata Tools and Utilities (TTU)
• Teradata workload management
• Performance tuning and resource optimization
• Extract Transform Load (ETL)
• Firewall knowledge
• Cloud computing fundamentals, resource allocation, networking, preferably MS Azure
• Statistics
• Audits & security plans
• The Data Warehouse Service offered by DTMB provides customers the ability to conduct high performance analytics, data mining activities, and enhanced decision support capabilities.
• Currently, the Data Warehouse Service employs Teradata technology.
• This position will serve as a platform administrator for the Enterprise Data Warehouse (EDW), consisting of 3 distinct platforms (Production, Test and Development/Disaster Recovery).
• The EDW provides Enterprise Data Warehousing services to executive branch agencies as well as the State Court Administrator Offices statewide.
• A total of 7 agencies are supported, with a user base of over 10,000 internal and external clients and 40 Terabytes of data.
• This position researches and coordinates long term EDW strategies with all current and potential clients, DTMB management and vendor personnel.
• This position defines the technical planning, implementation plan, and delivery of the EDW platform service and supporting technologies to meet the State of Michigan’s business requirements and objectives.
• This includes vendor communication, trouble reporting, escalated troubleshooting, and release/patch management.
• This position is responsible for providing operating system guidance along with EDW security expertise for the systems as well as advising the Agencies on disaster recovery planning strategies related to the EDW and their business applications.
• The position is also responsible for platform performance monitoring and resolving performance issues.
• This position provides direct technical expertise to agency DBAs and specialists across the enterprise.