Oracle Database Administrator

Oracle DBA / Spatial EngineerCEdge has an opportunity for an 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! Clearance Required: None; MoDOT MACHS background check required.POSITION SUMMARYThe 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 RESPONSIBILITIESAdminister and sustain the TMS Oracle 19c+ production database; perform OS upgrades, patching, and configuration management to maintain security and performanceExecute and monitor the nightly Travelways refresh; validate changes to Roadway Network Coverage and resend tables to Oracle as requiredExecute the Travelway Maintenance Interface to apply ArcGIS updates to the Oracle databaseDevelop and maintain PL/SQL packages, procedures, triggers, and functions; resolve PL/SQL-level error and malfunction reports within the 2-business-day SLAMaintain Oracle Spatial geometry tables, indexes, and materialized views; support Travelway Associative Maintenance application data quality assuranceSupport the Nightly Refresh System: modify applications, packages, procedures, and views as needed; maintain database trigger objects; execute annual History and Safety updatesPerform data quality and integrity checks; maintain production data accuracy as required by TMS management activitiesRun security code scans against database-layer objects; remediate High-Threat vulnerabilities within 10 business daysDocument all maintenance performed in Technical Records; maintain engineering notebooks for database changes and PL/SQL modificationsCoordinate with.NET developers on data-model changes: provide impact analysis on dependent TMS applications before any structural database changeREQUIRED QUALIFICATIONSMinimum 3 years of Oracle database administration experienceMinimum 1 year of experience with Oracle Spatial databaseMinimum 1 year of PL/SQL development experienceMinimum 1 year of experience with location referencing applications and dataExperience with Oracle 19c or higherMinimum 1 year of experience similar to MoDOT's current computer technical architectureAbility to pass MoDOT background checkPREFERRED QUALIFICATIONSExperience with ESRI ArcGIS integration with Oracle Spatial (ArcSDE or direct Oracle Spatial connection)Experience with SQL Developer 23.1 and Oracle SQL Server Management toolingFamiliarity with nightly batch processing architecture in an Oracle environmentMinimum 1 year of experience with transportation-related applicationsOracle Database Administrator Certified Professional (OCP) credentialExperience with Crystal Reports connecting to Oracle data sourcesMissouri residency or St. Louis metro area location