Powered by JobAps

1044 IS Engineer-Principal

Recruitment #PBT-1044-059567

Introduction

1044 IS ENGINEER - PRINCIPAL

DEPARTMENT OF PUBLIC HEALTH

This is a position Based Test conducted in accordance with Civil Service Rule 111A.

Under general direction of the Information Technology (IT) Manager, the 1044 IS Engineer - Principal Database Administrator (DBA) works in the IT Application Group. The incumbent will be responsible for a wide range of in-house and vendor supported SQL Servers. These include SQL versions 2000 to 2012, stand alone servers, clustered, and VM and SAN based instances. Many of the databases support high availability 24/7 healthcare applications.  The incumbent will be responsible for implementing backup strategies, ensuring that recovery mechanisms are in place and tested, that database growth and resource requirements are monitored, log files managed, and “best practice” security requirements are met. In addition, the Database Administrator will ensure the ability to migrate databases between servers and be responsible for patching and upgrading the SQL applications as required.

 

The essential duties and responsibilities of the Data Base Administrator include:

 

  • Design, create, implement and configure databases including backup/recovery, security and high availability solutions.   
  • Perform database administration functions, including setting up and running databases, and management utilities to backup, reorganize and restore databases and resolve production and operational problems.
  • Monitor and maintain a large number of SQL database servers running across the DPH enterprise.
  • Monitor memory and disk utilization; manage and reorganize database objects across servers to meet requirements and make optimal use of available resources.
  • Monitor and evaluate database performance including memory utilization and input/output efficiency.
  • Design, test and maintain the appropriate backup and restoration for each application. 
  • Use application tools and utilities to tune and optimize databases performance.
  • Develop, recommend and implement security permissions, privileges, standards and guidelines.
  • Troubleshoot and identify root causes and resolve or advise others on resolving the most complex and ambiguous database management hardware/software, data communication, and interoperating problems.
  • Analyze disk resource and growth requirements and recommend hardware and RDBMS upgrades and enhancements to meet long term needs.
  • Develop specifications for database management hardware and software upgrades and enhancements. 
  • Participate with systems administration team to evaluate and recommend enhancements to DPH technology infrastructure.
  • Participate in planning and executing installation of upgrade patches, new releases, and upgrades of any DPH software.
  • Establish and participate in project planning for testing, evaluation and implementation process
  • Manage project change and control processes, and integrate, configure, upgrade and monitor new data base management and developer tools and software in addition to performing SQL and executing SQL tuning.
  • Maintain “What’s Up Gold” agents to monitor SQL Server instances across the enterprise
  • Perform other related duties as assigned.

       

     

    Minimum Qualifications

    1. Possession of a Bachelor's degree from an accredited college or university, preferably in Computer Science, Business Administration, Information Technology, Engineering or a closely related field; AND

    2. Five (5) years of verifiable experience managing  relational databases, and design rules and development practices, including data modeling, data flow and entity relationship analysis, performance tuning, data structure analysis, logical and physical database design, storage capacity management and database recovery techniques; AND

    2. Possession of a Microsoft Certified Solutions Expert (MCSE) certificate.

    Special Requirements:
    Essential duties require the following physical skills and work requirements: Some positions may require sufficient strength and coordination for lifting, pushing, pulling and/or carrying the weight of computer systems equipment. May require bending, stooping and/or crawling in order to install or repair computer systems hardware.  May require hand/eye coordination and manual dexterity for taking apart casings, installing parts and reconnecting computer systems hardware. May involve extensive VDT exposure.

    How To Apply

    Applications for City and County of San Francisco jobs are being accepted through an online process. Visit www.jobaps.com/sf to register an account (if you have not already done so) and begin the application process.

    • Select the desired job announcement (PBT-1044-059567)
    • Select “Apply” and read and acknowledge the information
    • Select either “I am a New User” if you have not previously registered, or “I have Registered Previously”
    • Follow instructions on the screen

    Computers are available for the public (from 8:00 a.m. to 5:00 p.m. Monday through Friday) to file online applications in the lobby of the Dept. of Human Resources at 1 South Van Ness Avenue, 4th Floor, San Francisco.

    Applicants may be contacted by email about this announcement and, therefore, it is their responsibility to ensure that their registered email address is accurate and kept up-to-date.  Also, applicants must ensure that email from CCSF is not blocked on their computer by a spam filter.  To prevent blocking, applicants should set up their email to accept CCSF mail from the following addresses (@sfgov.org, @sfdpw.org, @sfport.com, @flysfo.com, @sfwater.org, @sfdph.org, @asianart.org, @sfmta.com, @sfpl.org).

    Applicants will receive a confirmation email that their online application has been received in response to every announcement for which they file.  Applicants should retain this confirmation email for their records.  Failure to receive this email means that the online application was not submitted or received.

    All work experience, education, training and other information substantiating how you meet the minimum qualifications must be included on your application by the filing deadline.  Information submitted after the filing deadline will not be considered in determining whether you meet the minimum qualifications.

    Applications completed improperly may be cause for ineligibility, disqualification or may lead to lower scores.

    If you have any questions regarding this recruitment or application process, please contact the exam analyst, Elaine Lee, by telephone at 415-206-5033, or by email at Elaine.Lee@sfdph.org.

    Verification:
    Applicants may be required to submit verification of qualifying education and experience at any point in the application, examination and/or departmental selection process. 

    Note: Falsifying one’s education, training, or work experience or attempted deception on the application may result in disqualification for this and future job opportunities with the City and County of San Francisco.

    Selection Procedures

    Training and Experience Evaluation:                                            Weight:  100%

    The information provided by candidates on the job application, requested verification, if required, and a Supplemental Questionnaire will be evaluated in relations to the knowledge, skills and abilities required for this position in class 1044 IS Engineer - Principal.

     

    Candidates will be placed on the eligible list in rank order according to their final score.

    Note: Applicants who meet the minimum qualifications are not guaranteed to advance through all of the steps in the selection process.

    The hiring department may administer additional position-specific selection procedures to make final hiring decisions.

     

    CERTIFICATION RULE: The certification rule for the ranked eligible lists resulting from this examination will be Rule of Three (3) Scores.

     

    ELIGIBLE LISTS:

    http://sfdhr.org/index.aspx?page=20#eligiblelists

    The eligible list resulting from this examination is subject to change after adoption (e.g., as a result of appeals), as directed by the Human Resources Director or the Civil Service Commission. The duration of the eligible list resulting from this examination process will be 6 months, and may be extended with the approval of the Human Resources Director.

     

    Upon approval of the Human Resource Director (see Civil Service Rule 111A.26.5), the eligible list resulting from this announcement may be used by other departments that also use this classification or a similar classification.  To find other Departments which use this classification, please see http://www.sfdhr.org/Modules/ShowDocument.aspx?documentID=13693. Search that document by title or job code to see which departments use the classification.

     

    POSITION BASED TESTING:

    http://www.sfdhr.org/index.aspx?page=20#positionbasedtesting

     

    REASONABLE ACCOMMODATION REQUEST:

    Information on requesting reasonable accommodation for persons with disabilities can be found at: http://www.sfdhr.org/index.aspx?page=20#applicantswithdisabilities

    Applicants with disabilities requiring reasonable accommodation for this examination must contact the examination analyst, Elaine Lee, by telephone at (415) 206-5033 (voice) or if hearing impaired (415) 557-4810 (TDD) or in writing to Elaine Lee, Department of Public Health Human Resources Services, 2789 – 25th Street, 3rd Floor, San Francisco, CA 94110 as soon as possible (specify class 1044 IS Engineer - Principal in all correspondence).

     

    VETERAN’S PREFERENCE:

    Information regarding requests for veteran’s preference can be found at:

    http://www.sfdhr.org/index.aspx?page=20#veteranspreference

     

    SENIORITY CREDIT IN PROMOTIONAL EXAMS:

    Information regarding seniority credit can be found at: http://www.sfdhr.org/index.aspx?

    page=20#senioritycredit

     

    TERMS OF THE ANNOUNCEMENT:

    http://www.sfdhr.org/index.aspx?page=20#announcementsdefinitions

     

    GENERAL INFORMATION: Important Employment Information for the City and County of San Francisco can be obtained at: http://www.sfdhr.org/index.aspx?page=20 or hard copy at 1 South Van Ness Avenue, 4th Floor,

    San Francisco, CA 94103

     

    COPIES OF APPLICATION DOCUMENTS:

    Applicants are advised to keep copies of all documents submitted. Submitted documents become a permanent part of the exam record and will not be returned. The hiring department may require applicants to submit the same documents and/or additional documents at a later date.

     

    RIGHT TO WORK: All persons entering the City and County of San Francisco workforce are required to provide verification of authorization to work in the United States.

     

    MEDICAL EXAMINATION:

    Prior to appointment, at the Department’s expense, applicants may be required to take a TB screening test, and a medical examination.

     

     

     

    COMBINED PROMOTIVE & ENTRANCE

    ISSUED: July 26, 2013

    ANNOUNCEMENT NO: PBT-1044-059567

    DEPARTMENT OF PUBLIC HEALTH

    TELEPHONE: (415) 206-5033 (EL)

    MICKI CALLAHAN

    HUMAN RESOURCES DIRECTOR

    DEPARTMENT OF HUMAN RESOURCES

    01122115

    Disaster Service Workers

    All City and County of San Francisco employees are designated Disaster Service Workers through state and local law (California Government Code Section 3100-3109). Employment with the City requires the affirmation of a loyalty oath to this effect. Employees are required to complete all Disaster Service Worker-related training as assigned, and to return to work as ordered in the event of an emergency.

    Benefits

     

    All employees hired on or after January 10, 2009 will be required (pursuant to San Francisco Charter Section A8.432) to contribute 2% of pre-tax compensation to fund retiree healthcare. In addition, most employees are required to make a member contribution towards retirement, typically 7.5% of compensation. For more information on these provisions, please contact the personnel office of the hiring agency.

    For more information about benefits, please click here.