Database Administrator

Akaasa Technologies; Austin (TX); Hybrid; USD 90,000 - 130,000; Full time

Job summary

Akaasa Technologies is seeking a Database Administrator for a HYBRID role in Austin, TX. The position requires 5+ years of experience in database development and administration, with emphasis on Oracle 19c, SQL/PLSQL, and performance tuning.

The candidate should be adept at schema design and migration management within enterprise environments. The role includes working in a hybrid model (3 days onsite) and leveraging Azure DevOps for CI/CD—supporting bulk data operations and integration with

Qualifications

• Oracle database development experience required.
• Designing, developing, and maintaining relational databases for backend services.
• TxDOTCONNECT experience preferred.

Job description

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, HTTP 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