 | NEW MEXICO STATE UNIVERSITY |
HUMAN RESOURCES SERVICES | |
POSITION CLASSIFICATION DESCRIPTION | |
| Position Classification Title: | Database Analyst,Inter |
| Position Classification Code: | M3044 |
| Job Family: | Information Technology |
| Pay Level: | 07 |
| Exempt Status: | Exempt |
| This description is intended to describe the general nature of the work being performed. It is not intended to be a complete list of specific duties of any particular position. Duties, responsibilities and bargaining unit eligibility may vary based on the specific tasks assigned to the position. | |
| Purpose of Classification: | |
| Under general supervision, assists in the evaluation and design of existing or proposed systems to structure and access enterprise databases . Analyzes database requirements of the user department, applications programming and operations. May submit recommendations for solutions that require definition of the physical structure and functional capabilities of databases and require data security and data backup/recovery specifications. Proposes detailed specifications and flowcharts. | |
| Standard Duties: | |
| Under supervision performs work that is varied and that may be somewhat difficult in character, but usually involves limited responsibility. Works with IT team to configure hardware or software to perform installations, upgrades, testing, working at optimization of capacity planning, data storage, efficiencies, and database growth. Writes and understands Microsoft SQL. Writes SQL statements, stored procedures and views using industry best practices for security and efficiency. Works on database and code management, review and documentation. Works with application developers to know how applications work and testing results. Creates, develops and manages internal procedures for various job functions within the ERP system. Manages relationship between ERP vendors and carousel. Supports ERP software, database structure and data. Works with implementation team to build, customize and roll new ERP solution to organization and with consultants to design and build database structure specific to carousel's needs. Coordinates installation of revised or new systems.Performs miscellaneous job-related duties as assigned . | |
| Knowledge, Skills and Abilities: | |
| Knowledge and understanding of principles, procedures, regulations, and standards applicable to the job. Understanding of the University's mission, vision and goals. | |
| short- and long-term planning; problem analysis and resolution; report preparation and presentation; interpersonal and organizational communication, both oral and written. | |
| Ability to gather and interpret relevant data and information. Ability to use inductive reasoning. Ability to determine the interrelationships between solutions and requirements. Should be able to communicate and market data administration concepts to management, staffs and clients. Ability to think analytically and should be a problem solver. Ability to make effective decisions under pressure. | |
| Minimum Qualifications: | |
| Education- Bachelor's degree in a related field. | |
| Experience- Three (3) years of experience directly related to the standard duties as outlined. | |
| Equivalency- None | |
| Certifications/License- | |
| Departmental Requirements- | |
| Special Requirements- | |