DATABASE ADMINISTRATOR

Position/Program Information

EXAM NUMBER:

W2620D

When to Submit Your Application:
The application filing period will begin on Thursday, June 20, 2024, at 7:00 a.m. (PT) through Wednesday, July 3, 2024, 5:30 p.m. (PT).

TYPE OF RECRUITMENT: Open Competitive Opportunity

No with-hold or out-of-class experience will be accepted.

Check Out Our Outstanding Benefits!
Los Angeles County offers one of the strongest public-sector benefits packages in the nation.

• Flexible Benefit Plans - Benefits may be purchased using tax-free County contribution of an additional 14.5%-17% of the employee's monthly salary.
• Robust Retirement Packages - Contributory-defined benefit plan; optional tax-deferred income plans that may include a County matching contribution up to 4% of employee's salary.
• Generous Maternity and Family Leave Benefits
• Flexible Schedules (4/40 workweeks - where appropriate, Telework - where appropriate)
• Rideshare, Parking, and Transit Benefits
• 13 paid holidays per year
  

Who We Are:
The Internal Services Department (ISD) plays a major role in supporting all County of Los Angeles departments and commissions. With an annual budget of over $885M and 2,162 budgeted positions along with over 5,120 contracted workers of varying professions in facilities management, information technology, environmental, administrative, purchasing, and contracting, ISD is the County's trusted partner and provider of choice.

The Opportunity:
We are pursuing a qualified candidates to fill a Database Administrator in the Computing Services Branch. The position performs a full range of activities required to support databases running on enterprise-level database management system (DBMS) software.
Positions allocable to this class are responsible for logical and physical database design, implementation, and maintenance of databases. Incumbents are responsible for ensuring that Department and/or County-wide data and technical requirements, including data definition, data structure, documentation, operational guidelines, and data protection are met. Incumbents possess knowledge of the principles and practices of multiple information technology disciplines, including database design, application development, network, hardware, systems software, and applications software.

Essential Job Functions

What you will be doing:

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.

Develops or assist in the development of programs for data extraction, transformation, and loading.

Serves as liaison to vendors for negotiating license and support.

Assists in the administration and support of application servers.

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

Requirements

Requirements to Qualify
OPTION I:
Graduation from an accredited college with a Bachelors degree in Computer Science, Information Systems or a closely related field 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 performing a variety of tasks in support of administering databases

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.

Physical Expectations:
Physical Class II - 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.

SPECIAL REQUIREMENT INFORMATION:
*A Senior Application Developer in the service of Los Angeles County is defined as, under direction, performs a wide range of application development related duties including analysis, design, evaluation, development, coding, testing and maintenance of complex application systems.

**A Senior Operating Systems Analyst in the service of Los Angeles County is defined as, 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.

We would like for you to submit proof of education along with the application. Acceptable documents are:

• A photocopy of diploma or official transcript OR
• A verification or confirmation letter from the school's Registrar's Office on the official letter head of the school, with college or university seal. It should indicate that the student has completed all the academic requirements

All documents should clearly indicate the degree in English language and the date when the degree was conferred or awarded.

DESIRABLE QUALIFICATIONS:
Strong organizational skills, including the ability to handle tasks and meet critical deadlines.
Excellent customer service and interpersonal skills.
Excellent oral and written communications skills.
Strong project management skills.

Additional Information

Our Assessment Process
First meet our requirements above. After that, our process includes a two-part assessment.

Part I: M ultiple-choice and/or simulation assessments, weighted at 50%, measuring:

• Deductive Reasoning
• Professional Potential
• Achievement
• Working Relationships
• Analyzing Information
• Learning Quickly
• Generating New Ideas
• Using Time Efficiently
• Working to High Quality Standards
• Adapting to Change
• Coping with Uncertainty
• Willingness to Learn
• Responsibility

Applicants must achieve a passing score of 70% or higher on Part I in order to proceed to Part II of the assessment.

Part II: Multiple-choice and/or simulation assessments, weighted at 50%, measuring the following Professional/Technical Knowledge areas:

• Software Business Analysis: Business Process; Diagramming and Modeling; Documentation; Joint Application Development; Methodologies and Tools; Project Development; Requirements Gathering; System Design; and User Interface.
• Cloud Computing: Knowledge of Cloud Computing Concepts; Cloud Service Models; Virtualization; Private Clouds.
• SQL: Knowledge of SQL Queries; Data Manipulation; Transaction Processing.
• Data Warehousing Concepts: Big Data and Data Warehouse Appliance, Business Considerations, Data Transformation, Data Warehousing and Data Marts, Design, Dimensional Data Model, Online Analytical Processing, Querying and Reporting/Data Extraction .

