ERP System Administrator II

HKS, Inc
United States, Texas, Dallas
Jan 10, 2025
Overview: Provides support for all ERP system products within the HKS environment. Performs advanced networking maintenance and hygiene activities. Responsible for producing & maintaining technical documentation of the overall infrastructure ecosystem through daily discourse of duties. Possesses and applies a broad knowledge of relevant practices and procedures to complete assignments with integrity and creativity in collaboration with team. Responsibilities: Coordinates the creation and changes to system databases and tests and implements the database applying knowledge of database management systems Plans, coordinates and implements security measures to safeguard computer databases as well as supports various corporate department business systems Creates and organizes systems to store and secure data; designs and builds new databases Collaborates closely with cross-functional teams to understand data requirements and translates them into technical solutions Collaborates with data architects, engineers and analysts to design, develop and maintain data pipelines and ETL processes Leverages best practices and monitoring tools to identify and address bottlenecks and inefficiencies Optimizes and tunes data pipelines and process workflows for performance, scalability and reliability Conducts data profiling, cleansing and validation activities to ensure data quality and integrity throughout the data life cycle, adhering to data governance and compliance requirements Maintains, troubleshoots, and repairs system software Implements processes/procedures necessary to maintain the databases and related systems used within the ERP system Administers installation, configuration, patching/updating, performance tuning and backups of ERP databases and application servers Implements standards and procedures for database administration tasks and security policies Performs database and application monitoring to ensure databases run at peak performance; troubleshoots performance issues Assists with SQL programming using SQL and stored procedure languages such as PL/SQL Creates, loads and manages databases and database objects needed by the implementation, development, testing and training teams Performs upgrading/patching of database and related systems Responds to, troubleshoots and repairs issues with databases and associated applications Implements the processes necessary to refresh or otherwise maintain sets of data for testing and development purposes and automates processes when possible Supports data loading, migration, conversion and scheduled job operations Manages and maintains system documentation Provides afterhours support as needed for high severity, overseas situations and off hours maintenance; monitors incoming user tickets which may require after hours resolution Works closely with ERP vendor (Deltek) to troubleshoot system issues, which may include running scripts, sending copy of database for review and other trobleshooting efforts Develops System user access level manual and oversees Deltek security and access, including creating and maintaining user accounts and security roles. Monitors license usage. Supports Sage Software (Asset Mangement), including monthly backups, adding users, yearly software updates and managing integrations with other programs Supports Elevia Software, including software updates and managing integrations with other programs Participates in daily stand-up and Sprint planning meetings working within the AGILE Processes database backup and restore Performs other duties assigned by leadership Qualifications: Bachelor's degree in Computer Science or an equivalent combination of education and experience Typically with 5+ years supporting an ERP Application Stack, both On Premise and Cloud. Deltek Vision/Vantagepoint experience preferred Proficient in respective ERP system (e.g. Vision, Vantagepoint) preferred Experience in MS Office Suite, including Excel, Outlook and Word Experience in EleVia software preferred Experience with ASP.NET, C#, T-SQL, SSRS, SSIS, Microsoft SQL Server database platform Experience in providing technical support, covering database administration and operations to include monitoring maintenance capacity, performance monitoring/planning and incident/problem troubleshooting and resolution Understanding of finance/accounting processes Understanding of file structure system Understanding of Project Accounting processes and workflows in a professional services environment Strong skills in both logical and physical database design, building SQL and Stored Procedures Strong customer service, interpersonal skills and the ability to interact with all levels of staff Strong work ethic and eagerness to produce high quality, accurate results Ability to comprehend and assist the global finance organization in building requirements for its financial systems enhancements Ability to hold sensitive information with a high level of confidentiality and integrity Ability to communicate and present ideas in a clear, concise and professional manner both verbally and in writing Ability to proactively problem solve and apply innovative solutions Ability to work and collaborate in a team environment, and ability to work independently and prioritize work Ability to work on multiple projects at the same time Ability to effectively meet deadlines at expected quality If you currently work for HKS, please submit your application via the Internal Careers Portal. HKS is an EEO/AA Employer: M/F/Disabled/Veteran