Senior Oracle Apps DBA
Ministry of Communication and Information Technology
Total years of experience :18 years, 2 Months
• Administrating Oracle SSO Database and Oracle RAC Databases.
• Monitoring the Database, Cluster, ASM and SSO Alert.
• Patching E-Business Suite to troubleshoot issues which include RUPs, CUPs, Maintenance Packs and Database Server Patchsets.
• Upgraded Oracle Database from 11.1.0.7 to 11.2.0.4 and 12.1.0.2.1 with Oracle ERP R12 environment.
• Monitoring the size of the Tablespaces and File System at OS level.
• Monitoring all the Logs and Alert files in the Database and Application servers.
• Cloning Oracle E-Business Suite Application and Database whenever required by Functional Consultant/Developers.
• Validating the Backups.
• Monitoring the newly created users in Oracle ERP using SSO Components.
• Monitoring SSO Component’s like OID, OAM, Oracle Web Access Gate etc.
• Resolving issues raised by Functional consultants and End users.
• Troubleshooting the Performance Issues for Oracle ERP.
• Working with Oracle Support in case of any open SR.
• Applying Patches for resolving performance issues and bugs.
• Troubleshoot problems with Concurrent Managers & other application Server Processes.
• Monitoring Notification Mailer status whether sending proper email to users or not.
• Purging log files created by various adadmin utilities such as adpatch, adadmin, adctrl at a regular interval.
• Monitoring Daily Backup for Banner SIS & Oracle ERP Application.
• Monitoring the Alert and Warning in the EMC SAN Storage.
• Monitoring the Alert and Warning in the HP Servers.
• Monitoring the size of the Tablespaces and File System at OS level.
• Moving the Backup files from Datacenter to other location in Riyadh and keeping
One more set in the campus
• Monitoring all the Alert log files in the Database and Application servers.
• Cloning the TEST environment in Banner SIS Application and Oracle E-Business Suite whenever required by Functional Consultant/ Developers.
• Validating the Backups
• Handling different project in the University Microsoft FIM, Enterprise SMS, Sharepoint Integration, Blackboard, KIOSIK, Document Management System/Solution (Laserfische), Attendance System (Finger Print System) etc.
• Managing all the application issues from Finance Department, HR Department, Inventory Department and Purchasing Department.
• Creating the new users join in HR, Finance and Purchasing Departments and assigning a required responsibility.
• Monitoring the Notification Mailer status running or not for the Purchasing users.
• Managing issues in the Students Administration Department in University.
• Providing support on the MOHE (Minister of Higher Education) Statistics Reports.
• Providing support on the NBU Adhoc Reports.
• Troubleshooting the Applications issues and performance problems.
• Managing the user's and responsibilities of EBS.
• Diagnosed hardware and software problems and provided solution to them. Managing the paging space, increase or decrease according to requirements.
• Replacing the HDD in EMC Stroage and HP Servers in case of failure.
It’s an IT solution company where I worked for Princess Noura Bint Abdul Rahman Univeristy responsible for handling Oracle Database Administration, Solaris Administration, Banner Application issues and providing support to students in Oracle.
Oracle DBA
• Performing Daily backup for PROD.
• Moving the Backup files from Server to my local PC (If server goes down then the backup will be in my Local PC)
• Checking the alert log file to know when the DB has Down and when it is up.
• Auditing the selected required Tables.
• Validating the Daily Backup
• Monitoring the size of Table spaces, DF through OEM
• Running the Stats Gather schema on weekly basis for better Performance of Database.
• Browsing the Metalink to check the new updates
• Performing Cloning on DEV, TRNG whenever required.
• Validating the Backup monthly from PROD to TEST.
UNIX Admin
• Monitoring the Disk space available at OS level.
• Creating users in the UNIX as per the request.
• Assigning the appropriate privileges to requested person
• Performing the required task with DAR & SGHE while upgrading Banner.
• Monitoring the user's works at the OS Level.
Banner Application Administrator
• Troubleshooting the various Technical issues face by the Functional users.
• Performing Password reset for all the Students in the Banner Application.
• Validating the student's id whether the request came from the right student or not.
• Validating the Students id whether the Email id is Registered in the Banner Application or not.
• Performing monthly backup for INB server.
• Performing monthly backup for SSB server.
• Browsing the SGHE to check the new updates.
Software's Administrator
• Gathering the requirement from all the Colleges in a University.
• Validating the requirement of software whether Free or need to Purchase.
• Gathering the information for all the Software's from the Google.
• Collecting the information of software's in term of Finance and Products details
• Ordering to Vendor to Purchase the requested software's
• Validating whether the right Product with right number of License is Delivered to University or not.
• Supervision for installing all the software's in the required Labs.
• Support to Wipro in case of software's issues.
• Setting up the License Server on the Server.
• Resolving the Technical issues facing while activating the software's.
• Communicating with Vendor to resolve the issues.
• Communicating with Wipro to resolve the issues.
Oracle Support for Colleges
• Installing the Oracle on the required Lab for College of Computers & Information Sciences.
• Creating the Database for the College of Computer & Information Sciences students to practice in the Labs.
• Creating the users in Oracle for Computer Science College students.
• Providing Technical support for all the Colleges Labs in the University.
• Providing Technical support for the Colleges Labs outside University like Malaz etc2.
This is a Construction Company where I was worked as an Oracle Apps DBA (Oracle E-Business Suite -11i) responsible for Monitoring Database and along with this I was also responsible for AIX administration.
Main Responsibilities
• Installed Oracle Database 9i, 10g, 11g, and E-Business Suite 11i, Release 12 on various platforms like Windows, IBM, Linux.
• Instance planning from patches to production instances
• Cloned E-Business Suite Release 11i and 12 for prodution and test instances.
• Using adpatch, adadmin, adsplice, adlicmg and adctrl for database patching, compiling objects, schemas, generating files, relinking, troubleshooting patching process, and licensing new products
• Database disk storage Management.
• Day-to-day user support related to Database and Applications.
• Work with and help Financial and Technical team members resolve techno-functional issues.
• Co-ordination of database administration tasks among team.
• Applying Patches for resolving performance issues and bugs.
• Troubleshooting the Applications issues and performance problems.
• Troubleshoot problems with Concurrent Managers, and other application Server Processes.
• Maintaining Database Security.
• Creating or modifying users, assigning Responsibilities to users, creating and running Request and troubleshooting.
• Implemented recovery strategy by establishing recovery catalog and setup scripts for database backups using RMAN, recover and test the backups regularly.
• Registering different types of Printers and customized the Style and Drivers to troubleshoot the printing issues for Oracle Application reports.
Main Duties:
Responsible for Preparing Weekly Program Manager Progress Report.
Coordinating with other departments PMs & controllers.
Review and analyze project accomplishment reports to ensure accuracy and excellence.
Check for dependency issues causing impediment in projects, to escalate the issues to higher management.
To coordinate with Vendor for implementation (Installation, Integration or PAT) of Transmission Projects, and check and resolve dependencies to meet project deadline.
Responsible for analyzing all the systems in the organization and looking after maintainance of these systems.
Designed and implemented system for acquisation applications.
Liasion between all impacted departments to ensure proper communication and reporting practices.
Duties & Responsibilities:
• Teaching the Oracle DBMS Pracitcal to the Engineering students.
• Responsbile for the entire Computer Labs.
• Invigilation for the exams going in the College.
• Performing via for the final Engineering students.
• Performing Project to the final year students.
• Designed and implemented system for the Computer Labs.
• Installing all the required software in the Computer Labs.
• Coordinating with other departments HODs and Principle.