INFORMATION TECHNOLOGY SPECIALIST II

The position: (s) being advertised may be subject to allocation approval by the Human Resources Branch. Fingerprint/Criminal Record Clearance is required before hire. The Salary Range shown is the minimum and maximum for a full‐time appointment. Moving and relocation expenses will not be reimbursed for this position.

Working Conditions: Part‐time telework available. Telework requires California residency. This position offers hybrid telework opportunities; however, telework arrangements are subject to change at any time based on State & departmental operational needs. Employees may be required to report to the office as necessary. DMV operates 24 hours a day, 7 days a week. The incumbent may be required to carry a work cell phone and laptop. There may also be times when the incumbent is required to attend an out‐of‐town conference, or work evenings and weekends to maintain project schedules. The position may be required to occasionally report to the designated office location in DMV headquarters at 2415 First Avenue, Sacramento, California, 95818. Travel expenses related to reporting to designated office is employee's own responsibility and is not eligible for reimbursement.

Minimum Requirements: You will find the Minimum Requirements in the Class Specification. INFORMATION TECHNOLOGY SPECIALIST IIClassification: INFORMATION TECHNOLOGY SPECIALIST II $8,625.00 - $11,557.00 A New to State candidates will be hired into the minimum salary of the classification or minimum of alternate range when applicable.# of Positions:1

Work Location: DMV Headquarters, Sacramento, California Telework: Hybrid

Job Type: Permanent, Full Time

Work Shift: 8:00 a.m. to 5:00 p.m. Work Week: Monday through Friday Department Information The Department of Motor Vehicles (DMV) is a recognized leader in public service and has existed for over 100 years. The DMV is responsible for registering approximately 36 million vehicles in California, and serving 34 million driver license and identification card holders, collecting over $14 billion in annual revenue. The DMV also maintains and oversees many other functions. The DMV provides quality licensing and motor vehicle‐related services in its field offices located throughout California and online at www.dmv.ca.gov

The position: (s) require(s) a Background Investigation be cleared prior to being hired. Applicants must be eligible for appointment (e.g., must take and pass examination); see Who May Apply section below for more information. Additionally, applicants must have authorization to work in the United States. Please note that we are unable to provide visa sponsorship at this time. Completed applications and all required documents must be received or postmarked by the Final Filing Date in order to be considered. Dates printed on Mobile Bar Codes, such as the Quick Response (QR) Codes available at the USPS, are not considered Postmark dates for the purpose of determining timely filing of an application. Required Application Package Documents 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 www. Cal Careers.ca.gov. 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 A written response to the item(s) listed in the Written Response section below, no more than 2 page(s) in length with no less than Arial 12‐point font and 1‐inch margins, submitted as a separate document. A resume does not take the place of a written response. Written responses may be similar in format to a Statement of Qualifications. Be sure to follow all instructions closely. For helpful tips on crafting a strong SOQ, view CalHR's video at https://www.youtube.com/watch?v=NA-mGmyx1TY. Candidates are advised to:use simple formatting (avoid justified text, large text boxes, or custom bullets), use standard fonts like Arial or Times New Roman, left‐align the text, save the written response as a PDF document, and "flatten" it before uploading by printing to PDF or using the "Save as PDF" feature, andsubmit or upload the written response PDF document as part of the application package. Applicants requiring reasonable accommodations for the hiring interview process must request the necessary accommodations if scheduled for a hiring interview. The request should be made at the time of contact to schedule the interview. Questions regarding reasonable accommodations may be directed to the EEO contact listed on this job posting.

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 administering and supporting mission‐critical Oracle database environments with a focus on high availability, performance, security, and disaster recovery. Extensive experience with Oracle RAC, Data Guard, RMAN, ASM, Multitenant (CDB/PDB), Exadata, Golden Gate, and Oracle Enterprise Manager (OEM). Experience administering Oracle Cloud Infrastructure (OCI), including Database Services, Exadata Cloud Service, Autonomous Database, IAM, Vault, Monitoring, Backup, and Disaster Recovery. Experience planning, testing, and implementing Oracle Release Updates (RU), Grid Infrastructure, Exadata, database, middleware, and operating system patching while minimizing business impact and ensuring compliance with security requirements. Experience leading database upgrades, migrations, cloud modernization initiatives, and technology refresh projects. Expert knowledge of Oracle performance tuning, SQL and PL/SQL optimization, AWR/ASH analysis, execution plans, indexing, capacity planning, and root cause analysis. Experience implementing backup and recovery, high availability, replication, database security, encryption, auditing, vulnerability remediation, and compliance controls. Experience supporting ETL/ELT processes, data integrations, and large‐scale data migrations across Oracle, SQL Server, PostgreSQL, Snowflake, and cloud platforms. Proficient with TOAD for Oracle, Oracle SQL Developer, Oracle Enterprise Manager (OEM), SQL*Plus, SSMS, pg Admin, SnowSQL, Moba Xterm and database monitoring tools. Experience developing automation solutions using PL/SQL, Python, Shell scripting, Power Shell, REST APIs, OCI CLI, Terraform, or Ansible. Working knowledge of SQL Server, PostgreSQL, Snowflake, Azure, AWS, Salesforce, and Service Now. Strong leadership, communication, troubleshooting, project management, and mentoring skills supporting enterprise database and cloud modernization initiatives. The Department of Motor Vehicles and the State of California offer many benefits to its employees. These include health, vision, and dental benefits; retirement plans (CalPERS); savings plans (401K and 457b); leave benefits; insurance (such as group legal insurance and group long term disability insurance); and employee assistance program. Benefits may be based on the job classification, bargaining unit, tenure, time basis, and length of appointment. Click on each web link below for more information.

Hiring Unit Contact: William Chan(916) 398‐6610 Please direct requests for Reasonable Accommodations to the interview scheduler at the time the interview is being scheduled. You may direct any additional questions regarding Reasonable Accommodations or Equal Employment Opportunity for this position(s) to the Department's EEO Office.

EEO Contact: Office of Civil Rights and Resolution(916) 657‐7553 California Relay Service: 1-800-735-2929 (TTY), 1-800-735-2922 (Voice) TTY is a Telecommunications Device for the Deaf, and is reachable only from phones equipped with a TTY Device.

Equal Opportunity Employer: The State of California is an equal opportunity employer to all, regardless of age, ancestry, color, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding and related medical conditions), and sexual orientation. It is an objective of the State of California to achieve a drug‐free work place. Any applicant for state employment will be expected to behave in accordance with this objective because the use of illegal drugs is inconsistent with the law of the State, the rules governing Civil Service, and the special trust placed in public servants.