Applicants must meet the Requirements and achieve a passing score of 70% or higher on each weighted part of the assessment in order to be placed on the Eligible List.

MULTIPLE-CHOICE AND/OR SIMULATION ASSESSMENT(S) ARE NOT REVIEWABLE BY CANDIDATES PER CIVIL SERVICE RULE 7.19.

TRANSFER OF TEST COMPONENTS

• Applicants who have taken identical components recently for other exams may have their responses automatically transferred to this examination.
• This examination contains test components that may be used in the future for new examinations and your test responses may be transferred.

Test Preparation: There are websites that may help you prepare for the assessments. One is our Online Test Prep site, located at https://hr.lacounty.gov/job-search-toolkit/. Another resource is the SHL website, located at https://www.shldirect.com/en/practice-tests. While the sites will help you in preparing for tests, we advise you to review all related materials you deem necessary.

ELIGIBILITY INFORMATION: The names of candidates receiving a passing score in the assessment will be placed on the Eligible List in the order of their score group for a period of twelve (12) months following the date of promulgation. Passing this examination and being placed on the Eligible List do not guarantee an offer of employment.

Vacancy Information:
The resulting Eligible List for this examination will be used to fill vacancies in the Internal Services Department, Information Technology Service located at 9150 E. Imperial Highway, Downey, CA 90242.

Shift: Any

How to Apply
Applications must be field online only. We must receive your application before 5:30 p.m., (PT), on the last day of filing. Applications submitted by U.S. Mail, Fax, or in person will not be accepted. Apply online by clicking on the green “Apply” button at the top right of this posting. You can track the status of your application using the website https://www.governmentjobs.com/careers/lacounty .
Many important notifications including invitation letters will be sent electronically to the email address provided on the application. It is important that you provide a valid email address. Please add “hvasquez@isd.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.

Plan to submit your online application well in advance of the deadline 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 www.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.

Please make sure you put in the time and effort when filling out your application and supplemental questions completely. The acceptance of your application depends on whether you have clearly shown that you meet the Requirements to Qualify as listed on this bulletin. 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 requirements. Doing so may result in an incomplete application and you may be disqualified.

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 Human Resources 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. (optional)

Have questions about anything listed above?
Contact us:
Exam Number: W2620D
Department Contact Name: Hugo Vasquez
Department Contact Phone: 323-881-3670
Department Contact Email: hvasquez@isd.lacounty.gov

ADA Coordinator Phone: (323) 267-2432
Teletype Phone: (800) 899-4099
Alternate Teletype Phone: (800) 897-0077
California Relay Services Phone: (800) 735-2922

Any language contained in the job posting supersedes any language contained below.
Your Responsibilities:
1. Completing Your Application :
a. Before submission of the application, it is your responsibility to ensure that all information provided is correct and complete on the application. Incomplete applications cannot be accepted.
b. List each payroll title separately for each job. Do not group your experience. Specify the beginning and ending dates for each job. If you are a Los Angeles County employee and have held multiple positions, do NOT list all of your time with the County under your present payroll title.
c. Please include your Social Security Number for record control purposes. Federal law requires that all employed persons have a Social Security Number.
d. To receive credit, include required documents (e.g., copy of your diploma, transcript, certificate, or license) as directed on the job posting. International degrees in a foreign language must be translated to English and evaluated for equivalency to U.S. standards. Refer to the job posting for specific deadlines for supporting documentation.
2. Requirements on Job Posting :
a. Your application will only be accepted if it clearly shows you meet the requirements. The information you give will determine your eligibility and is subject to verification at any time.
b. You must be at least 16 years of age at the time of appointment unless other age limits are stated on the job posting. The Federal Age Discrimination in Employment Act (ADEA) of 1967, as amended, prohibits discrimination on the basis of age for any individual over age 40.
c. Experience is evaluated on the basis of a verifiable 40- hour week, unless specified otherwise. Prorated part-time experience may be acceptable.
3. Application Deadline : All job applications must be completed and submitted before the closing time on the last day of the filing period as indicated on the job posting unless other instructions are provided. Job postings with an open continuous filing period are subject to closure without prior notice. It is to your advantage to file your application early and not wait until the last allowable date and time as you will not be able to apply once the filing period has closed.
4. Change of Name or Address : To change personal information such as your name or address, log into your profile on www.governmentjobs.com and make the necessary change. This can be done at any time.
5. Equal Employment Opportunity/Non-Discrimination Policy :
a. It is the policy of the County of Los Angeles to provide equal employment opportunity for all qualified persons, regardless of race, color, religion, sex, national origin, age, sexual orientation or disability. b. If you are an individual requesting reasonable accommodation(s) in the examination process, please contact the testing accommodation coordinator listed on the job posting. The provision of accommodation may be subject to verification as allowable with State and Federal law. All accommodation-related information will remain confidential.

