Database developer [h1.location_city]

ABOUT THE POSITION

The County of Riversides Information Technology Department (RCIT) is recruiting for multiple IT Database Administrator III (ITDBA III) positions within the Database Solutions Division in Riverside. These senior-level roles provide advanced database administration support for enterprise Oracle and Microsoft SQL Server environments serving multiple County departments including critical systems such as PeopleSoft Financial Management (FMS) and Human Capital Management (HCM).

The ITDBA III is responsible for the design implementation maintenance and optimization of complex databases that support mission-critical applications. Duties include defining database requirements; designing data models and table structures; ensuring data integrity security and performance; and performing advanced monitoring tuning backup and disaster recovery activities. Incumbents support the Countys most complex systems and projects applying advanced technical and analytical skills on an ongoing basis.

These positions require advanced expertise in Oracle 19c and higher and Microsoft SQL Server 2019 and higher including optimization tools and advanced backup and recovery methods. Experience with Oracle Exadata and cloud platforms such as Oracle Cloud Infrastructure (OCI) AWS or Azure is desirable. Depending on the assignment responsibilities may also include supporting enterprise GIS / ESRI and specialized databases and software system upgrades data replication security and compliance initiatives and participation in 24 / 7 on-call rotations to ensure high availability of business-critical systems.

Meet the Team!

The Riverside County Information Technology (RCIT) department provides information technology services to County departments and agencies and is entrusted with managing and safeguarding the Countys enterprise and mission-critical solutions and infrastructure. RCIT is committed to cultivating a collaborative and inclusive culture that fosters best of breed solutions with a focus on problem-solving to deliver quality products and services to our customers.

EXAMPLES OF ESSENTIAL DUTIES

Define database information access and file structure requirements through discussions with users and colleagues.

May provide technical oversight mentor and delegate work to subordinate staff.

Develop methods for storing analyzing and organizing data; monitor various third party vendor tools; analyze various vendor products and contribute to request for proposals.

Perform migrations for version upgrades; transfer files.

Develop transaction logs for backups to ensure business continuity; implement disaster recovery plan when needed.

Administer and troubleshoot database issues for users; monitor databases and database interfaces.

Ensure database performance optimization and availability.

Maintain security and integrity of databases and servers; develop reports and queries as requested.

Develop procedures and data applications; access user access and response time.

Design and implement database management systems by creating models building table structure establishing referential integrity and preparing documentation; design databases to enhance existing applications; provide database support for application development lifecycle.

Maintain databases by performing database management system backups and recovery including off-site storage for disaster recovery; maintain databases by tuning monitoring data integrity and security and resolving problems.

Ensure acceptable database performance through assessing user access and response time modifying structure and conferring with others responsible for system resource interface and data users.

Manipulate data through normalization transfer tuning cleansing and scrubbing processes and database population.

Create and maintain data warehousing and data mining systems; design and maintain database software configuration library specifications documentation and operating procedures.

Research evaluate and test proposed products product versions and systems solutions.

Develop quality standards based on industry standards and evaluation of available technology and resources.

MINIMUM QUALIFICATIONS

Education : Completion of 30 semester or 45 quarter units from an accredited college or university preferably with coursework in computer science computer information systems data processing information management or a related field to the assignment. (Additional qualifying IT job-related experience may substitute for the required education on the basis of 30 semester or 45 quarter units equaling one year of full-time experience).

Experience : Four years of successful journey level IT job-related experience one year of which included either lead person duties or technically advanced IT job-related work. (One year as an IT Database Administrator II will satisfy the one year of lead or technically advanced experience requirement.)

Knowledge of : The principles methods and techniques used in the course of work for the IT Database Administrator series; principles and techniques applied to IT devices applications and systems; principles of organization and administration; the principles of documentation and recordkeeping storage and retrieval.

Ability to : Gather and analyze data reason logically draw valid conclusions and make appropriate recommendations; resolve technical problems and innovate more efficient use of IT resources; perform systems analysis work and problem solving; interpret and follow written and oral instructions; prepare concise reports and documents; establish and maintain effective working relationships with staff customers other employees and the public; communicate effectively with people at all organizational levels.

