Oracle DBA & Spatial Engineer — Remote/Onsite

CEdge Inc.; St. Louis (MO); Hybrid; USD 95,000 - 150,000; Full time

Job summary

CEdge Inc. in Saint Louis, MO, seeks an Oracle DBA / Spatial Engineer to own the database layer of the TMS contract, including Oracle 19c administration, Spatial geometry maintenance, and PL/SQL development with ArcGIS integration.

This role requires coordinating with .NET developers, ensuring data quality, and supporting security across a massive production database. MoDOT background check is required.

Qualifications

• Minimum 3 years of Oracle database administration experience.
• Minimum 1 year of experience with Oracle Spatial database (2.2.3)
• Minimum 1 year of PL/SQL development experience (2.2.3)
• Minimum 1 year of experience with location referencing applications and data (2.2.3)
• Experience with Oracle 19c or higher
• Minimum 1 year of experience similar to MoDOT's current computer technical architecture
• Ability to pass MoDOT background check

Responsibilities

• Administer and sustain the TMS Oracle 19c+ production database; perform OS upgrades, patching, and configuration management to maintain security and performance
• Execute and monitor the nightly Travelways refresh; validate changes to Roadway Network Coverage and resend tables to Oracle as required (2.3.9)
• Execute the Travelway Maintenance Interface to apply ArcGIS updates to the Oracle database (2.3.9)
• Develop and maintain PL/SQL packages, procedures, triggers, and functions; resolve PL/SQL-level error and malfunction reports within the 2-business-day SLA
• Maintain Oracle Spatial geometry tables, indexes, and materialized views; support Travelway Associative Maintenance application data quality assurance
• Support the Nightly Refresh System: modify applications, packages, procedures, and views as needed; maintain database trigger objects; execute annual History and Safety updates (2.3.11)
• Perform data quality and integrity checks; maintain production data accuracy as required by TMS management activities
• Run security code scans against database-layer objects; remediate High-Threat vulnerabilities within 10 business days (2.3.7)
• Document all maintenance performed in Technical Records; maintain engineering notebooks for database changes and PL/SQL modifications
• Coordinate with .NET developers on data-model changes: provide impact analysis on dependent TMS applications before any structural database change

Skills

Oracle DBA

Oracle Spatial

PL/SQL development

Location referencing data

Oracle 19c+

Education

Oracle DBA Certification (OCP)

Tools

SQL Developer 23.1

ArcGIS/ArcSDE integration

Crystal Reports

Oracle SQL Server Management tooling

Job description

CEdge Inc. in Saint Louis, MO, seeks an Oracle DBA / Spatial Engineer to own the database layer of the TMS contract, including Oracle 19c administration, Spatial geometry maintenance, and PL/SQL development with ArcGIS integration.

This role requires coordinating with .NET developers, ensuring data quality, and supporting security across a massive production database. MoDOT background check is required.