Oracle Database Engineer

Position: Oracle Database Engineer )
Description

WHO WE ARE:

Texas Workforce Commission connects people with careers across the state. While we are based in Austin on the north lawn of the Texas State Capitol, we have offices statewide. We're a Family Friendly Certified Workplace with great work-life balance, competitive salaries, extensive opportunities for training and development, and fantastic benefits. This position is located at 101

E. 15th Street, Austin TX.TWC is not considering applications from individuals who require sponsorship for an employment visa, now or in the future, for this position. This includes, but is not limited to, individuals currently on H-1B, F-1 (OPT/CPT), or H-4 visas. You must be a Texas resident to work for the Texas Workforce Commission or willing to relocate to Texas.

WHAT YOU WILL DO:

The Oracle Database Engineer will perform highly complex (senior-level) computer systems analysis work. Work involves planning and analyzing user requirements, procedures, and problems to automate processing or to improve existing systems. May supervise the work of others. Works under limited supervision, with considerable latitude for the use of initiative and independent judgment.

YOU WILL BE TRUSTED TO:

-Architect, develop, and maintain complex backend database systems using Oracle PL/SQL (Procedures, Functions, and Packages).

-Engineer, build, and optimize automated ETL pipelines utilizing Informatica Cloud Services (IICS).

-Translate business requirements into robust, scalable database designs and technical specifications.

-Reverse-engineer, refactor, and modernize legacy SQL and PL/SQL codebases to improve performance, maintainability, and scalability.

-Perform query optimization, performance tuning, and index management within an Oracle Enterprise Data Warehouse environment.

-Design and implement robust error-handling, data validation, and logging mechanisms within ETL processes and database code.

-Write and maintain clear, concise technical documentation including system architectures, data flow diagrams, and codebase comments.

-Collaborate with cross-functional IT and business teams to ensure seamless integration of database systems with downstream reporting tools and applications.

-Participate in peer code reviews, enforce coding standards, and contribute to the establishment of database engineering best practices.

-Perform other duties as assigned.

YOU QUALIFY WITH:

-Three years of full-time experience in computer programming, systems analysis and/or program analysis or three years of full-time experience which provided general knowledge of data processing or systems analysis.

-Relevant academic credits may be applied toward experience qualifications for this position.

YOU ARE A GREAT FIT WITH:

-Three years of full-time software engineering experience developing, troubleshooting, and reverse-engineering complex Oracle SQL and PL/SQL codebases.

-Three years of full-time experience designing and converting legacy ETL solutions to contemporary ETL implementations.

-Three years of full-time experience architecting systems for, and processing, large data sets in an enterprise environment.

-Deep expertise writing backend code within Oracle database environments (Packages, Functions, Procedures).

-Hands-on experience designing and creating Informatica Cloud Services (IICS) taskflows, mappings, and components.

-Professional experience coding within Oracle SQL Developer, DBeaver, VS Code, or other industry-standard SQL IDEs, ideally utilizing version control (Git Hub).

-A strong systems-thinking mindset—driven to improve system architecture, optimize performance, and eliminate technical debt when points of potential improvement are encountered.

-An intra- and inter-team player with strong interpersonal and communication…