TDI - Information Technology - Database Administra

Please paste the following URL into a browser to view the entire job posting on the CAPPS Careers page.https://erphcmprd.cpa.texas.gov/psp/candidateportal/EMPLOYEE/HRMS/c/HRS\_HRAM\_FL.HRS\_CG\_SEARCH\_FL.GBL?Page=HRS\_APP\_JBPST\_FLandAction=UandFOCUS=ApplicantandSiteId=1andJobOpeningId=106935andPostingSeq=1Agency InformationDo 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.Work-life-balance.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 full-time 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 part-time 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 DescriptionDatabase Administrator II Performs complex (journey-level) database administration work. Work involves providing support in day-to-day 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 DutiesThis 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 cost-effective database system.Assists with the migration to new data management system software levels.Performs other duties as assigned.Minimum QualificationsThis position requires: Graduation from an accredited four-year college or university with major course work in computer science, management information systems, or a related field is generally preferred.One years 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 years experience collaborating with developers on schema esign and SQL tuning for web applications.One years 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 Drivers License. Substitution language:Education and experience relevant to position requirements may be substituted for one another on a year-for-year basis.Preferred QualificationsPreferences 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 controlsExperience in the design and delivery of efficient, scalable data pipelines from structured sources into an enterprise data lakehouse.Experience maintaining endtoend data quality and support metadata management for transactional and analytical systems.Knowledge/Skills/AbilitiesThis 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