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.
TWC is not considering applications from individuals who require sponsorship for an employment visa, including those currently on student or postgraduate visas. You must be a Texas resident to work for the Texas Workforce Commission or willing to relocate to Texas.
WHO YOU ARE:
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 recovery 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.
WHAT YOU WILL DO:
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 the 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.
- Documents database processes and interfaces.
- Defines and documents the technical architecture of the mainframe DB2 database, including the physical components and their functionality, data models and data dictionaries.
- Coordinates activities with the rest of the Mainframe DBA team and with developers.
- Assists in promoting DB2 database objects from lower to higher environments.
- Creates and maintains data models and data dictionaries.
- Performs other analysis and documentation tasks as required to facilitate and support TWC’s mainframe DB2 database.
- Maintains disaster recovery procedures and participate in disaster recovery tests and actual recoveries as needed.
- May develop, and conduct training and/or give expert advice on database/information availability, design policies and standards and database query tools.
- May work outside normal office hours and days when needed to resolve production issues and provide on-call activities.
- Ensures compliance with all Federal, State, and agency laws, rules, policies, and procedures, including IT Handbook and Standard Operating Procedures (SOPs), that govern TWC IT.
- Contributes to teamwork and communicates effectively.
- Promotes an image of IT excellence.
- Maintains a reliable, predictable work schedule.
- May be called upon to work outside of normal business hours to sustain operations or complete urgent assignments.
- Performs other duties as assigned to maintain IT operations.
YOU ARE A GREAT FIT WITH:
- 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, develops 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 recovery databases from hardware and software failures.
- Recommends and implements necessary database security standards and controls. Detail oriented with strong analytical and problem-solving skills.
- 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 QUALIFY WITH:
- Database Administrator III: Three years of full-time experience in computer programming and/or systems analysis.
- Database Administrator IV: Four years of full-time experience in computer programming and/or systems analysis.
- Both Levels: Relevant academic credits may be applied toward experience qualifications for this position.
YOU GAIN:
- A Family Friendly Certified Workplace
- 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.
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
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.
TWC is not considering applications from individuals who require sponsorship for an employment visa, including those currently on student or postgraduate visas.
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.