This job has closed.

County of Riverside · 1 day ago

IT Database Administrator III

Riverside County, CA

Full-time

Onsite

Mid, Senior Level

4+ years exp

The County of Riverside’s Information Technology Department is recruiting for IT Database Administrator III positions within the Database Solutions Division. These senior-level roles provide advanced database administration support for enterprise Oracle and Microsoft SQL Server environments, focusing on the design, implementation, maintenance, and optimization of complex databases.

GovernmentHealth CarePublic RelationsPublic SafetySocial

No H1B

U.S. Citizen Only

Responsibilities

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

Qualification

Oracle 19cMicrosoft SQL Server 2019Database optimizationOracle ExadataCloud platformsRDBMS modelingData replicationData securityDisaster recoveryTechnical oversightEffective communication

Required

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

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

Advanced expertise in Oracle 19c and higher and Microsoft SQL Server 2019 and higher, including optimization tools and advanced backup and recovery methods

Knowledge of the principles, methods, and techniques used in the course of work for the IT Database Administrator series

Ability to gather and analyze data, reason logically, draw valid conclusions, and make appropriate recommendations

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

Experience with Oracle Exadata and cloud platforms such as Oracle Cloud Infrastructure (OCI), AWS, or Azure

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