Database Administrator
SALARY: $6737 - $8154/month
FILING DEADLINE: midnight 9/28/20
THE POSITION
Under general direction, manages the City's databases, which include standards and procedures relating to the integrity of City-wide information systems; serving as an expert technical resource on database architecture design, and administration; recommending and maintaining City-wide and industry standards for database design and data administration; and, maintaining system security. Incumbents may serve as a lead worker to other staff. The ideal candidate should be highly skilled in Oracle and MS SQL databases including SQL server 2012, 2016 and newer, operating systems (Windows, Linux, Unix), ArcSDE, as well as project management. Accela and PeopleSoft experience is advantageous.
The current vacancy exists in the Fresno Police Department (FPD). Immediate and future vacancies will be filled from this eligible list for a period of six (6) months from the date the eligible list is created, with the option of extending that period at the City's discretion. If the examination process is suspended for this recruitment, the eligible list may be limited to three (3) months.
THE REQUIREMENTS
Applicants must meet the minimum qualifications on or before the posted filing deadline in order to qualify for the examination and does not assure a place on the eligibility list.
A Bachelor's Degree from an accredited college or university with major course work in Computer Science, Business Administration, Information Systems, or related fields (A copy of diploma must be scanned and attached to your online application); AND Two years of experience involving application development, operation and maintenance of system software, and database administration functions.
A copy of degree or college transcripts must be uploaded and included in your on-line application for verification of requirement. Applicants lacking the documentation may be rejected if relying upon education to meet the Minimum Requirements.
Eligibles certified to the Police Department for consideration must successfully complete a polygraph test, an extensive background investigation, and a department interview before receiving conditional offers of employment. Individuals receiving a conditional offer of employment must successfully complete the Department of Justice fingerprinting process before receiving a final offer of employment.
SELECTION PROCESS
The examination process may consist of the following:
Application review - Qualifying Only: Applications which meet the minimum qualifications will be reviewed and a limited number of the most qualified candidates will be invited to the Oral Examination. Selection of the most qualified candidates will be based upon those applications demonstrating the greatest breadth and depth of applicable education, experience, skills and training. Therefore, applicants are urged to submit sufficiently detailed information in their application materials for evaluation.
Oral Exam 100%: A panel of subject matter experts will conduct a job-related oral examination to evaluate a candidate's knowledge of: current technology of operating systems and database administration; data structure design and implementation; system design and analysis; along with relevant technical knowledge of database systems; oral and written communication skills; and ability to establish positive working relationships. Candidates must achieve a passing score to qualify for the eligible list.
The oral examination has been tentatively scheduled for the week of October 19, 2020.
VETERAN’S PREFERENCE
Candidates applying for veteran's preference are required to submit a copy of their DD214 with their application during the specified filing period. Evidence must be presented to indicate that the candidate was discharged honorably from the military service. Veterans, including City employees, must resubmit proof of honorable service for every examination for which veteran's preference credit is requested. Qualified veterans who pass the examination will have five (5) points added to their final score.
EOE
The City of Fresno is an Equal Opportunity Employer. Should you need a special accommodation due to a qualifying disability, please contact the Personnel Service Department at (559) 621-6950 in advance of the examination.
BENEFITS: UNIT 13–City of Fresno Professional Employees Association (CFPEA)
RETIREMENT: Fresno City Retirement System, one of the best funded public systems in the state. Reciprocity with other public California systems. The City does not participate in Social Security. Vested in Retirement benefits after 5 years of service.
HEALTH INSURANCE: The City contributes toward monthly premiums for PPO medical, dental and vision for employee and dependents.
FLEXIBLE SPENDING ACCOUNT: IRS 125 Plan for health and dependent care expenses.
DEFERRED COMPENSATION: Increase your retirement savings with the City’s 457 plan.
MANAGEMENT LEAVE: 60 hours per fiscal year.
ANNUAL LEAVE: Twenty (20) days per year of Annual Leave with cash out provisions.
HOLIDAYS: Ten (10) City-observed annual holidays plus birthday and one (1) personal day.
LIFE INSURANCE: Benefit equal to annual salary; premium paid by the City.
LONG-TERM DISABILITY: Benefit equal to 66.66% of monthly salary up to $7,500 per month after 30 days of disability; premium paid by the City.
Additional information regarding the City of Fresno benefits is available at www.fresno.gov.
HOW TO APPLY
APPLICANTS MUST COMPLETE AN ON-LINE APPLICATION. PLEASE VISIT www.fresno.gov/jobs. TO APPLY. For information on how to complete an on-line application, please view "Instruction Guide" on the City's website, Personnel Services Career Opportunities page, or call (559) 621-6950 for assistance. Resumes will not be accepted in lieu of a completed employment application.
ALL CORRESPONDENCE regarding this recruitment and exam process will be sent via e-mail. All applicants will acknowledge such understanding when they complete their on-line application. Verify we have your correct e-mail address before you submit your application. It is an applicant's responsibility to check their email frequently to ensure they receive all pertinent communication from the Personnel Services Department on a timely basis. Applicants will receive an automatically generated confirmation e-mail upon a successful application submittal. The e-mail is the only proof of submittal.
Applications must be submitted by midnight on the filing deadline or they will not be accepted for any reason. FOR THIS RECRUITMENT, IT IS RECOMMENDED THAT PERMANENT FRESNO CITY EMPLOYEES APPLY THROUGH PEOPLESOFT SELF SERVICE.