Disclaimer : The County of Los Angeles is not responsible or in any way liable for any computer hardware or software malfunction which may affect the employment application or the application selection process.

You assume all responsibility and risk for the use of this system and the Internet generally. This system and the information provided on it are provided on an "as is" and "as available" basis without warranties of any kind, either express or implied. No advice or information given by the County of Los Angeles or its respective employees shall modify the foregoing or create any warranty.

The County of Los Angeles expressly disclaims any warranty that the information on this system or on the Internet generally will be uninterruptible or error free or that any information, software or other material accessible from the system is free of viruses or other harmful components. You shall have no recourse against the County of Los Angeles as the system provider for any alleged or actual infringement of any proprietary rights a user may have in anything posted or retrieved on our system.

The County of Los Angeles shall not be liable for any direct, indirect, punitive, incidental, special or consequential damages arising out of or in any way connected with the use of this system or with the delay or inability to use it (or any linked sites), or for any information obtained through this system, or otherwise arising out of the use of this system, the Internet generally or on any other basis.

NOTE: Your application is submitted using Secure Encryption to ensure the privacy of all information you transmit over the Internet.

By accepting the Use Disclaimer set forth here, you agree to all of the above terms and further agree to use this Online Job Employment Application System only for the submission of bona fide employment applications to the County of Los Angeles. Any other use of this Online Job Employment Application System, including without limitation any copying, downloading, translating, decompiling, or reverse engineering of the system, data, or related software, shall be a violation of the Use Disclaimer.

Test Preparation : Study Guides and other resources are available to help candidates prepare for employment tests. An interactive system for taking practice tests may be accessed on the Department of Human Resources website at https://hr.lacounty.gov /. Additional resources may be listed on the job posting. COUNTY OF LOS ANGELES Employment Information Any language contained in the job posting supersedes any language contained below.

Veteran’s Credit : In all open competitive examinations, a veteran’s credit of 10 percent of the total credits specified for such examinations will be added to the final passing grade of an honorably discharged veteran who served in the Armed Forces of the United States under any of the following conditions: During a declared war; -or- During the period April 28, 1952 through July 1, 1955; -or- For more than 180 consecutive days, other than for training, any part of which occurred after January 31, 1955, and before October 15, 1976; -or- During the Gulf War from August 2, 1990 through January 2, 1992; -or- For more than 180 consecutive days, other than for training, any part of which occurred during the period beginning September 11, 2001, and ending on August 31, 2010 the last day of Operation Iraqi Freedom; -or- In a campaign or expedition for which a campaign medal or expeditionary medal has been authorized and awarded. Any Armed Forces Expeditionary medal or campaign badge, including El Salvador, Lebanon, Grenada, Panama, Southwest Asia, Somalia, and Haiti qualifies for credit.

A campaign medal holder or Gulf War veteran who originally enlisted after September 7, 1980 (or began active duty on or after October 14, 1982, and has not previously completed 24 months of continuous active duty) must have served continuously for 24 months or the full period called or ordered to active duty.

This also applies to the spouse of such person who, while engaged in such service was wounded, disabled or crippled and thereby permanently prevented from engaging in any remunerative occupation, and also to the widow or widower of any such person who died or was killed while in such service. A DD214, Certificate of Discharge or Separation from Active Duty, or other official documents issued by the branch of service are required as verification of eligibility for Veterans preference. Applicants must submit the documentation for each open competitive exam to qualify for veteran’s credit. More information available at: https://www.opm.gov/policy-data-oversight/veteransservices/vet-guide-for-hr-professionals/

