Skip to main content
Menu

Information Systems Analyst V - DBA

Recruitment #0814-RI1005-01

Introduction

This examination is being given to fill one (1) vacancy in the Information Systems Division and to establish an eligible list which may be used to fill future vacancies.

On June 11, 2014, the Civil Service Commission approved the request to fill this position through a recruitment with selective criteria.  The selective criteria does require experience as an Oracle Database Administrator using the Oracle 11g product line.  Please see below the minimum qualifications for this selective criteria recruitment.

Resumes will not be accepted in lieu of an application. A completed application must be postmarked or received online by the final filing deadline.

NOTE: All correspondences relating to this recruitment will be delivered via e-mail. The e-mail account used will be the one provided on your employment application during time of submittal. Please be sure to check your e-mail often for updates. If you do not have an e-mail account on file, Human Resources will send you correspondences via US Mail.

TYPICAL DUTIES

  • Assumes responsibility for developing, directing and ensuring operational availability and security of the County's most complex and strategic operations including mainframe, networked and database systems.
  • Performs comprehensive systems analysis to design and develop new systems and enhancements to current systems; consults, confers and coordinates activities with users, staff from various departments, outside agencies and vendors to resolve program, system, operational and procedural problems; analyzes problems and recommends corrective action.
  • Plans, develops and analyzes additions, changes and enhancements to mainframe system software; researches, evaluates, installs and implements new versions and releases for integration into existing systems; determines impact on existing County systems and applications; troubleshoots, analyzes and resolves hardware and software related problems; coordinates and documents testing procedures.
  • Serves as technical resource in architecting wide area network and Internet/Intranet growth that supports the County's strategic direction; directs, plans and coordinates the development, implementation and maintenance of the County's Internet and Intranet sites to ensure service availability and connectivity to County departments.
  • Develops and administers strategies, policies and procedures for network availability and security; designs and implements firewall strategies to ensure County data security and integrity.
  • Installs and maintains new and upgraded software for database management systems; establishes procedures for database operation, control and recovery.
  • Serves as technical advisor for data planning, modeling, conceptual and physical design of database entities; updates and maintains County data dictionary.
  • Ensures database availability to system users; provides controls, grants and revokes user access; develops standards and strategies for maintaining database security and integrity; monitors users to ensure compliance with operational and security procedures; performs database management duties; provides support to information technology staff in planning, designing and implementing highly complex databases; designs, creates, maintains and modifies database structure, tables, files, views, and indexes; manages database and file space allocation; develops methodologies to export data from mainframe environment to other platforms; makes recommendations on strategies to meet future storage requirements.
  • Develops, maintains and enforces data resource management standards and procedures; develops standards and strategies for data recovery.
  • Serves as project leader on information systems projects; analyzes client information system needs; recommends solutions and appropriate technology to meet client needs; designs project and resource plans and schedules; develops proposals using cost/benefit analyses; evaluates proposed system hardware and software to ensure compatibility with existing systems; oversees the installation and evaluation of software and hardware; controls and reports budget expenditures; directs members of the project team; provides written reports and presentations on project status.
  • Performs technical writing duties in the development and production of highly complex system documentation, instructional and procedural manuals.
  • Trains assigned project staff in their areas of work including system, network and database design, development, and programming methods, procedures and techniques.
  • Attends and participates in professional group meetings; stays abreast of new trends and innovations in the field of information technology.
  • MINIMUM QUALIFICATIONS

    Either I

    **Experience:  One year as an Information Systems Analyst IV in San Joaquin County with responsibility as an Oracle Database Administrator using the Oracle 11g product line.

     

    Note:  This requirement shall be waived for individuals employed within the Information Systems Division in the San Joaquin County classes of Senior Office Systems Analyst and Senior Systems Programmer on September 13, 2000.   Individuals employed within the Information Systems Division in the San Joaquin County classes of Systems and Programming Analyst IV, Systems and Procedures Analyst II or Systems and Programming Coordinator on September 13, 2000 shall receive credit for their experience in those classes on a year-for-year basis.

    Or II

    Education: Graduation from an accredited four-year college or university with a major in computer science, information systems, mathematics, business administration or a related field   

    And

    **Experience: :Four years of increasingly responsible professional, analytical computer and related systems work as an Oracle Database Administrator with at least one year of experience using the Oracle 11g product line.  

    Substitution #1:  Possession of an approved information systems technology certificate, or completion of an approved information systems training course may substitute for all or part of the above required education. A list of approved certificates and/or courses shall be maintained within the Human Resources Department.

     

    Substitution #2:   Additional qualifying experience may substitute for the above required education on a year-for-year basis to a maximum of two years.

     

    **Note: The above special recruitment requirements were approved by the Civil Service Commission on 6/11/14.

    KNOWLEDGE

    Operations, services and activities of a comprehensive information systems program across multiple operating platforms; advanced principles and practices of system design, development, analysis, testing and security administration; advanced methods and techniques of evaluating business requirements and developing information systems solutions for strategic County systems; principles and practices of project management; advanced principles and practices of programming languages, job control languages, and executive control command; advanced principles and practices of system software and hardware installation and troubleshooting; functional structure of various operating system components, including system control programs and data access methods; advanced concepts, principles and practices of Internet and Intranet web site design, development and administration; advanced concepts, principles and practices of wide area network design, development, protocols, security and administration; operations, services and activities of a comprehensive database administration program; advanced programming techniques including integrated database management applications; advanced methods and techniques of developing data security, integrity, backup and recovery processes; advanced principles of database design, administration, management and integrity; principles and concepts of relational database management systems; principles and concepts of data planning, modeling, design and storage; operational characteristics of database support tools, servers and communication devices; principles of lead supervision and training; methods and techniques of developing complex application technical user manuals and documentation; pertinent Federal, State and local laws, codes and regulations.

    ABILITY

    Direct and coordinate technical operations and services in assigned systems area; serve as technical advisor in assigned systems area; analyze department procedures and data to develop logical solutions to complex systems problems; recommend, evaluate, design, develop, test and install complex operating systems, applications and supporting hardware and software; plan, develop, establish, monitor and maintain system security strategies in assigned systems area; provide advanced level technical support for the implementation and maintenance of mainframe software systems; perform operational functions on mainframe systems; plan and oversee quality assurance and security procedures for mainframe, database, and network systems; provide support to complex wide are network design and implementation projects; troubleshoot and analyze complex local and wide area network operating, hardware and software problems; design and manage physical storage structures; develop strategies to accommodate future data storage needs; evaluate database needs and develop database models to meet County information technology needs; as assigned, lead and review the work of project staff; prepare clear and concise technical reports and documentation; communicate clearly and concisely, both orally and in writing; establish and maintain effective working relationships with those contacted in the course of work.

    PHYSICAL/MENTAL REQUIREMENTS

    Mobility-Frequent use of keyboards; frequent sitting, standing or walking for long periods; occasional pushing/pulling, bending, squatting and crawling; driving; Lifting-Frequently 5-30 pounds; occasionally 70 pounds or less; Vision-Constant use of good overall vision; frequent reading/close-up work; occasional color, depth and peripheral vision; Dexterity-Frequent repetitive motion; frequent writing; frequent grasping, holding, reaching; Hearing/Talking-Frequent talking/hearing in person and on the telephone; Emotional/Psychological-Frequent decision making and concentration; frequent public contact; occasional working alone, working nights and traveling; Environmental-Frequent exposure to noise.

    BENEFITS

    Health Insurance:  San Joaquin County provides employees with a choice of three health plans:  a Kaiser Plan, a Select Plan, and a Premier Plan.  Employees pay a portion of the cost of the premium. Dependent coverage is also available. 

    Dental Insurance:  The County provides employees with a choice of two dental plans:  Delta Dental and Pacific Union Dental.  There is no cost for employee only coverage in either plan; dependent coverage is available at the employee’s expense.

    Vision Insurance:  The County provides vision coverage through Vision Service Plan (VSP).  There is no cost for employee only coverage; dependent coverage is available at the employee’s expense.

    For more detailed information on the County’s benefits program, visit our website at www.sjgov.org under Human Resources/Benefits. 

    Life Insurance:  The County provides eligible employees with life insurance coverage as follows: 

     1 but less than 3 years of continuous service:                   $1,000
     3 but less than 5 years of continuous service:                   $3,000
     5 but less than 10 years of continuous service:                 $5,000
    10 years of continuous service or more:                           $10,000
     

    Employee may purchase additional term life insurance at the group rate.

    125 Flexible Benefits Plan:  This is a voluntary program that allows employees to use pre-tax dollars to pay for health-related expenses that are not paid by a medical, dental or vision plan (Health Flexible Spending Account $2080 annual limit); and dependent care costs (Dependent Care Assistance Plan $5000 annual limit).

    Retirement Plan:  Employees of the County are covered by the County Retirement Law of 1937.  Please visit the San Joaquin County Employees’ Retirement Association (SJCERA) at www.sjcera.org for more information.  NOTE:  If you are receiving a retirement allowance from another California county covered by the County Employees’ Retirement Act of 1937 or from any governmental agency covered by the California Public Employees’ Retirement System (PERS), you are advised to contact the Retirement Officer of the Retirement Plan from which you retired to determine what effect employment in San Joaquin County would have on your retirement allowance.

    Deferred Compensation:  The county maintains a deferred compensation plan under Section 457 of the IRS code. You may annually contribute $17,500 or 100% of your includible compensation, whichever is less. Individuals age 50 or older may contribute to their plan, up to $23,000.

    Vacation:  Maximum earned vacation is 10 days each year up to 3 years; 15 days after 3 years; 20 days after 10 years; and 23 days after 20 years.

    Holiday:  For current Civil Service employees:  14 paid holidays per year.  For new employees:  10 paid holidays per year.

    Sick Leave:  12 working days of sick leave annually with unlimited accumulation.  Sick leave incentive:  An employee is eligible to receive eight hours administrative leave if the leave balance equals at least one- half of the cumulative amount that the employee is eligible to accrue.  The employee must also be on payroll during the entire calendar year.

    Bereavement Leave3 days of paid leave for the death of an immediate family member, 2 additional days of accrued leave for death of employee’s spouse, domestic partner, parent or child.

    Merit Salary Increase:  New employees will receive the starting salary, which is the first step of the salary range.  After employees serve 52 weeks (2080 hours) on each step of the range, they are eligible for a merit increase to the next step.

    Job Sharing:  Employees may agree to job-share a position, subject to approval by a Department Head and the Director of Human Resources.

    Educational Reimbursement Program:  Eligible employees may be reimbursed for career-related course work up to a maximum of $850 per fiscal year.  Eligible employees enrolled in an approved four (4) year College or University academic program may be reimbursed up to $800 per semester for a maximum of $1600 per fiscal year.

    Parking Supplemental Downtown Stockton:  The County contributes up to $17 per pay period for employees who pay for parking and are assigned to work in the Downtown Core Area.

    School Activities:  Employees may take up to 40 hours per year, but not more than eight (8) hours per month, to participate in their children’s school activities.

    Selection Procedures

    Applicants who meet the minimum qualifications will go through the following examination process:

    • Written Exam: The civil service written exam is a multiple choice format.  If the written exam is administered alone, it will be 100% of the overall score.  Candidates must achieve a minimum rating of 70% in order to be placed on the eligible list.
       
    • Oral Exam:   The oral exam is a structured interview process that will assess the candidate’s education, training, and experience and may include a practical exercise.   The oral exam selection process is not a hiring interview.   A panel of up to four people will determine the candidate’s score and rank for placement on the eligible list.  Top candidates from the eligible list are referred for hiring interviews.  If the oral exam is administered alone, it will be 100% of the overall score.  Candidates must achieve a minimum rating of 70% in order to be placed on the eligible list. 
       
    • Written & Oral Exam:  If both a written exam and an oral exam is administered, the written exam is weighted at 60% and the oral exam is weighted at 40% unless otherwise indicated on the announcement.  Candidates must achieve a minimum rating of 70% on each examination in order to be placed on the eligible list.
       
    • Rate-out:  A rate-out is an examination that involves a paper rating of the candidate’s application using the following criteria: education, training, and experience. Candidates will not be scheduled for the rate-out process. 

     Note:  The rating of 70 referred to may be the same or other than an arithmetic 70% of the total possible points.

    Testing Accommodation:  Candidates who require testing accommodation under the Americans with Disabilities Act (ADA) must call Human Resources Division at (209) 468-3370 prior to the examination date.   

    Veteran’s Points:  Eligible veterans, unmarried widows and widowers of veterans of the United States Armed Forces who have been honorably discharged and who have served during wartime shall be given veteran’s points in initial appointment to County service.  Eligible veterans receive 5 points and eligible disabled veterans receive 10 points. Disabled veterans must submit a recent award letter stating a 10% service connected disability issued by the United States Veterans Administration.  Note:  A copy of your DD214 showing the discharge type must be received in the Human Resources by the date of the examination.

    Acceptable wartime service dates:

    • September 16, 1940 to December 31, 1946

    • June 27, 1950 to January 31, 1955

    • August 5, 1964 to May 7, 1975

    • Persian Gulf War, August 2, 1990, through a date to be set by law or Presidential Proclamation.

    Eligible Lists:   Candidates who pass the examination will be placed on an eligible list for that classification.  Eligible lists are effective for one year, but may be extended up to two additional years by the Civil Service Commission.

    Certification/Referral: Names from the eligible list will be referred to the hiring department by the following methods.

    • Rule of the Rank: The top three ranks will be referred for hiring interviews.  If there are less than 5 names in the top three ranks the next rank is referred.  This applies only to open competitive recruitments.
    • Rule of Five:  The top five names will be referred for hiring interviews.  This applies only to department or countywide promotional examination.

    Physical Exam:  Some classifications require physical examinations. Final appointment cannot be made until the eligible has passed the physical examination. The County pays for physical examinations administered in its medical facilities.

    Employment of Relatives: Applicants who are relatives of employees in a department within the 3rd degree of relationship, (parent, child, grand parent, grand child or sibling) either by blood or marriage, may not be appointed, promoted, transferred into or within the department when;

    • They are related to the Appointing Authority or

    • The employment would result in one of them supervising the work of the other.

    Department Head may establish additional limitations on the hiring of relatives by departmental rule.

    Proof of Eligibility:  If you are offered a job you will be required to provide proof of U.S. citizenship or other documents that establish your eligibility to be employed in the U.S.

     

    HOW TO APPLY

    Apply Online:       

    www.sjgov.org/hr

    By mail or in person:  

    San Joaquin County Human Resources

    44 N. San Joaquin Street Suite 330

    Stockton, Ca 95202                                  

     

    Office hours:               
    Monday – Friday 8:00 am to 5:00 pm; excluding holidays.

    Phone:  (209) 468-3370 

     

    Job Line:

    For current employment opportunities please call our 24-hour job line at (209) 468-3377. 

    When a final filing date is indicated, applications must be filed with the Human Resources Division before 5:00 p.m. or postmarked by the final filing date. Resumes will not be accepted in lieu of an application. Applications sent through county inter-office mail, which are not received by the final filing date, will not be accepted. (The County assumes no responsibility for mailed applications which are not received by the Human Resources Division).  

    San Joaquin County Substance Abuse Policy: San Joaquin County has adopted a Substance Abuse Policy in compliance with the Federal Drug Free Workplace Act of 1988. This policy is enforced by all San Joaquin County Departments and applies to all San Joaquin County employees.

    Equal Opportunity Employer:  San Joaquin County is an Equal Employment Opportunity (EEO) Employer and is committed to providing equal employment to all without regard to age, ancestry, color, creed, marital status, medical condition, national origin, physical or mental disability, political affiliation or belief, pregnancy, race, religion, sex, or sexual orientation.  For more information go to
    www.sjgov.org/eeo.




    Powered by JobAps



    San Joaquin County
    Human Resources Division  Stockton, CA 95202
    E-mail | Phone: (209) 468-3370 | 8am - 5pm M-F | Powered by JobAps