IT Database Administrator II (HSD/ITD #80514)

$33.71 – $53.94 Hourly

$70,124 – $112,198 Annually

This position is a Pay Band IE

Posting Details

This posting may be used to fill multiple vacancies.

This posting will be used to conduct an ongoing recruitment and will remain open until all positions have been filled.

Why does the job exist?

The IT Database Administrator II will:

  • Serve as a Database Administrator for the New Mexico Human Services Department.

How does it get done?

The IT Database Administrator II is responsible for:

  • Providing support, management, and operation of enterprise MS SQL and Oracle database systems associated with meeting the HSD needs;
  • Data reporting and analysis, software installation and maintenance, Extraction, Transformation, and Loading (ETL), database and query performance tuning, database backup and recovery, security, user authentication, capacity planning, performance monitoring, and troubleshooting.

Who are the customers?

  • This position will collaborate with and serve internal and external business and technology stakeholders at all levels.

Ideal Candidate

The ideal candidate has experience with:

  • T-SQL, stored procedures, database modeling, and query performance tuning;
  • Database maintenance and management experience;
  • Exporting, Transforming and Loading (ETL) is required.

Minimum Qualification

Bachelor’s degree in Computer Science, Management Information Systems (MIS), Information Technology, Engineering or similar technical degree and two (2) years of experience in data analysis, design, storage and security. Substitutions Apply. See Substitution Table below.

Substitution Table

These combinations of education and experience qualify you for the position:
Education Experience Education Experience 1 High School Diploma or Equivalent AND 6 years of experience OR High School Diploma or Equivalent AND 6 years of experience 2 Associate’s degree in the field(s) specified in the minimum qualification AND 4 years of experience Associate’s degree or higher in any field AND 6 years of experience 3 Bachelor’s degree in the field(s) specified in the minimum qualification AND 2 years of experience 4 Master’s degree or higher in the field(s) specified in the minimum qualification AND 0 years of experience
• Education and years of experience must be related to the purpose of the position.
• If Minimum Qualification requires a specific number of “semester hours” in a field (e.g. 6 semester hours in Accounting), applicants MUST have those semester hours in order to meet the minimum qualifications. No substitutions apply for semester hours.

Employment Requirements

  • Employment is subject to a pre-employment criminal history background investigation and is conditional pending results.
  • Must possess and maintain a valid driver’s license.

Working Conditions

Work is performed in an office setting with exposure to Visual/Video Display Terminal (VDT) and extensive personal computer and phone usage. Some sitting, standing, bending and reaching may be required.

Supplemental Information

Benefits:

Do you know what Total Compensation is? Click here

Agency Contact Information: Angela.Simmons@hsd.nm.gov

For information on Statutory Requirements for this position, click the Classification Description link on the job advertisement.

Bargaining Unit Position

This position is covered by a collective bargaining agreement and all terms/conditions of that agreement apply and must be adhered to.

Job Category
Computer and IT
Job Type
Full Time/Permanent
Salary
USD 70,124.00 - 112,198.00 per year
Country
United States
City
Santa Fe
Career Level
unspecified
Company
State of New Mexico
JOB SOURCE
https://careers.share.state.nm.us/psc/hprdcg/EMPLOYEE/HRMS/c/HRS_HRAM_FL.HRS_CG_SEARCH_FL.GBL?Page=HRS_APP_JBPST_FL&Action=U&FOCUS=Applicant&SiteId=1&JobOpeningId=137639&PostingSeq=1