Job Description and Duties This position is a 12 month limited term position. It may become permanent, be extended or be canceled at any time. This position is remote-centered and is eligible for telework up to 5 days a week, in accordance with the Statewide Telework Policy, and will be required to report to the office as needed/required. A teleworker is considered remote-centered if they work fifty percent or more of their time from an alternate work location. The successful candidate must reside in California upon appointment.
Under the general direction of the Chief Information Officer (Information Technology Manager I), the incumbent will perform a wide variety of database administration, including maintenance of database systems. Ensure the availability, reliability, and performance of production and development databases. Conduct regular performance tuning and capacity planning to accommodate growing data volumes and user demands. Develop complex queries and ETL processes within Microsoft SQL Server, PostgreSQL, and other commercial database platforms. Additional duties will include development and maintenance of database documentation, including data dictionaries, schema diagrams, and other technical documentation. You will find additional information about the job in the .
Working Conditions Conflict of Interest
This position is designated under the Conflict of Interest Code. The position is responsible for making or participating in the making of governmental decisions that may potentially have a material effect on personal financial interests. The appointee is required to complete Form 700 within 30 days of appointment.
Special Requirements Candidates that believe they meet the Minimumqualifications based on a pattern of education from the classificationdescription (specifications) must provide a copy of your degree/transcriptsand/or license along with your application (STD. 678) to be considered for thisposition. If selected for the position official sealed transcriptswill be required prior to appointment. Individuals who are new to state service must have listeligibility in order to gain employment with any state agency. Clickhere to learn more about examinations available online . DO NOT include any confidential information to your application or supportingdocuments (i.e., Social Security Number, birthdate, marital status, medicalinformation, examination results, method of eligibility, etc.) SROA/SURPLUS Applicants: You must check the SROA/Surplus asyour claimed method of eligibility and attach your SROA/Surplus letter as anadditional document. 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:
Experience in developing and orchestrating data pipelines using Azure Data Factory, facilitating the seamless flow and transformation of data across various sources and destinations. Experience in developing and deploying dashboards using Azure services like Power BI, providing actionable insights to technical and business-oriented stakeholders. Capable of effectively communicating with both highly technical and business-focused stakeholders. Benefits There are many benefits to joining our team!The State of California has a generous benefits package, some benefits include:
Medical Benefits, including health, dental, and vision insurance Paid Holidays and leave Defined benefit retirement program Savings Plus Program (401(k), 457) Commute Program Employee Wellness Program Employee Assistance Program Medical/Dependent Care Reimbursement Account Some added benefits include: Flexible Work Hours, Telework Opportunities, Health, Dental & Vision Benefits, Paid Sick & Vacation, Retirement, Basic Group Term Life Insurance, Employee Assistance Program, 11 Paid Holidays, 401(k) & 457 plans, Military Leave, Student Loan Forgiveness, Long Term Care, Group Legal Services, and Reimbursement Accounts.
Additional Instructions Ifsubmitting your completed Application Package by mail or hand delivery, you must include thePosition #******** and the Job Control # JC-433176 in the "Examinationor Job Title for which you are applying" section on the STD. 678. Note: Ifyou are applying for multiple positions, you must complete a STD. 678 for eachposition separately. Incomplete applications or applications received with multiplepositions listed on one application will not be considered.
Employment History onthe STD 678 must be complete and include dates, accurate hours per week, totaltime worked, duties and responsibilities, and contact names and phone numbersof supervisors. Failure to submit a completed STD 678 may result in you beingscreened out. Only the most qualified candidates will be invited to aninterview. 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.
