Start Your Search Here

push notification bell

Would you like to receive notifications about Computer and Mathematical Occupations jobs in Austin?

push notification bell

You have blocked notifications

Oops! You have blocked notifications. Click here for more info

You have blocked notifications, please check your browser settings.

push notification bell

You're currently subscribed to job notifications

Want to change your notifications for job alerts?

push notification bell

Subscribe to notifications

You will no longer receive notifications

Job Search

Anveta

Austin / Global

Database admin (Oracle DB developer)

Job Description

Database Admin (Oracle DB Developer)Long term contract c2c is ok - In office weekly (3 days weekly) - Austin TXAll resources require a minimum of 5+ years of experience in their specified role.Technical Stack Category Technologies:Database: Oracle 19cBackend Stack: Java JDK 17 (17.0.17), Spring Boot 3.4.5 (UI and Services), Spring Framework 5.3.26, Hibernate 6.2.5Frontend Stack: Angular 16.2, AgGrid 31.3.2, Bootstrap 5.3.7Integration: REST APIs with JSON payloads, Spring Batch for multi-sheet Excel ingestion, HTTP Webhooks, SMTPDevelopment Platform: Azure DevOps (branch from TxDOTCONNECT Main); all code remains on TxDOT-controlled hardware & infrastructureRequired Skills:Oracle Database Development - Designing, developing, and maintaining relational databases for backend servicesPreferred Skills:TxDOTCONNECT Experience: Prior experience with the TxDOTCONNECT application or TxDOT database conventionsSchema Design: Designing new tables integrated with existing enterprise schemas, including foreign key relationships across multiple table domainsView Design and Performance Tuning: Oracle 19c view design and query optimization for aggregation across multiple related tablesAudit 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 tablesMigration Management: Version-controlled migration script development for schema changes in enterprise applicationsLogical Delete Patterns: Understanding of logical delete patterns for preserving audit trails in relational systemsBulk 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 evaluationCI/CD Integration: Integration of database migration and change management into continuous integration pipelinesArea - Approx. % - What they would actually do:Oracle Database Development - 45–55% - Schema/table design, views, SQL/query development, relationships, audit columns, logical deletes, bulk operations, reference data, performance tuningJava/Spring Backend Development - 25–35% - Spring Boot services, Hibernate, REST APIs, Spring Batch, Excel ingestion, webhooks, backend business logicFrontend Development - 5–10% - Angular 16, AgGrid, Bootstrap—likely supporting/changing UI rather than being the primary focusDBA / Database Administration - 5–10% - Potentially deployment, migration execution, troubleshooting, performance monitoring, CI/CD database integration—but not traditional DBA workThe important distinction: I would not source this as an Oracle DBA position. The wording "Oracle Database Development – Designing, developing, and maintaining relational databases for backend services" is the key.

Apply Now

Similar Opportunities

View all jobs

Get Job Alerts

Don't miss the perfect fit. Get Daily curated job alerts.

Job Title or Keyword(s)
Location