Job Description:
***Crop to Crop resumes are accepted
Location Requirement: - Hybrid: Resource will be working a hybrid schedule. NO REMOTE ONLY OPTION. 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 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)
- 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 with 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). EDW provides Enterprise Data Warehousing services to executive branch agencies as well as the State Court Administrator Offices statewide.
A total of 7 agencies is 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 State of Michigan 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 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.
Required Skills:
- 3+ years - Teradata Platform Administration including the following: Teradata database, Teradata node management, Teradata Viewpoint administration, Teradata Tools and Utilities (TTU), Teradata vendor upgrades
- 3+ years - Monitoring & Observability including the following: Teradata ecosystem health monitoring, PSIM (Platform Service Intelligent Monitoring) administration
- 3+ years - Performance & Workload Management including the following: Performance tuning and resource optimization, Teradata workload management
- 3+ years - Teradata backup & recovery
- 3+ years - Automation & Scripting including the following: Upgrades, provisioning, software maintenance, scripting BASH, Perl, Python, Glink
- 3+ years - Extract Transform Load (ETL)
- 3+ years - Cloud & Infrastructure including the following: Cloud computing fundamentals, resource allocation, networking, preferably MS Azure, Unix/Linux knowledge, Firewall knowledge
- 3+ years - Security & Compliance including the following: Audits & security plans, Federal requirements NIST 800-53, IRS Pub 1075, SSA, Medicaid, etc
- 3+ years - Statistics
Never miss an opportunity! Create an alert based on the job you applied for.
