The Texas General Land Office primarily serves the schoolchildren, veterans, and the environment of Texas. The agency does so by preserving our history, maximizing state revenue through innovative administration, and through the prudent stewardship of state lands and natural resources. This position is with our Enterprise Technology Solutions program area, Technology Integration Services Division. Performs routine to complex (journey-level) database administration work. Work involves developing, maintaining, and monitoring integrated database systems; implementing database procedures; and maintaining data integrity. May provide guidance to others. Works under general supervision, with limited to moderate latitude for the use of initiative and independent judgment. Military Crosswalk information can be accessed at: http://www.hr.sao.texas.gov/Compensation/MilitaryCrosswalk/MOSC_InformationTechnology.pdf In order to receive Veterans' preference, a copy of Form DD#214 is required at time of interview.
Essential Job Elements:
Serves in the design, administration, analysis, maintenance, performance tuning, backup and recovery, and security of all agency DBMS systems. Monitors the DBA service desk queue and alert monitoring systems to ensure service level agreements are met. Performs logical and physical data modeling. Designs relational database models. Creates physical data models; works closely with the database development teams to ensure that the physical database designs are efficient, functional and consistent with the agency business needs. Assists in team activities to ensure tasks or projects are completed within applicable time frames. Recommends and implements necessary database security standards and controls; including ensuring that all database servers are up-to-date with the latest tested service packs and security fixes. Provides guidance, training, and mentoring to team members, staff, and users in the network and database environments.
Graduation from an accredited four-year college or university with a bachelor's degree Understanding of SQL Server planning and maintenance Solid troubleshooting skills Strong verbal and written skills Demonstrate good interpersonal skills Substitution: One (1) additional year of experience supporting complex computer networks may substitute for thirty (30) semester hours
Graduation from an accredited four-year college or university with a bachelor’s degree in computer science, computer information systems, or management information systems. Network or IT related certification, within the last four years. Shown learning and training initiative in advance on the technologies for which they are applying. Three or more years of SQL Server planning, implementation and maintenance Experience supporting and maintaining Windows Server Experience writing stored procedures, views and scripts with ANSI SQL & T-SQL Knowledge of SSRS reports, data sources and security Ability to maintain and manipulate ETL objects via SSIS SQL Server replication Knowledge of Visual Studio, Tuning Advisor and SQL Profiler Knowledge of Solarwinds monitoring Knowledge of Spotlight for SQL Server An understanding of database design best practices, including normalization, query optimization and referencial integrity. Understanding of ANSI SQL and/or T-SQL
Knowledge, Skills, Abilities:
Procedural documentation writing. Identifying and resolving problems by using strong analytical techniques, innovative approaches, and taking initiative in preventing and solving problems. Skill in using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions, or approaches to problems. Knowledge of network facilities and data processing techniques, of computer hardware and software, of network operating system and security software, and of performance monitoring and capacity management tools. Windows Admin, Active Directory, SQL Server, T-SQL, SSRS, SSIS, Amazon RDS, Visual Studio, database normalization, SQL replication Ability to attend work regularly and adheres to established work schedule in accordance with agency leave and attendance.
This position requires the employee to primarily perform sedentary office work; however, mobility (moving around the work-site) is routinely required to carry out some duties. This position requires extensive computer, telephone and client/customer contact and communication. It requires the ability to move and position oneself as needed for filing and similar routine office duties. The job also requires normal cognitive abilities requiring the ability to learn, recall, and apply certain practices and policies. It requires the stamina to maintain attention to detail despite interruptions. Ability to read printed materials and computer screens. The individual must be able to move and transport records, documents, boxes, and all related information and materials, weighing up to 20 pounds when required. The individual must be able to remain stationary for long periods of time when commuting to and from assigned destination and when traveling on state business including fieldwork and training assignments.
Other (licenses, certifications, et cetera):
All applications for employment with the Texas General Land Office (GLO) must be submitted electronically by the job closing date through www.WorkInTexas.com. PAPER, FAX OR E-MAIL APPLICATIONS WILL NOT BE ACCEPTED. Please visit our website at www.glo.texas.gov for more information about applying for a GLO job posting.
The Texas General Land Office/Veterans Land Board does not discriminate on the basis of race, color, national origin, sex, sexual orientation, religion, age, disability or genetic information in employment or the provision of services. A criminal conviction records check is required for applicants who are selected for a position. The State of Texas requires all males who are 18 through 25 and required to register with the Selective Service to present either proof of registration or exemption from registration upon hire. The U.S. Immigration Reform and Control Act of 1986 requires new employees to present proof of identity and eligibility to work in the United States. The Texas General Land Office is a non-smoking agency. Smoking is permitted only in designated areas. In compliance with the FLSA, the GLO compensates overtime work though time off in lieu of payment.