DATA BASE ADMINISTRATOR I/II

Print (https://www.governmentjobs.com/careers/clarkcounty/jobs/newprint/4496449)

Apply



DATA BASE ADMINISTRATOR I/II

Salary

$31.79 - $53.28 Hourly

Location

Clark County - Las Vegas, NV

Job Type

PERMANENT

Job Number

25977AX

Department

District Attorney

Opening Date

05/07/2024

Closing Date

Continuous

• Description

• Benefits

• Questions

ABOUT THE POSITION

The Clark County District Attorney's Office is seeking qualified candidates to apply for the Data Base Administrator I/II position. Candidates must be able to perform data base development, implementation, maintenance support and related staff training of a routine to complex nature in support of County administrative and business services for centralized and distributed network database applications.

Candidates must have strong MS SQL database administration, performance tuning, disaster recovery and database security skills. Additionally, candidates must be proficient in performing ETL operations utilizing SSIS, as well as in the creation of SSRS reports. MS SQL Azure skills and data base design skills are desirable.

Data Base Administrator I: $31.79 - $49.33 Hourly

Data Base Administrator II: $34.35 - $53.28 Hourly

The Data Base Administrator I is a training underfill position, upon successful completion of the training program the successful candidate will be non-competitively promoted to Data Base Administrator II.

This is an open and continuous recruitment, scheduling dates will vary depending on when the application was received and reviewed by Human Resources.

Human Resources reserves the right to call only the most qualified applicants to the selection process.

Employment is contingent upon the results of a background investigation, which may include both a pre-and post-offer background check for positions within the District Attorney’s Office.

MINIMUM REQUIREMENTS

Education and Experience:

Data Base Administrator I - Equivalent to a Bachelor's Degree in Computer Science, Management Information Systems, or a closely related field AND two (2) years of full-time systems analysis and/or applications programming experience, preferably in a large-scale computer system environment.

Data Base Administrator II - In addition to the above: Minimum of one (1) year of full-time professional level experience in complex data base definition and installation in a large-scale computer system environment.

Qualifying education and experience must be clearly documented in the “Education” and “Work Experience” sections of the application. Do not substitute a resume for your application or write "see attached resume" on your application.

Background Investigation: Employment is contingent upon successful completion of a background investigation. Periodically after employment background investigations may be conducted.

Pre-Employment Drug Testing: Employment is contingent upon the results of a pre-employment drug examination.

EXAMPLES OF DUTIES

Plans, prepares, defines, structures, develops and implements data base systems. Defines and implements interfaces to insure that various applications and user-installed or vendor-developed systems interact with the required data base systems. Tests, troubleshoots, refines and documents systems; applies quality assurance and security standards to ensure against the loss of data and a minimal interruption of usage in the event of equipment failure. Plans and develops test data to validate new or modified data base applications; monitors system performance by the use of appropriate utilities, online capabilities and batch reports. Confers with programmer/analyst and customer staff to define functional requirements, perform data modeling and implement final products; resolves errors and interface problems and ensures integrated systems in accordance with development standards. Writes program documentation and user procedures and instructions and assists user departments and staff in implementing new or modified data base applications; tracks and evaluates project and systems progress. Confers with customer staff regarding assigned functional program areas; serves on a variety of committees, project teams and task forces and provides "help desk" support, as assigned. Maintains records and prepares periodic and special reports of work performed. Maintains current knowledge of technology and data base applications and systems. Contributes to the efficiency and effectiveness of the unit's service to its customers by offering suggestions and directing or participating as an active member of a work team. Uses standard office equipment in the course of the work; may drive a County motor vehicle or be able to arrange for appropriate transportation between various work sites.

PHYSICAL DEMANDS

Mobility to work in a typical office setting and use standard office equipment, stamina to remain seated and maintain concentration for an extended period of time, vision to read printed materials and a computer screen, and hearing and speech to communicate in person or over the telephone. Accommodation may be made for some of these physical demands for otherwise qualified individuals who require and request such accommodation.

Come Make a Difference and Join the Clark County Family where we offer a comprehensive benefits package that includes:

• Flexible Schedules including 4/10 options

• More Money in Your Pocket

• 100% Employer Paid Defined Benefit Retirement

• No Social Security Deduction

• No State Income Taxes

• Two Employer Sponsored Health Plans Offered - Choice of PPO or EPO (hybrid of HMO)

• Medical (https://www.clarkcountynv.gov/government/departments/risk_management/employee_and_retiree_health_benefits.php#outer-2778) - Employer pays 90% of premium

• Pharmacy Benefits (30, 90-day retail or mail order fills)

• 24/7 Telephone Advice Nurse - no employee cost

• Teledoc, Doctoroo, and Dispatch Health

• Retiree insurance – eligible after 5 years of service

• Dental

• Vision

• Life Insurance – Employer Paid

• AD&D – Employer Paid

• Long Term Disability – Employer Paid

• Generous Leave Accruals that include:

• 13 Paid Holidays including a Floating Birthday Holiday

• Paid Vacation Leave

• Paid Sick Leave

• Holiday Leave

• Other leave options

• Catastrophic Leave

• Parental Leave – Up to 90 days

• Wide Variety of Voluntary Benefits that include

• Guardian – Accident, Cancer, Critical Illness, Hospital Indemnity, and Short-Term Disability Insurance.

• Trustmark – Permanent Life Insurance benefits and long-term care.

• Sunlife Financial – Basic and Voluntary Life Insurance, AD&D, and long-term disability insurance

• TASC – Flexible Spending Account – FSA & Dependent Day Care Debit Card Available

• Morgan Stanley – Deferred Compensation Plan

• Employee Assistance Program

• Onsite Fitness Center – $12/month

*Benefits vary and are subject to change depending on assignment, hiring organization and bargaining unit.

01

The following questions 1 - 6 will be used to assist in determining if candidates meet the minimum qualifications.

Which describes your highest level of education?

• Some High School

• High School Diploma or GED

• Trade School or Technical Degree

• Some College (1-29 semester credits)

• Some College (30-59 semester credits)

• Some College (60-89 semester credits)

• Some College (90-120+ semester credits)

• Associates Degree

• Bachelor's Degree

• Master's Degree or higher

• None of the above

  02

  Please indicate the major of your degree that best qualifies you for this position.

• Computer Science

• Management Information Systems

• Other

• Not Applicable

  03

  If you indicated "Other" in question 2, please list what major your degree was in. If this does not apply, type N/A.

  04

  Indicate your full-time professional experience in systems analysis and/or applications programming experience, preferably in a large-scale computer system environment.

• No Experience

• Less than 2 years

• 2 to 3 years

• 3 to 4 years

• 4 to 5 years

• 5 to 6 years

• More than 6 years

  05

  Indicate your full-time professional experience in complex data base definition and installation in a large-scale computer system environment.

• No Experience

• Less than 1 year

• 1 to 2 years

• 2 to 3 years

• 3 to 4 years

• 4 to 5 years

• More than 5 years

  06

  Please list the employer(s) on your application where your experience was obtained in questions 4 - 5. Type N/A if you have no related experience (see template below).

  Employer Name:

Job Title:

Hours Worked Per Week:

Dates of Employment:

07

The following skills assessment is a self-assessment used to evaluate an applicant's training and experience.

I understand that:

A) Part-time experience must be prorated and credited as half of full-time experience (i.e., if you performed the task for two years in a part-time position, 20 hours per week, you can only credit yourself with one year of experience in that area)

B) The education, knowledge, and experience levels indicated by my skills assessment responses must be supported and clearly documented in the "Education" and "Work Experience" sections of my application;

