INFORMATION TECHNOLOGY SPECIALIST I
Role details
Job location
Tech stack
Job description
Are you looking for a fast-paced and challenging position that will provide you with extremely valuable SQL Database Administration experience, extensive variety, and frequent exposure to managers and staff in the Information Technology Branch? The Employment Development Department (EDD) is looking for a highly motivated and qualified individual to work in the SQL Server Database Administration Group. The Information Technology Specialist I provides technical expertise as a Microsoft SQL Server Database Administrator for the SQL Server Database Group at EDD. Responsibilities include engineer level technical tasks to produce a robust SQL server environment. In addition to performing maintenance, operations, and enhancement tasks in the SQL environment, the database administrator works collaboratively with ITB support teams to ensure the successful integration of SQL databases with applications, troubleshoots SQL database related application issues, test new patches and new releases, and assists in resolving critical production failures. This position may be eligible for a hybrid work schedule. The amount of telework is at the discretion of the Department and is subject to change as business needs arise. Employees are required to report to their headquarters office on their assigned in-office days. Travel expenses to and from the assigned headquarters are the responsibility of the employee. Position is located at EDD's newly built headquarters located at 1416 9th street, Sacramento, California. Benefits of working at this brand new location include:
- Fitness center with showers
- Secure bike storage
- Work café with micro market
- Two private outdoor courtyards for employees
- 100% cost coverage of public transit including light rail, bus, or licensed public conveyance
- Close to major freeways, light rail, and transit stops
- Close to downtown shopping and restaurants
- Close to the Golden 1 Center and Sutter Health Park
Working Conditions
Visa Sponsorship
This position is not eligible for visa sponsorship. Applicants must be authorized to work in the US without the need for visa sponsorship by the start date of employment.
- Position located in a multi-story building.
- Standard office environment.
- Requires being in a stationary position, consistent with office work, for extended periods of time.
- Daily use of a personal computer, office equipment, and/or telephone.
- Standard 8-5 and after hours work as required.
- Telework is partially available., A Statement of Qualifications (SOQ) is Required. The SOQ serves as documentation of each candidate's ability to present information clearly and concisely in writing. The SOQ is not a resume or cover letter. Resumes and/or Cover Letters DO NOT take the place of the SOQ. Applications received without an SOQ or an SOQ submitted without following instructions may not receive further consideration and may be excluded from the hiring process.
The SOQ will be considered the first phase of the hiring process for this position. If your qualifications are competitive, you may be invited to an interview. We ask that you not use Artificial Intelligence assistance when composing your written response. Written responses are an attempt to assess and gain an understanding of your personal writing and communication skills and abilities.
The SOQ should be typed and not more than two pages in length, not less than 12-point font, single-spaced, with margins not less than one inch, including your first and last name and Job Control (JC) number at the top of the page, and must include a response to the statements below, including specific examples:
Please restate the questions with your response.
- Describe how your work experience and education qualify you for the role and responsibilities of this position based on the desirable qualifications and the duty statement.
- Describe your experience in database administration. Please include your specific role, the tasks you performed in that role, the versions and tools you used.
Background Investigation Requirement
The position(s) may require an applicant to pass a background investigation. However, applicants will not be asked to provide information about a conviction history unless they receive a conditional offer of employment.
The department will make an individualized assessment of whether the conviction history has a direct or adverse relationship with the specific duties of the job and the work performed by the department. The department will consider potential mitigating factors, including, but not limited to, evidence and extent of rehabilitation, recency, nature and seriousness, and age at the time of the offense(s).
The investigation will consist of completion of a personal history statement and fingerprinting checks with the Federal Bureau of Investigation, Department of Justice, and/or local law enforcement agencies. Anyone failing to pass the background investigation will be provided information on how to appeal the process. A criminal conviction may not result in an automatic determination of "Not Qualified."
Additional Department Information
The Employment Development Department may require a new probation in accordance with applicable probationary period rules.
Requirements
In addition to evaluating each candidate's relative ability, as demonstrated by quality and breadth of experience, the following factors will provide the basis for competitively evaluating each candidate:
- Experience with Microsoft SQL Server Database Administration with knowledge and hands-on skills supporting a production database in all operations, such as troubleshooting daily operational issues.
- Experience with SQL Server performance tuning, backup/restore, troubleshooting and Problem resolution.
- Designing, enabling and maintaining SQL Server high availability capabilities (preferably SQL Always On Availability Groups) in complex environment and mission critical applications.
- Experience with automation and scripting in Power Shell.
- Experience with Microsoft SQL Server Integration Services (SSIS) and Microsoft SQL Server Reporting Services (SSRS).
- Experience with Cloud based Database Services (Preferably AWS Relational Database Services).
- Experience with Windows Server Administration.