Senior Database Manager

Job Description

Under the general direction of the Assistant Director of Housing Services, the Senior Database Manager is responsible for the database analysis, administration, maintenance, process development, planning, and organization of the StarRez database. The role requires the supervision of one or more of the Housing Services databases and staff. Supervise, hire, train, evaluate, and counsel one career staff member on Housing Services database responsibilities. Using advanced database maintenance and data management techniques and functions, this role is responsible for routine database upkeep essential for ensuring accurate data of a complex relational database. This includes other the management of other databases connected to the StarRez database. This role is responsible for creating and maintaining standard operating procedures for highly complex processes and database maintenance, as well as the processes and procedures required for the supervised position. Resolves complex, wide ranging, and diverse database and process issues for housing staff system users and students. Develops and prepares financial and analytical reports and data as requested by Housing Senior Management. Ensures the database and integrated applications are accurate and available for users and customers. Manages user access and user access level on a daily basis. Develops user group rights to ensure only necessary access is provided available based on job function. Assist Senior Management with the usage and application of databases and resolution of database inquiries and application inquiries and issues. Independently develop and implement new business processes based on requests and requirements from business partner stakeholders using advanced data management strategies. Ensure timely completion of reports and daily maintenance of report tracking. Reconcile daily emails to ensure correspondence and responsibilities are completed. Responsible for auditing Housing Services directories to ensure timely archives and updates are completed. Submit annual process analysis results of functional area with recommendations and strategic proposals. Cross train and assist in other Housing Services areas during peak or vacation periods. Train management and staff in database policies and procedures to ensure compliance with University policies and internal audit guidelines. Train end users and management staff in the proper use of the databases and report analysis. Prepare training manuals for the Housing Services database management and end users. Ensure annual review of procedures and training manuals are submitted to senior management.

Job Qualifications

Experience with StarRez database and highly advanced knowlede of managing a relational database.
Preferred

Advanced working knowledge of developing and maintaining automated tools using Visual Basic to provde work efficiencies and lessen data accuracy issues.
Required

Advanced knowledge and ability to develop database views to ensure efficient and accurate reporting with complex queries.
Required

Ability to perform duties independently and with a great degree of accuracy, while meeting established deadlines.
Required

Ability to set goals and priorities which accurately reflect the relative importance of job responsibilities when faced with fluctuating workloads, and competing requirements to meet deadlines.
Required

General knowledge of data processing (principles and terminology) and the ability to work with hardware and software vendors.
Required

Working knowledge of computerized billing and receivable systems.
Required

Demonstrated ability in and working knowledge of basic accounting and collections practices and principles. Working knowledge of internal cash handling and controls.
Required

Demonstrated skills in supervision of staff including: organization of workflow, delegating responsibility, training evaluating, motivating, hiring and counseling.
Required

Organizational skills to manage workflow and establish a harmonious and productive environment.
Required

Working knowledge of management and leadership principles, trends, and practices as applicable to staff supervision and motivation.
Required

Skill in analyzing operating procedures and recommending necessary changes consistent with accepted accounting practices.
Required

Working knowledge of Microsoft Office (Including Word, Excel, and Access).
Required

Ability to establish and maintain cooperative working relationships with staff, coworkers, and other University personnel and interact diplomatically with a diversified public.
Required

Skill in analyzing information, situations and procedures to define problems and formulate conclusions.
Required

Skill in speaking concisely and logically, using grammatically correct language to convey information and explain policies and procedures.
Required

Experience in writing routine business correspondence, operating procedures, performance evaluations and presentation materials using grammatically correct language.
Required

Advanced working knowledge of query and ad Hoc reporting software in order to create concise analytical reports (i.e., Crystal, SQL PlusServer Management Studio, Microsoft Access, Visual Basics, SQL Server Reporting Service (SSRS) etc).
Required

Advanced skill in identifying issues and errors with complex processes and providing solutions and answers quickly and concisely to many different audiences and customers.
Required

Advanced skill in identifying issues and errors with complex processes and providing solutions and answers quickly and concisely to many different audiences and customers.
Required

Advanced skill in identifying issues and errors with complex processes and providing solutions and answers quickly and concisely to many different audiences and customers.
Required

Advanced knowledge of data processing (principles, practices, functions, and terminology) and the ability to work with hardware and software vendors.
Required

Advanced experience and knowledge of data management and data analysis techniques.
Preferred