Banner DBA
Job Description 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, 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