 | NEW MEXICO STATE UNIVERSITY |
HUMAN RESOURCES SERVICES | |
POSITION CLASSIFICATION DESCRIPTION | |
| Position Classification Title: | Database Analyst,Sr |
| Position Classification Code: | M3045 |
| Job Family: | Information Technology |
| Pay Level: | 08 |
| 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 minimal supervision, evaluates and designs existing or proposed systems to structure and access databases. Analyzes database requirements of the user department, applications programming and operations. Submits 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 and coordinates installation of revised or new systems. | |
| Standard Duties: | |
| Usually works with minimal supervision, conferring with superior on unusual matters. May be assisted by Associate/Intermediate level personnel. Assignments are broad in nature, usually requiring originality and ingenuity. Has appreciable latitude for unrelieved action or decision. 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 tests 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.May train Associate or Intermediate level personnel in technical complexities of assigned work.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- Five (5) years of experience directly related to the standard duties as outlined. | |
| Equivalency- None | |
| Certifications/License- | |
| Departmental Requirements- | |
| Special Requirements- | |