Information Technology Systems/Database Administrator Analyst I

Position Summary

The Information Technology Systems/Database Administrator Analyst I is an experienced, senior-level specialist. Incumbent has primary responsibility for Systems or Database administration at the College-wide or District-wide level. The Information Technology Systems/Database Analyst I operates with routine oversight.

The primary focus of the department is on maintaining an Enterprise Resource Planning (ERP) system by:

• Supporting the change management, update, and upgrade processes of the District’s PeopleSoft implementation.
• Utilizing tools such as Application Designer, Data Mover, and PeopleSoft Update Manager.
• Maintaining components of software security.
• Analyzing/Resolving problems using DB access tools, PeopleBooks, and My Oracle Support.
• Supporting data initiatives across the district and with district partners.

For a detailed job description for this Los Rios Classified Employees Association (White Collar) posting click here.

Typical Duties

Operations (including security, performance, problem resolution, & budgets):

• Maintains multiple servers, databases and application software across multiple systems.
• Performs installation and patching of servers, databases and application software for production and development environments.
• Specifies requirements for infrastructure components (virtual servers, vMemory, vCPU, storage, networking, databases, applications) to ensure performance, reliability, backup, and recovery (as defined for each system).
• Analyzes and resolves complex technical issues.
• Works with vendors to resolve problems.
• Provides vendors with enhancement requests.
• Creates scripted procedures and/or programming to automate support functions.
• Maintains security and staff access to servers, databases and/or software applications.
• Monitors performance, availability, reliability, and capacity of systems to meet defined Service Level Agreements (SLAs).
• Systems Administrator – configures, administers and maintains network servers providing file, print, application, web, and network services (DHCP, DCs, PXE, SAN, NAS, etc.).
• Systems Administrator – configures, administers and maintains host servers for virtual servers and assigns appropriate resources, vCPU, vMemory, vNetwork, vStorage, etc.
• Database Administrator – configures, administers and maintains databases, the DBMS and database servers providing database functions to application and web services.
• Database Administrator – configures, administers and maintains virtual database servers and assigns appropriate resources, vCPU, vMemory, vNetwork, vStorage, etc.
• Tracks and migrates Los Rios customizations and provides change management to the ERM.
• Works as a liaison between the business analysts and technical support to coordinate creation of and/or refreshes of test instances of the ERM.
• Ability to design, code and test scripts for the management of applications, servers and databases.
• Creates timelines and documentation as needed.
• Troubleshoots problems and consults with users for system needs, design, and operation. Provides assistance and direction to other Information Technology personnel.
• Maintains working knowledge of current industry information, vendor direction, new products, and technical architectures/approaches.