Job Description

Under the general direction of the Assistant Director of Housing Services, the position is responsible for the database administration, maintenance, data analysis, and organization of the hospitality systems used by UCLA Housing & Hospitality Services. These systems consist of Opera Property Management System, Delphi.fdc, iHotelier/TravelClick online booking engine and online travel agencies (OTA’s), OXI interfaces, HotSOS, Shift4, IdeaS G3 Revenue Management, UniFocus, Revinate and CENDYN E-Proposal system. This position is responsible for data integrity, establishing and maintaining appropriate application security access rights for users based on user job function. Maintaining daily logs to ensure data is passing correctly and consistently through the databases and connected interfaces. The position is responsible for independently developing and implementing new processes based on requests and requirements from business partner stakeholders using current hospitality and database industry standards, as well as considering current business practices and how the existing policies and procedures are affected. Develop and prepare analytical reports and graphs using Excel or SQL Server Reporting Services (SSRS). Develop and maintain necessary views for efficient reporting in complex environments. 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. This position is responsible for analyzing and solving complex and wide-ranging database and application issues. This can include diagnosing and correcting the issue or triaging and tracking the error and escalating to the appropriate team member or vendor when necessary. Ensure timely completion of reports and daily maintenance of report tracking. The position is responsible for completing User Acceptance Testing (UAT) on their managed databases when version upgrades are needed. 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 and necessary updates 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.

Job Qualifications

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

Advanced experience and knowledge of structure query language (SQL), 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). Abilitiy to write and develop complex queries, datbase views, and stored procedures when needed to improve system performance and reliability.
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

Ability to develop new processes and policies using best hospitality and database practices available.
Required

Develop and maintain new business processes and policies using best hospitality and database practices available.based on requests and requirements for business partner stakeholders utilizing current and best hospitality and database practices available.
Required

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

Ability to analyze wide range and complex issues reported by users. Develop recommendations for solutions and prevention of future occurrences if needed and/or applicable.
Required