Senior Database Administrator
United Arab Emirates University
Total des années d'expérience :16 years, 5 Mois
• 24/7 support for Educational production ERP systems (Application and Database) running on Oracle RDBMS 10g, 11g, 12c with RAC and Oracle Fusion Middle ware (Web-logic, Forms, Reports).
• Administrating and support Ellucian Banner ERP.
• Handling regular Banner DBA activities.
• Working on Tickets (support), day-to-day alerts, Projects, Issues, Service improvement and adhering University IT security policies.
• Installed/Upgraded Banner database from 11g (11.2.0.2) to 12c (12.1.0.2) RAC.
• Analyzing backups (RMAN, Data Pumps and Online/Offline backups).
• Refreshing Production Database/Applications to non-production
(PPRD, DEVL, DEMO, TRNG etc)
• Analyzing Database Performance, tuning database, optimizing reports/quires
• Applying regular patches Database, Applications and Ellucian recommended App patches
• Harding Application/Databases as per ISO Standards.
• Configured DR for Banner Application and Database.
• Upgraded Banner Modules to latest 8.x release
(Student, General, HR, Finance, etc.)
• Installed and Configured Banner 9 Applications for Test environments
(Application Navigator, Banner Admin Common, Self Service Applications).
• Handling Oracle License requirements, managing support renewals.
• 24/7 support for Critical Core Banking databases
(Productions and non-Production)
• Handling Multi Node Oracle E-business Suit Environment running on R12.1.3 and 11.5.10.2
• Handling Multi Node Siebel CRM Environment running on 8.1.1.7 and OBIEE 11g.
• Installed and configured Oracle 10g /11g RDBMS on IBM AIX, Sun Solaris
• Installed and Configured Oracle 11g RAC on IBM AIX, Oracle Enterprise LINUX 5 with Scan IP’s.
• Working on Remedy tickets to address day-to-day alerts, support, issue and Projects.
• Performing Health checks for Oracle standby databases.
• Analyzing backups (RMAN, EMC Clones, Data Pumps and hot/cold backups).
• Cloning Oracle RDBMS, Databases, Oracle EBS Instances for Testing and Development.
• Performing patching on Oracle EBusiness Suit (adpatch) to fix application bugs/product enhancements.
• Performing patching on Oracle Databases PSU / CPU to fix Oracle Vulnerabilities.
• Analyzing and tuning long running quires, concurrent reports, batch jobs, End of Days, End on Months etc.
• Harding Database as per ITIL, INA, PCI and McAfee Standards.
• Performing DR drills on regular interval.
(Databases fail-over to DR site and fails back to Production site)
• Handling multiple clients (Government offices, Sports University, etc.)
• Performing Installations, Administration/Trouble shooting/Performance Tuning, Upgrades
• Database and Application health check activities.
Off-Shore oracle dba support activities.
Worked as Assistant DBA