Senior Database Manager - Hospitality Systems Manager University Of California
Los Angeles, CA

Job Description

Requisition Number: 30601 Job Title: ADMINISTRATIVE ANALYST, SENIOR Working Title: Senior Database Manager - Hospitality Systems Manager Salary: $4,842 - $9,591 monthly Job Type: Career Department Name: 3130E-HOUSING SERVICES Department Website URL: http://housingandhospitalityservices.ucla.edu/ Job Summary Statement: 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. Percentage of Time: 100 Shift Start: 8:00 am Shift End: 5:00 pm Qualifications for Position

21 Records Qualifications Required/Preferred

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 Additional Posting Information Bargaining Unit: 99-Policy Covered Application Deadline: 07-05-2019 External Posting Date: Quicklink To Posting: hr.mycareer.ucla.edu/applicants/Central?quickFind=76634 Special Instructions: Please provide Cover Letter, Resume, and References. References will not be contacted without approval of applicant.

The target salary for this position is between the posted minimum $4842 and $7,217 monthly.

The value of the University of California employment goes beyond your salary. As a UC employee, you'll enjoy a full range of benefits, services and pension programs. To estimate the approximate value of your total UC compensation, please go to:

https://ucnet.universityofcalifornia.edu/compensation-and-benefits/total-compensation-calculator.php

For a full list of employee benefits, please visit:

https://www.chr.ucla.edu/benefits &

https://www.chr.ucla.edu/benefits/other-provisions-privileges Contact information: Number of Positions: Special Employment Designations/ Requirements Per UC Policy Conflict of Interest: N/A Critical: Continued employment contingent upon completion of satisfactory background investigation. Driving Record: N/A E-Verify Check:

Certain positions funded by federal contracts/subcontracts requires UCLA to notify job applicants that an E-Verify check will be conducted and the successful candidate must pass the E-Verify check.

More Information This position does not require E-Verify check. CANRA:

Is this position designated as a mandatory reporter under CANRA? No Other Special Employment Requirements: Position is subject to performance standards and other requirements of the University wide Police Policies and Administrative Procedures.

Return to Search Results