Oracle DBA / Spatial Engineer Job id:006

POSITION SUMMARY

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.

KEY 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
• Cooordinat with .NET developers on data-model changes: provide impact analysis on dependent TMS applications before any structural database change

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

PREFERRED QUALIFICATIONS

• 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