County of Riverside
IT Database Administrator ll
County of Riverside, Riverside, California, United States, 92504
The Riverside County Information Technology (RCIT) Department is seeking a skilled
IT Database Administrator II (IT DBA II)
to join the Database Solutions Division located in Riverside, CA. This role will focus on the installation, implementation, and management of Microsoft SQL Server and Oracle database solutions to support various in-house and third-party applications and data repositories.The ideal candidate will have hands-on experience with SQL Server 2019 or higher, Oracle databases, and the ability to handle database creation, table and view design, stored procedures, and functions development. Additionally, you will manage and monitor database maintenance plans, SSIS (SQL Server Integration Services), agent jobs, and perform import/ETL processes from external sources.Key Responsibilities:
Install and implement Microsoft SQL Server and Oracle database solutions.Create and manage SQL Server and Oracle databases, tables, views, stored procedures, and functions to support applications and data repositories.Implement, manage, and monitor SQL and Oracle database maintenance plans, SSIS packages, and agent jobs.Perform data imports and ETL processes from external sources.Collaborate with internal and external teams to support in-house and third-party applications.Desired Qualifications:
Proficiency with Microsoft SQL Server 2019 or higher.Experience with Oracle Databases (version 19g or higher).Working knowledge or experience with:SolarWinds monitoring and management tools.Veeam backup solutions.Microsoft Power BI.Tyler EnerGov Permitting & Land Management software and databases.Required Qualifications:
Extensive knowledge of Oracle Databases.Experience in Microsoft SQL Server database administration and management.Strong understanding of database maintenance plans, agent jobs, and SSIS.Preferred Experience:
Experience with Tyler EnerGov software and database.Working knowledge of SolarWinds and Veeam tools.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 database administrator 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.Other Requirement:
A successful Security Clearance conducted by the Sheriffs' Department is required for positions within the Riverside County Information Technology Department.This recruitment is open to all applicants.For specific questions regarding this position, contact Ebelyn Skinner at eskinner @rivco.org .
#J-18808-Ljbffr
IT Database Administrator II (IT DBA II)
to join the Database Solutions Division located in Riverside, CA. This role will focus on the installation, implementation, and management of Microsoft SQL Server and Oracle database solutions to support various in-house and third-party applications and data repositories.The ideal candidate will have hands-on experience with SQL Server 2019 or higher, Oracle databases, and the ability to handle database creation, table and view design, stored procedures, and functions development. Additionally, you will manage and monitor database maintenance plans, SSIS (SQL Server Integration Services), agent jobs, and perform import/ETL processes from external sources.Key Responsibilities:
Install and implement Microsoft SQL Server and Oracle database solutions.Create and manage SQL Server and Oracle databases, tables, views, stored procedures, and functions to support applications and data repositories.Implement, manage, and monitor SQL and Oracle database maintenance plans, SSIS packages, and agent jobs.Perform data imports and ETL processes from external sources.Collaborate with internal and external teams to support in-house and third-party applications.Desired Qualifications:
Proficiency with Microsoft SQL Server 2019 or higher.Experience with Oracle Databases (version 19g or higher).Working knowledge or experience with:SolarWinds monitoring and management tools.Veeam backup solutions.Microsoft Power BI.Tyler EnerGov Permitting & Land Management software and databases.Required Qualifications:
Extensive knowledge of Oracle Databases.Experience in Microsoft SQL Server database administration and management.Strong understanding of database maintenance plans, agent jobs, and SSIS.Preferred Experience:
Experience with Tyler EnerGov software and database.Working knowledge of SolarWinds and Veeam tools.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 database administrator 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.Other Requirement:
A successful Security Clearance conducted by the Sheriffs' Department is required for positions within the Riverside County Information Technology Department.This recruitment is open to all applicants.For specific questions regarding this position, contact Ebelyn Skinner at eskinner @rivco.org .
#J-18808-Ljbffr