DATABASE ADMINISTRATOR
DATABASE ADMINISTRATOR
FILING DEADLINE: Open until filled
THE POSITION
The Fresno Police Department is offering an outstanding career opportunity to a dedicated professional to manage the Police Department’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 database 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/or Microsoft SQL Server databases (including Microsoft SQL Server 2012, 2016, 2017 and newer), operating systems (Windows, Linux, Unix), Esri SDE Geodatabases, as well as project management. Experience with Accela, human resource, financial, and utility billing applications is advantageous.
The current vacancy exists in the Fresno Police Department. Immediate and future vacancies will be filled from this eligible list for a period of three (3) months from the date the eligible list is created, with the option of extending that period for up to a maximum of two years at the City's discretion. If the examination process is suspended for this recruitment, the eligible list may be limited to three (3) months.
CONDITIONS OF EMPLOYMENT
All newly hired and current City employees are required to comply with Administrative Order 6-30 “Employee Covid-19 Safety Protocols.” For more information, please visit: Personnel Services | Policies and MOU’s (fresno.gov)
BENEFITS: UNIT 13 Classification – City of Fresno Professional Employees Association (CFPEA)
3% salary increase, effective June 19, 2023
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: Voluntary 457 plan with Fidelity Investments to increase your retirement savings.
MANAGEMENT LEAVE: 60 hours per fiscal year for exempt employees.
ANNUAL LEAVE: Accrue 15.5 hours per month with cash out provisions.
SUPPLEMENTAL SICK- 40 hours per fiscal year. 80 hours lifetime maximum
HOLIDAYS: Ten (10) City-observed annual holidays plus birthday and two (2) personal days.
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.
BILINGUAL PREMIUM: PAY: $100 per month
HEALTH REIMBURSEMENT ARRANGEMENT: To reimburse retirement medical insurance and qualified medical expenses.
RETIREMENT: City of Fresno Retirement Systems, one of the best funded public systems in the state. Reciprocity with other CA public agencies. Vested in Retirement benefits after 5 years of service. City employees do not participate in Social Security.
DROP (Deferred Retirement Option Program): an optional, voluntary program that allows an employee to deposit retirement benefits in a special savings account within the Retirement System while continuing to work for the City of Fresno for up to 10 years. Participation minimum is age 50 and vested. Benefits includes ownership of accumulated funds, compound interest earnings, and alternative distribution options.
Additional information regarding the City of Fresno benefits is available at
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 (2) 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.
ADDITIONAL REQUIREMENTS
The selected eligible candidates certified will be required to successfully pass a Department interview and a Department of Justice fingerprint prior to employment with the City of Fresno.
Possession of a valid California Driver's License required at time of appointment. Candidates considered for hire must provide proof of a valid driver's license and current copy of their driving record.
Eligibles certified to the Police Department for consideration must successfully complete a Computer Voice Stress Analyzer (CVSA) and/or 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: To be determined.
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.
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.
It is an applicant's responsibility to check their email account and to ensure it is set up to accept emails from the City of Fresno. Dependent upon your settings, notices from the City of Fresno may be directed to the junk mail or spam folders. It is the applicant's responsibility to check these folders.
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.