Job Posting: Microsoft SQL Server DBA

Public Utilities Commission

JC-168347
-
Microsoft SQL Server DBA
INFORMATION TECHNOLOGY SPECIALIST I

$5,297.00 - $8,570.00 per Month

Final Filing Date: 8/20/2019

Job Description and Duties

The Information Technology Specialist I acts as a Microsoft SQL Database Administrator and serves as a technical lead to provide guidance on database and application development efforts.

The tasks for the SQL Server DBA include, but are not limited to, the following:

• On-going maintenance of Microsoft SQL Server databases. Daily operational tasks like:
    o Monitoring backups
    o Assisting with database recovery
    o Monitoring MS SQL Server database availability
    o Monitoring MS SQL Server error logs
    o Monitoring database mirroring
    o Performance monitoring and tuning as needed
• Production support of Microsoft SQL Server database issues, this may include work outside of normal business hours.
• Maintain and monitor High-Availability of SQL Server Database Mirrors between production and disaster recovery (DR) environments.
• Develop and implement proactive monitoring for a multi-server Microsoft SQL Server environment (email reports like a SQL Server Job Failure report ran as a SQL Job).
• Provide advice/recommendations on SQL Server architecture, design and implementation.
• Provide training, documentation for knowledge transfer to other CPUC ITSD team members, and communicate both to non-technical users and to technical personnel in the CPUC ITSD support team.
• Provide technical coverage for all CPUC deployed Microsoft SQL Servers.

You will find additional information about the job in the Duty Statement.

Minimum Requirements

You will find the Minimum Requirements in the Class Specification.

Additional Documents

Position Details

Job Code #:
JC-168347
Position #(s):
680-406-1402-XXX
Working Title:
Microsoft SQL Server DBA
Classification:
INFORMATION TECHNOLOGY SPECIALIST I
$5,297.00 - $8,570.00
# of Positions:
1
Work Location:
Sacramento County
Job Type:
Permanent, Full Time

Department Information

Information Technology Services Division/ Enterprise Architect & Web/App Development

The California Public Utilities Commission (CPUC) is one of the most influential regulatory agencies in the United States. For almost 100 years, the CPUC has worked to protect consumers and ensure the provision of safe, reliable utility service and infrastructure at just and reasonable rates, with a commitment to environmental enhancement and a healthy California Economy. The CPUC regulates privately owned electric, natural gas, telecommunications, water, railroad, rail transit, and passenger transportation companies.

The Information Technology Services Division is looking for the best candidate to join the team and continue our years of integrity and excellence. Do you strive to embody the same values that the Commission upholds? Take the opportunity now to start your career or further your career development with the CPUC.

Department Website: http://www.cpuc.ca.gov/

Special Requirements

If you are using education to meet the minimum qualifications for this position, you must submit a copy of your transcript or diploma. An official transcript il be required prior to appointment.

A statement of qualifications (SOQ) is required.  Your SOQ response must not be more than two (2) pages, using Arial, 11-point font, and address the following questions.  Please answer each of the questions and number your responses according to the question you are answering. 

Responses will be evaluate based on the content of your answers and on your written communication skills.

A cover letter may not be submitted in place of the Resume and SOQ.  Failure to follow instructions and format will result in disqualification.

Please write your SOQ to address the following:

  1. Knowledge and experience with designing, installing, upgrading, configuring, and administering Microsoft SQL Server in both on premise and cloud environments.
  2. Knowledge and experience with data modeling, data normalization/denormalization, import/export/ETL, and data validation/quality assurance.
  3. Knowledge and experience with writing, troubleshooting, and optimizing MS SQL Server queries.
  4. Knowledge and experience with capacity planning, supporting high availability configurations, backups and recovery, and disaster recovery of MS SQL Server environments.

Application Instructions

Completed applications and all required documents must be received or postmarked by the Final Filing Date in order to be considered. Dates printed on Mobile Bar Codes, such as the Quick Response (QR) Codes available at the USPS, are not considered Postmark dates for the purpose of determining timely filing of an application.

Final Filing Date: 8/20/2019

Who May Apply

Individuals who are currently in the classification, eligible for lateral transfer, eligible for reinstatement, have list eligibility, are in the process of obtaining list eligibility, or have SROA and/or Surplus eligibility (please attach your letter, if available). SROA and Surplus candidates are given priority; therefore, individuals with other eligibility may be considered in the event no SROA or Surplus candidates apply.

Applications will be screened and only the most qualified applicants will be selected to move forward in the selection process.

Applicants must meet the Minimum Qualifications stated in the Classification Specification(s).

How To Apply

Complete Application Packages (including your Examination/Employment Application (STD 678) and applicable or required documents) must be submitted to apply for this Job Posting. Application Packages may be submitted electronically through your CalCareer Account at www.CalCareers.ca.gov. When submitting your application in hard copy, a completed copy of the Application Package listing must be included. If you choose to not apply electronically, a hard copy application package may be submitted through an alternative method listed below:

