CT02 Core Infrastructure Services - Senior Systems Engineer

Zenfreed•Lansing, MI

6d•Hybrid

About The Position

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.

Requirements

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.

Responsibilities

Researches and coordinates long term EDW strategies with all current and potential clients, DTMB management and vendor personnel.
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.
Vendor communication, trouble reporting, escalated troubleshooting, and release/patch management.
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.
Responsible for platform performance monitoring and resolving performance issues.
Provides direct technical expertise to agency DBAs and specialists across the enterprise