SERVER SYSTEM ADMINISTRATOR (Information Technology Specialist I)

Job Description and Duties Under the direction of the Information Technology Supervisor II, the Information Technology Specialist I is responsible for serving as a Microsoft Structured Query Language (SQL) Server Database Administrator for California Highway Patrol's (CHP) databases and several commercial off-the-shelf applications. T his position is responsible for Microsoft SQL Server database planning, analysis, design, monitoring, troubleshooting, development, and maintenance of information technology infrastructure initiatives essential to the Department's mission, affecting a large number of the organization's business areas for the Technical Services Group. You will find additional information about the job in the Duty Statement. Special Requirements • The position(s) require(s) a Background Investigation be cleared prior to being hired. • Possession of Minimum Qualifications will be verified before appointment. To satisfy the minimum qualification requirement with education, you must include your unofficial transcript(s)/diploma for initial review. Original diplomas or official, sealed transcripts will be required before the start date. Applicants with foreign transcript(s)/degree(s) must provide a third-party transcript/degree credential evaluation that indicates the number of units, course by course, to which the foreign coursework is equivalent. Foreign education evaluation services can be found at https://naces.org/ and https://aice-eval.org/. The Statement of Qualifications (SOQ) serves as documentation of each applicant's ability to present information clearly and concisely in writing. We encourage candidates to write their responses without the assistance of AI tools; we highly value honesty and clarity in your writing. Your SOQ must be written as a narrative of your professional experience. Please include specific details such as your exact roles and employers, and elaborate on the experiences that qualify you for this position. Rather than simply listing your professional experience or describing the technologies used in your previous roles, focus on providing a meaningful narrative. Furthermore, ensure that the information in your SOQ strictly aligns with both your employment application (STD 678) and your resume. The SOQ is the most critical element of the selection process and should not be treated as a casual quiz or questionnaire. Each question must be numbered and addressed in the same order as the questions below. The SOQ must be typed, no more than three pages in length, and 12-point Arial font. NOTE: Please remember to answer these questions in a narrative format detailing your professional experience, as outlined in the SOQ instructions. • Describe your knowledge, skills, and abilities in troubleshooting and resolving complex databases issues as they relate to backup/restoration, database connection, performance tuning, identifying bottlenecks, and optimization and configuration. Include an example of a technical issue you experienced and the steps and processes you used to resolve the issue. • Describe how your education and work experience qualify you for the role and responsibilities of this Database Administrator position based on the desirable qualifications and duty statement. • Describe your experience implementing and managing solutions like Always On Availability Groups, Replication to ensure continuous database availability and minimize downtime in case of failures. • Describe your experience implementing and enforcing security measures to protect sensitive data, including managing user access, roles, permissions, and auditing database activity to detect and prevent security breaches. Desirable Qualifications In addition to evaluating each candidate's relative ability, as demonstrated by quality and breadth of experience, the following factors will provide the basis for competitively evaluating each candidate: Strong, well-developed verbal and written communication skills; good organization and prioritization skills; and strong analytical and problem solving skills. Must be dependable, accurate, detail oriented, team oriented, and able to provide outstanding customer service. Experience and knowledge of best practices for identifying and handling databases that store and provide access to important information.