Oracle Database Administrator (Austin)

Texas Workforce Commission; Austin (TX); On-site; USD 95,000 - 128,000; Full time

Benefits offered by this job

Family Friendly Workplace

Competitive salary

Defined Retirement Benefit Plan

Optional 401(k) and 457 accounts

Medical Insurance

PTO & leave

Job summary

The Texas Workforce Commission seeks an experienced Oracle DBA to manage complex database environments in the Information Technology Division in Austin, TX. You will safeguard data integrity, implement robust procedures, and partner with cross-functional teams to deliver reliable data solutions.

Responsibilities include advanced database administration, performance tuning for OLTP and data warehousing workloads, and disaster recovery planning. Travel within Texas may be required.

Qualifications

• Five years of full-time experience in computer programming and/or systems analysis.
• Experience with Oracle 19c and 26ai.
• Developing and supporting stored procedures, CRON scripts, and UNIX shell scripts.

Responsibilities

• Provide direction in database administration operations and planning.
• Monitor and tune database performance for OLTP and decision support environments.
• Oversee disaster recovery procedures and testing; ensure data integrity.
• Collaborate with cross-functional teams to deliver data solutions and security standards.

Skills

Oracle DBA

PL/SQL

UNIX Shell

PowerShell

SQLPlus

Data Modeling

Tools

AWS

Oracle Cloud

CRON Scripts

Job 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 based at 1411 Brazos Street, Austin in the Information Technology Division.

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 based at 1411 Brazos Street, Austin in the Information Technology Division. 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.

Who You Are

You are a forward-thinking Oracle DBA who thrives on the challenge of managing complex database environments. You take pride in being the guardian of data integrity, developing robust procedures that keep systems secure and reliable and work as a collaborative partner with cross-functional teams to deliver strategic data solutions. With your technical expertise and "owner" mindset, you have a proven ability to solve intricate problems and implement industry-leading database standards.

What You Will Do

The Database Administrator V performs highly advanced database administration work. Work involves providing direction and guidance in database administration operations and planning; overseeing the effective and efficient storage, retrieval, customization, and archiving of data by managing diverse data sets to ensure integrated database systems; planning, developing, and implementing database policies and procedures; and ensuring and verifying data integrity. May oversee the work of others. Works under minimal supervision, with considerable latitude for the use of initiative and independent judgment.

You Will Be Trusted To

• Provide professional and technical assistance in the planning and development of TWC on-line transaction processing (OLTP) and decision support databases.
• Consult with programmer/analysts to ensure the conceptual and design phases of new applications are consistent with the structural parameters within the database environment.
• Responsible for the development and ongoing enhancements of decision support database systems, monitoring and fine-tuning database performance in both the OLTP and decision support environment, developing and supporting business interface processes and developing database conversion stored procedures.
• Implements and maintains policies and standards related to the design of databases, data access requirements, security and recovery procedures for the database.
• Evaluate database engines, query and performance monitoring tools.
• Maintain disaster recovery procedures and participate in disaster recovery tests and actual recoveries as needed.
• Will be expected to give expert advice on database/information availability, design policies and standards and database query tools.
• Contribute to teamwork and communicate effectively.
• Promote an image of IT excellence.
• Maintains a consistent and reliable work schedule, with the flexibility to work outside of standard business hours, including on-call rotations, to support production issues or address urgent operational needs.
• Perform other duties as assigned to maintain IT operations.

You Qualify With

• Five years of full-time experience in computer programming and/or systems analysis.
• Relevant academic credits may be applied toward experience qualifications for this position.

You Are a Great Fit With

• Knowledge of the principles, practices, and techniques of computer programming and systems design, of computer operations, systems, and procedures.
• Knowledge of data structure design and proficiency with current database technologies in Oracle version 19c and 26ai.
• Demonstrated experience developing and supporting stored procedures, CRON scripts, and UNIX shell scripts to support business operations and application requirements and to enhance database performance and efficiency.
• Provide support in troubleshooting and resolving database-related issues.
• Knowledge of performance tuning, backup, recovery, and security best practices.
• Strong experience with programming Powershell and SQLPlus scripts.
• Knowledge of industry best practices for configuring and supporting large, complex relational databases, including database backup/restoration, maintain database security, and disaster recovery procedures to safeguard agency data.
• Excellent problem-solving skills with the ability to troubleshoot complex issues.
• Skilled in the development of computer programs and stored procedures utilizing high level programming languages, data modeling, and industry standard data extract/transform/load (ETL) tools.
• Skilled in applying data modeling methodologies, data conversion techniques and implementing repeatable processes for creating and modifying data base structures.
• Experience working with databases in the cloud environments like AWS or the Oracle cloud.
• Ability to work cooperatively with a team of database administrators, analysts and developers to complete work assignments.
• Ability to communicate technical information effectively, both orally and in writing to establish and maintain effective working relationships with customers, coworkers, and vendors.
• Ability to work independently while understanding the need for communicating and coordinating work efforts with others.
• Ability to analyze complex information and develop plans to address identified issues.

You Gain

• A Family Friendly Certified Workplace
• Competitive salary: $8,500 - $11,500/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 10% 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: https://hr.sao.texas.gov/Compensation/MilitaryCrosswalk/MOSC_InformationTechnology.pdf