IT Database Administrator II - Assessor / Clerk Recorder

Job Summary

The Riverside County Assessor-County Clerk-Recorder has an opportunity for an IT Database Administrator II (IT DBA II) in Riverside, CA.

Key Responsibilities

• Install, monitor, and implement Microsoft SQL Server 2016 or newer database solutions.
• Implement, monitor, and maintain backup solutions including disaster recovery scenarios, database performance, user security, and data imports.
• Oversee interactions with other databases and assist with conceptual design of new data warehousing models for large enterprise systems.
• Create SQL Server databases, tables, views, stored procedures and functions to support in?house and third?party applications and data repositories.
• Define database information, access, and file structure requirements through discussions with users and colleagues.
• Administer and troubleshoot database issues for users, monitor databases, maintain security and integrity, and develop reports as requested.
• Develop procedures and data applications; manage user access and response time.
• Design architecture of server applications and implement by writing, testing, and debugging complex programs.
• Design and implement database management systems by creating models, building table structure, establishing referential integrity, and preparing documentation.
• Perform database backups and recovery including off?site storage for disaster recovery; tune, monitor data integrity and security, and resolve problems.
• Ensure acceptable database performance through assessing user access and response time, modifying structure, and coordinating with system resources 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, versions, and systems solutions.
• Develop quality standards based on industry standards and evaluation of available technology and resources.

Qualifications

Preferred Skills

Notice

Under the condition of employment with the Assessor-County Clerk-Recorder Department, employees are prohibited from engaging in any real estate, appraisal, auditing, or notarial activities related to property located within the State of California, outside the scope of their official duties. This includes acting as a real estate agent or broker, performing appraisals or audits for compensation or otherwise, and notarizing documents in a private capacity. The use of any professional license (e.g., Broker, Salesperson, Notary Public) in connection with California property is not permitted while employed by ACR.

Additional Information

Contact Christopher Recinos at Crecinos@rivco.org with any questions regarding this recruitment.

Application Policy

This recruitment is open to all applicants.

#J-18808-Ljbffr