Senior Systems Engineer

Overview:

TekWissen is a global workforce management provider headquartered in Ann Arbor, Michigan that offers strategic talent solutions to our clients world-wide. The below Client runs through fifteen executive departments which carry out the day-to-day administration of the federal government. Popular departments like Agriculture and Rural Development, Civil Rights, Environment, Health and Human Services, Natural Resources, Secretary of State. This Client has opportunities in a number of career pathways, including, but not limited to, business and administrative support, education and human services, IT and computers, medical and healthcare, natural resources, law enforcement and public safety, skilled trades and more. With positions in over 18 state departments, your perfect career fit is waiting for you at the client. This client is an Equal Opportunity Employer.

Job Title: Senior Systems Engineer

Location: Lansing, MI 48917

Duration: 12 Months

Job Type: Hybrid

Work Type: Temporary Assignment

Shift: 8.00AM - 5.00 PM

Job Description:

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 client'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.

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.

TekWissen® Group is an equal opportunity employer supporting workforce diversity.