Position Classification Title: Database Analyst,Ld
Position Classification Code: M3013
Job Family: Information Technology
Pay Level: 11
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:
Provides team leadership 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. 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 systems.
Standard Duties:
Under general supervision, plans, conducts and may supervise assignments. Reviews progress and evaluates results. May train Associate level personnel in technical complexities of assigned work. Recommends changes in procedures. Operates with substantial latitude for unreviewed action or decision. Reviews progress with management. 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 solutions to organization, and with consultants to design and build database structure specific to carousel's needs. 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- Eight (8) years of experience directly related to the standard duties as outlined.
   Equivalency- None
   Departmental Requirements-
   Special Requirements-