Job Description

The Officetrax Database Administrator at AAP is an expert user and developer for programs such as OfficeTrax or another Facility Maintenance Management Software Solution. This role designs and develops company specific enhancements, modifications, and customizations to better support all internal users of the programs driving increased accurate knowledge sharing across business units. This individual is comfortable utilizing SQL.

In addition to managing the Real Estate Systems and creating efficiencies; this role will provide production support for all team members with access. It will be critical for this role to be able to manage the expectations on system capability and time to deliver customizations or improvements to all internal customers including senior leaders. This role will own the relationship with system vendors to submit and track support requests and ensure they meet SLAs. Work with financial business partners and analysts to help track variances between AP system and Facilities Maintenance system and troubleshoot system-related discrepancies. Provide reporting assistance to users as needed, building training materials and SOPs for enhancements, editing, troubleshooting, as well as training users when applicable. Provide support to the Market Research team with reporting and systems. Maintain system and data integrity through monitoring and updating on routine basis.

Responsibilities

• Assist users with design and development advice as the business needs
• Report creation/troubleshooting for Lucernex system
• Maintain a consistent presence in the team inbox, evaluating and prioritizing incoming email to determine importance and assignment
• Work with AMS support team to resolve issues
• Utilize existing software tools to provide reporting
• Report issues to proper teams for resolution
• Work with vendor support teams to submit, track, and close support requests and resolve complex issues
• Manage system workflows
• Manage implementation, testing, design, and training of any new development in the system or that will impact the system
• Lead integration management, including requirements gathering and design
• Lead and implement upgrade projects for Real Estate systems
• Monitor data quality across systems and perform data integrity exercises as needed or requested
• Manage relationship between IT and business users

Skills

• To support high-level reporting: visual basic experience a plus, SQL experience a plus

• Excellent communication skills
• Excellent at partnering across business units and at all levels of the organization
• Good working knowledge of all basic desktop software products in the Microsoft desktop suite, especially Excel
• Ability to learn as you work, evaluating learned information and applying it to complex problems to provide best solutions
• Organize and manage multiple priorities with changing finish lines

Qualifications and Experience:

• Bachelor’s degree and 5 years’ experience in internal application design and development, desktop support roles, or other web-based software support required
• 5 years’ experience with Lucernex lifecycle system, OfficeTrax Facilities Management system, or other System-as-a-Service tools highly desired
• Understanding of databases, networking, data management highly desired
• Microsoft Access reporting skills preferred
• Visual basic and SQL experience preferred

#LI-GG1

California Residents click below for Privacy Notice: