Job Description

Under the general direction of the Assistant Director of Housing Services, responsible for the database administration, maintenance, planning, and organizing of the hospitality systems used by UCLA Housing & Hospitality Services. These systems consist of Opera Property Management System, Delphi Sales & Catering, iHotelier online booking engine, OXI interfaces, CENDYN E-Proposal system. This position is responsible for data integrity, setting appropriate security access rights for users, maintaining daily logs to ensure data is passing correctly and consistently through the databases and connected interfaces. Prepare analytical reports and graphs using Excel, Crystal Reports or SQL Server Reporting Services (SSRS) as directed by Senior Management. Create, maintain, audit, and reconcile analytical reports generated from Housing Services databases. Assist Senior Management with the usage and application of databases, reporting software, and resolution of database inquiries. 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. During the absence of the other Database Managers, manage the remaining Housing Services Database staff. This may include shifting to a night shift during the months of June through September. Provide supervisory assistance in other Housing Services departments as needed or requested. 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.
The target salary for this position is between the posted minimum $4842 and $7,217 monthly.

Job Qualifications

Demonstrates the ability to provide excellent customer service to both internal and external customers.
Required

Advanced working knowledge of structure query language, relational databases, and ad Hoc reporting software in order to create concise analytical reports (i.e., Crystal, SQL Server Management Studio, SQL Server Reporting Services (SSRS), Microsoft Access and Excel, Visual Basic, etc).
Required

Experience with inventory control and revenue forecasting.
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

Organizational skills to manage workflow and establish a harmonious and productive environment.
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

Skill in keyboarding with speed and accuracy.
Required

Working knowledge of the configuration and use of hospitality sales and catering software, property management software, revenue management software, accounting software, point of sale software, and online booking engine software, as well as vendor interfaces between systems.
Preferred

Ability to read, write, and understand complex queries written in SQL, XML
Preferred

Working knowledge of HTML and CSS to design mailings and e-mail templates
Preferred

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

Working knowledge of computerized billing and receivable systems.
Preferred

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

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

Demonstrated working knowledge in customer service, accounting, and database management.
Preferred

Experience with Sharepoint administration
Preferred