Oracle Database Engineer (Austin)

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 (GitHub). -A strong systems-thinking mindsetdriven 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 skills. -Strong ability to present technical architectures, observations, and findings clearly and concisely to both technical and non-technical audiences. -An emphasis on consistency, accuracy, and pre ision in codebases and communication style. -Ability and willingness to lean the business aspects behind projects. YOU GAIN: - A Family Friendly Certified Workplace - Competitive salary: $6,290.00 - $7,156.00/month - Defined Retirement Benefit Plan - Optional 401(k) and 457 accounts - Medical Insurance - Paid time off, including time for vacation, sick and family care leave - Additional benefits for active employees can be found at https://www.ers.texas.gov/Active-Employees/Health-Benefits. Duty involves up to 5% travel within the state of Texas. VETERANS: Use your military skills to qualify for this position or other jobs! Go to www.texasskillstowork.com to translate your military work experience and training courses into civilian job terms, qualifications, and skill sets. Also, you can compare this position to military occupations (MOS) at the Texas State Auditor's Office by pasting this link into your browser: HOW TO APPLY: To be considered, please complete a State of Texas Application for Employment and apply online at www.workintexas.com or on Taleo (Job Search). 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. In compliance with federal law, all persons hired will be required to verify identity and eligibility to work in the United States and to complete the required employment eligibility verification document form upon hire. A position utilizing this classification will be designated as security sensitive according to the Texas Labor Code, Section 301.042.