California State Controller's seal

(267) Information Technology Specialist I

Applicants with disabilities who need reasonable accommodations, such as a Sign Language interpreter, a reader, or assistance attending an interview please call (916) 323-3055.

051-340-1402-045

$5562.00 - $8999.00

9/23/2020

Denise Middleton (916) 323-6695

Information Systems Division
300 Capitol Mall Suite 634
Sacramento, CA 95814

November 3, 2020

Individuals who are currently in this classification, or are eligible for lateral transfer or promotion, or are reachable on a certification list may apply.  

For permanent positions, SROA and surplus candidates should attach “surplus letters” to their application.  Failure to do so may result in your application not being considered.

Submit application package electronically via your CalCareers account or to address below:  

State Controller’s Office
Human Resources Office
ATTN: Classification Unit - AP
300 Capitol Mall, Ste. 300
Sacramento, CA 95814

Application package must include all the required documents.  Mailed application package must include either ARF # 21-024 or Position #051-340-1402-045 in the job title section.  Application received without this information may be rejected.   

Looking for a job that you can feel passionate about?  Looking for work in an inviting work environment?  If you are interested in working in a fast-paced environment surrounded by enthusiastic and self-motivated people, then look no further!  The Office of the State Controller (SCO) is the destination Constitutional employer within the State of California.

The following link outlines a summary of benefits available to state employees: https://www.calhr.ca.gov/Pages/California-State-Civil-Service-Employee-Benefits-Summary.aspx

Applications will be screened and only the most qualified will be interviewed. Application must include “to” and “from” employment dates (m/d/y), hours per week, and prior employer contact information including contact number.  Applications received without this information may not be considered for this position.

The selected candidate considered for the advertised position will be required to undergo a fingerprint clearance and any offer of employment will be contingent upon live scan fingerprint results.

Scope of Position:

Under the general direction of the Information Technology Supervisor II, the Information Technology Specialist I is the lead expert who performs the most complex database software design, specifications, implementation, changes, problem identification and resolution, and administration for SCO business systems.  There are 18 systems utilizing Computer Associates (CA) Integrated Database Management System (IDMS) and 3 systems utilizing IBM’s DB2 universal database software operating in an IBM z/OS in development, test, and production environments within the SCO and the California Department of Technology (CDT) mainframe infrastructure.  The incumbent works independently and as part of a team to perform highly critical and data sensitive technical tasks to assure the department receives maximum use and value from its data, database and information resources.  The incumbent leads discussion, direction and decisions with the Information Systems Division (ISD) and the Information Security Office (ISO) staff in the architecture, high-availability, integrity, security, and scalability of databases to comply with the department’s strategic plan, align with business goals, and meet enterprise security guidelines and data architecture standards. 

Duties and Responsibilities:

(Candidates must perform the following functions with or without reasonable accommodations.)

  • Provide expert level IDMS and DB2 support to independently act and make decisions on complex database proprietary software products, CA’s IDMS and IBM’s DB2, in support of 21 business systems.  Collaborate with the CDT staff on configuration, backup, and support services.  Assist application programmers to migrate database changes from the development environment, to user acceptance testing all the way through to the production environment.  Participate in legacy business system replacement projects, which includes mainframe database components.            
  • Define, configure and test database logical and physical design using IDMS and DB2 software tools and utilities.  Collaborate with the CDT database peers to build and maintain development, test, and production environments.  Use database management tools and utilities to monitor database performance tuning for optimal efficiency; analyze, monitor and report on database capacity usage, recommend actions for data growth.  Perform database expansions to expand capacity when thresholds are met.  Coordinate with the CDT, business customers, and other ISD technical staff to schedule expansion during non-business hours.  Lead database software testing for operating system (z/OS) upgrades, which occur regularly as part of mainframe infrastructure refresh.  Coordinate database testing activities with application developers, ISO staff, mainframe support staff, and the CDT.  Identify all problems noted during testing and lead the effort to resolve them prior to implementation.  Define, load, and restructure databases using IDMS and DB2 software tools based on performance and program need changes.  Assess impact of changes to mainframe infrastructure and other software interfaces or compatibility.  Re-create, identify root cause, test, and resolve all technical and production software problems.  Create and maintain all system, technical documentation, Bachman diagrams to administer IDMS. 
  • Plan, research, evaluate, test and implement IDMS and DB2 software version upgrades.  Coordinate activities with the CDT staff, the Information Security Office staff, and application programmers.  Conduct tests to ensure security requirements are met; validate new features and functions, and monitor the impact to database design, functionality, and performance.  Create views, stored procedures, and user-defined functions.  Identify, test, and resolve all problems.  Keep current on software technology trends, industry best practices, and processes.  Assist ISD staff with updates to IDMS database dictionaries and maintain the DB2 catalog. 
  • Participate in operational recovery drills twice a year with the CDT specific to IDMS database restoration during a data center outage.  Create and/or maintain all operational recovery related documentation.   

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, hair style and texture, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding and related medical conditions), and sexual orientation. Rev. 02/2020