IO Datasphere, Inc. has been providing project management, software development and IT staff augmentation services to our clients in the Midwest and throughout the U.S. since 1996. We are an approved vendor on contract to provide software development and IT staff augmentation services for the States of Illinois, Michigan, Minnesota, Iowa, and Wisconsin. We also provide these services to businesses, as well as local and county governments, in the Midwest and nationwide.

Our client is looking for a Teradata Systems Engineer. The state maintains an enterprise data warehouse built on the Teradata ecosystem . The Data Warehouse Service offered provides customers 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). The EDW provides Enterprise Data Warehousing services to executive branch agencies as well as the State Court Administrator Offices statewide. A total of 7 agencies are 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,

Tasks

• 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.
• 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.
• Provide direct technical expertise to agency DBAs and specialists across the enterprise.

NOTE: Local candidates ONLY. NO RELOCATION ALLOWED. Must be located within 1-1.5 hours within Lansing, MI at time of submission. 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)

Location: Lansing, MI (Hybrid)

Contract: 1 year

Skills Required:

3+ years in the following:

• Teradata database
• Experience with upgrades, provisioning, software maintenance, scripting BASH, Perl, Python, Glink
• Teradata ecosystem health monitoring
• Experience with Teradata node management
• Experience with Teradata Viewpoint administration
• Experience with Teradata Tools and Utilities (TTU)
• Experience with PSIM (Platform Service Intelligent Monitoring) administration
• Experience with Teradata vendor upgrades
• Experience with Teradata workload management
• Experience with Teradata backup & recovery
• Experience with performance tuning and resource optimization
• Experience with extract Transform Load (ETL)
• Firewall knowledge
• Unix/Linux knowledge
• Experience with cloud computing fundamentals, resource allocation, networking, preferably MS Azure
• Experience with Statistics
• Experience with Audits & security plans
• Experience with Security Federal requirements NIST 800-53, IRS Pub 1075, SSA, Medicaid, etc.

*** Rate depends on experience

*** Candidates authorized to work in the US are encouraged to apply. We can accept H1b, , TN, and other valid work visas for IT. However, we cannot accept OPT or CPT visas at this time.

*** Companies submitting candidates should only submit direct W2 employees for this position.

Please submit your resume by using the "URL" below