JC-537128 INFORMATION TECHNOLOGY SPECIALIST I

This posting states its location as Sacramento County rather than a street address. The work is assigned within that county.

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.

Working Conditions

Monday through Friday, 0800-1700 hours on-site; some weekend hours as required; some travel as required.

Qualifications

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 and
• 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.

Work for Warriors is a no-cost employment program of the California Military Department for Service Members, Veterans, and military family members. The Veteran Staffing Consultant for California Highway Patrol is Martin Rivera.