Oracle DBA / Spatial Engineer

The Oracle DBA / Spatial Engineer owns the database layer of the TMS contract: Oracle 19c administration, Oracle Spatial geometry maintenance, PL/SQL development and troubleshooting, nightly refresh execution, and integration between the ArcGIS layer and the Oracle data model. The TMS database is massive - 3,026 tables, 3,831 indexes, 163 packages, 123 procedures, 94 triggers, 80 jobs - and the 4-million-plus media item repository depends on Oracle performance and availability. This individual is the production-database escalation point for all TMS teams., · 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

· 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, · Experience with ESRI ArcGIS integration with Oracle Spatial (ArcSDE or direct Oracle Spatial connection)

· Experience with SQL Developer 23.1 and Oracle SQL Server Management tooling

· Familiarity with nightly batch processing architecture in an Oracle environment

· Minimum 1 year of experience with transportation-related applications (§2.2.3)

· Oracle Database Administrator Certified Professional (OCP) credential

· Experience with Crystal Reports connecting to Oracle data sources

· Missouri residency or St. Louis metro area location.

CEdge has an opportunity for a Oracle DBA / Spatial Engineer , located in Saint Louis, MO (remote/on-site when required). If you are ready to work alongside World Renowned Technology experts, and carry the skills below, this is the opportunity that will inevitably take your career to unbelievable levels!