Core Infrastructure Services - Senior Systems Engineer

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.

Job Duties

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

Requirements

3+ years:

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.

Minimum Education

None

Location

Local candidates ONLY. Must be located within 1-1.5 hours within Lansing, MI at time of submission

Position is a hybrid schedule with onsite from day 1, two days a week (Tues/Wed required onsite) NO REMOTE ONLY OPTION

Working hours Monday-Friday, approximately 8:00 a.m. to 5:00 p.m.Additional Requirements

Must be authorized to work in the United States; We are unable to offer sponsorships at this time

Must undergo a background check and drug screening for employment.

Employment Terms

This is a W2 position

40 hrs per week

HYBRID schedule - onsite from day 1, two days a week (Tues/Wed required onsite) NO REMOTE ONLY OPTION

About Zenfreed

At Zenfreed, we are more than an IT company. We bridge the gap between people wanting to do the work they were meant to do and organizations needing the right talent.

We are dedicated to building a diverse, inclusive and authentic workplace, so if you're excited about this role but your past experience doesn't align perfectly with every qualification in the job description, we encourage you to apply anyway. You may be just the right candidate for this or other roles.

Benefits

We understand a comprehensive benefits package is crucial to employment satisfaction. We offer medical, dental and vision coverage options for all employees.