The Database Administrator is responsible for the maintenance, reliability, security, and performance of the University’s Enterprise Resource Planning ( ERP ) systems. With other members of the Enterprise Systems Administration team, the Database Administrator ensures that Oracle Databases, Application Servers and ERP systems are highly available, technically current and seamlessly integrated. The incumbent must effectively coordinate activities with the Principal Database Administrator, Data Warehouse Administrator, application development team, networking staff, systems administrators and key stakeholders from the University community.
Duties and Responsibilities:
Provide primary technical support for the implementation, management and support of the Banner Information System and auxiliary ERP systems including document management, workflow, room scheduling, job scheduling, customer relationship management,degree audit and other systems.
Provide secondary technical support for the implementation, management and support of the data warehouse system to include the Oracle database and reporting tools.
Assist the Principal DBA with the administration of the University Oracle databases.
Performance tuning for Oracle Application Servers on UNIX servers. Write UNIX shell scripts to automate Oracle Application Server Admin tasks. Install configure and test new version of Oracle Fusion Middleware software ( OFM ) for Oracle Forms, Reports, mod/plsql, J2EE and OC4J applications. Create Oracle Wallet for SSL certificate used for iAS and OFM servers.
Manage, modify and upgrade the University’s ERP systems including database and application software to ensure the technical currency of these systems.
Develop and maintain ERP system documentation following procedures outlined by the Exec Director of the Enterprise Administration Team.
Effectively manage projects keeping the Exec Director of Enterprise System Admin and the rest of the Enterprise Systems Admin Team informed.
Participate in technical planning within the Enterprise Systems Admin Team.
Keep pace with technologies by attending conferences and training, monitoring product developments and strategic direction related to core vendors such as Oracle, Ellucian and other vendor web sites and user groups.
Provide technical support for web-based, departmental initiatives that require systems or database administration support.
Provide excellent customer service to the user community and develop a strong partnership with the administrative users. Anticipate and respond to the needs of the administrative users enlisting the expertise of members of the IT staff as necessary.
Keep pace with new technologies.
Ensure the security of the University ERP systems at both the operating system and database levels.
Ensure the reliable backup and recovery of the University’s ERP Systems.
Develop, maintain and document system utilities in support of user requirements
Perform system performance monitoring, tuning and capacity planning.
Physical Requirements and/or Unusual Work Hours:
The position requires long periods spent in front of a PC.
Evening and weekend hours are required for production system upgrades and configuration changes.
Baccalaureate degree in computer science or related field.
Must possess excellent problem-solving, organization, project management and professional skills.
Must possess excellent interpersonal, written, and oral skills.
One to two years experience is required to include a combination of any, and/or all of the following areas:
- Oracle Database Administration and Administration of other Oracle technologies including OWB , PL/ SQL , Application Server, Discoverer, Fusion Middleware, RAC , Grid Control
- Shell Scripting in Unix, Linux, Solaris
- Specific experience with the Banner ERP system, Ellucian’s ODS / EDW , Banner Document Management System, UC4 job scheduling system.
- Cognos Business Intellegence tools, star schemas and cubes is desired.
- SQL Server Database Admin and Windows OS
- Web technologies including Apache, TomCat
Higher Education experience is desirable
Oracle DBA OCA or OCP certification is not required but is desirable
Number of direct reports to this position:
434000 - Enterprise System Admin Dept
$59,000 - $64,000
Date Open to Internal Applicants:
Date Open to External Applicants:
Job Close Date:
Open Until Filled
Internal and External Applicants
Message to Applicants
Saint Joseph's University - 14 months ago