Database Administrator

Database Administrator HYBRID - 3 days ONSITE - Stassney Lane AUSTIN, TX Job Description All resources require a minimum of 5+ years of experience in their specified role. Technical Stack Skills Required by Role All resources require a minimum of 5+ years of experience in their specified role. Technical Stack Category Technologies Database Oracle 19c Backend Stack Java JDK 17 (17.0.17), Spring Boot 3.4.5 (UI and Services), Spring Framework 5.3.26, Hibernate 6.2.5 Frontend Stack Angular 16.2, AgGrid 31.3.2, Bootstrap 5.3.7 Integration REST APIs with JSON payloads, Spring Batch for multi-sheet Excel ingestion, Webhooks, SMTP Development Platform Azure DevOps (branch from TxDOTCONNECT Main); all code remains on TxDOT-controlled hardware & infrastructure Required Skills: Skill Description Oracle Database Development Designing, developing, and maintaining relational databases for backend services Preferred Skills: Skills Description TxDOTCONNECT Experience Prior experience with the TxDOTCONNECT application or TxDOT database conventions Schema Design Designing new tables integrated with existing enterprise schemas, including foreign key relationships across multiple table domains View Design and Performance Tuning Oracle 19c view design and query optimization for aggregation across multiple related tables Audit Column Standardization Applying enterprise audit column patterns (Created By, Created Date, Effective From/To Date, Last Update By, Last Update Date, Logical Delete) consistently across new tables Migration Management Version-controlled migration script development for schema changes in enterprise applications Logical Delete Patterns Understanding of logical delete patterns for preserving audit trails in relational systems Bulk Operation Query Design Query design and optimization for bulk lookup, bulk update, and bulk insert operations supporting batch processing patterns (e.g., Spring Batch chunk-oriented processing) Reference Data Design Experience designing configuration-driven library tables that support runtime business rule evaluation CI/CD Integration Integration of database migration and change management into continuous integration pipelines #J-18808-Ljbffr