Database Analyst Jobs in Texas (NOW HIRING)

Agency Information
Database Administrator IV
To apply for any posted position with the Texas Commission on Law Enforcement, please register or log in at:
https://erphcmprd.cpa.texas.gov/psc/candidateportal/EMPLOYEE/HRMS/c/HRS_HRAM_FL.HRS_CG_SEARCH_FL.GBL?FOCUS=Applicant
Resumes are not accepted in lieu of State of Texas application
All positions with TCOLE are security sensitive. Applicants are subject to an indepth background investigation including criminal history, employment history and references, military, education, and personal references. Employment is contingent upon the verification of credentials and/or other information required.
TCOLE Mission
The mission of the Texas Commission on Law Enforcement, as a regulatory State agency, is to establish and enforce standards to ensure that the people of Texas are served by highly trained and ethical law enforcement, corrections, and telecommunications personnel.
Our IT Department
TCOLE IT Division is tasked with developing and managing the software tools for law enforcement in Texas to have the best training and track mandatory compliance for peace officers and jailers. The TCOLE IT Division has the security of an established agency with the flexibility of a small startup in implementation and design.
Who We're Looking For
The Texas Commission on Law Enforcement (TCOLE) is seeking a Database Administrator to join the IT Division located at 6330 E HWY 290, Suite 200, Austin, TX.
The Database Administrator IV performs advanced (senior level) database administration work involving developing, maintaining, and monitoring integrated database systems; implementing database procedures; and maintaining data integrity under minimal supervision.
Salary is dependent on qualifications and experience. The salary range is $84,182 $113,278. This Job Class for this position is 0214 and salary group is B27.
Remote work within the state of Texas will be considered. This position requires regular travel to the organization's headquarters in Austin, TX.
Essential Job Duties
Examples of Work Performed
Performs database installation, configuration, migrations, upgrades, security patches, and support integration with other ETL/ Analytic tools.
Performs analysis on database and storage capabilities and gives recommendations for storage solutions and expansions based on research, including cost analysis.
Performs user provisioning and access management based on the Principle of Least Privilege monitors the health of the databases, logging, and auditing to ensure compliance with organizational policies and standards.
Participates in agile data engineering development and supports database design and implementation based on data pipeline requirements.
Develops, maintains and extends the business intelligence data warehouse for reporting on new data objects.
Provides service and vendor reviews and evaluations.
Configures SQL Server monitoring utilities for SQL server management of development and production environments.
Coordinates with contractor DBSs to plan and implement backups and manage size upgrades.
Minimum Qualifications
Required Education and Experience:
Bachelor's Degree from accredited university in Computer Science, Management Information Systems (MIS), or a related field.
At least five (5) years of experience as a Database Administrator or similar role.
Experience or education may be substituted for one another on a yearforyear basis.
Knowledge/Skills/Abilities
Required Knowledge, Skills, and Abilities:
Ability to maintain the highest standards of security and safeguard critical infrastructure. This includes adhering to strict background checks, reporting any suspicious activities, and participating in security training and drills as required.
Knowledge of the principles, practices, and techniques of computer databases, programming, and systems design; computer operations, systems, and procedures; project control and cost estimating techniques; computer database application systems; computer programming languages; data processing flowcharting techniques; database structures and theories; current database technologies; and data analysis, evaluation, and testing techniques.
Skill in complex problem solving and critical thinking, and in the use of a computer and applicable software.
Preferred Knowledge, Skills, and Abilities:
At least two (2) years of experience working with relational databases e.g. Microsoft SQL Server
Understanding of TSQL, ETL, and PowerShell
Advanced understanding of optimization, indexes, creating views for quick retrieval of data
Knowledge of integrating with BI reporting tools and creating data warehouses like Tableau, Power BI, MicroStrategy
Experience in creating solutions from business needs and providing recommendations
Experience with cloud database solutions (e.g., AWS RDS, Azure SQL Database, Google Cloud SQL)
Working knowledge of Semistructured data formats such as XML and JSON
Benefits
Why work at TCOLE?
Working for the Texas Commission on Law Enforcement (TCOLE) empowers you to make an impact on public safety while engaging in continuous learning within a supportive environment. You'll play a crucial role in upholding high law enforcement standards, collaborating with local agencies, and enhancing the wellbeing of Texans. As a Texas State employee, you will have access to our comprehensive benefit programs including:
Comprehensive health, dental, and vision insurance plans with several types of coverage to state employees and their eligible family members
For new hires and rehires, health insurance is available on the 1st of the following month after a 60day waiting period. More information about benefits is available at https://ers.texas.gov/benefitsataglance
12 16 days of annual paid holidays
At least eight hours of paid vacation and up to eight hours of paid sick leave each month for fulltime employees
Retirement options with the State of Texas Retirement that provide flexibility and security
Health and Wellness programs including wellness leave, fitness and weight management programs, and personalized wellness tools
TCOLE is a qualifying organization for the Public Service Loan Forgiveness Program
The Discount Purchase Program provides access to an online marketplace offering discount on a wide range of products and services
Additional Information
Equal Opportunity Employer TCOLE is an Equal Opportunity Employer. All qualified applicants receive consideration for employment without regard to race, color, religion, sex, national origin, disability, or protected veteran status.
ADA In compliance with the Americans with Disabilities Act (ADA), TCOLE will provide reasonable accommodation during the hiring and selection process for qualified individuals with a disability. If you need assistance completing the online application, contact the Human Resources Department at 5129360831. If you are contacted for an interview and need accommodation to participate in the interview process, please notify the person scheduling the interview.
MILITARY OCCUPATIONAL SPECIALTY CODES can be found
at: http://www.hr.sao.texas.gov/CompensationSystem/JobDescriptions
VETERAN'S PREFERENCE: If you choose to claim veteran's employment preference including surviving spouse or orphan of a veteran as outlined by the State of Texas, you must attach a DD214 at the time your application is submitted.