JAMS Automation Engineer

TechDigital Group; Alpharetta (GA); On-site; USD 80,000 - 100,000; Full time

Job summary

A leading tech firm in Alpharetta is seeking a qualified automation specialist. You will be responsible for creating and managing automation workflows, monitoring database performance, and ensuring optimal reliability of JAMS Scheduler Jobs. The role requires excellent technical skills in Microsoft servers, PowerShell scripting, and experience with Azure SQL databases. The ideal candidate should possess relevant certifications and experience in system orchestration. Competitive salary and growth opportunities are offered.

Qualifications

• Excellent technical skills, including Microsoft Server, PowerShell, and Azure.
• Experience with database management and automation workflows.
• Certifications in Azure or AWS are desirable.

Responsibilities

• Develop and maintain PowerShell scripts for automation.
• Create and manage a dynamic inventory of JAMS Scheduler Jobs.
• Monitor database performance and reliability.
• Collaborate with application teams to develop automation workflows.
• Troubleshoot and resolve automation errors.

Skills

Microsoft Operating systems 2012-2019

PowerShell scripting

Microsoft SQL Server 2012-2025

Microsoft Azure

JAMS Enterprise Manager

Azure SQL databases

Maia DB

PostgreSQL

Cosmos DB

MongoDB

Elastic job Agent

System Center Orchestrator

Job description

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