Accreditation Information : Accredited institutions are those listed in the publications of regional, national or international accrediting agencies which are accepted by the Department of Human Resources. Publications such as American Universities and Colleges and International Handbook of Universities are acceptable references. Also acceptable, if appropriate, are degrees that have been evaluated and deemed to be equivalent to degrees from United States accredited institutions by an academic credential evaluation agency recognized by The National Association of Credential Evaluation Services or the Association of International Credential Evaluators, Inc. (AICE). More information available at: http://file.lacounty.gov/SDSInter/dhr/070812_PPG123.pdf (Download PDF reader) and http://file.lacounty.gov/SDSInter/dhr/205105_PPG_123_AC E_Resource_Guide.pdf

Background Check : 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). I f 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.

Career Planning : Resources to help current and prospective employees plan a career with Los Angeles County are available. To explore career paths to and from nearly all job titles, please visit our interactive Career PathFinder application at https://career-pathfinder.hr.lacounty.gov/#/ .

Benefit Information : Depending on the position, the successful candidate will enroll in a contributory defined benefit pension plan if the candidate is a “new member” of the County’s defined benefit plan (LACERA) on or after January 1, 2013 (first employed by the County on or after December 1, 2012) - unless she or he established reciprocity with another public retirement system in which she or he was a member before January 1, 2013. It should be noted that County employees do not pay into Social Security, but do pay the Medical Hospital Insurance Tax portion of Social Security at a rate of 1.45%. The Los Angeles County Employees Retirement Association (LACERA) has reciprocal agreements with several public retirement systems in California.

Americans with Disabilities Act of 1990 : All positions are open to qualified men and women. Pursuant to the Americans with Disabilities Act of 1990, persons with disabilities who believe they need reasonable accommodation, or help in order to apply for a position, may contact the ADA/Personnel Services for Disabled Persons Coordinator. Hearing impaired applicants with telephone teletype equipment may leave messages by calling the teletype phone number on the job posting. The County will attempt to meet reasonable accommodation requests whenever possible.

Equal Employment Opportunity : It is the policy of the County of Los Angeles to provide equal employment opportunity for all qualified persons, regardless of race, religion, sex, national origin, age, sexual orientation, or disability or any other characteristic protected by State or Federal law. All positions are open to qualified men and women pursuant to the Americans with Disabilities Act of 1990 and the California Fair Employment and Housing Act. The County will comply with all of its obligations under State and Federal laws regarding the provision of reasonable accommodations to applicants. COUNTY OF LOS ANGELES Employment Information Any language contained in the job posting supersedes any language contained below.

Los Angeles County Child Support Compliance Program : In an effort to improve compliance with courtordered child, family and spousal support obligations, certain employment and identification information (i.e., name, address, Social Security number and date of hire) is regularly reported to the State Directory of New Hires which may assist in locating persons who owe these obligations. Family Code Section 17512 permits under certain circumstances for additional employment and identifying information to be requested. Applicants will not be disqualified from employment based on this information.

Social Security Act of 2004 : Section 419 (c) of Public Law 108-203, the Social Security Protection Act of 2004, requires State and local government employers to disclose the effect of the Windfall Elimination Provision and the Government Pension Offset Provision to employees hired on or after January 1, 2005, in jobs not covered by Social Security. The County of Los Angeles does not participate in the Social Security System. All newly hired County of Los Angeles employees must sign a statement (Form SSA1945) prior to the start of employment indicating that they are aware of a possible reduction in their future Social Security benefit entitlement. For more information on Social Security and about each provision, you may visit the website www.socialsecurity.gov , or call toll free 1-800-772- 1213. Persons who are deaf or hard of hearing may call the TTY number 1-800-325-0778 or contact a local Social Security office.

Employment Eligibility Information : Final appointment is contingent upon verification of U.S. citizenship or the right to work in the United States. Immigration law provides that all persons hired after November 6, 1986, are required to present original documents to the County, within three (3) business days of hiring, which show satisfactory proof of 1) identity and 2) U.S. employment eligibility.

The California Fair Employment and Housing Act (Part 2.8 commencing with Section 12900 of Division 3 of Title 2 of the Government Code) and the Regulations of the Fair Employment and Housing Commission (California Code of Regulations, Title 2, Division 4, Sections 7285.0 through 8504) prohibits employment discrimination based on race or color; religion; national origin or ancestry, physical disability; mental disability or medical condition; marital status; sex or sexual orientation; age, with respect to persons over the age of 40; and pregnancy, childbirth, or related medical conditions.

For detailed information, please click here

Closing Date/Time: 7/3/2024 5:30 PM Pacific

Los Angeles, California United States View Map