Senior Systems Engineer

Job Title: Senior Systems Engineer
Location: Lansing, MI (Hybrid - 2 days a week - Tues/Wed required onsite)
Duration: 1 year Contract with possible extension

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.
3+ years required for each of the below:

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

Overview:

• The Data Warehouse Service offered by the client 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.

 
Position Summary:

• 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 Client's Offices statewide.

 
Scope & Environment:

• A total of 7 agencies are supported, with a user base of over 10,000 internal and external clients and 40 Terabytes of data.

 
Key Responsibilities:

• Researches and coordinates long term EDW strategies with all current and potential clients, client management and vendor personnel.
• Defines the technical planning, implementation plan, and delivery of the EDW platform service and supporting technologies to meet the Client’s business requirements and objectives.
• 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.
• 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 agency DBAs and specialists across the enterprise.