Programmer, IT​/Tech, Database Administrator

1 day ago Be among the first 25 applicants

Get AI-powered advice on this job and more exclusive features.

• The position is responsible for providing ongoing maintenance and support for the Master Person Index (MPI), Michigan Index Data Stewardship Portal, and Symmetry applications supported within our department.
• These applications are part of the Date Warehouse / MPI program area.
• The resource is integral to supporting and improving MDHHS automated processes, streamlining critical business processes, data integrity, SEM/SUITE compliance, and securing the applications.
• As a lead, the resource participates in a variety of assignments that provide for the enhancement, integration, maintenance, and analysis of the Master Person Index and its integration with other teams.
• Not having a resource on staff will delay ongoing and future project work within the area and lead to DTMB inability to deliver on prioritized enhancements and maintenance from MPI to all major applications (Bridges, Mi Integrate, HESB in MDHHS).

• Write high level functional requirement documents.
• Work in Linux operating systems.
• Develop scripts in Power Shell.
• Work in Git and Git Hub for repositories.
• Work closely with Database Administrators to develop and execute SQL scripts.
• Create monthly reports for MDM applications.
• Work with client for task and ticket resolutions in MPI and MIDSP.
• Work on creating and deploying certificates on Windows and Linux systems.
• Work closely with Infrastructure teams such as the Server team (Linux, Windows) and Network team for maintenance and issue resolution.
• Execute full software development life cycle (SDLC) including gathering requirements and writing functional/technical specifications for complex projects.
• Experience developing prototypes and mockups for user review and approval.
• Exposure to flowcharts, screen layouts and documentation to ensure logical flow of the system requirements.
• Assist with Enterprise Architecture Solution Assessment (EASA), Hosting documents and Firewall Rules.
• Design, develop, and implement test plans and test reports for applications or subsystems.
• Create or collect test data and execute approved tests to determine the accuracy of program logic.
• Assist with UAT Testing, test cases, and post‑implementation testing.
• Provide defect and incident tracking information.
• Assist with implementation of Request for Change (RFC) for application and infrastructure changes.
• Maintain and update system documentation following upgrades.
• Monitor applications in both production and non‑production environments.
• Provide application support for business client applications maintained by DTMB.
• Deliver product and service based on core software development principles.

• 8+ years of software development experience supporting enterprise‑scale systems.
• Strong hands‑on experience with IBM Info Sphere MDM v11.x, including data models, entities, transactions, batch processing, configuration, customization, and troubleshooting.
• Strong understanding of MDM concepts and IBM MDM product capabilities, with the ability to understand, maintain, and enhance an existing MDM implementation built by a third‑party vendor.
• 8+ years of Java/J2EE experience, including Java, JSP, and REST/SOAP services, with strong production troubleshooting skills.
• 5+ years of experience working with Linux/Unix operating systems, including command‑line usage, log analysis, and system‑level troubleshooting.
• Hands‑on experience with Apache Kafka, including topic creation, configuration, producer and consumer development, messaging flow troubleshooting, and understanding of Zookeeper and Kafka.
• Experience with KRaft concepts using Strimzi operator.
• Experience with batch processing using Wild Fly and Kafka.
• Experience working with application servers such as Wild Fly, including deployments, startup, configuration, health checks, and runtime issue resolution.
• Experience integrating Kafka with Wild Fly‑based applications and IBM MDM.
• Proficiency in writing and optimizing SQL queries in Oracle and Microsoft SQL Server environments.
• Strong Linux/Unix shell scripting skills (Bash), including automation and operational…