Oracle DBA

Support Oracle, RDBMS, Ellucian Banner, Tomcat, Oracle Fusion Middleware, OracleGrid Control, and a variety of ancillary systems (ODS, WebFOCUS, Sciquest, Touchnet,etc), and Red Hat Enterprise Linux.

-Establish system process scheduling procedures using appropriate mechanisms suchas Oracle scheduler, crontab and perform regular optimization and maintenance.

-Develop and maintain system maintenance procedures including database and servicesAutoStart, shutdown.

Generate and maintain scripts to support DB creation, schemas, automate tasks and related activities.

Participate in Banner Disaster Recovery planning and testing.

-Maintain Oracle system and user accounts, keep a clear audit trail of database accessand update records that meet industry security standards. Assist with the end-user's database and application access issues. Apply patch fixes and test defect fixes with functional users.

-Maintain and support Oracle databases including database upgrades; Oracle security patching, database backup and recovery, and performance tuning.

-Stay abreast of Ellucian and Oracle technology, develop an enterprise architecture roadmap based on technology trends, Ellucian new releases or new business functional expansion.

-Provides a broad range of administrative and support services including Banner upgrade compatibility analysis, downloading release notes.

-Function as the technical expert in database design and system configuration to maintain a flexible and scalable Banner environment for most optimal performance and growth.

-Install, implement, and upgrade Banner ERP software system including Application Navigator, Banner applications and programs using the Ellucian Solution Manager

-Configure, deploy and support Banner ERP modules such as Banner 9 Admin and self-service pages, AppNavigator, Banner Access Management, Elucian Solution Manager, the Banner technical architecture and ancillary applications.

-Monitor and manage database backups, perform regular database restoring practices, developing scripts and sound troubleshoot mechanism to monitor logs, disk space, risk factors, establish performance metrics for optimal Banner and enterprise system performance; keep current, up-to-date database backups for recovery standards.

-Troubleshoots critical database and application service outages after-hours and weekends, providing escalation support as necessary. Perform root cause analysis, document, and present to team and management.

-Coordinate application installs, upgrades, maintenance across multiple internal and external cross functional teams.

-Manage Enterprise systems software migration following IT change management practices, response to migration requests and keep clear migration audit trail.

- Be responsible for mapping and documenting operational procedures, server inventory,and system dependencies.

-This position collaborates with technical, functional, development and business groups to ensure that database performance standards adhere to enterprise service level agreements.

-Collaborate with UNC System Office Hosting Services team to create clear database backup, and file system archiving and retention plans. Keep Banner applications upgrade status, version inventory and ready for response to external system auditing.

-Work with infrastructure and UNC System Office Hosting Services team to develop and test Banner server-based disaster recovery, backup and Business Continuity strategysta