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