SoMI - Senior Systems Engineer - 154579

Goodfit; Lansing (MI); On-site; USD 95,000 - 130,000; Full time

Job summary

OCTO is seeking a Senior Systems Engineer to administer the Enterprise Data Warehouse (EDW) across Production, Test and Development/Disaster Recovery environments in Michigan. You will coordinate long-term EDW strategies with agencies, manage vendor communications, and drive delivery of EDW platform services to meet business requirements.

The role requires 3+ years in Teradata platform administration, monitoring, security, and automation, with strong scripting skills and knowledge of cloud

Qualifications

• Teradata database experience and administration across production and development platforms.
• Scripting and automation skills with BASH, Perl and Python for maintenance tasks.
• Teradata Viewpoint, TTU, PSIM administration experience.
• Experience with vendor upgrades and workload management.
• Teradata backup & recovery, performance tuning, and ETL workflows.
• Unix/Linux proficiency, networking basics, and firewall concepts.
• Cloud fundamentals with Azure; understanding of resource allocation.
• Knowledge of security, audits and federal requirements (NIST 800-53, IRS Pub 1075).
• Statistics or data governance awareness is a plus.

Responsibilities

• Serve as platform administrator for Enterprise Data Warehouse (Production, Test, Dev/DR).
• Coordinate long-term EDW strategies with clients, DTMB, and vendors.
• Define technical planning, implementation, and delivery of EDW platforms.
• Handle vendor communication, escalation, and patch management.
• Provide OS guidance and EDW security expertise; advise on disaster recovery.
• Monitor platform performance and resolve performance issues; support DBAs.

Skills

Teradata DB

Scripting (BASH, Perl, Python)

Teradata Viewpoint

TTU

PSIM administration

Vendor upgrades

Workload management

Backup & recovery

Performance tuning

ETL

Unix/Linux

Azure cloud basics

Security & audits

NIST 800-53 / IRS 1075

Networking fundamentals

Job description

OCTO – Senior Systems Engineer

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:

• Teradata database

• Upgrades, provisioning, software maintenance, scripting – BASH, Perl, Python, Glink

• Teradata ecosystem health monitoring

• Teradata node management

• Teradata Viewpoint administration

• Teradata Tools and Utilities (TTU)

• PSIM (Platform Service Intelligent Monitoring) administration

• Teradata vendor upgrades

• Teradata workload management

• Teradata backup & recovery

• Performance tuning and resource optimization

• Extract Transform Load (ETL)

• Firewall knowledge

• Unix/Linux knowledge

• Cloud computing fundamentals, resource allocation, networking, preferably MS Azure

• Statistics

• Audits & security plans

• Federal requirements – NIST 800-53, IRS Pub 1075, SSA, Medicaid, etc.

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.

• 3+ years – Teradata Platform Administration: Teradata database, Teradata node management, Teradata Viewpoint administration, Teradata Tools and Utilities (TTU), Teradata vendor upgrades

• 3+ years – Monitoring & Observability: Teradata ecosystem health monitoring, PSIM (Platform Service Intelligent Monitoring) administration

• 3+ years – Performance & Workload Management: Performance tuning and resource optimization, Teradata workload management

• 3+ years – Teradata backup & recovery

• 3+ years – Automation & Scripting: Upgrades, provisioning, software maintenance, scripting (BASH, Perl, Python, Glink)

• 3+ years – Extract Transform Load (ETL)

• 3+ years – Cloud & Infrastructure: Cloud computing fundamentals, resource allocation, networking, preferably MS Azure, Unix/Linux knowledge, firewall knowledge

• 3+ years – Security & Compliance: Audits & security plans, federal requirements (NIST 800-53, IRS Pub 1075, SSA, Medicaid, etc.)

• 3+ years – Statistics