Job DescriptionThe state maintains an enterprise data warehouse built on the Teradata ecosystem.
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 10,000 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.
JobDuties- Defines the technical planning, implementation plan, and delivery of the EDW platform services 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 department DBAs and specialists across the enterprise
Requirements8+ 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)
- 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
MinimumEducationLocation- Local candidates ONLY. Candidates must be located in Michigan within 1 hour of Lansing, MI at time of submission.
- Positionis ahybrid schedulewith 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.)
- WorkinghoursMonday-Friday,approximately8:00 a.m. to 4:30 p.m.
AdditionalRequirements- Must be authorizedtowork in the UnitedStates; We are unable to offersponsorships atthis time
- Must undergo a background checkand drugscreening foremployment.
EmploymentTerms- This is a W2 position
- 40 hrs per week
- 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.)
BenefitsWe understand a comprehensive benefits package is crucial toemployment satisfaction. We offer medical, dental and vision coverageoptions for all employees.
