Technology Services serves the University by providing access to high quality, state-of-the-art, computing, communications and information resources through the Internet, local and wide area networks, databases and libraries, and by supporting the management information needs of the university. The department implements, customizes and maintains the PeopleSoft ERP system to best serve the university administrative needs. The department also maintains and manages various specialized business applications to support the specific functional and business process needs of our campus departments and the university.
Application Administrator III reviews, analyzes, and modifies programming systems including coding, testing, debugging and installing to support the university's Enterprise Resource Planning (ERP) and business applications systems. Assists with the development and maintenance of ERP and business application systems. Tests ERP and application layouts to ensure the system is meeting university needs. Ensures that software and services can be integrated into the ERP system.
Customizes and configures workflow to allow the integration of client/server applications. Designs new modules to improve system efficiency. Consults with users to identify current operating procedures and to clarify program objectives. Writes documentation to describe program development, logic, coding, and corrections, and to describe installation and operating procedures.
Configure, maintain and manage the application services environment
Install, upgrade and maintain applications and services (including and not limited to ERP, ancillary and cloud based applications).
Administer and maintain assigned applications (production and non-production environments).
Develop processes for routine maintenance and management tasks related to application administration, monitoring, security administration etc.
Identify and research software patches/fixes for systems.
Perform system upgrades, patching tasks and activities for ancillary application.
Develop and maintain monitoring scripts to monitor systems.
Troubleshoot and repair system problems.
Create and update system documentation.
Apply patches and fixes to ancillary applications and systems.
Define appropriate metrics to measure performance and ensure metrics are collected, reported and reviewed regularly.
Develop, maintain and report results of monitoring scripts to measure identified quality metrics and alert appropriately to any exceptions.
Periodically audit logs and access privileges to ensure appropriate security and privacy of applications and data.
Application development, integration, maintenance and management
Develop detailed specifications based on system requirements.
Develop and implement the technical architecture of ancillary applications and interfaces to the ERP environment.
Work closely with the technical teams to develop, configure and maintain system interfaces (internal and external).
Design, and develop custom application as appropriate using SDLC life cycle management methodologies.
Troubleshoot reported issues and work with database team to identify root causes and remedies.
Perform quality control, assurance and testing on systems.
Participate in new functionality development to ensure secure, elegant and low maintenance data designs are adopted. Activities include:
Work closely with our partners (user groups and departments) to create business process analysis and mapping, assist in identifying opportunities for process improvement.
Evaluate existing products for enhancements, review new products and services to enhance the overall service management of the application services environment.
Perform analysis to identify systems requirements.
Communicate with users on system development activities.
Work as part of the application engineering team to carry out assignments within the framework established by the supervisor and in conformance with established practices and procedures; bring unexpected or controversial findings to the supervisor’s attention.
Be a team player and champion to peers and customers.
Lead projects and implementations as assigned.
Work closely with managed services providers, vendors and contractors.
Share knowledge and experience to develop a culture of collaboration and sharing.
Participate in developing framework to establish documentation standards and mentor peers and team members to adopt culture of keeping documentation up-to-date.
Interface with IT auditors during audit cycles to provide related information and implement suggested solutions and controls.
Perform other job-related duties as assigned by supervisors.
Bachelor’s Degree with at least five (5) years’ experience administering systems and applications in support of a multi-tiered environment.
Seven to Ten (7-10) years’ experience as an Application or Systems Engineer accepted in lieu of degree.
At least 4-6 years’ experience as an application engineer.
At least 6-8 years’ programming experience using at least one programming language or toolset.
Two years’ experience can be substituted by a Master’s degree.
Demonstrated experience as a SQL developer: writing SQL code, scripts and using report tools
Experience developing interfaces between ERP and ancillary applications (hosted, cloud based) using scripting, SQL coding, file transfer, web services etc.
And one or both of the following:
Experience developing and maintaining ERP applications (PeopleSoft, Banner or similar)
Experience installing and configuring COTS applications in a multi-tier environment, including integration with ERP applications.
Project planning and project management experience desired.
Higher education experience a plus.
Technical Qualifications or Specialized Certification:
Knowledge of, and materially demonstrable skill in applying, the following:
IT concepts, principles, methods, and practices.
Information security principles and methods.
Performance monitoring principles and methods.
Relational database principles, methods, and practices.
Database backup, recovery and high availability principles, methods, and practices.
ERP principles, methods, and practices.
Software development lifecycle (SDLC) principles, methods, and practices.
Operational task automation through programming and scripting principles and methods.
Principles, methods, and tools for developing, scheduling, coordinating, and managing projects and resources.
Experience implementing and configuring the following technologies is a plus:
Windows Server 2012 or later in an Active Directory environment.
Linux server, especially Red Hat Enterprise.
Infrastructure as a Service (IaaS) services, especially Amazon Web Services or Microsoft Azure.
Database and Application monitoring/management tools, especially SolarWinds.
One or more of the following certifications is desirable:
Oracle Database Administrator Certified Professional
Microsoft Solutions Expert (MCSE): Data Platform [SQL Server]
Information security certification, e.g., CompTIA Security+, CompTIA CASP, CISSP.
Project management certification, e.g., PMP
Other Knowledge, Skills and Abilities Needed:
Analytical skills: Ability to integrate differing bodies of knowledge in troubleshooting and solving technical problems, including performing root cause analysis and follow up to ensure the issues are addressed at the root level.
Learning skills: Ability to learn and adopt new ideas and technologies.
Organizational skills: Ability to organize work, coordinate with other team members to accomplish goals, and ensure progress is made on assigned tasks.
Good oral and written communication skills: Ability to express information to individuals or groups effectively, and to make clear, comprehensible oral and written reports.
Technology awareness: Knowledge of developments and new applications of computing infrastructure technologies to the university’s technical infrastructure.
Teamwork skills: Ability to work effectively in teams, both as a member and leader.
To apply, go directly to: https://staff-cua.icims.com/jobs/8794/sr.-systems-and-application-administrator/job