Banner Technical Consultant & Progammer Analyst

ESP Engineered; Chicago (IL); On-site; USD 100,000 - 130,000; Full time

Job summary

ESP Engineered is looking for a Senior Banner & Oracle Database Administrator in Chicago. This role demands strong expertise in administering Oracle databases that support Ellucian Banner ERP modules. Responsibilities include managing upgrades, monitoring performance, and ensuring database security.

The ideal candidate will have significant experience in managing multi-tiered environments and working closely with functional teams. This position is full-time, offering the opportunity to work in a dynamic environment.

Qualifications

• 5+ years of experience managing Oracle databases for Banner ERP.
• Hands-on experience with database administration and upgrades.
• Proficiency in performance tuning using AWR/ASH.

Responsibilities

• Administer Oracle databases supporting Banner ERP modules.
• Perform Banner version upgrades and regulatory updates.
• Monitor and tune Banner-related SQL workloads.
• Manage DB cloning and backup strategies.

Skills

Banner ERP experience

Oracle 12c / 19c administration

RMAN backup and recovery

Data Guard configuration

Performance tuning

SQL troubleshooting

Linux/Unix command line

Job description

Job Title and Basic Information

Role: Senior Banner & Oracle Database Administrator

Experience: 5–6 Years

Location: [Insert Location]

Employment Type: Full-Time

Core Responsibilities

1. Banner Database Administration
   • Administer and maintain Oracle databases supporting Ellucian Banner ERP modules (Student, Finance, HR/Payroll, Financial Aid)
   • Perform Banner version upgrades, cumulative patches and regulatory updates
   • Manage Banner‑related database objects, schemas and packages
   • Support Banner job submission processes (GJAPCTL, Job Submission architecture)
   • Troubleshoot Banner performance issues related to forms, jobs and batch processing
   • Manage Banner environment cloning and refresh activities
   • Coordinate with functional teams during Banner upgrades and testing cycles
   • Monitor and tune Banner‑related SQL workloads
2. Oracle Database Administration
   • Install, configure and maintain Oracle 12c / 19c databases
   • Perform database patching (PSU/CPU), upgrades and migrations
   • Manage RMAN backup and recovery strategy, including full, incremental and archivelog backups
   • Implement and support Oracle Data Guard (physical standby preferred)
   • Monitor performance using AWR, ASH and ADDM reports
   • Perform SQL tuning and index optimization
   • Manage tablespaces, datafiles, redo logs and archive log configurations
   • Support database replication and high‑availability configurations
   • Manage database encryption and security hardening
3. Environment & Infrastructure Management
   • Manage multi‑tier environments (Dev, Test, UAT, Prod)
   • Perform database cloning using RMAN and hot/cold backup methods
   • Work closely with system administrators on Linux/Unix servers
   • Coordinate storage allocation and performance tuning with infrastructure teams
   • Support capacity planning and database growth forecasting
   • Assist in migration projects (on‑prem to cloud or data center transitions)
4. Performance & Optimization
   • Identify and resolve locking, blocking and long‑running queries
   • Tune Banner batch jobs and heavy transactional workloads
   • Optimize database parameters (SGA, PGA, memory structures)
   • Review execution plans and optimize poorly performing SQL
   • Conduct proactive health checks
5. Security & Compliance
   • Manage database users, roles and privileges
   • Implement password policies and access controls
   • Support database auditing and compliance reporting
   • Perform regular vulnerability assessments and remediation
   • Ensure secure handling of sensitive student and financial data
6. Incident & Change Management
   • Provide L2/L3 production support
   • Conduct root‑cause analysis for critical database incidents
   • Participate in change management processes
   • Maintain detailed documentation for upgrades, patches and DR procedures
   • Support 24x7 on‑call rotation if required

Required Technical Skills

• Banner ERP
  • Hands‑on experience supporting Ellucian Banner ERP database environments
  • Experience with Banner upgrades and regulatory patches
  • Understanding of Banner schema structure and job submission framework
  • Experience supporting Student, Finance or HR modules
  • Knowledge of Banner technical architecture
• Oracle Database
  • Oracle 12c / 19c administration
  • RMAN backup and recovery
  • Data Guard configuration and monitoring
  • Performance tuning using AWR/ASH
  • SQL and PL/SQL troubleshooting
  • Linux/Unix command line proficiency

Preferred Skills

• Experience in Higher Education institutions
• Familiarity with Ellucian Ethos integrations
• Exposure to Banner ODS or Data Warehouse environments
• Experience with AWS, Azure or Oracle Cloud Infrastructure
• Scripting experience (Shell, Python)
• ITIL‑based service delivery experience