Core Infrastructure Services Data Warehouse Architect 3 #161027

Data Warehouse Architect 3
1 YearsContract with possible extension
Lansing Michigan
Hybrid: Resource will be working a hybrid schedule. NO REMOTE ONLY
OPTION. (Tuesdays and Wednesdays)

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

Required Skills:

PYTHONMS AZURENETWORKINGPERLTERADATAMEDICAIDSTATISTICS