Teradata AdminDeveloper
Job Location:
Job Location:
Lansing, IL - USA
Monthly Salary:
Not Disclosed
Monthly Salary:
Posted on:
7 days ago
Posted on:
Vacancies:
1 Vacancy
Vacancies:
Job Summary
Client: State of MI
Job ID: 160228
Job Title: Lansing MI - IT - CTO - CT02 Core Infrastructure Services - N/A - Data Warehouse Architect 3
Job Title: Data Warehouse Architect 3
Job Location: 515 Westshire Dr Lansing MI 48917
Projected Start Date: 07/21/2026
Projected End Date/Duration: 1 Years from projected start date with a possibility of extension based on performance and business needed
Interview Process: Virtual Interview via MS Teams video. Please use laptop and be prepared to share screen if asked.
Hybrid: Resource will be working a hybrid schedule. NO REMOTE ONLY OPTION. Will need to be onsite from day 1 two days a week. (Required onsite days are currently Tuesdays and Wednesdays but this is subject to change.)
Local candidates ONLY. Candidates must be located in Michigan within 1 hour of Lansing MI at time of submission.
Clear and concise written and verbal communication is crucial to success and productivity in this role.
The following are required for bid submission:
- Resume
- R2R
- Meets Work Location
- Cover Sheet
Job Description
- The state maintains an enterprise data warehouse built on the Teradata ecosystem. Below is a list of services; however this list is not exhaustive.
- 8 years required for the following:
- 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)
- 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 Enterprise Data Warehouse (EDW) service offered by DTMB provides customers with the ability to conduct high performance analytics data mining activities and enhanced decision support capabilities. Currently the EDW service employs Teradata technology.
- This position will serve as a platform administrator for the EDW consisting of 3 distinct platforms (Production Development/Disaster Recovery and Test). The EDW provides enterprise data warehousing services to executive branch department as well as the State Court Administrator Offices statewide. A total of 7 departments are supported with a user base of over 10000 and 40 Terabytes of data. This position researches and coordinates long term EDW strategies with all current and potential users DTMB management and vendor personnel. This position defines the technical planning implementation plan and delivery of the EDW platform services 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 department DBAs and specialists across the enterprise.
