Oracle/SQL Database Administrator

Posted Yesterday
Be an Early Applicant
Austin, TX, USA
In-Office
Expert/Leader
Information Technology • Security • Consulting • Cybersecurity
The Role
Perform advanced Oracle and Azure SQL database administration to support an Oracle-to-Azure SQL migration. Duties include data modeling, ETL/migration, performance tuning, monitoring, security, high-availability/disaster recovery, converting stored procedures to Azure SQL, and supporting Java full-stack applications in an Agile environment.
Summary Generated by Built In

This is a hybrid role; only local candidates will be considered.

The Oracle/SQL Database Administrator will support the Texas Health and Human Services Commission on the Oracle-to-Azure SQL database migration and modernization project. This role performs advanced database administration for applications with complex data models, workflows, and reporting requirements. The Database Administrator will work with full-stack Java applications on HHSC's cloud platform within an Agile Scrum environment. Core responsibilities include database tuning, migration, performance optimization, and security of data at rest and in motion. The role also involves creating and maintaining logical and physical data models with a primary focus on Oracle and Azure Microsoft SQL.

Responsibilities:

  • Performs advanced database administration tasks for databases supporting applications with complex data models, workflows, and reports.
  • Creates and maintains logical and physical data models in coordination with the development team.
  • Migrates data from Oracle applications to SQL schemas and loads it into collections.
  • Optimizes database performance during and after migration, and identifies and resolves performance bottlenecks.
  • Implements monitoring solutions to track database health and performance metrics.
  • Performs database tuning, indexing, customization, and transformation activities.
  • Executes data migrations/conversions, installations, troubleshooting, upgrades, and patching.
  • Manages user access and security of data at rest and in motion.
  • Performs disaster recovery, clustering for high availability, load balancing, and data backup, purging, and archiving.
  • Converts Oracle Stored Procedures and Functions to Azure SQL.
  • Implements database policies and procedures to ensure the integrity, availability, and confidentiality of sensitive and business-critical databases.


Requirements

Minimum Qualifications:

  • 10 years of database experience.
  • 8 years of experience with Oracle, Microsoft SQL, or similar.
  • 8 years of experience with relational database administration, such as SQL Server or Oracle.
  • 8 years of experience in database design, analysis, and performance tuning.
  • 8 years of experience in database structures, data analysis, and performance tuning.
  • 8 years of experience designing enterprise applications and/or services.
  • 8 years of experience creating technical and functional design documentation.
  • 8 years of experience within the software development life cycle using Agile methodology, such as Scrum.
  • 8 years of experience with multi-tier system/application development, such as SOA, Microservices, or 3-Tier applications.

Preferred Qualifications:

  • 8 years of experience with large volume databases, high availability, and disaster recovery infrastructure.
  • 6 years of experience with Azure.
  • 6 years of experience with the ability to extract, transform, and load (ETL) data from various sources into Azure SQL.
  • 3 years of experience in DevOps technology, including CI/CD pipelines and build and deployment tools such as Git.
  • 3 years of experience in Java/J2EE enterprise development.
  • 1 year of experience with Azure certification preferred.
  • 1 year of experience with DBA Associate certification preferred.

Additional Requirements:

  • Local candidates only; must currently live within 50 miles of the Austin, Texas work location.
  • Candidates will be subject to a pre-employment security review to determine employment eligibility.
  • Total estimated hours shall not exceed 454 hours.
  • This service may be amended, renewed, and/or extended if both parties agree to do so in writing.
Work Location and Schedule:


Location: 701 W. 51st, Austin, Texas 78751
Schedule: Monday through Friday, 8:00 AM to 5:00 PM, excluding State holidays when the agency is closed.
Work Arrangement: Hybrid – On Site and Telework


Skills Required

  • 10 years of database experience
  • 8 years experience with Oracle, Microsoft SQL, or similar
  • 8 years relational database administration (SQL Server or Oracle)
  • 8 years database design, analysis, and performance tuning
  • 8 years experience in database structures and data analysis
  • 8 years designing enterprise applications and/or services
  • 8 years creating technical and functional design documentation
  • 8 years experience within the SDLC using Agile methodology (Scrum)
  • 8 years experience with multi-tier system/application development (SOA, Microservices, 3-Tier)
  • Local candidate within 50 miles of Austin, TX (hybrid role)
  • Subject to pre-employment security review
  • Experience with large volume databases, high availability, and disaster recovery infrastructure
  • 6 years experience with Azure
  • 6 years experience extracting, transforming, and loading (ETL) data into Azure SQL
  • 3 years experience with DevOps technology, CI/CD pipelines and build/deployment tools such as Git
  • 3 years experience in Java/J2EE enterprise development
  • Azure certification (preferred)
  • DBA Associate certification (preferred)
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company

What We Do

Air InfoSec is a veteran-owned and led cybersecurity consulting and staffing firm based in Austin, Texas, focused on enhancing government security through expert staff placement.

Similar Jobs

PNC Bank Logo PNC Bank

Detection and Response Manager - Tempus

Machine Learning • Payments • Security • Software • Financial Services
Remote or Hybrid
USA
55000 Employees
100K-223K Annually

PNC Bank Logo PNC Bank

Business Systems Analyst

Machine Learning • Payments • Security • Software • Financial Services
Hybrid
Farmers Branch, TX, USA
55000 Employees
53K-128K Annually

PNC Bank Logo PNC Bank

Software Engineering Manager

Machine Learning • Payments • Security • Software • Financial Services
Remote or Hybrid
USA
55000 Employees
100K-223K Annually

Liberty Mutual Insurance Logo Liberty Mutual Insurance

Inside Sales Representative

Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Remote or Hybrid
9 Locations
40000 Employees
55K-75K Annually

Similar Companies Hiring

Standard Template Labs Thumbnail
Artificial Intelligence • Information Technology • Software
New York, NY
25 Employees
Milestone Systems Thumbnail
Artificial Intelligence • Security • Software • Analytics • Big Data Analytics
Lake Oswego, OR
1500 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account