RESPONSES TO SUPPLEMENTAL QUESTIONS REQUIRED
APPLICATIONS WILL BE REVIEWED WEEKLY UNTIL POSITION IS FILLED
ABOUT THE POSITION
Under general direction, provide administration, planning, 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. This opening is in the Information Technology Department of Shasta County.
The Information Technology (IT) Database Support Specialist is expected to work under the general direction of an IT Supervisor to carry out complex assignments and projects and to perform technical support for SQL Server database instances and related databases. The IT Database Support Specialist performs independently and is proficient in all aspects of SQL Server database management and administration. The IT Database Support Specialist will have strong interpersonal and communication skills; is capable of explaining procedures in writing or verbally; and possesses good phone skills.
EXAMPLES OF ESSENTIAL DUTIES:
This position requires the ability to perform a variety of complex tasks related to SQL Server database administration; researches and responds to staff and management technical inquiries concerning SQL Server database management system (DBMS) environments; participates in the evaluation of available database hardware and software and facilitates adoption discussions; provides input on hardware, software, training and other costs; participates in DBMS upgrades; provides project and or team leadership for SQL Server implementations; develops, implements, and maintains database backup and recovery procedures to ensure data integrity, security, and recoverability of data; prepares and implements business continuity and disaster recovery planning as it relates to SQL Server databases; develops, acquires, installs, and maintains database performance measuring and reporting systems; analyzes performance data to determine need for modification or addition to system configuration to meet current and future needs; confers and consults with management and other technical staff and vendors as required; responsible for database documentation; responsible for database security and security strategies; considers security at each phase of planning and design; responsible for capacity planning to ensure that the database infrastructure is designed for current needs and future expansion; represents database support at meetings; provides technical database training as required; works closely with development team to assist with design and implementation of SQL Server databases for complex business applications; assists with interface implementation to other systems; confers 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 database.
Any combination of education and experience sufficient to directly demonstrate possession and application of the following:
Knowledge of: Relational databases, database design, and normalization; RDBMS 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; Visual Studio, Object Oriented Programming and XML; DTS and SSIS; Replication and Mirroring; and Reporting tools; SQL Reporting Services, 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; 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; and handle multiple tasks with shifting priorities.
These employment standards are typically attained with the equivalent of a Bachelors 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.
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.
Responses to the following must be submitted with a completed application.
1. Describe your experience with Microsoft SQL Server as it relates to:
a. Administration (Backup, Performance Monitoring/Tuning, etc.)
b. Infrastructure Design/Implementation/Installation
(Be sure to mention which versions of SQL Server you have worked with.)
2. List and describe tools you have used to perform the duties described above.
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.
• 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.
• All individuals offered employment with Shasta County must pass a pre-employment physical examination that includes drug and alcohol testing.
• 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 (UPEC) 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 7% of his/her pay to this plan, or will contribute such other amount to the plan as authorized by PEPRA and other applicable laws. Click here 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 AND SELECTION PROCEDURES:
Shasta County Personnel will accept applications and responses to the supplemental questions until this position is filled A cover letter and/or resume will be accepted in addition to the application form but will not serve as a substitute for a completed application. Incomplete applications will not be processed. It is not acceptable to complete the application with statements such as, "See/Refer to Resume," or "See Attached." 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.
Applicants are encouraged to apply on-line at http://agency.governmentjobs.com/shasta/default.cfm 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 St. Rm. 348
Redding, CA 96001-1676
Shasta County - 24 months ago