Job Description

Job Description and Duties

Under general direction of the Information Technology Manager IT Mgr I of SQL Server Support, the Information Technology Specialist IT Spec II demonstrates a depth of leadership and expertise in one or more domains. The IT Spec II will perform a wide variety of tasks requiring innovative problem solving where guidance is not readily available. The IT Spec II will optimize and apply architecture solutions for the benefit of the overall organization and play a major role in advising management or formulating information technology strategy and policy within the organization. The IT Spec II typically work in the Software Engineering, Information Security Engineering, Information Technology Project Management, or System Engineering domains.  

The IT Spec II may perform feasibility studies and research analysis related to technology projects; provide information technology consultation in support of business programs; establish inventory management guidelines; work closely with customers and other Office of Technology Services (OTech) service units in the analysis of business/technical requirements, product specifications, application integration support, and network / portal design necessary to develop and implement MS SQL/MySQL server components, functions, migration assessments; provide metrics on service level agreements; install or repair hardware or peripheral equipment; develop, implement, and maintain security and privacy training; investigate security incidents; develop and/or review data sharing agreements prior to release of confidential information; monitor project milestones and deliverables; coordinate and consult with users, administrators, and engineers to identify business and technical requirements; develop and sustain cooperative working relationships with project stakeholders; perform software product deployment and release management activities; define and design software solutions; identify infrastructure system requirements and recommend technology, hardware, software, and plans installation; advise, create, or participate in the design of new system architecture, standards, and methods to support organizational needs; conduct research and perform analysis to recommend system upgrades, cost-effective solutions, and process improvements; troubleshoot, track, and conduct root cause analysis of system/database/operational issues; and act in a lead role over lower-level staff.

Telework
This position is eligible for a hybrid work schedule within California based on the departmental policy and operational needs. The telework policy is subject to change depending on business needs, and/or reporting to the work site may be required with minimal notification.

Visa Sponsorship
This position is not eligible for visa sponsorship. Applicants must be authorized to work in the US without the need for a visa sponsorship now or in the future. 

Working Conditions

CA Residency:
Candidates who reside outside of the State of California may be admitted to the job interview. However, upon a job offer, candidates must provide proof of residence in California prior to their appointment becoming effective, or the offer may be rescinded.

• Periodic weekend and off shift work may be required.
• Must maintain consistent, predictable attendance.
• Core Business hours are from 0800 to 1700 hours.
• Occasional travel may be required to perform assigned duties, attend training, and provide customer support.
• May be required to respond to after-hours support calls and carry a PDA.
• Must pass a fingerprint background criminal record check completed by the Department of Justice (DOJ) and the Federal Bureau of Investigation (FBI).

Special Requirements

• The position(s) require(s) a Background Investigation be cleared prior to being hired.

Do not submit the “Equal Employment Opportunity” questionnaire (page 5) with your completed state application (STD. 678) – For exam use only.

Please do NOT include your Social Security Number on any of the submitted documents.

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:

• Advanced level Knowledge and experience with Microsoft SQL server components like SSRS, SSAS, and SSIS.
• Advanced level knowledge and use of Microsoft SQL/MySQL installs and maintenance updates including critical patch updates.
• Advanced level knowledge and use of Microsoft SQL/MySQL System and Database Administration Tools.
• Advanced level knowledge and use of Microsoft SQL/MySQL upgrade and migration strategies.
• Advanced level knowledge of Microsoft SCOM, PowerShell scripting and Windows scripting and utilities
• Advanced level knowledge and experience with Windows Server OS (Windows 2012, 2016) and clustering.
• Knowledge of virtual server environments (Hyper-V and VMWare ESX1 5.5 or higher)
• Understanding of Cloud Computing
• Ability to work with a variety of technical and management staff
• Excellent writing and communication skills.

Benefits

Benefit information can be found on the CalHR website and the CalPERS website.

Additional Application Instructions

Using the online application system as specified in the announcement is the preferred method of applying for civil service job opportunities; however, applicants may instead apply by way of U.S. mail, parcel delivery or courier service, or in person, as set forth in this announcement.

Applicants who wish to submit hard copy applications shall use the most current version of the State Application (STD. 678) revised 10/2023. The position number and job control number must be identified in the job title line of the STD 678 (these numbers will auto-populate in the job title of the STD 678 if submitting an electronic application through CalCareers Account). The hard copy application MUST be signed. Applicants who fail to submit the most current version of the STD. 678 may be disqualified.

Note: Applications MUST include the “From dates“ and “To” dates, “Hours Per Week”, and “Duties Performed” fields for all job listed in the “Employment History” fields, and contact names and phone numbers of supervisors. State employees must list the specific departments for which they worked and indicate the specific civil service classification titles held (not working titles). Applications that are submitted blank will be considered incomplete. Reference to a resume in place of a description of the duties will not be accepted. Failure to submit a completed STD 678 may result in you being screened out. Only the most qualified candidates will be invited to an interview.

Please note that the CalCareer system will not allow you to make changes to your application information once it is submitted. For all other questions regarding your CalHR CalCareer account, you may contact the CalCareer Unit at (866) 844-8671.

Required Application Package Documents

The following items are required to be submitted with your application. Applicants who do not submit the required items timely may not be considered for this job:

• Current version of the State Examination/Employment Application STD Form 678 (when not applying electronically), or the Electronic State Employment Application through your Applicant Account at All Experience and Education relating to the Minimum Qualifications listed on the Classification Specification should be included to demonstrate how you meet the Minimum Qualifications for the position.
• Resume is required and must be included.
• Other -

  If you are using EDUCATION to meet the minimum qualifications for this classification, you MUST provide your unofficial transcripts as proof of meeting the education requirements as listed in the Classification Specification.. Applicants who completed their education outside of the United States (with foreign degrees/transcripts) must provide a foreign transcript evaluation. The transcript evaluation must state the number of units to which foreign coursework is equal. Foreign education evaluation services can be found at   . Official transcripts and official foreign degree transcripts will be required prior to appointment. If you are not using education to qualify for this classification, you do not need to submit transcripts. To bypass the required document, select Choose/Upload and select Bypass File.

Job Tags

Permanent employment, Full time, Remote job, Shift work,

Similar Jobs