Job Posting

Job Description and Duties

The tasks for the Senior DB2 DBA include, but are not limited to, the following:

• Support of the development environment for SFO and Batch.

• Development of and support of integration between SQL Server and DB2 databases from and to SQL Server and

DB2 and vice versa.

• Develop and implement DB2 Stored Procedure verification tools that assists developers and operations with problematic

Store procedures.

• Develop and implement “DB2 Reorganize procedures” that automatically selects and “reorgs” tables based upon

pre-selected criteria without interrupting production performance or activity.

• Analyze and evaluate anomalies in the BMC Logmaster product and set up procedures that will prevent future anomalies

that corrupt production data.

• Develop and implement and support procedures for the synchronization between different environments.

• Develop and implement and support proactive tools for DB2 environments (lock escalation report).

• Evaluate new products (IBM, BMC, CA)

• Maintain the “Policy database split” that significantly increased table’s availability.

• Develop and implement local and remote database backup procedures to increase nightly batch window times.

• Review SQL statements for accuracy and impact

• Provide training to explain DBA procedures, communicate both to non-technical users and to technical personnel on

DBA team, Applications teams, and to Mainframe Data Center teams.

• Provide generalist DB2 databases tasks, provide technical coverage for DB2 databases when the primary DBA

unavailable including after hours support on weekends.

• Mentor new SCIF employee DBA if needed.

Working Conditions

This job may be extended to a 24 month Limited Term appointment.

Minimum Requirements

You will find the Minimum Requirements in the Class Specification.

STAFF INFORMATION SYSTEMS ANALYST (SPECIALIST)

Additional Documents

Job Application Package Checklist

Position Details

Job Control Details
Job Code #:	JC-63557
Position #(s):	402-415-1312-XXX
Working Title:	Senior DB2 DBA
Classification:	STAFF INFORMATION SYSTEMS ANALYST (SPECIALIST) $5,295.00 - $6,963.00 A

# of Positions:	1
Work Location:	Solano County
Job Type:	12 Month Limited Term - Full Time

Department Information

State Fund is California’s largest provider of workers’ compensation insurance. Established in 1914 by the state legislature, we offer diverse and comprehensive products and services that provide a strong and stable option for employers and injured employees with fast, reliable claims service and medical and indemnity benefits.

Our culture centers on our purpose and values. We exist to provide fairly priced workers' compensation insurance, make workplaces safe, and restore injured workers. We recognize and reward high performance, yet value a healthy work/life balance.

Department Website: www.statefundca.com

Application Instructions

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.

Final Filing Date: Until Filled

Who May Apply

Individuals who are currently in the classification, eligible for lateral transfer, eligible for reinstatement, eligible for a Training and Development assignment, have SROA and/or Surplus eligibility, or have list eligibility (or are in the process of obtaining list eligibility). SROA and Surplus candidates may attach “surplus letters” to their applications.

Applications will be screened and only the most qualified applicants will be selected for an interview.

How To Apply

Complete Application Packages (Applications and any applicable or required documents) must be submitted electronically through your CalCareer account at www.jobs.ca.gov.

Required Application Documents

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

Electronic State Employment Application through your Applicant Account at www.jobs.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.

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:

Technical Skills and Experience:

• 4+ years technical knowledge and experience with most of the following systems, platforms, applications

• IBM Z/OS Mainframe environment

• Knowledge of data conversion and integration processes and procedures and practices between DB2 and SQL

Server 2008 and 2012

• DB2 Version 8

• DB2 DBA skills with hands on in a production database

• Backup and recovery scenarios including Disaster Recovery

• Data Propagator, CA Insight, BMC toolset, IBM toolset, Data Joiner, or DB2 connect

• TSO / ISPF skills, Z/OS JCL

• Explain reports, Work Load Manager Stored Procedures, performance tuning

• Maintain DB2 relational databases

• IBM DB2 Utilities and BMC DB2 Administration, Backup, Recovery and Utilities

• Providing end user support and customer service management

• Responding to email, clients, support calls, IT management

• Tracking, monitoring, and reporting IT jobs and processes using various software products

• Communicate and prepare management reports to IT management and end users

• Sharing knowledge with other team members and mentoring/coaching employees

Benefits

State Fund employees are eligible for a number of benefits. Our benefit package includes:

Health Benefits Program (CalPERS), Retirement (CalPERS ), Employer Health and Consolidated Benefits Contributions, Dental, Vision, 401(k) and 457 Deferred Compensation Plans, Employee Assistance Program, Group Legal Services Insurance, Holidays, Vacation/Sick/Other Paid Leave, Flex Elect Reimbursement Program, Wellness and Recognition, Alternate Work Schedules, Transit Pass Program, Tuition Reimbursement, Dependent Scholarship Program, Leadership Training, Mentoring Program

Contact Information

The Human Resources Contact is available to answer questions regarding the position or application process.

Human Resources Contact:
Leslie Maqueda
(800) 499-8668

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:
Rosa Gil-Robles
(323) 981-6707

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.

BACKGROUND INVESTIGATION

Prior to employment with State Compensation Insurance Fund, a background investigation (BI) will be conducted.

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.