IT Database Administrator II AssessorClerk Recorder

Not Interested
Bookmark
Report This Job

profile Job Location:

Riverside, CA - USA

profile Yearly Salary: $ 95173 - 128787
Posted on: 12 hours ago
Vacancies: 1 Vacancy

Job Summary

ABOUT THE POSITION


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

The IT DBA II will primarily utilize Microsoft SQL Server 2016 or newer to install monitor and implement Microsoft SQL Server database solutions. They will be responsible for implementing monitoring and maintaining backup solutions including disaster recovery scenarios database performance user security and data imports. Additionally they will oversee the interaction with other databases and their functionality and assist with the conceptual design of new data warehousing conceptual models for large enterprise systems. The incumbent will also be tasked with creating SQL Server databases tables views stored procedures and functions to support in-house and 3rd party applications and data repositories.

The most competitive candidates will have:

  • Proficiency with Microsoft SQL Server 2016 or higher.
  • Data modeling experience including logical conceptual and physical model development for large-scale enterprise data systems.
  • Experience in building Data warehousing conceptual models utilizing multiple database administrations preferably within AWS My SQL.
  • Strong Knowledge of SolarWinds and PowerShell
  • Working experience with Microsoft Power BI

Required Experience and Education: Candidates must have a completed Bachelors degree from an accredited college or university within a major listed under the positions minimum qualifications experience in Microsoft SQL Server database administration and management experience with AWS MySQL SQL Server PostgreSQL RDS and Aurora databases and working within a public nonprofit or large scale organization for the integration of large enterprise systems.

Meet the Team!

Assessor - County Clerk - Recorder (ACR) The ACR has a staff of over 375 employees located in offices throughout Riverside County. The Assessor is responsible for locating identifying and valuing all taxable property in Riverside County. The Recorder is responsible for providing the public with constructive notice of private acts and creating and maintaining custody of permanent records for all documents filed and recorded in Riverside County. The County Clerk services range from issuing marriage licenses and performing marriage ceremonies to accepting filings of Fictitious Business Name Statements. The Records Management Archives Program (RMAP) unit provides professional records management services and the Archives Program provides public access to the history of Riverside County.

jfc:

EXAMPLES OF ESSENTIAL DUTIES

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 of databases and servers; develop reports as requested.

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

Design architecture of server applications;

Design and implement by writing testing and debugging complex programs.

Design and implement database management system by creating models building table structure establishing referential integrity and preparing documentation.

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: Two years of IT job-related experience preferably with the County of Riverside.

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.

Notice: As a condition of employment with the Assessor-County Clerk-Recorder (ACR) 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 Recinoswith any questions regarding this recruitment.

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

ABOUT THE POSITIONThe Riverside Countys Assessor-County Clerk-Recorder has an opportunity for an IT Database Administrator II (IT DBA II) for their location in Riverside CA.The IT DBA II will primarily utilize Microsoft SQL Server 2016 or newer to install monitor and implement Microsoft SQL Server d...
View more view more

Key Skills

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