What are the responsibilities and job description for the IT Database Administrator II (DOH/ITSD #37131) position at New Mexico Department of Health?
Salary
$34.05 - $54.48 Hourly
$70,826 - $113,321 Annually
This position is a Pay Band IE
Posting Details
This posting will be used for ongoing recruitment and may close at any time. Applicant lists may be screened more than once.
Department of Health DOH, Information Technology Support Division ITSD, Infrastructure, Operations and Networks ION group all work together to server public health care needs of the citizens of New Mexico.
Why does the job exist?
The purpose of this position within the Operations team in the Information Technology Services Division will be to serve as a Database Administrator for the New Mexico Department of Health.
How does it get done?
This position will work within our three person database administration team and be responsible for the support, management, maintenance, and operation of our 300 Microsoft SQL databases, our 50 Microsoft SQL database servers, and multiple SAS servers. The applicant will need to create and maintain databases, manage permissions, perform server and software maintenance, monitor databases, upgrade databases, perform database backups and restores, plan and perform On Premise to Cloud database migrations, troubleshoot issues, write and modify SQL queries, and provide long term planning and guidance. This position will work directly with, and will need to communicate effectively with, our DBA team, our Operations team, DOH Program partners, external Program partners, ITSD staff and Leadership, DOH management, and other technical staff at the Department of Information Technology (DoIT). This position requires the ability to perform and accomplish job requirements with minimal direction and/or supervision; the ability to work successfully in a team environment; and the ability to apply industry best practices.
Who are the customers?
This position supports all of Department of Health.
Ideal Candidate
Experience with Microsoft SQL Database Administration, SQL queries, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SAS Servers, and Microsoft Azure.
Excellent written and verbal communication skills.
Excellent organizational and time management skills.
The ability to adapt and to thrive in an ever changing, fast paced environment.
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. Any combination of education from an accredited college or university in a related field and/or direct experience in this occupation totaling six (6) years may substitute for the required education and experience.
Substitution Table
These combinations of education and experience qualify you for the position:
EducationExperienceEducationExperience
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
Must possess and maintain a valid Driver's License. Must possess and maintain a current Defensive Driving Course Certificate from the State of New Mexico OR must pass and receive Defensive Driving Course Certification as a condition of continued employment. Successful completion of Health Insurance Portability and Accountability Act (HIPAA) prior to being authorized to perform work.
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
Do you know what Total Compensation is? Click here
Agency Contact Information: Steven Santistevan (505) 635-1058. Email
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.
$34.05 - $54.48 Hourly
$70,826 - $113,321 Annually
This position is a Pay Band IE
Posting Details
This posting will be used for ongoing recruitment and may close at any time. Applicant lists may be screened more than once.
Department of Health DOH, Information Technology Support Division ITSD, Infrastructure, Operations and Networks ION group all work together to server public health care needs of the citizens of New Mexico.
Why does the job exist?
The purpose of this position within the Operations team in the Information Technology Services Division will be to serve as a Database Administrator for the New Mexico Department of Health.
How does it get done?
This position will work within our three person database administration team and be responsible for the support, management, maintenance, and operation of our 300 Microsoft SQL databases, our 50 Microsoft SQL database servers, and multiple SAS servers. The applicant will need to create and maintain databases, manage permissions, perform server and software maintenance, monitor databases, upgrade databases, perform database backups and restores, plan and perform On Premise to Cloud database migrations, troubleshoot issues, write and modify SQL queries, and provide long term planning and guidance. This position will work directly with, and will need to communicate effectively with, our DBA team, our Operations team, DOH Program partners, external Program partners, ITSD staff and Leadership, DOH management, and other technical staff at the Department of Information Technology (DoIT). This position requires the ability to perform and accomplish job requirements with minimal direction and/or supervision; the ability to work successfully in a team environment; and the ability to apply industry best practices.
Who are the customers?
This position supports all of Department of Health.
Ideal Candidate
Experience with Microsoft SQL Database Administration, SQL queries, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SAS Servers, and Microsoft Azure.
Excellent written and verbal communication skills.
Excellent organizational and time management skills.
The ability to adapt and to thrive in an ever changing, fast paced environment.
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. Any combination of education from an accredited college or university in a related field and/or direct experience in this occupation totaling six (6) years may substitute for the required education and experience.
Substitution Table
These combinations of education and experience qualify you for the position:
EducationExperienceEducationExperience
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.
Must possess and maintain a valid Driver's License. Must possess and maintain a current Defensive Driving Course Certificate from the State of New Mexico OR must pass and receive Defensive Driving Course Certification as a condition of continued employment. Successful completion of Health Insurance Portability and Accountability Act (HIPAA) prior to being authorized to perform work.
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
Do you know what Total Compensation is? Click here
Agency Contact Information: Steven Santistevan (505) 635-1058. Email
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.
Salary : $70,826 - $113,321
