Database Administrator I/II/III

Veteran’s Preference

Veterans, Reservists or Guardsmen with an MOS or additional duties that fall in the fields of 25B Information

Technology Specialist, IT Information Systems Technician, 0670 Data Systems Engineering Officer or other related fields pertaining to the minimum experience requirements may meet the minimum qualifications for this position and are highly encouraged to apply.

Additional Military Crosswalk information can be accessed at http://www.hr.sao.texas.gov/Compensation/MilitaryCrosswalk/MOSC_InformationTechnology.pdf.

Job Description Summary

Performs entry-level up to complex (journey-level) database administration work. Work involves planning, developing, maintaining, and monitoring integrated database systems; developing and implementing database policies and procedures; and maintaining data integrity. May train others. Works under moderate supervision, with limited latitude for the use of initiative and independent judgment. Reports to the Manager of the Information Technology (IT) Operations Department.

Essential Job Functions

·        Coordinates and supports the installation of database software and migrations to new data management system software levels, and tests the migrations to ensure data reliability and functionality.

·        Performs database performance monitoring and implements efficiency improvements.

·        Designs and/or implements the procedures necessary to save, retrieve, and recover databases.

·        Assists with capacity planning and monitoring.

·        Performs data migrations, load, and/or updates.

·        Modifies existing databases and database management systems.

·        Assists in developing standards, guidelines, and policies designed to ensure the integrity of the database environment.

·        Maintains data standards; prepares and develops database documentation, procedures, and definitions for data dictionaries.

·        Assists in establishing and implementing necessary database security controls.

·        Plans, coordinates, and supports the installation of database software and migrations to new data management system software levels; and verifies and tests the migrations to ensure data reliability and functionality.

·        Evaluates and recommends database software packages for potential acquisition.

·        Performs Quality Control Tests from the Labor (Time) Table.

·        Maintains confidential and sensitive information.

·        Ensures individual and team files (electronic and hard versions) are appropriately maintained and timely disposed of in accordance with the agency’s records retention procedures and schedule.

·        Maintains required certifications and licenses and meets the continuing education needs and requirements of the position to include, attending mandatory training courses.

·        May be required to operate a state or personal vehicle for business purposes.

·        Performs other duties as assigned.     

Minimum Qualifications

Database Administrator I:

o  Graduation from an accredited four-year college or university with major course work in Computer Science, Information Science, Information Technology or related fields.

o  One to two years of database administration experience with Microsoft SQL Server 2005/2008/2012/2016.

o  Education and experience may be substituted for one another.

Database Administrator II:

o  Graduation from an accredited four-year college or university with major course work in Computer Science, Information Science, Information Technology or related fields.

o  Three to five years of database administration experience with Microsoft SQL Server 2005/2008/2012/2016.

o  Education and experience may be substituted for one another.

 

Database Administrator III:

o  Graduation from an accredited four-year college or university with major course work in Computer Science, Information Science, Information Technology or related fields.

o  Five years of database administration experience with Microsoft SQL Server 2005/2008/2012/2016.

o  Education and experience may be substituted for one another.

 

Preferred Qualifications

·        Previous experience with SQL Server Reporting Services and Integration Services.

·        Previous experience with Database Management and Development tools.

 

Knowledge, Skills, and Abilities (KSAs)

·        Knowledge of local, state, and federal laws and regulations relevant to Database Administration team; and of the principles and practices of public administration.

·        Knowledge of Windows Server 2003/2008/2016.

·        Knowledge of database concepts (table design, relationships, indexing strategies and normalization), backup and recovery, and maintenance plans.

·        Knowledge of SQL Server Reporting Services and Integration Services.

·        Knowledge of project management and software development lifecycle.

·        Knowledge of features and limitations of current Internet/Intranet web development technologies including .NET, C#, VBScript and JavaScript.

·        Skills in using Microsoft Office programs such as Word, Excel, and Access.

·        Skills in use of internet, email, word processing, spreadsheet, presentation, and database software.

·        Skills in constructing stored procedures.

·        Skills in understanding the implications of new information for both current and future problem-solving and decision-making.

·        Skills in negotiating and facilitating work-related interaction with professionals in order to achieve goals and objectives.

·        Ability to adhere to work schedules, follow procedures with respect to leave and submit accurate timesheets by prescribed deadlines.

·        Ability to make mature, objective decisions and identify areas of potential problems.

·        Ability to perform effectively and willingly when changes occur in scope and nature of the work and work environment.

·        Ability to perform routine and non-routine work assignments accurately and on-time with little or no supervision.

·        Ability to perform assigned duties and improve work habits and/or output.

·        Ability to complete assigned work, on time, neatly and with infrequent errors.

·        Ability to interpret policies, procedures, and regulations.

·        Ability to provide prompt, courteous and accurate assistance and clear and concise communication to internal and external stakeholders both verbally and in writing.

·        Ability to work and cooperate with others in a team environment.

·        Ability to manage multiple tasks.

·        Ability to stand/sit/move with no physical limitations or aids to perform activities such as retrieve/replace files in a large file system for boxes up to 30 lbs.

·        Ability to operate a vehicle (state or personal) for state business and maintain a driver’s license and driving record that complies with state and agency requirements.

·        Ability to work days that may exceed 8 hours, including early mornings, nights, and weekends.

·        Ability to train others.

·        Important Notice: Otherwise qualified candidates who are ultimately considered for potential employment with the Texas Water Development Board may be the subject of a request for any criminal history record information maintained by the Texas Department of Public Safety (DPS). Evidence of a criminal conviction or other relevant information obtained from the DPS shall not automatically disqualify an individual from employment with the Texas Water Development Board.