* In Person Interview Very long term project; initial PO for 1 year and usually the project goes for 3-5 years with this customer Hybrid; 2 days a week onsite**
Job Description 8+ Years Required Experience
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.
Position Overview
The Enterprise Data Warehouse (EDW) service offered by client 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:
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.
Key Responsibilities
This position researches and coordinates long term EDW strategies with all current and potential users, client 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 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 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.
