SOAH - Database Administrator IV

GENERAL DESCRIPTION

Performs 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. May supervise the work of others. Works under minimal supervision, with considerable latitude for the use of initiative and independent judgment.

This position reports to the Austin office at 300 West 15th Street, Suite 504, Austin, Texas 78701.

ESSENTIAL JOB FUNCTIONS

• Coordinates and provides application and database operations triage support to troubleshoot and resolve functional and performance issues encountered in production, development, and test environments.

• Provides advanced database development and oversees and modifies and maintains database structures.

• Performs logical and physical data modeling, evaluates relational database models, and reviews physical data models created from logical data models.

• Designs, recommends, and implements procedures necessary to save, retrieve, and recover databases from hardware and software failures.

• Develops and reviews policies and procedures to guide in the use of database software and resources.

• Develops goals and objectives for the use and improvement of an efficient and cost-effective database system.

• Develops standards, guidelines, policies, and procedures designed to ensure the integrity of the database environment.

• Evaluates and reviews database performance monitoring and implements efficiency improvements.

• Recommends and implements database security standards and controls, and user access levels.

• Performs other duties as assigned.

• Five years' experience in computer systems, data analysis, or database development and maintenance work.

• Graduation from an accredited college or university with a bachelor's degree in computer science, management information systems, or a related science and technology field.

• Education may be substituted with additional four years of experience.

• Prior Texas state agency experience in an information technology capacity.

• Strong system and business analysis skills.

• Experience using SQL Server Reporting Services (SSRS).

REGISTRATION, CERTIFICATION, OR LICENSURE

• None

• Knowledge of the principles, practices, and techniques of computer databases, programming, and systems design.

• Knowledge of computer operations, systems, and procedures.

• Knowledge of computer database application systems.

• Knowledge of computer programming languages, data processing flowcharting techniques, database structures and theories, current database technologies, and data analysis, evaluation, and testing techniques and protocols.

• Skilled in analyzing complex data and business processes.

• Skilled in report and query building.

• Skilled in complex problem solving and critical thinking.

• Skilled in data analytics. 

• Ability to perform work related tasks promptly and professionally.

• Ability to identify and define user needs.

• Ability to provide excellent customer service.

• Ability to communicate technical issues effectively, both verbally and in writing.

• Ability in using current technology including, but not limited to, use of Microsoft Word, Excel, Outlook, Teams, SharePoint, and Adobe Document Cloud Professional.

• Must be able and willing to work physically in the office during work hours as required.

Please visit the Texas Workforce Commission's Skills to Work page to translate your military work experience and training courses into civilian job terms, qualifications, and skill sets.  Additional military crosswalk information may be found on the Texas State Auditor's website at:  https://hr.sao.texas.gov/Compensation/MilitaryCrosswalk/MOSC_InformationTechnology.pdf

ADDITIONAL INFORMATION

• Selected applicant must reside in Texas.
• Professional references may be requested following an interview.
• Applicants must be able to certify their ability to maintain the security and integrity of critical infrastructure and information systems.
• Criminal background checks, driving history, and reference checks are conducted on all applicants selected for hire. Certain positions require a fingerprint background check that is submitted to the Federal Bureau of Investigation (FBI).
• The State Office of Administrative Hearings participates in E-Verify and will provide the federal government with your Form I-9 information to confirm that you are authorized to work in the United States. The agency does not participate in any visa sponsorship program.
• The State Office of Administrative Hearings is an equal opportunity employer. Any form of unlawful discrimination, harassment, or retaliation that affects any aspect of employment and participation in the workplace environment is strictly prohibited.
• Men aged 18 through 25 must be registered with the Federal Selective Service System or have an exemption from registration.
• Applicants contacted for interviews who need special accommodations should notify Human Resources prior to the interview.

BENEFITS

Positions with the State Office of Administrative Hearings may offer the following benefits:

• State-paid health insurance (a 60-day waiting period will apply if not currently employed by the State of Texas)
• State-paid life insurance for the employee
• Retirement plan
• Monthly annual and sick leave accruals
• An average of 13 paid holidays per fiscal year (September 1st through August 31st)
• Participation in agency-sponsored work alternative programs
• Participation in agency Employee Assistance Plan (EAP)
• TexFlex Commuter Spending Account
• Dependent health insurance
• Texa$aver 401(k) and 457 programs
• TexFlex healthcare and dependent care reimbursement accounts
• Dental insurance
• Term life insurance
• Short-term and long-term disability coverage

• Dental insurance

• Term life insurance

• Short-term and long-term disability coverage