Oracle Database Administrator (Austin)
Advanced Oracle database administrator at the Texas Workforce Commission in Austin, managing OLTP and decision-support databases: performance tuning, backup/disaster recovery, security, and scripting with SQLPlus, PowerShell, and UNIX shell scripts, plus cloud exposure (AWS/Oracle Cloud). Pays $8,500-$11,500/month; no visa sponsorship.
- Compensation
- $8.5K–$11.5K / mo
- Location
- United States-Texas-Austin
- Work setup
- Not specified
- Seniority
- Not specified
- Employment
- Full time
- Experience
- Not specified
- Category
- Devops
- Posted
Skills
Must have
- Five years of full-time experience in computer programming and/or systems analysis
- Alternative: one year of full-time in-service TWC experience as a Database Administrator IV with regular status
Nice to have
- Knowledge of computer programming, systems design, and data structure design
- Proficiency with Oracle database technologies, version 19c and 26ai
- Experience developing and supporting stored procedures, CRON scripts, and UNIX shell scripts
- Experience troubleshooting and resolving database-related issues
- Knowledge of performance tuning, backup, recovery, and security best practices
- Strong experience programming PowerShell and SQLPlus scripts
- Knowledge of best practices for configuring large, complex relational databases, backup/restoration, security, and disaster recovery
- Skilled in developing programs and stored procedures in high-level languages, data modeling, and ETL tools
- Skilled in data modeling methodologies and data conversion techniques
- Experience working with databases in cloud environments like AWS or Oracle Cloud
- Ability to work cooperatively in a team and communicate technical information orally and in writing
- Ability to work independently and analyze complex information to develop plans
Full 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.
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.