IT Database Administrator II

$34.05 - $54.48 Hourly $70,826 - $113,321 Annually This position is a Pay Band IE Posting Details We are so pleased that you are interested in making an impact through our work at CYFD The department thrives on dedicated, empathetic, and talented employees who ensure the well-being of the children and families in New Mexico by keeping them safe and healthy. By joining CYFD, you'll work to find the best ways to support families through difficult situations using community-based prevention and intervention programs. Employees have teammates and a committed leadership team to support them every day. We look forward to you joining us because caring for and supporting New Mexico's children and youth will take all of us. I know the department's mission is critical to improving the overall well-being of children in our state and, in turn, strengthening the future of New Mexico. THIS JOB POSTING WILL BE USED FOR ONGOING RECRUITMENT AND MAY CLOSE AT ANY TIME. APPLICANT LISTS MAY BE SCREENED MORE THAN ONCE. Why does the job exist? Install, configure, upgrade, administer, monitor, and maintain operationally efficient databases. Experience and knowledge in administration and in developing new dashboards or report development in the various platforms like Power BI, Sql Server Reporting Services, and Cloud databases (e.g. Azure). How does it get done? Duties and responsibilities include the following: 1. Tune database applications for optimal performance. 2. Conduct data modeling and design services. 3. Support and design of detailed conceptual data models and translation into outline designs. 4. Install, configure, and support database management systems and related software to resolve highly complex and/or unique issues without precedent and/or structure. Work on databases using more advanced database administration concepts. 5. Maintain highly- available databases. Work closely with application developers to implement robust, scalable applications that interface with those databases. 6. Provide on-going system administration and technical infrastructure support. 7. Review the physical and logical design of databases for optimal database structures, performance tuning, security protocols, and database backup recovery. Plan and implement pro-active and reactive performance analysis, monitoring, troubleshooting and capacity planning. 8. Evaluate and test marketplace tools and utilities, including system integration and automation, which enhance server functionality and promote the development of database management systems and applications. 9. Develop and maintain efficient and appropriate connectivity solutions between various databases to ensure necessary data is available as needed. 10. Create data flow and data life cycle documentation. 11. Adhere to database standards and/or new development protocols. 12. Participate in the identification of continuity disaster recovery risks and migration plans. Assist in the development of disaster recovery plans with service providers. 13. Develop reports and dashboards for presentation to the senior management. 14. Perform duties reflective of hierarchical database systems. 15. The job also requires skills in the upgrading the old database to new platform or even into cloud technologies like Azure or from Sybase to SQL Server. The position will support all the tasks in performing this function. The candidate will cross train other team members in this skill as a part of knowledge transfer and cross training the members in the team. Who are the customers? The customers for this department are both internal divisions like Protective Services Division, Behavioral Health Services, Juvenile Justice Division, Office of the Secretary and also some of the external entities with whom data is shared and data reports are developed. The position supports external government and non government companies and federal government agencies for varied programs and audits. Ideal Candidate The position requires Five (5) or more years in working with database administration Three (3) or more years in database development skills including data migration and data performance tuning to the database objects. Experience in working with the businesses and with the development team to coordinate any data clean up and maintenance. Experience with one or more common databases and / or data modeling tools (e.g. Microsoft SQL Server). Technical knowledge of various platforms to ensure applications and infrastructure stacks are current and supported. Technical knowledge and expertise in the server administration and management of server resources. Experience in working with server admin group and infrastructure team to implement any changes to the servers or in deployment of new software. Experience and knowledge in developing new dashboards or report development in the various platforms like Power BI or Sql Server Reporting Services. Excellent verbal, written, interpersonal, and customer service skills. Project and time management skills with abilities of effectively managing competing priorities. 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 Must possess a current and valid Driver's License. Pre-employment background investigation is required and conditional pending results. 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: Sujatha Seethapathi, (505) 660-1749. 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.