DATABASE ADMINISTRATOR

Job Description:

DATABASE ADMINISTRATOR

Description

Position/Program Information

TYPE OF RECRUITMENT

Open Competitive Job Opportunity

The application filing period will begin on December 13, 2024, at 8:00 a.m. (PT)-Continuous.

We will continue accepting applications until we determine it is no longer necessary. We may close the application filing window without prior notice.

EXAM NUMBER Y2620E

No withhold will be allowed. Required experience/education must be fully met at the time of filing and clearly indicated on the application.

ABOUT LOS ANGELES COUNTY DEPARTMENT OF HEALTH SERVICES:
The Los Angeles County Department of Health Services (DHS) is the second largest municipal health system in the nation. Through its integrated system of twenty-five (25) health centers and four (4) acute hospitals - and expanded network of community partner clinics - DHS annually provides direct care for over 600,000 unique patients, employs over 23,000 staff, and has an annual budget of over $6.9 billion. For additional information regarding DHS please visit www.dhs.lacounty.gov .

Through academic affiliations with the University of California, Los Angeles (UCLA), the University of Southern California (USC), and the Charles R. Drew University of Medicine and Sciences (CDU), DHS hospitals are training sites for physicians completing their Graduate Medical Education in nearly every medical specialty and subspecialty. In addition, to its direct clinical services, DHS also runs the Emergency Medical Services (EMS) Agency and the County's 911 emergency response system, as well as Housing for Health and the Office of Diversion and Re-entry, each with a critical role in connecting vulnerable populations, including those released from correctional and institutional settings to supportive housing.

MISSION:
“To advance the health of our patients and our communities by providing extraordinary care”.

DEFINITION:
Under direction performs a full range of activities required to support databases running on enterprise-level database management system (DBMS) software.

Essential Job Functions

Creates and maintains database management systems in the cloud.

Installs, configures and maintains database management systems utilizing high availability architectures.

Utilizes industry best practices standards for hardening database management systems.

Designs and implements secure authentication mechanisms that utilize Kerberos, Certificates, Active Directory and Managed Service Accounts.

Utilizes 3rd party tools and custom scripts to monitor system wait times to aid in identifying system performance issues.

Supports database environments.

Selects or assists in the selection of new database management systems including design, feasibility studies, cost estimates, impact analysis, data conversion functions, and reduction of redundant data.

Installs and configures database management software, including upgrades, patches, and third-party tools. Maintains database management software and related software.

Assists in the selection of new application systems by reviewing database design, database technologies, hardware specifications, and configuration and deployment plans for performance, maintainability, scalability, operations impact, and conformance to architectural standards.

Performs database backup and database recovery.

Manages disk space for database systems.

Conducts capacity planning.

Performs preventive maintenance tasks and database tuning.

Analyzes database requirements. Evaluates, designs, and implements database systems.

Develops or validates deployment scripts for database software changes and deploys databases and database changes in testing, training, preproduction, and production environments.

Writes stored procedures, functions, triggers, and batch jobs in the database system. Writes scripts used in database system management.

Analyzes query plans and monitors database system performance to identify and address performance problems.

Creates and manages indexes to support application performance requirements.

Analyzes database code written by developers to assess impact on the database system and application performance.

Designs and implements database security for applications, including creating database users, designing and assigning roles, and granting and denying database privileges.

Responds to database outages or performance problems and restores normal operations.

Monitors data quality, data integrity, and database availability.

Analyzes and resolves database problems.

Writes policies and procedures pertaining to database standards, management, security and maintenance.

Establishes and maintains security and integrity controls including data backup/recovery specifications.

Participates in the formulation of database strategies.

Participates in evaluation of new technologies in database management.

Assists in the development of database system related standards and methodologies and the selection of a standard DBA toolset.

Acts as a technical specialist on database concepts and functional capabilities.

Develop or assist in the development of programs for data extraction, transformation, and loading as needed.

Serve as liaison to vendors for negotiating license and support as needed.

Assist in the administration and support of application servers as needed.

Participate on a team of developers engaged in the overall database design, query tuning, creating indexes, and in the creation of triggers and stored procedures as needed.

Requirements

SELECTION REQUIREMENTS:
OPTION I:
Graduation from an accredited college with a bachelor’s degree* in computer science, information systems, or computer engineering with four (4) years of experience performing progressively responsible** information technology functions, one (1) year of which must include planning, designing, implementing, and administering of server-based, scalable databases.

OPTION II:
Two (2) years of experience at the level of Senior Application Developer*** or Senior Operating Systems Analyst**** in the service of Los Angeles County supporting and administering databases which must include planning, designing, implementing, and administering server-based, scalable databases.

