Database Administrator; 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 based at 1411 Brazos St, Austin.

Seeking an IT professional to provide support in the design and maintenance of database structures and develop policies and procedures designed to ensure the integrity of the database environment. The ideal candidate will have experience in designing, recommending, and implementing procedures necessary to backup and recover databases from hardware and software failures. Must have the ability to communicate in a professional, customer‑focused manner.

Collaborates with other IT teams as well as business customers to accomplish work.

The Database Administrator is selected by and accountable to the Data Governance Officer with the approval of the Chief Information Officer. Performs highly complex to advanced (senior‑level) database administration work. Work involves providing direction and guidance in database administration operations and planning; providing for efficient and effective storage, retrieval, customization, and archiving of data to ensure integrated database systems; planning, developing, and implementing database policies and procedures;

and maintaining and verifying data integrity. Work is performed under limited to minimal supervision, with considerable latitude for the use of initiative and independent judgment. May supervise the work of others. Maintains a reliable, predictable work schedule. May be called upon to work outside of normal business hours to sustain operations or complete urgent assignments.

• Document database processes and interfaces.
• Define and document the technical architecture of the mainframe DB2 database, including the physical components, data models, and data dictionaries.
• Coordinate activities with the rest of the Mainframe DBA team and with developers.
• Assist in promoting DB2 database objects from lower to higher environments.
• Create and maintain data models and data dictionaries.
• Perform other analysis and documentation tasks as required to facilitate and support TWC’s mainframe DB2 database.
• Maintain disaster recovery procedures and participate in disaster recovery tests and actual recoveries as needed.
• Develop and conduct training and/or give expert advice on database/information availability, design policies and standards, and database query tools.
• Work outside normal office hours and days when needed to resolve production issues and provide on‑call activities.
• Ensure compliance with all Federal, State, and agency laws, rules, policies, and procedures, including IT Handbook and Standard Operating Procedures (SOPs), that govern TWC IT.
• Contribute to teamwork and communicate effectively.
• Promote an image of IT excellence.
• Maintain a reliable, predictable work schedule.
• May be called upon to work outside of normal business hours to sustain operations or complete urgent assignments.
• Perform other duties as assigned to maintain IT operations.

• Bachelor’s degree in computer information systems, computer science, management information systems, or related technical field and 6 years’ related work experience.
• Experience and understanding of mainframe based relational databases.
• Experience overseeing the design and maintenance of database structures and developing policies and procedures designed to ensure the integrity of the database environment.
• Experience assessing future information requirements, develop goals and objectives for improvement and use of an efficient and cost‑effective database system.
• Experience in designing, recommending, and implementing procedures necessary to backup and recover databases from hardware and software failures.
• Recommend and implement necessary database security standards and controls. Detail oriented with strong analytical and problem‑solving skills.
• Ability to work…