Information Technology Database Administrator I/II
Apply Here: https://www.governmentjobs.com/careers/shasta/jobs/3575980/information-technology-database-administrator-i-ii?page=3&pagetype=jobOpportunitiesJobs
CURRENT VACANCY IS WITHIN THE SHASTA COUNTY
INFORMATION DEPARTMENT
ORAL EXAM IS TENTATIVELY SCHEDULED FOR JUNE 2022
SKILLS OR EXPERIENCES LISTED UNDER THE IDEAL CANDIDATE
STATEMENT MAY ALSO BE USED TO SCREEN APPLICATIONS
SEE “SPECIAL REQUIREMENT” SECTION REGARDING
POSSESSION OF A VALID DRIVER’S LICENSE
FINAL FILING DATE: JUNE 21, 2022 AT 5:00 PM
SALARY INFORMATION
Information Technology Database Administrator I: $5,739 - $7,325 APPROXIMATE MONTHLY* / $33.11 - $42.26 APPROXIMATE HOURLY*
Information Technology Database Administrator II: $6,451 - $8,235 APPROXIMATE MONTHLY* / $37.22 - $47.51 APPROXIMATE HOURLY*
*Please refer to the appropriate Bargaining Unit Memorandum of Understanding for potential future salary increases* Please visit https://co.shasta.ca.us/MOUs
ABOUT SHASTA COUNTY
Shasta County offers all the amenities of the big city while retaining a comfortable small-town atmosphere. With its natural beauty, affordable housing, excellent educational system, abundance of recreational opportunities, and excellent quality of life, Shasta County is a great place to live, work, and raise a family.
ABOUT THE DEPARTMENT
Information Technology
Information Technology provides electronic data processing services to County departments including systems development and maintenance, computer programming, network management, computer operations, and personal computer support. Information Technology also assists departments with the selection and acquisition of their computer systems and personal computers. All telephone, voice mail, and related telecommunication equipment is installed, maintained, and upgraded by this department.
ABOUT THE POSITION
Information Technology Database Administrator I: Under supervision, to provide administration, technical support for, and management of SQL Server databases and related systems at Shasta County; to provide excellent customer service; and to perform related work as required.
Information Technology Database Administrator II: Same as Information Technology Database Administrator II, but under general direction.
DISTINGUISHING CHARACTERISTICS
Information Technology Database Administrator I:
This is the entry-level class for SQL Server database administration classification. Incumbents are expected to develop a variety of database skills and abilities and are gradually given more responsible assignments required for promotion to the next higher class of IT Database Administrator II. The IT Database Administrator I is capable of learning the skills necessary to be proficient in all aspects of SQL Server database management and administration and will have strong interpersonal and communication skills; is capable of explaining procedures in writing or verbally; and possesses good phone skills.
Information Technology Database Administrator II:
The IT Database Administrator II is expected to work under general direction to carry out complex assignments and projects and to perform technical support for SQL Server database instances and related databases. The IT Database Administrator II performs independently and is proficient in all aspects of SQL Server database management and administration. The IT Database Administrator II will have strong interpersonal and communication skills; is capable of explaining procedures in writing or verbally; and possesses good phone skills.
EXAMPLES OF DUTIES
Information Technology Database Administrator I:
This position requires the ability to: learn and perform a variety of tasks related to SQL Server database administration; research and respond to staff and management technical inquiries concerning SQL Server database management system (DBMS) environments; participate in the evaluation of available database hardware and software and facilitates adoption discussions; provide input on hardware, software, and other costs; participate in DBMS upgrades; develop, implement and maintains database backup and recovery procedures to ensure data integrity, security, and recoverability of data; prepare and implement business continuity and disaster recovery planning as it relates to SQL Server databases; develop, acquire, install, and maintain database performance measuring and reporting systems; analyze performance data to determine need for modification or addition to system configuration to meet current and future needs; confer and consult with management and other technical staff and vendors as required; create and maintain database documentation; participate in database security and security strategies; consider security at each phase of planning and design; participate in capacity planning to ensure that the database infrastructure is designed for current needs and future expansion; represent database support at meetings; work closely with development team to assist with design and implementation of SQL Server databases for complex business applications; assist with interface implementation to other systems; confer with IT management to ensure that proposed solutions are appropriate; perform other related projects and tasks as required/assigned.
Examples of Specific Duties:
- Primary support of databases for specified vendor applications; to include administration, implementation, maintenance and ongoing support of production SQL Server database environments
- Work with leads in other functional areas to troubleshoot system problems when SQL Server databases are involved
- Install, patch, upgrade and test custom and vendor SQL Server software and databases
- Ad-hoc reporting and incident tracking
- Develop and debug SQL queries, stored procedures, and triggers
- Work with vendors and or developers to tune existing queries and configuration to improve performance or resolve performance issues
- Work closely with development team to assist with design and implementation of SQL Server databases for complex business applications
- Review proposed changes to databases to advise on performance impacts
- Provide support and suggestions for improving departmental processes
- Assist in the research and evaluation of support tools and methodologies
Information Technology Database Administrator II:
This position requires the ability to: perform a variety of complex tasks related to SQL Server database administration; research and respond to staff and management technical inquiries concerning SQL Server database management system (DBMS) environments; participate in the evaluation of available database hardware and software and facilitates adoption discussions; provide input on hardware, software, training and other costs; participate in DBMS upgrades; provide project and or team leadership for SQL Server implementations; develop, implement and maintain database backup and recovery procedures to ensure data integrity, security, and recoverability of data; prepare and implement business continuity and disaster recovery planning as it relates to SQL Server databases; develop, acquire, install and maintain database performance measuring and reporting systems; analyze performance data to determine need for modification or addition to system configuration to meet current and future needs; confer and consult with management and other technical staff and vendors as required; create and maintain database documentation; understand and implement database security and security strategies; consider security at each phase of planning and design; conduct capacity planning to ensure that the database infrastructure is designed for current needs and future expansion; represent database support at meetings; provide technical database training as required; work closely with development team to assist with design and implementation of SQL Server databases for complex business applications; assist with interface implementation to other systems; confer with IT Supervisor (in charge of databases) to ensure that proposed solutions are appropriate; perform other related projects and tasks as required/assigned.
Examples of Specific Duties:
- Primary support of databases for specified vendor applications; to include administration, implementation, maintenance and ongoing support of production SQL Server database environments
- Work with leads in other functional areas to troubleshoot system problems when SQL Server databases are involved
- Install, patch, upgrade and test custom and vendor SQL Server software and databases
- Ad-hoc reporting and incident tracking
- Develop and debug SQL queries, stored procedures, and triggers
- Work with vendors and or developers to tune existing queries and configuration to improve performance or resolve performance issues
- Work closely with development team to assist with design and implementation of SQL Server databases for complex business applications
- Review proposed changes to databases to advise on performance impacts
- Advise developers in database design and lead in the area of development and design standards
- Develop and ensure standardization of SQL coding practices and adherence to coding standards, change control, and SQL best practices
- Coach and mentor development team members on best practices for database technologies
- Provide support and suggestions for improving departmental processes
- Assist in the research and evaluation of support tools and methodologies
- Secondary support for custom databases.
QUALIFICATIONS
Any combination of education and experience sufficient to directly demonstrate possession and application of the following:
Information Technology Database Administrator I:
Knowledge of:
- Relational databases, database design, and normalization
- Relational DBMS architecture
- Microsoft SQL Server product family
- Security; system and object level privileges, roles and an understanding of how OS security options relate to the database environment
- Windows operating systems and networking
- SQL Server administration and configuration
- Database performance management and monitoring tools and methods
- SQL Profiler, Execution Plans
- Transact-SQL
- Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)
- Reporting tools; SQL Server Reporting Services (SSRS), Crystal Reports
Ability to:
- Perform database problem resolution and cause analysis as well as recommend and implement preventative techniques
- Design, develop and maintain database and data transformation packages
- Create and update technical documentation
- Understand, translate and coordinate requirements into efficient usage of software and hardware products
- Demonstrate good time management skills by organizing work and desk space, managing priorities, meeting critical deadlines, and follow-up on assignments with a minimal of direction
- Adhere to and suggest improvements for standards in place at Shasta County for Database Management Systems
- Plan and implement changes to database systems
- Learn how to independently problem-solve
- Assess causes of database failures and initiate corrective action
- Establish and maintain effective working relationships with department staff, other County departments, other agencies, and the public
- Communicate clearly and concisely, both orally and in writing
- Handle multiple tasks with shifting priorities
These employment standards are typically attained with three years of database administrator experience. Successful completion of each thirty (30) semester units in a college or university with an emphasis in programming, database, or related course work may be substituted for each one year of total experience.
Information Technology Database Administrator II:
Knowledge of: Same as Information Technology Database administrator I, additionally:
- Replication and Mirroring
Ability to: Same as Information Technology Database administrator I, additionally:
· Independently problem-solve
These employment standards are typically attained with the equivalent of a Bachelor's degree in Computer Science or a related field of study, and at least three years of database experience. One year of database application development desired. Any combination of relevant education and work experience may be substituted for the required education on a year-for-year basis. SQL Server certification is preferred.
SPECIAL REQUIREMENT
· Possession of an appropriate California driver license may be required for some positions. Depending upon assignment, an incumbent may need to regularly have access to and utilize a suitable personal vehicle in the course of business (mileage is reimbursed at the IRS rate). Proof of adequate insurance for the vehicle may be required.
IDEAL CANDIDATE
The ideal candidate will have a proven track record demonstrating the following:
· Knowledge and experience of database administration and software installation using Microsoft SQL Server
· Creating, monitoring and supporting SQL Server databases; performance optimization; resizing and restructuring; index maintenance; backup, restoration and recovery
· Supporting and enhancing SQL Server processes
· Establishing procedures for database operation, control and recovery
· Developing, implementing, administering, and maintaining policies and procedures ensuring the security and integrity of databases
· Configuration and maintenance of databases; disaster recovery design
· Data modeling, schema design, ETL architecture, development, documentation, optimization, and collaboration with different teams
Characteristics of the ideal candidate:
· Good interpersonal skills; excellent oral and written communication skills
· Willingness to learn and work with a highly technical, dedicated team
· Able to troubleshoot database performance and respond to system problems
SUPPLEMENTAL QUESTIONS
Responses to the following must be submitted with a completed application.
- List all enterprise database systems you have supported in a professional capacity.
- List any SQL Server training or certifications you have completed.
- Describe your experience with Microsoft SQL Server Administration as it relates to each of the seven below options. For each item below, be sure to include which versions of SQL Server you have worked with, years of experience with each, and size of environments (number of instances, databases, and users). If no experience in any of the below options, please type "N/A".
Backup and Recovery
Performance Monitoring
Tuning
Scripting
SSRS
SSIS
Installation, Setup, and Configuration of databases/servers
PHYSICAL DEMANDS AND WORK ENVIRONMENT
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
While performing the duties of this job, the employee is regularly required to sit; use hands to finger, handle or feel objects, tools, or controls; and talk or hear. The employee occasionally is required to stand; walk; reach with hands and arms; and stoop, kneel, crouch, or crawl.
The employee must occasionally lift and /or move up to 25 pounds. Specific vision abilities required by this job include close vision and color vision.
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
While performing the duties of this job, the employee occasionally works in outside weather conditions.
The noise level in the work environment is usually moderate.
OTHER CONSIDERATIONS
- All new employees are required to have their paycheck directly deposited to a bank account.
- Some positions may require a valid California driver's license and acceptable driving record according to County policy.
- Reasonable accommodations may be made for those persons who are disabled under the Americans with Disabilities Act to perform the essential functions of the position.
- As part of the selection process, all individuals provided with a preliminary offer of employment with Shasta County will be subject to a background investigation, including a criminal history check (primarily completed through the taking of fingerprints). An image of your fingerprints will be captured and sent to the California Department of Justice (DOJ) and the Federal Bureau of Investigation (FBI). The resulting report of your conviction history, (if any), will be evaluated along with the other information received in connection with your application. Except as otherwise required by law, a criminal conviction will not necessarily disqualify you from the position. The nature of the offense, the date of the offense, the surrounding circumstances, and the relevance of the offense to the position applied for may, however, be considered.
- Based on the results of the background investigation and criminal history check, applicants may then be provided with an offer of employment conditioned on the results of a medical examination, which includes drug/alcohol testing.
- Shasta County participates in E-Verify. For more information click here. If you do not have internet access, contact Personnel at (530) 225-5515 to request a flyer.
- In accordance with Government Code Section 3100, County employees, in the event of a disaster are considered disaster workers and may be asked to respond accordingly.
- Positions in this classification are covered by a collective bargaining agreement between the County and the United Public Employees of California – General Unit.
- Employees in this classification are covered under the CalPERS retirement program. Depending on the provisions of the California Public Employees’ Pension Reform Act (PEPRA) and other applicable laws, an employee in this classification will be covered under one of the following CalPERS retirement formulas: (1) 2% at 55, (2) 2% at 60, or (3) 2% at 62. An employee in this classification will also contribute up to 8.75% of his/her pay to this plan, or will contribute such other amount to the plan as authorized by PEPRA and other applicable laws. Please visit our employees benefit page at Employee Benefits for additional information regarding benefits and CalPERS coverage information. The provisions in this flyer and on the County’s website are for information purposes only. To the extent the provisions of the flyer or the County’s website are inconsistent with PEPRA and other applicable laws, PEPRA and other applicable laws shall govern.
APPLICATION & SELECTION PROCEDURES
Shasta County Personnel will accept applications and responses to the supplemental questions until 5:00 p.m., on June 21, 2022. A Resume and/or Cover Letter will be accepted in addition to the application form but will not serve as a substitute for a completed application. It is not acceptable to complete the application with statements such as, “Refer to Resume and/or Cover Letter,” or “See Attached Resume and/or Cover Letter” the employment application must be completed in its entirety prior to submission. Incomplete applications will not be processed. Closing date postmarks or faxes will NOT be accepted. This recruitment will establish a list that may or may not be used by other departments. Prior applicants must reapply to be considered.
Applicants will be screened and those considered best qualified will be invited to appear for an oral and/or written examination. Meeting the announced requirements does not guarantee inclusion into the selection process. Depending upon the number of applications received, the selection process may consist of additional application screening, written and/or practical exam(s), oral interview, or any combination thereof.
Veterans' Credit: Veterans (as defined by California Government Code section 18973) who have been discharged from military service under conditions other than dishonorable and who receive a passing score on all components of the employment examinations (up to and including oral examinations) shall receive credit for an additional five points to be added to their final examination score. To be considered for this credit, a veteran MUST provide a copy of his or her discharge document (DD-214 or equivalent) and information as to the type of discharge (honorable, dishonorable, etc.) WITH THE EMPLOYMENT APPLICATION ON OR BEFORE THE FINAL FILING DATE.
Applicants are encouraged to apply on-line at apply online or submit an application to the Shasta County Personnel Office.
Arrangements may be made to accommodate applicants with disabilities. Requests for accommodations may be made to the Shasta County Personnel Office by the filing deadline posted on this bulletin. Shasta County does not discriminate on the basis of disability. If you feel you are being denied service based on a disability, our ADA Coordinator may be reached at (530) 225-5515; relay service (800) 735-2922; fax (530) 225-5345.
SHASTA COUNTY IS AN EQUAL OPPORTUNITY EMPLOYER
Shasta County Personnel
1450 Court Street, Suite 348; Redding, CA 96001; (530) 225-5515