Required IT-Related Skills : RDBMS modeling design replication propagation and tuning; working in a multi-user multi-platform network environment with understanding of dB / OS interaction; DB2 IMS Informix Sybase; one or more of CA-7 COBOL CLISTS DBRC DFDSS Erwin ER Studio FDR ISPF MVS PACE RMF SMF TSO Turbo Image or VSAM.

Preferred IT-Related Skills : RDBMS in a client server environment (e.g. NT UNIX); internal consulting to determine user information needs identify systems of origin and encourage enterprise resource use.

SUPPLEMENTAL INFORMATION

This recruitment is open to all applicants.

For questions regarding this recruitment contact Ebelyn Skinner at

APPLICATION INFORMATION

Veterans Preference

The County has a Veterans Preference Policy applicable to new hires. To qualify upload a copy of your (or your spouses) Member-4 Form DD-214 indicating dates of service and a copy of your spouses letter of disability (if applicable) with your application. For privacy reasons it is recommended that you remove your social security information from the document(s). A Human Resources Representative will review the materials and determine if you qualify for veterans Veterans Preference Policy C-3 is available here : Accommodations

The County of Riverside is committed to providing reasonable accommodation to applicants as required by the Americans with Disabilities Act (ADA) and Fair Employment and Housing Act (FEHA). Qualified individuals with disabilities who need a reasonable accommodation during the application or selection process should contact the recruiter for the position noted above. For additional information and / or to obtain the appropriate form for requesting a reasonable accommodation please visit the Disability Access Office web page located at : of Education

If using education to qualify or when requested by the recruiter upload a copy of any license(s) official / unofficial transcript(s) degrees and / or related employment documents to your NeoGov account at the time of application and before the closing date. Official or unofficial transcripts will be accepted.

If your education was completed outside of the United States you will need to provide a copy of your Foreign Education Equivalency evaluation from a member of the National Association of Credential Evaluation Services ( NACES) or Association of International Credential Evaluators Inc. ( AICE).

Work Authorization Requirement

Applicants must be legally authorized to work in the United States at the time of application. The County of Riverside does not participate in visa sponsorship programs including H1-B visas and will not provide sponsorship for any employment-based visas.

Equal Opportunity Employer

The County of Riverside is an Equal Opportunity Employer. It is the policy of the County of Riverside to provide equal employment opportunities for all qualified persons. All applicants will be considered without regard to race color religion sex national origin age disability sexual orientation gender gender identity gender expression marital status ancestry medical condition (cancer and genetic characteristics) genetic information or denial of medical and family care leave or any other non-job-related factors.

Pre-Employment

All employment offers are contingent upon successful completion of pre-employment requirements including a criminal background investigation which involves fingerprinting. (A felony or misdemeanor conviction may disqualify the applicant from County employment). A pre-employment physical examination and background check may be required.

Probationary Period

As an Approved Local Merit System all County of Riverside employees except those serving At Will are subject to the probationary period provisions as specified in the applicable Memorandum of Understanding County Resolution or Salary Ordinance. Temporary and Per Diem employees serve at the pleasure of the agency / department head.

General Information

Current County of Riverside and / or current employees of the hiring department may receive priority consideration. Qualified candidates may be considered for future County vacancies.

Job postings may close without notice based on application volume. Submit your complete application by the recruitment close date; no late applications are accepted. Ensure all relevant experience / education is reflected on your application / resume as a failure to demonstrate position requirements may disqualify applicants. A description of job duties directly copied from the job classification or job posting will not be considered.

Please read and follow any special application instructions on this posting. Click the Apply link located on this page to submit your application. For additional instructions on the application process examinations Veterans preference pre-employment accommodation or other employment questions please refer to our web site .

If you are experiencing technical problems you may contact the applicant support desk Monday through Friday 6 am to 5 pm Pacific Time at or toll-free 1-.

Required Experience :

Unclear Seniority

Key Skills

Databases,Disaster Recovery,SQL,High Availability,Microsoft SQL Server,ssrs,Database Design,Performance Tuning,SSIS,Database Administration,Sybase,Oracle

Employment Type : Full Time

Experience : years

Vacancy : 1

Yearly Salary Salary : 110905 - 155162