DATABASE ADMINISTRATOR

DATABASE ADMINISTRATOR

Print (/ governmentjobs. com/careers/lacounty/jobs/newprint/4739137)

Apply



DATABASE ADMINISTRATOR

Salary

$122,388. 00 - $164,937. 84 Annually

Location

Los Angeles County, CA

Job Type

Full time

Job Number

Y2620E

Department

HEALTH SERVICES

Opening Date

12/12/2024

• Description

• Benefits

• Questions

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 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 withfour (4) yearsof experience performing progressively responsible* information technology functions,one (1) yearof which must include planning, designing, implementing, and administering of server-based, scalable databases.

OPTION II:

Two (2) yearsof 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) yearsof experience performing progressively responsible* information technology functions,two (2) yearsof 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 .