DATA BASE ADMINISTRATOR I/II

DATA BASE ADMINISTRATOR I/II Print (https://www.governmentjobs.com/careers/clarkcounty/jobs/newprint/4496449) Apply ? DATA BASE ADMINISTRATOR I/II 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 + 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: $32.74 - $50.81 Hourly Data 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 Attorneys 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 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