TDI - Information Technology - Database Administrator II

Agency Information

Do you have a passion for public state service and enjoy making a difference? The Texas Department of Insurance (TDI) is hiring! We regulate the insurance industry, administer the Texas workers' compensation system, perform the duties of the State Fire Marshal's Office, and educate and protect consumers. Apply now if you're looking for a rewarding career in public service. The Texas Department of Insurance is in the Capitol Complex, in the Barbara Jordan Building at 1601 Congress Avenue in Austin, near the Texas Capitol.

Benefits of working at TDI:

• Flexible work schedules.
• Worklifebalance.
• 96 hours of accrued vacation a year.
• 96 hours of accrued sick leave a year.
• 20+ holidays every year.
• Career advancement opportunities.
• Free parking.
• 401(k) and 457 Programs.
• State of Texas retirement plan with a lifetime annuity through the Employee Retirement System of Texas (ERS).
• Free comprehensive medical insurance for fulltime employees and 50% off premium costs for dependents.
• Optional benefits like dental, vision, life insurance, and many more.
• Qualified employer for the Federal Public Service Loan Forgiveness Program.
• Some benefits for parttime employees are earned proportionately to the hours worked.

Before you apply:

TDI does not sponsor or assume sponsorship of an employment visa.

Learn about our selection process, our military employment preference, licensing, and credential requirements.

Job Description

Database Administrator II

Performs complex (journeylevel) database administration work. Work involves providing support in daytoday database administration operations and planning; providing for the efficient and effective storage, retrieval, customization, and archiving of data to ensure integrated database systems; adhering to database policies and procedures; and maintaining and verifying data integrity. The ability to work in multiple database environments and to create, maintain connections to each such as Oracle, Tableau datasets and Snowflake. This position is also responsible for troubleshooting and resolving database issues as they are reported. Works under general supervision with moderate latitude for the use of initiative and independent judgment.

Essential Job Duties

This position:

• Evaluates and reviews database performance monitoring, implements efficiency improvements, and modifies existing databases and database management systems.
• Assists with the design and maintenance of database structures, and develops policies and procedures designed to ensure the integrity of the database environment.
• Recommends and assists with the implementation of necessary database security standards and controls.
• Designs, recommends, and implements procedures necessary to save and recover databases from hardware and software failures.
• Oversees logical and physical data modeling, evaluates relational database models, and reviews physical data models created from logical data models.
• Assesses future information requirements and develops goals and objectives for the improvement and use of an efficient and costeffective database system.
• Assists with the migration to new data management system software levels.
• Performs other duties as assigned.

Minimum Qualifications

This position requires:

• Graduation from an accredited fouryear college or university with major course work in computer science, management information systems, or a related field is generally preferred.
• One year s experience with Oracle databases, computer programming work, and computer systems analysis.
• One year's experience writing, optimizing, and troubleshooting complex SQL queries, stored procedures, and functions.
• One year s experience collaborating with developers on schema design and SQL tuning for web applications.
• One year s experience with Tableau, Power BI, or equivalent data analysis and visualization tool.
• Regular work attendance.
• Travel may be required for up to 5% of the time. If travel is 10% or more, you must maintain a state of Texas Driver s License.

Substitution language:

Education and experience relevant to position requirements may be substituted for one another on a yearforyear basis.

Preferred Qualifications

Preferences for this position include:

• Experience working for a government agency.
• Demonstrated ability to develop effective data architectures and create robust, well structured data models.
• Proficiency in performance tuning, query optimization, indexing strategies, and analyzing execution plans.
• Scripting experience (PowerShell, Bash, or Python) to automate SQL tasks and operational workflows.
• Experience implementing and maintaining database security, permissions, and auditing controls
• Experience in the design and delivery of efficient, scalable data pipelines from structured sources into an enterprise data lakehouse.
• Experience maintaining end to end data quality and support metadata management for transactional and analytical systems.

Knowledge/Skills/Abilities

This position requires demonstrated knowledge of:

• State laws, rules, procedures, and regulations relevant to job requirements.
• The principles, practices, and techniques of computer programming and systems design.
• Computer operations, systems, and procedures.
• Project control and cost estimating techniques.
• Computer programming languages. Such as: (Oracle SQL, PL/SQL)
• Data processing flowcharting techniques.
• Database structures and theories.
• Current database technologies.
• Data analysis techniques.

This position requires demonstrated skill in:

• Problem solving and critical thinking.
• Using Microsoft Office software applications, including Word, Excel, Outlook, and SharePoint.
• Using personal computers sufficient to enter and extract data from related systems and programs, such as Centralized Accounting Payroll and Personnel (CAPPS) and other systems required to perform the job.

This position requires the demonstrated ability to:

• Communicate and work effectively with a wide range of people with varied skills, knowledge, and backgrounds.
• Maintain the confidentiality of sensitive information.
• Analyze and solve workrelated problems and work independently on a variety of administrative work and technical assignments.
• Manage and coordinate multiple tasks and priorities to meet necessary deadlines.
• Work both independently and as a team player.

Military/Veteran Information

Military Employment Preference

Get help translating your military work experience and training courses into civilian job terms, qualifications/requirements, and skill sets. Redact personal or sensitive information from all attachments.

To receive a military employment preference, you must submit the required documents, as applicable, with your application. See Military Employment Preference.

Applicable Military Occupational Specialty (MOS) codes are included, but not limited to one of the following:

25B CTI IT 0671 1D7X1 5C0X1S

Click or copy and paste the following link into your browser to access Military Crosswalk information:

_InformationTechnology.pdf

How to Apply

You may apply through CAPPS Agency Career Site or Work in Texas (WIT).

The following information is required with your submission. Your submission must include complete:

• Employment history (month and year)
• Duties and responsibilities
• Education
• Certifications
• Licenses
• Employment questions

We may reject submissions that do not include all the required information.

If you are applying through WIT, log into CAPPS Agency Career Site to access employment questions and review your submission.