Clark County
DATA BASE ADMINISTRATOR I/II
Clark County, Las Vegas, Nevada, us, 89105
Salary:
$32.74 - $54.88 Hourly
Location :
Clark County - Las Vegas, NV
Job Type:
PERMANENT
Job Number:
25977AX
Department:
District Attorney
Opening Date:
05/07/2024
Closing Date:
Continuous
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: $32.74 - $50.81 HourlyData Base Administrator II: $35.38 - $54.88 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.
THE SALARY FOR THIS RECRUITMENT HAS BEEN CHANGED AND IS NOW REFLECTED IN THE JOB ANNOUNCEMENT.
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.
Citizenship:
Candidates must be legally authorized to work in the United States.
Please note,
Clark County does not provide H1B visa sponsorships or transfers for any employment positions.
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 optionsMore Money in Your Pocket
100% Employer Paid Defined Benefit RetirementNo Social Security DeductionNo State Income Taxes
Two Employer Sponsored Health Plans Offered - Choice of PPO or EPO (hybrid of HMO)
- Employer pays 90% of premium
Pharmacy Benefits (30, 90-day retail or mail order fills)24/7 Telephone Advice Nurse - no employee costTeledoc, Doctoroo, and Dispatch Health
Retiree insurance - eligible after 5 years of serviceDentalVisionLife Insurance - Employer PaidAD&D - Employer PaidLong Term Disability - Employer PaidGenerous Leave Accruals that include:
13 Paid Holidays including a Floating Birthday HolidayPaid Vacation LeavePaid Sick LeaveHoliday Leave
Other leave options
Catastrophic LeaveParental 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 insuranceTASC - Flexible Spending Account - FSA & Dependent Day Care Debit Card AvailableMorgan Stanley - Deferred Compensation Plan
Employee Assistance ProgramOnsite 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 SchoolHigh School Diploma or GEDTrade School or Technical DegreeSome College (1-29 semester credits)Some College (30-59 semester credits)Some College (60-89 semester credits)Some College (90-120+ semester credits)Associates DegreeBachelor's DegreeMaster's Degree or higherNone of the above02
Please indicate the major of your degree that best qualifies you for this position.
Computer ScienceManagement Information SystemsOtherNot 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 ExperienceLess than 2 years2 to 3 years3 to 4 years4 to 5 years5 to 6 yearsMore 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 ExperienceLess than 1 year1 to 2 years2 to 3 years3 to 4 years4 to 5 yearsMore 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 ExperienceLess than 2 years2 to 4 years4 to 6 yearsMore than 6 years
09
Indicate your full-time professional experience with MS Azure SQL.
No ExperienceLess than 2 years2 to 4 years4 to 6 yearsMore than 6 years
10
Indicate your full-time professional experience working with either Cosmos or MongoDB.
No ExperienceLess than 2 years2 to 4 years4 to 6 yearsMore 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 ExperienceLess than 2 years2 to 4 years4 to 6 yearsMore than 6 years
13
Indicate your full-time professional experience working with XML or JSON.
No ExperienceLess than 2 years2 to 4 years4 to 6 yearsMore than 6 years
14
Indicate your full-time professional experience working with RESTful Services or SOAP Web Services or WCF Services.
No ExperienceLess than 2 years2 to 4 years4 to 6 yearsMore 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 ExperienceLess than 2 years2 to 4 years4 to 6 yearsMore than 6 years
17
Indicate your full-time professional experience working with the SSRS Reports Builder or Visual Studio Report Designer.
No ExperienceLess than 2 years2 to 4 years4 to 6 yearsMore 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):
OracleMy SQLIBM DB2MQLBusiness ObjectsAzure Data FactoryCrystal ReportsVisual StudioVisual Studio CodeC# languageJavaScript languageNone of the above
20
Do you currently hold a valid driver's license?
Yes, I currently hold a valid Nevada driver's licenseYes, I currently hold a valid driver's license from another state.No, I do not currently hold a valid driver's license.
Required Question
$32.74 - $54.88 Hourly
Location :
Clark County - Las Vegas, NV
Job Type:
PERMANENT
Job Number:
25977AX
Department:
District Attorney
Opening Date:
05/07/2024
Closing Date:
Continuous
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: $32.74 - $50.81 HourlyData Base Administrator II: $35.38 - $54.88 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.
THE SALARY FOR THIS RECRUITMENT HAS BEEN CHANGED AND IS NOW REFLECTED IN THE JOB ANNOUNCEMENT.
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.
Citizenship:
Candidates must be legally authorized to work in the United States.
Please note,
Clark County does not provide H1B visa sponsorships or transfers for any employment positions.
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 optionsMore Money in Your Pocket
100% Employer Paid Defined Benefit RetirementNo Social Security DeductionNo State Income Taxes
Two Employer Sponsored Health Plans Offered - Choice of PPO or EPO (hybrid of HMO)
- Employer pays 90% of premium
Pharmacy Benefits (30, 90-day retail or mail order fills)24/7 Telephone Advice Nurse - no employee costTeledoc, Doctoroo, and Dispatch Health
Retiree insurance - eligible after 5 years of serviceDentalVisionLife Insurance - Employer PaidAD&D - Employer PaidLong Term Disability - Employer PaidGenerous Leave Accruals that include:
13 Paid Holidays including a Floating Birthday HolidayPaid Vacation LeavePaid Sick LeaveHoliday Leave
Other leave options
Catastrophic LeaveParental 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 insuranceTASC - Flexible Spending Account - FSA & Dependent Day Care Debit Card AvailableMorgan Stanley - Deferred Compensation Plan
Employee Assistance ProgramOnsite 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 SchoolHigh School Diploma or GEDTrade School or Technical DegreeSome College (1-29 semester credits)Some College (30-59 semester credits)Some College (60-89 semester credits)Some College (90-120+ semester credits)Associates DegreeBachelor's DegreeMaster's Degree or higherNone of the above02
Please indicate the major of your degree that best qualifies you for this position.
Computer ScienceManagement Information SystemsOtherNot 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 ExperienceLess than 2 years2 to 3 years3 to 4 years4 to 5 years5 to 6 yearsMore 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 ExperienceLess than 1 year1 to 2 years2 to 3 years3 to 4 years4 to 5 yearsMore 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 ExperienceLess than 2 years2 to 4 years4 to 6 yearsMore than 6 years
09
Indicate your full-time professional experience with MS Azure SQL.
No ExperienceLess than 2 years2 to 4 years4 to 6 yearsMore than 6 years
10
Indicate your full-time professional experience working with either Cosmos or MongoDB.
No ExperienceLess than 2 years2 to 4 years4 to 6 yearsMore 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 ExperienceLess than 2 years2 to 4 years4 to 6 yearsMore than 6 years
13
Indicate your full-time professional experience working with XML or JSON.
No ExperienceLess than 2 years2 to 4 years4 to 6 yearsMore than 6 years
14
Indicate your full-time professional experience working with RESTful Services or SOAP Web Services or WCF Services.
No ExperienceLess than 2 years2 to 4 years4 to 6 yearsMore 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 ExperienceLess than 2 years2 to 4 years4 to 6 yearsMore than 6 years
17
Indicate your full-time professional experience working with the SSRS Reports Builder or Visual Studio Report Designer.
No ExperienceLess than 2 years2 to 4 years4 to 6 yearsMore 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):
OracleMy SQLIBM DB2MQLBusiness ObjectsAzure Data FactoryCrystal ReportsVisual StudioVisual Studio CodeC# languageJavaScript languageNone of the above
20
Do you currently hold a valid driver's license?
Yes, I currently hold a valid Nevada driver's licenseYes, I currently hold a valid driver's license from another state.No, I do not currently hold a valid driver's license.
Required Question