OPTION III:
Five (5) years of experience performing progressively responsible** information technology functions, two (2) years of which must include planning, designing, implementing, and administering server-based, scalable databases.

PHYSICAL CLASS 2-Light:
This class includes administrative and clerical positions requiring light physical effort that may include occasional light lifting to a 10-pound limit and some bending, stooping, or squatting. Considerable ambulation may be involved.

LICENSE:
A valid California Class “C” Driver License or the ability to utilize an alternative method of transportation when needed to carry out job-related essential functions.

SPECIAL REQUIREMENT INFORMATION :

*In order to receive additional credit for degree you must include a legible copy of your official degree, official transcripts (which shows proof of degree awarded), or official letter, from the accredited institution which shows the area of specialization at the time of filing or within seven (7) calendar days from the date of filing application.

Applications received without evidence of the required degree will not be accepted as meeting the stated requirements. OFFICIAL TRANSCRIPT(S) MUST SHOW PROOF OF DEGREE AWARDED OR IF TRANSCIPT(S) DOES NOT SHOW DEGREE AWARDED BOTH TRANSCRIPT(S) AND DEGREE SHOULD BE SUBMITTED.

At the time of appointment, the successful candidate must be prepared to provide an original "official" transcript from the college or university to verify the required degree(s).

NOTE: If you are unable to attach required documents during application submission, you may email them to the exam analyst at kshelvy@dhs.lacounty.gov within 7 calendar days of filing online. Please include your name, the exam number and exam title in the subject line of the email.

To receive credit for your education, include a copy of your official diploma, official transcript, or certificate from an accredited institution as directed on the job posting. The document should be in English; if it is in a foreign language, it must be translated and evaluated for equivalency to U.S. standards. For more information on our standards for educational documents, please visit https://file.lacounty.gov/SDSInter/dhr/070812_PPG123.pdf and https://file.lacounty.gov/SDSInter/dhr/205105_PPG_123_ACE_Resource_Guide.pdf

We do not accept password-protected documents. Ensure documents are unlocked before attaching to your application or sending a copy to the exam analyst.

**Progressively responsible experience is defined as an increase in the level of complexity, difficulty, and responsibility performed within the field of information technology.

***Experience at the level of Senior Application Developer is defined under direction, performs a wide range of application development related duties including analysis, design, evaluation, development, coding, testing and maintenance of complex***** application systems.

****Experience at the level of Senior Operating Systems Analyst is defined Under direction, supports complex***** operating systems and associated software and hardware on midrange servers or mainframes hosting critical applications in a high-availability environment. These environments require formal change management and problem resolution procedures, highly fault tolerant configurations, and comprehensive back-up and recovery solutions.

***** Complex is defined as computing systems that handles hundreds of gigabytes and enable organizations to integrate and coordinate their business processes. Such systems that are distinguished architecturally by distributed components--data sources, networks, computing engines, simulations, human-in-the-loop control and remote access stations. They ensure that information can be shared across all functional levels and management hierarchies. Typically, such systems support companies and organizations that employ 1,000s of users.

Are you a veteran? If so, you may be eligible for veteran’s credit, which is an additional 10% of the total points added to a passing score. For more information about veteran’s credit, please visit the following link: https://www.opm.gov/policy-data-oversight/veterans-services/vet-guide-for-hr-professionals/

DESIRABLE QUALIFICATIONS:
Additional credit will be given to applicants that possess the following desirable qualifications:

• Additional experience in excess of the Selection Requirement performing progressively responsible information technology functions, under Option I or Option III.
• Additional experience in excess of the Selection Requirement at the level of Senior Application Developer or Senior Operating Systems Analyst, under Option II.
• Experience developing and supporting back-end software applications in the areas of data integration and data replication, data modeling, data security, artificial intelligence/machine learning, and database management by utilizing various developmental tools.
• Experience gathering of software requirements and developing requirement specifications, user stories, functional and technical design specifications, user manuals, runbooks, release notes, and/or wiki pages by collaborating with stakeholders.

Additional Information

EXAMINATION CONTENT:
This examination will consist of an evaluation of education, experience, and desirable qualifications based upon application information and supplemental questionnaire weighted 100%.

Applicants must achieve a passing score of 70% or higher on the examination to be added onto the list of eligible candidates.

ELIGIBILITY INFORMATION:
Applications will be processed on an "as-received" basis and those receiving a passing score will be promulgated to the eligible register accordingly.

The names of candidates receiving a passing score in the examination will be added to the eligible register and will appear in the order of their score group for a period of twelve (12) months following the date of promulgation.

