Lead Teradata Data Warehouse Platform Administrator

Lansing, IL - USA

Monthly Salary: Not Disclosed

Posted on: 8 hours ago

Vacancies: 1 Vacancy

Job Summary

Lead Teradata Data Warehouse Platform Administrator

Lansing MI Hybrid Only Locals

One Year Contract

Candidates with prior experience working for State Government clients are preferred.

Interview Process: Virtual Interview via MS Teams video. Please use laptop and be prepared to share screen if asked.

Resource will be working a hybrid schedule. Will need to be onsite from day 1 two days a week (Tues/Wed required onsite)

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

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 statewide expert 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 10000 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 Michigans 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.

Lead Teradata Data Warehouse Platform Administrator Lansing MI Hybrid Only Locals One Year Contract Candidates with prior experience working for State Government clients are preferred. Interview Process: Virtual Interview via MS Teams video. Please use laptop and be prepared to share...