What are the responsibilities and job description for the Officetrax Database Administrator position at Advance Auto Business Support (300)?
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: https://jobs.advanceautoparts.com/us/en/disclosures Advance Auto Parts, Inc. is a leading automotive aftermarket parts provider that serves both professional installers and do-it-yourself customers. As of October 5, 2024, Advance operated 4,781 stores primarily within the United States, with additional locations in Canada, Puerto Rico and the U.S. Virgin Islands. The company also served 1,125 independently owned Carquest branded stores across these locations in addition to Mexico and various Caribbean islands. Additional information about Advance, including employment opportunities, customer services and online shopping for parts, accessories and other offerings can be found at www.AdvanceAutoParts.com.
