Data Warehouse Architect

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.

Requirements

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

Qualifications

• Researches and coordinates long term EDW strategies with all current and potential users, DTMB management and vendor personnel.
• 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.
• Includes vendor communication, trouble reporting, escalated troubleshooting, and release/patch management.
• Provides operating system guidance along with EDW security expertise for the systems as well as advises 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.