OP Consulting Group LLC · 5 hours ago
Teradata Senior Systems Engineer
OP Consulting Group LLC is seeking a Senior Systems Engineer to serve as a statewide expert platform administrator for the Enterprise Data Warehouse (EDW) in Michigan. The role involves coordinating long-term EDW strategies, managing platform performance, and providing technical expertise to agency DBAs and specialists.
ConsultingInformation TechnologyStaffing AgencyTraining
Responsibilities
Interview Process: Virtual Interview via MS Teams video. Please use laptop and be prepared to share screen if asked
Duration: 1 year
Hybrid: 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)
Local candidates ONLY. Must be located within 1-1.5 hours within Lansing, MI at time of submission
This position will serve as a statewide expert platform administrator for the Enterprise Data Warehouse (EDW), consisting of 3 distinct platforms (Production, Test and Development/Disaster Recovery)
This position researches and coordinates long term EDW strategies with all current and potential clients, DTMB management and vendor personnel
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
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 agency DBAs and specialists across the enterprise
Qualification
Required
3+ years required for Teradata database
3+ years required for upgrades, provisioning, software maintenance, scripting - BASH, Perl, Python, Glink
3+ years required for Teradata ecosystem health monitoring
3+ years required for Teradata node management
3+ years required for Teradata Viewpoint administration
3+ years required for Teradata Tools and Utilities (TTU)
3+ years required for PSIM (Platform Service Intelligent Monitoring) administration
3+ years required for Teradata vendor upgrades
3+ years required for Teradata workload management
3+ years required for Teradata backup & recovery
3+ years required for performance tuning and resource optimization
3+ years required for Extract Transform Load (ETL)
3+ years required for firewall knowledge
3+ years required for Unix/Linux knowledge
3+ years required for cloud computing fundamentals, resource allocation, networking, preferably MS Azure
3+ years required for statistics
3+ years required for audits & security plans
3+ years required for federal requirements - NIST 800-53, IRS Pub 1075, SSA, Medicaid, etc