|
|
|
|
| Job Title: |
Data Systems Coordinator (DB2 Database Administrator), LACERA
|
| Salary: |
$6,511.36 Monthly
$78,136.32 Annually
|
| Job Type: |
Full-Time Temporary |
| Location: |
Pasadena, California
|
| |
| |
|
|
| THIS EXAMINATION WILL REMAIN OPEN UNTIL LACERA'S HIRING NEEDS ARE MET, AND IS SUBJECT TO CLOSURE WITHOUT PRIOR NOTICE. THE EXCITING CAREER OPPORTUNITY: The Los Angeles County Employees Retirement Association (LACERA), has a challenging opportunity for an experienced, detail oriented and proactive Data Systems Coordinator (DB2 Database Administrator)to join our Systems Team. Located in the beautiful town of Pasadena, the Los Angeles County Employee's Retirement Association (LACERA) administers and manages the retirement fund for the County of Los Angeles, the largest county retirement system in the U.S. serving more than 151,000 members. Our organization is comprised of many exciting career areas. From early career seekers to senior level executives. We have a position that is sure to fit your interests. Career areas: Accounting, Administrative Services, Claims Processing, Communications, Disability Litigation, Disability Retirement, Executive, Human Resources, Internal Audit, Investments, Legal, Member Services, Quality Assurance, Retiree Healthcare, and Systems (IT). We offer an excellent benefits package. Please go to the benefits tab of this bulletin for more details. |
|
ESSENTIAL JOB FUNCTIONS:
|
| The position will be supporting a large DB2 database utilizing version 7.1 in a z/OS environment. The duties may include but are not limited too: Problem resolution, database configuration, capacity planning and performance tuning; Provide support to application developers; Perform day to day database operations; Administer technical design, testing, and implementation of new databases; Define, document, and implement backup procedures. |
|
REQUIREMENTS:
|
| SELECTION REQUIREMENTS: Four years' systems analysis and design experience, including extensive experience supporting a large DB2 database utilizing version 7.1 in a z/OS environment, one year of which must have been in a highly responsible capacity at the level of Data Systems Analyst II, LACERA or EDP Programmer Analyst II, LACERA. LICENSE: A valid California Class C Driver License or the ability to utilize an alternative method of transportation when needed to carry out job-related essential functions. PHYSICAL CLASS: 2 - Light. |
|
ADDITIONAL INFORMATION:
|
DESIRABLE QUALIFICATIONS: - Five or more years' of systems analysis and design experience including extensive experience supporting a large DB2 database utilizing version 7.1 in a z/OS environment.
- Demonstrated experience in migrating from a DB2 version 7 to version 8 or 9.
- Demonstrated experience working in a z/OS environment and related utilities.
- Demonstrated experience in JCL.
- Demonstrated experience in disaster recovery planning.
- Demonstrated experience in DB2 UDB.
- Strong analytical, troubleshooting and resolution skills.
- Demonstrated experience managing multiple databases.
- Excellent verbal and written communication skills.
To receive credit for the above desirable qualifications, your application must clearly describe your experience. EXAMINATION CONTENT: Each candidate’s background will be evaluated on the basis of information submitted at the time of filing to determine the level and scope of the candidate’s preparation for this position. The candidates with the highest qualifications as determined by the screening process will be invited to the interview weighted 100%. The interview will be designed to assess knowledge, education, experience, personal fitness, and general ability to perform the duties of the position. CANDIDATES MUST ACHIEVE A PASSING SCORE OF 70 PERCENT OR HIGHER ON THE EXAMINATION IN ORDER TO BE PLACED ON THE ELIGIBLE REGISTER. VACANCY INFORMATION: The resulting eligible register will be used to fill temporary appointments in LACERA's Systems Division:Platform Technology unit. ELIGIBLE INFORMATION: The names of candidates receiving a passing grade in the examination will be placed on the eligible register in the order of their score group for a period of six (6) months following the date of promulgation. SPECIAL INFORMATION: APPLICATION INFORMATION TO APPLY ONLINE GO TO: http://www.lacera.com and click on the Career Opportunity link. Applicants, who apply Online, must provide the appropriate attachments during application submission or fax a photocopy of the required documents to (626) 564-6699 within five (5) days of filing Online. Please include the examination number and examination title on the documentation. Please complete the Supplemental Questionnaire and submit it with your application. AN APPLICATION SUBMITTED WITHOUT THE SUPPLEMENTAL QUESTIONNAIRE WILL BE REJECTED AS INCOMPLETE. Applicants applying online can check the status of their applications at anytime by logging into their account on www.governmentjobs.com. Faxed applications will not be accepted. Resumes will not be accepted in lieu of a completed application. You may complete and submit a hardcopy application and any required documentation in person or by United States Mail to: LACERA Human Resources Office 300 North Lake Avenue, Suite 650 Pasadena, CA 91101-4199 The acceptance of your application depends on whether or not you have clearly shown that you meet the SELECTION REQUIREMENTS. In the space provided for education, include the names and addresses of schools attended, titles of courses completed, dates completed, and number of credits and/or certificates earned. In order to receive credit for any college course work, or any type of college degree, such as an Associate, Bachelor, Master, or Doctorate degree, or for completion of a certificate program, you must include a legible copy of the official diploma, official transcripts, or official letter from the accredited institution* which shows the area of specialization; or official certificates with your application. *Accredited institutions are those listed in the publications of regional, national or international accrediting agencies which are accepted by the Department of Human Resources. Publications such as American Universities and Colleges and International Handbook of Universities are acceptable references. Also acceptable, if appropriate, are degrees that have been evaluated and deemed to be equivalent to degrees from United States accredited institutions by an academic credential evaluation agency recognized by The National Association of Credential Evaluation Services or The Association of International Credential Evaluators, Inc. For each job held, give the name and address of your employer, your job title, beginning and ending dates, description of work performed, and salary earned. Part-time experience will be evaluated on the basis of its fractional equivalent of a 40-hour workweek. All required experience must be paid. This position may require working evenings, weekends, and holidays. All information supplied by applicants is subject to verification. Applications may be rejected at any stage of the selection process. VETERAN'S CREDIT Veteran’s Preference Credit of 10 points will be added to the final passing grade in any open competitive examination if you are an honorably discharge veteran who served in the Armed Forces of the United States: a. During a declared war; or b. During the period April 28, 1952 through July 1, 1955; or c. For more than 180 consecutive days, other than for training, any part of which occurred after January 31 1955, and before October 15, 1976; or d. In a campaign or expedition for which a campaign medal or expeditionary medal has been authorized and awarded. This also applies to the spouse of such person who, while engaged in such service was wounded, disabled or crippled and thereby permanently prevented from engaging in any remunerative occupation, and also to the widow or widower of any such person who died or was killed while in such service. A DD214, Certificate of Discharge or Separation from Active Duty, or other official documents issued by the branch of service are required as verification of eligibility for Veterans’ preference. If you are unable to provide any documentation at the time of filing, the 10 points will be withheld until such time as it is provided. EMPLOYMENT ELIGIBILITY INFORMATION: Final appointment is contingent upon verification of U.S. citizenship or the right to work in the United States. Immigration law provides that all persons hired after November 6, 1986, are required to present original documents to the County, within three (3) business days of hiring, which show satisfactory proof of: 1) identity and 2) U.S. employment eligibility. A criminal background investigation, including a fingerprint search will be conducted prior to appointment through the State and Federal Departments of Justice following a conditional job offer. Employment is contingent upon passing this process. |
| |
|
|
