DATABASE PROGRAMMER ANALYST-REMOTE

University of Missouri-Columbia; Columbia Township (MO); Sur place; USD 54 000 - 72 000; Plein temps

Résumé du poste

The University of Missouri-Columbia's Division of IT seeks a Database Programmer Analyst to develop, configure, and support the Enterprise Service Management platform, focusing on TeamDynamix.

You will design, implement, and maintain integrations, dashboards, reports, and workflows, collaborating with campus IT pros, application owners, vendors, and departments to ensure secure, scalable services. This role participates in on-call rotations to support availability and reliability.

Qualifications

• Experience administering enterprise applications and service management concepts.
• Knowledge of API-based integrations and iPaaS concepts.
• Proficiency with web technologies and data formats (HTML, CSS, JavaScript, JSON, XML, REST, SQL).
• Understanding of security, access control, and data protection.
• Experience in development lifecycle: design, development, testing, release, and documentation.

Responsabilités

• Develop, configure, and administer TeamDynamix capabilities.
• Design, test, deploy, and maintain iPaaS integrations.
• Analyze requirements and translate into secure, scalable solutions.
• Provide on-call support and maintain platform health.

Connaissances

Enterprise app admin

API integrations

Workflow automation

Security access control

Monitoring and troubleshooting

Documentation and training

Outils

TeamDynamix

Description du poste

Division of IT, Enterprise Service Management Database Programmer Analyst position is responsible for the development, configuration, integration, administration, and operational support of the University of Missouri’s Enterprise Service Management platform. As a member of the Enterprise Service Management development and administration team, this position designs, develops, implements, and maintains technical solutions supporting service management processes for campus IT organizations and University departments.

Primary Responsibilities

Primary responsibilities include the development, configuration, and administration of TeamDynamix capabilities, including the Client Portal, Service Catalog, Ticketing, Asset Management, Knowledge Management, reporting, dashboards, forms, workflows, automation rules, approval processes, notifications, templates, and related platform functionality. The position also designs, develops, tests, deploys, and maintains TeamDynamix iPaaS solutions, including forms, flows, connectors, authentication, data transformations, conditional logic, error handling, and reusable integration components. The position creates and supports integrations between TeamDynamix and University or third‑party systems using APIs, web services, webhooks, vendor‑provided connectors, and other supported technologies to automate processes and exchange, transform, synchronize, and orchestrate data across enterprise applications. The developer works closely with ESM team members, campus IT professionals, application owners, vendors, and departmental stakeholders to analyze business and technical requirements and translate them into secure, scalable, maintainable, and supportable solutions. Responsibilities include identifying opportunities for process improvement and automation, evaluating technical approaches, preparing solution designs, estimating development effort, completing development and configuration, conducting technical testing, coordinating user acceptance testing, implementing approved solutions, facilitating knowledge transfer, and developing technical and end‑user documentation. The position provides ongoing administration and operational support for the Enterprise Service Management environment, including monitoring application, workflow, integration, and overall platform health; analyzing performance; troubleshooting application, authentication, integration, and data‑related issues; correcting defects; and performing routine system maintenance. The developer also supports platform upgrades and releases, maintains technical configurations and documentation, and participates in an on‑call rotation to support the availability and reliability of Enterprise Service Management services. Solutions must appropriately address security, authentication and authorization, data access, accessibility, monitoring, error handling, operational support, and long‑term maintainability. Work is organized using Agile development practices and delivered through established development, testing, change, and release processes. The position requires strong technical problem‑solving and analytical skills, sound technical judgment, effective communication with technical and non‑technical stakeholders, and the ability to independently manage multiple priorities. The developer is expected to take ownership of solutions throughout their lifecycle, from requirements and technical design through development, production implementation, ongoing support, and continuous improvement, while contributing to platform standards and development practices that promote security, reliability, consistency, and maintainability.

Shift

Monday - Friday, 8am - 5pm CST

Minimum Qualifications

