Systems Database Engineer
Under the general direction of the Administrative Infrastructure Database Manager, the Systems Database Engineer will be responsible for the reliable and secure operation of the SPIRE and PeopleSoft hardware and software, Oracle database, and related software components underlying the SPIRE and PeopleSoft Student Information System and other administrative information systems.
Design, develop, and implement data solutions to include the following: architecture design, prototyping of concepts to proof of concept, development of standards, design and development of test plans, code and module design, development and testing, and data solution debugging.
Lead in the planning, implementation, and management of Windows and Linux operating systems, network platforms, VMWare virtualization, Windows OS, and Mac OS X; various technologies and tools as necessary and internet related protocols.
Essential Functions Include:
Leads in group reviews for new and existing technical data architecture and design, implementation, configuration, testing plans, and documentation.
Establishes administrative and technical design standards for application developers and technical support staff to ensure the performance, reliability, audibility, and maintainability of the SPIRE and PeopleSoft environment. This includes detailed coding style guides, naming specifications, and technical documentation standards. Coordinates periodic reviews to verify compliance with standards.
Provides support to various campus business and technology teams as necessary during design, development, and delivery to ensure solid, scalable, robust solutions.
Manages day-to-day tasks/activities in coordination with a team of Database Administrators and developers to effectively meet the deliverables and schedule of a data solution component within a larger application project.
Creates and maintains regression testing plan and associated test programs, scripts, and data which covers both vendor supplied and locally developed software.
Develops and maintain scripts to automate IT tasks and procedures.
Leads in technical reviews to ensure that application design decisions meet the long-term objectives of the PeopleSoft technical architecture.
Develops back-up and recovery plan; monitors compliance.
Serves as primary technical contact with software vendors for system upgrades, fixes, and problem resolution.
Performs root cause analysis to quickly recover from service interruptions and to prevent recurring problems.
Monitors, manages, and tunes platforms to ensure expected availability and performance levels are achieved.
Performs other related duties as required.
Facilitates operating system software installations, updates and upgrades. Troubleshoots system-related problems and issues and work with vendors to resolve technical issues.
Analyzes and resolves network and software communication problems using diagnostic software and technical troubleshooting processes.
Participates in off-hours on call rotation.