IT Database Administrator III
County of Riverside, California, MO, United States
Overview
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.
Inquiries about this recruitment can be directed to the RCIT recruitment team.
Responsibilities
Define database information, access and file structure requirements through discussions with users and colleagues.
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.
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.
This recruitment is open to all applicants.
For questions regarding this recruitment, contact Ebelyn Skinner at eskinner@rivco.org or 951-955-5196.
#J-18808-Ljbffr
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.
Inquiries about this recruitment can be directed to the RCIT recruitment team.
Responsibilities
Define database information, access and file structure requirements through discussions with users and colleagues.
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.
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.
This recruitment is open to all applicants.
For questions regarding this recruitment, contact Ebelyn Skinner at eskinner@rivco.org or 951-955-5196.
#J-18808-Ljbffr