• Working knowledge of enterprise application administration and service management concepts, including application configuration, user and group administration, roles and permissions, service catalogs, forms, workflows, approvals, notifications, knowledge management, asset management, reporting, and dashboards.
• Working knowledge of application integration, workflow automation, and iPaaS concepts, including APIs, web services, webhooks, connectors, credentials, data transformation, conditional logic, workflow orchestration, error handling, logging, monitoring, and automated data exchange between enterprise systems.
• Working knowledge of common web, application, integration, and data technologies, including HTML, CSS, JavaScript, JSON, XML, REST APIs, relational data structures, SQL or comparable query technologies, and the demonstrated ability to quickly learn technologies required to support assigned enterprise applications.
• Working knowledge of authentication, authorization, application security, and data protection concepts, including role‑based and least‑privilege access, service accounts, API credentials, tokens, secure credential management, data integrity, validation, and appropriate handling of institutional information.
• Working knowledge of application development and support lifecycle practices, including requirements analysis, solution design, configuration and development, version control, testing, debugging, user acceptance testing, change and release management, deployment, production validation, documentation, and ongoing support.
• Demonstrated ability to troubleshoot complex technical issues involving enterprise applications, workflows, integrations, APIs, authentication, permissions, and data; perform root‑cause analysis; and develop secure, scalable, maintainable, and supportable solutions.
• Working knowledge of reporting, monitoring, digital accessibility, and operational support practices, including the ability to interpret reports, dashboards, queries, and logs; monitor application and integration health; and apply accessibility practices to end‑user forms, portals, and application content.
• Effective analytical, organizational, communication, and interpersonal skills, including the ability to gather and translate business requirements into technical solutions, manage multiple priorities, explain technical concepts to varied audiences, develop technical and end‑user documentation, and collaborate effectively across technical and non‑technical teams.
• Ability to independently administer and support enterprise production systems, exercise sound technical judgment, learn new technologies and business processes, and follow established security, development, testing, change, release, documentation, and governance practices.
• Working knowledge of, experience with, or demonstrated ability to quickly learn TeamDynamix administration and development, including platform administration, application configuration, security and permissions, Ticketing, Asset Management, Client Portal, Service Catalog, forms, workflows, reporting, and iPaaS integration and automation capabilities.
• Ability to work effectively in a production support environment and participate in an on‑call rotation, including occasional evening, weekend, or after‑hours work for scheduled maintenance, deployments, upgrades, critical incidents, and restoration of service.
• Knowledge to the development, administration, integration, and support of enterprise solutions.
• Ability to work effectively in a production support environment, prioritize and respond to service interruptions and system failures, troubleshoot complex or time‑sensitive problems, and participate in coordinated incident resolution activities.
• Availability to participate in an on‑call rotation and perform occasional evening, weekend, or after‑hours work as necessary for scheduled maintenance, deployments, upgrades, critical incidents, and restoration of service.
• Incidents, and competing priorities while meeting established deadlines.

Preferred Qualifications

• Experience administering and developing TeamDynamix in an enterprise environment, including Global Administration, application administration, organizational configuration, user and group management, security roles and permissions, and platform governance.
• Experience configuring and supporting TeamDynamix Enterprise Service Management applications and capabilities, including Ticketing, Asset Management, Client Portal, Service Catalog, Knowledge Management, forms, custom attributes, workflows, approvals, notifications, automation, reports, and dashboards.
• Experience designing, developing, testing, deploying, monitoring, and maintaining TeamDynamix iPaaS integrations and automations, including flows, forms, connectors, credentials, data transformations, conditional logic, reusable components, and error handling.
• Experience developing and supporting enterprise application integrations using REST APIs, JSON, web services, webhooks, database connections, and other integration technologies, including authentication, authorization, credential management, and automated data exchange.
• Experience analyzing business and technical requirements and translating them into secure, scalable, maintainable, and supportable solutions, including solution design, development and configuration, testing, user acceptance testing, implementation, documentation, and knowledge transfer.
• Experience administering and supporting enterprise production applications, including monitoring platform, application, workflow, and integration health; analyzing performance; troubleshooting application, authentication, permission, integration, and data issues; performing root‑cause analysis; and resolving production incidents.
• Experience managing the enterprise application solution lifecycle, including platform maintenance and upgrades, testing, change and release management, production validation, documentation, configuration standards, accessibility, security, and continuous improvement.
• Demonstrated ability to serve as a technical resource and platform administrator for Enterprise Service Management solutions, independently manage multiple priorities, exercise sound technical judgment, and collaborate effectively with application owners, IT teams, business stakeholders, vendors, and other technical and non‑technical partners.

Anticipated Hiring Range

Salary Range: $53,976 - $72,000 Commensurate with experience

Grade: GGS 011

University Title: Database Programmer Analyst.

Internal applicants can determine their University title by accessing the Talent Profile tile in myHR.

Sponsorship Information

Employment visa sponsorship is not available for this position.

Benefit Eligibility

This position is eligible for University benefits. As part of your total compensation, the University offers a comprehensive benefits package, including medical, dental and vision plans, retirement, paid time off, short- and long-term disability, paid parental leave, paid caregiver leave, and educational fee discounts for all four UM System campuses. For additional information on University benefits, please visit the Faculty & Staff Benefits website at https://www.umsystem.edu/departments-staff/human-resources/benefits-retirement

Equal Employment Opportunity

The University of Missouri is an Equal Opportunity Employer.

To request ADA accommodations, please call the Director of Accessibility and ADA at 573-884-7278.