C) Any falsification or misrepresentation of the information listed on the employment application or skills assessment may result in removal from the eligibility list or rescinding a job offer;

D) Responses to assessment questions that are not supported and clearly documented in the "Education" and "Work Experience" sections on the application may result in question scores being adjusted to receive zero points;

E) Assessment scores may be used to consider applicants for the selection process;

F) I further understand that since exam scores will be automatically generated based on the applicant's response to each item in the assessment, score appeals will not be allowed for this recruitment.

• I have read and understand the above information regarding the completion of the following skills assessment questions. I further understand that this recruitment includes a skills assessment and that the answers I provide must be consistent with the "education" and "work history" sections detailed on my application and that scoring appeals will not be allowed for this recruitment.

  08

  Indicate your full-time professional experience working with the MS SQL Server.

• No Experience

• Less than 2 years

• 2 to 4 years

• 4 to 6 years

• More than 6 years

  09

  Indicate your full-time professional experience with MS Azure SQL.

• No Experience

• Less than 2 years

• 2 to 4 years

• 4 to 6 years

• More than 6 years

  10

  Indicate your full-time professional experience working with either Cosmos or MongoDB.

• No Experience

• Less than 2 years

• 2 to 4 years

• 4 to 6 years

• More than 6 years

  11

  Please list the employer(s) on your application where your experience was obtained in questions 8 - 10. Type N/A if you have no related experience (see template below).

  Employer Name:

Job Title:

Hours Worked Per Week:

Dates of Employment:

12

Indicate your full-time professional experience working with TSQL.

• No Experience

• Less than 2 years

• 2 to 4 years

• 4 to 6 years

• More than 6 years

  13

  Indicate your full-time professional experience working with XML or JSON.

• No Experience

• Less than 2 years

• 2 to 4 years

• 4 to 6 years

• More than 6 years

  14

  Indicate your full-time professional experience working with RESTful Services or SOAP Web Services or WCF Services.

• No Experience

• Less than 2 years

• 2 to 4 years

• 4 to 6 years

• More than 6 years

  15

  Please list the employer(s) on your application where your experience was obtained in questions 12 - 14. Type N/A if you have no related experience (see template below).

  Employer Name:

Job Title:

Hours Worked Per Week:

Dates of Employment:

16

Indicate your full-time professional experience working with the SSIS (SQL Server Integration Server) creating and implementing SSIS packages.

• No Experience

• Less than 2 years

• 2 to 4 years

• 4 to 6 years

• More than 6 years

  17

  Indicate your full-time professional experience working with the SSRS Reports Builder or Visual Studio Report Designer.

• No Experience

• Less than 2 years

• 2 to 4 years

• 4 to 6 years

• More than 6 years

  18

  Please list the employer(s) on your application where your experience was obtained in questions 16 - 17. Type N/A if you have no related experience See Template Below.

  Employer Name:

Job Title:

Hours Worked Per Week:

Dates of Employment:

19

Please indicate which of the following technologies you have experience working with (select all that apply):

• Oracle

• My SQL

• IBM DB2

• MQL

• Business Objects

• Azure Data Factory

• Crystal Reports

• Visual Studio

• Visual Studio Code

• C# language

• JavaScript language

• None of the above

  20

  Do you currently hold a valid driver's license?

• Yes, I currently hold a valid Nevada driver's license

• Yes, I currently hold a valid driver's license from another state.

• No, I do not currently hold a valid driver's license.

  Required Question

Agency

Clark County

Address

500 S. Grand Central Pkwy, 3rd Floor PO Box 551791 Las Vegas, Nevada, 89155-1791

Phone

(702)455-4565

Website

http://www.clarkcountynv.gov

Apply

Please verify your email address Verify Email