Sr. Banner Database Administrator Resume
PROFESSIONAL PROFILE:
- 15+ year of experience managing large Oracle(10g/11g/12c) databases and RDBMS products including the Oracle RAC, Oracle Webtier (Weblogic, FormFusion), Banner(INB & SSB), ESM, Banner XE, OAS 10g, WorkFlow, ODS, TouchNet, NelNet, IFEP, EFC, SICAS, Degree Works, etc. I have strong skills and proven experience with database development & design, software installations, Banner, Oracle release upgrades, CPU patches, performance tuning, backup and recovery with RMAN, capacity planning, production deployments and general Oracle database management with Oracle Cloud control 12c.
- As a Senior DBA, I have been responsible for and trained as a UNIX Systems Administrator and as an Oracle Application Server administrator.
- I have configured third - party software to utilize Oracle 10g/11g/12c RDBMS including RAC, Oracle OEM GRID, Cloud Control, Weblogic 11g, Form Fusion, Oracle Application Sever 10g(OAS), Oracle Forms, Oracle Reports, Oracle Applications(A/P, A/R & H/R) Oracle Warehouse Builder, Lawson, Peoplesoft, StarBase, Banner, BlackBoard, ERSI s ArcSDE)
- Having lead and/or participated in numerous high profile projects, implementing and designing information systems for several major Universities I have developed good project management skills and my communication skills are seasoned.
- Completed a 11 month program for Project Management
- I managed and worked on a team of four DBAs that provided 24/7 support for 125+ Oracle databases running on Linux/UNIX, AIX & NT platforms configured for Oracle ERP, Spatial, OLTP, Data Warehousing and WEB access.
TECHNICAL PROFICIENCIES:
Databases and Tools: Oracle 12c RAC, 11gR2, Oracle 11gR2 RAC, RMAN, Weblogic, FormFusion, Banner, OAS 10g, WorkFlow, ODS, TouchNet, NelNet, IFEP, EFC Oracle 10g, Oracle10g RAC, Oracle Cloud Control, OEM 10g Grid Control, Oracle Weblogic, Oracle Application Server(OAS10g), Oracle9iAS,Oracle10gAS, Oracle DataGuard, Oracle Forms and Reports, Oracle Warehouse Builder, Erwin/ER, MS-SQL-Server, NetApp/SMO
Hardware: Linux Red Hat Enterprise Linux, Sun, HP, AIX
Operating Systems: UNIX, Sun Solaris, AIX, Linux Red Hat, Windows
Software: Banner7/8/9 Banner Xtender(All modules), ODS, BEIS, WorkFlow,Degree Works, Weblogic, Oracle Applications (ERP), TOAD, SQL Developer, PeopleSoft, NetApp-SMO, BlackBoard, Oracle Financials(11.5.7, 11.5.8), Websphere, Oracle GRID Control/Cloud control
WORK HISTORY:
Confidential
Sr. Banner Database Administrator
Responsibilities:
- I configure WebLogic and Oracle Application Servers for all Banner modules and related products (ODS, WorkFlow, SS0, IFEP, EInvoice, EFC, TouchNet, Jobsub, SleepWake, CleanAddress, etc) on Linux RedHat,
- Provide 24/7 support. As a Banner DBA I am responsible for the configuration, testing and implementations of the web based Banner ERP system.
- I recently led major effort to upgrade some Banner ERP thru some 70+ upgrades for current client.
- Responsible for all trouble shooting, Banner user and system security, patch applications, Oracle backups via RMAN, release upgrades and day - to-day administration, security and interaction with the vendor for all Banner Modules and Oracle Webtier products.
Confidential
Banner Database Administrator
Responsibilities:
- Configured WebLogic and Oracle Application Servers for all Banner modules and related products (ODS, WorkFlow, IFEP, EInvoice, EFC, TouchNet, Effort Reporting, CleanAddress, SICAS, etc) on Linux RedHat.
- Provide 24/7 support. As a Banner DBA was responsible for the configuration, testing and implementations of the web based Banner ERP system.
- Led major effort to upgrade Banner ERP thru some 70+ upgrades. Managed and install ODS, Touchnet, and all Banner modules.
- Responsible for trouble shooting, Banner release upgrades and day - to-day administration, security and interaction with the vendor for all Banner Modules and Oracle Webtier products.
Confidential
Sr. Banner/Oracle Database Administrator
Responsibilities:
- Responsible for installation, configuration and upgrading multiple large Oracle 11g databases. I configure WebLogic and Oracle Application Servers for Banner and related products (ODS, BEIS, WorkFlow, etc) on Linux RedHat, AIX & Solaris. I evaluate database features and products that offer better enterprise systems productivity and makes recommendations to management. Provide 24/7 support.
- As a Senior Banner DBA I am responsible for the configuration, testing and implementations of the web based Banner ERP system. I led effort to migrate Student Information System (SIS) to Banner system.
- Responsible for all trouble shooting, user and system security, patch applications, release upgrades and day - to-day administration, security and interaction with the vendor for all Banner Modules and Oracle products.
- Primary DBA for the implementation and deployment of Oracle RAC in 10gR2. Includes Cluster management, implementation of all RAC software, working directly with System and Network Administrators for the required OS upgrades and patches.
- Implemented, tested and documented Oracle10g DataGuard and made technical recommendation on deployment of the product.
- Primary DBA for implementation and deployment of Oracle10g RAC for Student Information System.
- Researched, documented and upgraded Oracle10g (including RAC) environment from 10.2.0.3 10.2.0.4.
- Applied latest CPU patches
Confidential
Sr. Oracle Database Administrator/UNIX Systems Administrator
Responsibilities:
- My day - to-day duties included security administration (controlling user access) monitoring, tuning and troubleshooting production performance problems for the Oracle databases, Oracle ERP Application Servers and UNIX servers.
- Working directly with users and providing direction to development staff who supports the county Student Information System applications.
- Responsible for all application patches, release upgrades, backup & recovery policies and day-to-day administration of databases, security and interaction with the vendor.
- Project lead and DBA on Student information Data Warehouse
Confidential
Senior Oracle Database Administrator/Oracle Financials Systems Administrator
Responsibilities:
- Primary Database Administrator/Systems Administrator for the configuration, testing and implementation of the web based Oracle ERP Financials Applications.
- Responsible for all trouble shooting, patch applications, release upgrades and day - to-day administration and security for Application Server and supporting databases. First point of contact for vendor and support calls.
Confidential
Senior Oracle Database Administrator
Responsibilities:
- Primary DBA for implementation, configuration and support of GIS (Geographic Information System) data warehouse. Worked closely with the GIS administrator during initial design. Daily task included: (1.) Installing the ArcSDE application server (2.) Configuring the ArcSDE application server for the network, (3.) Starting, stopping and monitoring ArcSDE server processes (4.) Tuning the relational database and optimizing ArcSDE performance on the network. (5.) Setting up ArcSDE connections and user access to the database. The database was used for demographic analysis for: regulatory compliance, tracking consumer spending habits and economic growth forecasting.
- Primary DBA for the configuration, testing and implementation of the Lawson Financial application. The Lawson application is the Federal Reserve Bank system - wide web based accounting and control application. The configuration includes 10 separate databases with 24-hour access.
- Configured, tested and implemented Oracle9i Data Guard for of the Federal Reserve Bank s nation-wide problem tracking and change control systems. The system is web-based, run 24/7 and uses Remedy application software. The configuration includes 3 databases, one primary and two standbys. The setup allows primary database to be switched between any of the three sites for contingency events with minimal downtime or data loss.
- Applications DBA and Systems Administrator for the implementation, setup and daily maintenance of the Oracle Financials Systems (included AP, AR, GL and HR modules). Duties included initial selection, setup and subsequent upgrade of software versions from 11.5.4 > 11.5.7 >>-> 11.5.8, trouble-shooting and application of patches.
- Headed project that migrated some 70+-production databases from Oracle8i to Oracle9i. Included license negotiations with Oracle Corp., initial installation and testing of new software, project coordination and planning, capacity planning, application testing and migration into production environments.
- Work closely with users, system administrators and storage administration and management to setup standard implementation backup procedures for development, QA and production environments. Tested and implemented BMC SQL-Backtrack duct for backup and restores.
- Responsible for setup and maintenance of multiple Oracle Hot-Standby Database configurations. Tested fail-over scenarios and recovery procedures involving activation of hot standby databases and switching over applications. Developed a number of SQL and shell scripts for database performance monitoring and maintenance.
- Provided assistance and feedback to the development team on various issues regarding logical database design and SQL code tuning during development of Web enabled systems.
- Documented best practices and standards, which were used in the process of setup and configuration of all FRIT Oracle production environments.
- Primary DBA for the setup, testing and implementation of the Federal Reserve Banks Intercom system. This system tracks the health of system-wide computer configurations that are required to ensure that various Treasury applications are functional.
- Primary DBA for setup, implementation and testing of PlanView application. This is the project management and time tracking application for Confidential staff.
- Primary DBA for setup, implementation and testing of Tivoli/TEC and Tivoli/Inventory application. This application monitors the health, inventory and performance of the Federal Reserve Bank national wide computer network environment.