Description

Lead database development and integration efforts for OT system applications, owning stored procedures, middleware integrations, and data migrations.

This role is on-site.

Responsibilities

• Develop and maintain stored procedures, triggers, and database scripts using PL/SQL and SQL.
• Manage middleware integrations between OT systems and enterprise platforms like GIS, MWFM, and ADMS using Software AG webMethods.
• Lead technical upgrades, data migrations, and implementation projects while coordinating with vendors and stakeholders.
• Monitor and maintain Oracle 19C, SQL Server, and MySQL database environments, including patching and cybersecurity compliance.
• Document technical workflows and support after-hours troubleshooting for critical integrations.

Required Skills

• 5+ years of experience in database development and management.
• Expertise in Oracle 19C, including XQuery, packages, procedures, triggers, and queries.
• Proficiency in SQL, PL/SQL, MySQL, and SSRS.
• Experience with Software AG webMethods 10.x or later.
• Strong understanding of APIs (REST/SOAP), messaging systems, and data transformation (XML, JSON, XSD).
• Proficiency with the Microsoft .NET Framework (including WPF) and Microsoft Visual Studio.
• Working knowledge of Linux basic commands.
• Experience working with OT systems such as ADMS, Intergraph, or ESRI GIS.

Preferred Skills

• Experience with JavaScript, HTML5, CSS, and Python.
• General knowledge of GIS concepts.

Key Skills

Education

Any Gradute