Address for Mailing Application Packages

You may submit your application and any applicable or required documents to:

Public Utilities Commission
Attn: Human Resources Division
505 Van Ness Ave, Room 3008
San Francisco, CA 94102

Address for Drop-Off Application Packages

You may drop off your application and any applicable or required documents at:

Human Resources Division
505 Van Ness Ave, Room 3008
San Francisco, CA 94102
08:00 AM - 05:00 PM

Required Application Package Documents

The following items are required to be submitted with your application. Applicants who do not submit the required items timely may not be considered for this job:

  • Current version of the State Examination/Employment Application STD Form 678 (when not applying electronically), or the Electronic State Employment Application through your Applicant Account at www.CalCareers.ca.gov. All Experience and Education relating to the Minimum Qualifications listed on the Classification Specification should be included to demonstrate how you meet the Minimum Qualifications for the position.
  • Resume is required and must be included.
  • Statement of Qualifications - A Statement of Qualifications (SOQ) is required. Please see "Special Requirements" for instructions.
Applicants requiring reasonable accommodations for the hiring interview process must request the necessary accommodations if scheduled for a hiring interview. The request should be made at the time of contact to schedule the interview. Questions regarding reasonable accommodations may be directed to the EEO contact listed on this job posting.

Benefits

There are many benefits to joining the California Public Utilities Commission! The State of California offers a generous benefits package that includes:

  • Health, Dental & Vision Benefits
  • Paid Sick & Vacation
  • Retirement
  • Basic Group Term Life Insurance
  • Employee Assistance Program
  • 11 Paid Holidays
  • 401(k) & 457 plans
  • Telecommute Program
  • Alternate Work Schedule
  • Military Leave
  • Student Loan Forgiveness
  • Long Term Care
  • Group Legal Services
  • Reimbursement Accounts

and many more! Visit www.calhr.ca.gov for a full list of available benefits!

Contact Information

The Human Resources Contact is available to answer questions regarding the application process. The Hiring Unit Contact is available to answer questions regarding the position.

Department Website: http://www.cpuc.ca.gov/
Human Resources Contact:
Human Resources
(855) 663-0222
pucjobop@cpuc.ca.gov
Hiring Unit Contact:
Michael Bonner
(916) 823-4790
Michael.Bonner@cpuc.ca.gov

Please direct requests for Reasonable Accommodations to the interview scheduler at the time the interview is being scheduled. You may direct any additional questions regarding Reasonable Accommodations or Equal Employment Opportunity for this position(s) to the Department's EEO Office.

EEO Contact:
Mark Ferrara
(415) 703-5886
mark.ferrara@cpuc.ca.gov
California Relay Service: 1-800-735-2929 (TTY), 1-800-735-2922 (Voice) TTY is a Telecommunications Device for the Deaf, and is reachable only from phones equipped with a TTY Device.

Required and Desirable Experience/Qualifications

Required Experience/Qualification

  • Minimum qualifications for the Information Technology Specialist I.
Desirable Experience/Qualifications

  • Microsoft SQL Server DBA hands on skills in supporting a production database in all operations, such as troubleshooting daily operational issues.

  • Experience installing, maintaining, troubleshooting, and optimizing MS SQL Server technologies.

  • Experience with Microsoft SQL Server database capacity planning, performance tuning, high availability, backups/restores, and disaster recovery in complex environments and mission critical applications.

  • Data modeling (logical and physical), database normalization, and database denormalization experience.

  • Experience creating data load packages using MS SQL Server Integration Services (SSIS)/Data Quality Software (DQS), or comparable ETL and data quality software.

  • Tracking, monitoring, and reporting database jobs and processes using various software products.

  • Experience with Active Directory, LDAP, and Role/Responsibility Based User Control.

  • Experience deploying, supporting, and administering Microsoft SQL Server in cloud environments.

  • Communicate and prepare oral and written reports to IT management and end users.

  • Two years project/program lead experience.

Additional Application Information


To become “list eligible” for consideration, interested candidates must successfully pass a civil service exam.  

**The Department of Human Resources currently administers the Information Technology Specialist I online examination on a continuous basis. You may apply and take the exam on line at:

https://www.calcareers.ca.gov/JOBSGEN/7PB35.PDF

 

Equal Opportunity Employer

The State of California is an equal opportunity employer to all, regardless of age, ancestry, color, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding and related medical conditions), and sexual orientation.

It is an objective of the State of California to achieve a drug-free work place. Any applicant for state employment will be expected to behave in accordance with this objective because the use of illegal drugs is inconsistent with the law of the State, the rules governing Civil Service, and the special trust placed in public servants.