No person may compete in this examination more than once every twelve (12) months.

SPECIAL INFORMATION
The County of Los Angeles is a Fair Chance employer. Except for a very limited number of positions, you will not be asked to provide information about a conviction history unless you receive a contingent offer of employment . The County will make an individualized assessment of whether your conviction history has a direct or adverse relationship with the specific duties of the job, and consider potential mitigating factors, including, but not limited to, evidence and extent of rehabilitation, recency of the offense(s), and age at the time of the offense(s). If asked to provide information about a conviction history, any convictions or court records which are exempted by a valid court order do not have to be disclosed. Qualified applicants with arrest or conviction records will be considered for employment in accordance with County Fair Chance Policies and the Fair Chance Act (Gov. Code Section 12952).

VACANCY INFORMATION:
The list of successful candidates created from this exam will be used to fill vacancies throughout the Department of Health Services (DHS) as they occur.

AVAILABLE SHIFT:
Appointees may be required to work any shift, including evenings, nights, weekends, and holidays.

APPLICATION AND FILING INFORMATION:
Applications must be submitted online only.

Apply online by clicking on the "Apply" green button at the top right of this posting. You can also track the status of your application using this web site.

Plan to submit your online application well in advance as you may be required to verify your email address. This only needs to be done once per email address, and if you already have a job seeker account on governmentjobs.com/careers/lacounty , you can verify at any time by logging in and following the prompts. This is to enhance the security of your online application and to ensure you do not enter an incorrect email address.

Many important notifications including final results notices will be sent electronically to the email address provided on the application. It is important that you provide a valid email address. Please add kshelvy@dhs.lacounty.gov , as well as noreply@governmentjobs.com , and info@governmentjobs.com to your email address and list of approved senders to prevent email notifications from being filtered as spam/junk/clutter mail.

Applicants have the ability to opt out of emails from LA County. If you unsubscribe, you will not receive any email notification for any examination for which you apply with Los Angeles County.

Regardless of whether you choose to unsubscribe, you can always check for notifications by logging into governmentjobs.com and viewing your profile inbox, which saves a copy of all emailed notices.

It is your responsibility to take the above steps to view correspondence. Los Angeles County will not consider claims of not viewing or receiving notification to be a valid reason for late test administration or re-scheduling of a test component.

Fill out your application completely. The acceptance of your application depends on whether you have clearly shown that you meet the exam requirements as listed on this job posting. Provide any relevant job experience in the spaces provided so we can evaluate your qualifications for the job. For each job held, give the name and address of your employer, your job title, beginning and ending dates, number of hours worked per week, and description of work performed. If your application is incomplete, it will be rejected.

Please note that all information included in the application materials is subject to verification at any point during the examination and hiring process, including after an appointment has been made. Falsification of any information may result in disqualification or rescission of appointment. Utilizing verbiage from Class Specification and requirements serving as your description of duties will not be sufficient to demonstrate that you meet the exam requirements. Comments such as “See Resume” or referencing other unsolicited materials/documents will not be considered a response. Doing so may result in an incomplete application, and you may be disqualified.

SOCIAL SECURITY NUMBER:
Please include your Social Security Number for record control purposes. Federal law requires that all employed persons have a Social Security Number.

COMPUTER AND INTERNET ACCESS AT PUBLIC LIBRARIES:
For candidates who may not have regular access to a computer or the internet, applications can be completed on computers at public libraries throughout Los Angeles County. Please refer to their website for updated information https://lacountylibrary.org/library-locator .

NO SHARING OF USER ID, E-MAIL, AND PASSWORD:
All applicants must file their application using their own user ID and password. Using a family member's or friend's user ID and password may erase a candidate's original application record.

Anti-Racism, Diversity, and Inclusion (ARDI):
The County of Los Angeles recognizes and affirms that all people are created equal and are entitled to all rights afforded by the Constitution of the United States. The Department of Health Services is committed to promoting Anti-racism, Diversity, and Inclusion efforts to address the inequalities and disparities amongst race. We support the ARDI Strategic Plan and its goals by improving equality, diversity, and inclusion in recruitment, selection, and employment practices.

DEPARTMENT CONTACT:
Kendrea Shelvy, Exam Analyst
kshelvy@dhs.lacounty.gov
(213) 288-7000

CALIFORNIA RELAY SERVICES PHONE:
(800) 735-2922

TELETYPE PHONE:
(800) 899-4099

ADA COORDINATOR PHONE:
(323) 914-7111

For detailed information, please click here

Salary:

$122,388.00 - $164,937.84 Annually