IT Database Administrator III

IT DATABASE ADMINISTRATOR III

The County of Riverside's 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 Microsoft SQL Server environments serving multiple County departments, including critical systems.

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 County's most complex systems and projects, applying advanced technical and analytical skills on an ongoing basis.

These positions require advanced expertise in Microsoft SQL Server 2019 and higher, including optimization tools and advanced backup and recovery methods. Experience in 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.

The Riverside County Information Technology (RCIT) department provides information technology services to County departments and agencies and is entrusted with managing and safeguarding the County's 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 database administrator 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.