Must have skills
• Excellent technical skills including however not limited to Microsoft Operating systems server 2012-2019 including PowerShell scripting, Microsoft SQL Server 2012-2025, Microsoft Azure including Logic Apps, JSON Scripting, REST API, Azure Cloud Databases.
• Experience with JAMS Enterprise Manager is highly desirable and preferable.
• Experience with Azure SQL databases i.e., Maia DB, PostgreSQL, Cosmos DB, MongoDB required
RESPONSIBILITIES
• Develop, test and validate PowerShell scripts as part of automation workflows and maintain in source control for change management.
• Create and Maintain a Dynamic Inventory of all JAMS Scheduler Jobs.
• Monitor, manage, and maintain databases to ensure optimal performance and reliability.
• Create and monitor Azure SQL Elastic Jobs for automated database tasks.
• Create and maintain a JAMS incident tracker for logging dates and times of all warnings and errors from JAMS Scheduler Jobs as well as escalation and fix details.
• Proactively review and monitor the health of all JAMS Jobs i.e. daily reviewing output of all jobs.
• Review job failures and take corrective action where possible or escalate to Job owner as necessary.
• Log Service Desk ticket (incident) for all JAMS Scheduler Job failures, provide resolution in collaboration with job owner and maintain incident resolution log\ knowledge base.
• Installation of JAMS Client tools, JAMS software updates and\or reporting tools.
• Liaise with JAMS account representative and Sompo procurement in relation to JAMS Scheduler annual support License renewals.
• Participate in IT projects, responsible for development of automation workflows outlined in the Project Plan and directed by the Project Manager, at whatever level of effort or participation has been defined for them.
• Build, administer, monitor and maintain JAMS Enterprise Scheduler and System Center Orchestrator environments.
• Work with Application team members to evaluate automation workflow needs and requirements.
• Develop integrations between infrastructure systems for data analysis and reporting through REST API calls.
• Maintain JAMS platform, standard operating procedures, perform changes, apply patches, and updates as required.
• Prevent, diagnose, troubleshoot, and resolve automation runbook errors.
TECHNICAL QUALIFICATIONS
• Excellent technical skills including however not limited to Microsoft Operating systems server 2012-2019 including PowerShell scripting, Microsoft SQL Server 2012-2025, Microsoft Azure including Logic Apps, JSON Scripting, REST API, Azure Cloud Databases.
• Azure or AWS Certification is desirable.
• Experience with Azure SQL databases i.e., Maia DB, PostgreSQL, Cosmos DB, MongoDB required.
• Experience with JAMS Enterprise Manager is highly desirable and preferable.
• Experience with Elastic job Agent for Azure SQL Databases preferable.
• Experience with System Center Orchestrator 2012 or later preferred.