Core/Apps Oracle Database Administrator
The New Mowasat Hospital
Total des années d'expérience :26 years, 1 Mois
Oracle DBA Activities Involved
Activities As Aplication DBA
• Expertise Installing Oracle E-Business Suite release 12 on Solaris 10 / Linux / Windows Environments.
• Expertise Installing Configuring Discoverer 10g on Solaris 10
• Setting up & Cofiguration of ICX Parameters
• Starting Discoverer services and troubleshooting when it fails
• Ensuring compliance with Oracle license agreements
• Performing the Single node, two node and Multi node installations on different environments.
• Administrating the oracle database and applications with the AD utilities. Adautocfg, adamgr, adadmin, adpatch, adrelink
• Administrate the forms and reports using with AU utilities
• administrating the AOL/FND for setup the new user set user and system privileges.
• configuring the client connect to the applications through the Browser.
• Apply the patches like patch, mini pack, maintains pack to fix the bug.
• Perform the cloning for test and development purpose.
• Storage management, sizing the database objects, monitoring file Systems and tablespace growth.
• Resizing the SGA and tablespaces, added data files as when necessary.
• Developing, testing, continuously monitoring, and updating the Backup and Recovery strategy. This strategy includes all three types of backups like Logical (Export), Offline or Cold, Online or Hot Backups of tablespaces.
• Having experience and Production Support a result oriented, self-motivated and well organized having individual abilities in Database Administration.
• Having Good experience in System administration Concepts.
Activities As Core DBA
• Administered Oracle server by tuning security, monitoring databases and providing user administration.
• Configured Dataguard for ORACLE 10G Database
• Database Design & Management
• Developed. and maintained new user schema, roles, grants and synonyms.
• Having One to One Meetings with Managers and Involving in Presentation of the developed softwares
• Installed the ORACLE 10G for SOLARIS 10 and applied the different version of the patch.
• Major Software/Systems Implementations and Upgrades
• Migrated the Oracle application schema into differential Oracle instance.
• Migrated the oracle instance to another server including scripts and scheduled job.
• Monitoring Regularly ADDM Reports and resolving the Issues
• Responsible for database availability, data integrity, technical maintenance and system troubleshoot.
• Running RMAN Backup
• Supported the Oracle Application developer assorted issues on Dev, test and prod Environment.
• Systems Security & Disaster Recovery Planning
• Testing/Scripting/Documentation
• Tuning Buffer Related Issues for Efficient Performance
• Working Experience in RAC Database Instances
• Working Experience on Oracle Application Server
Expertise Installing Oracle E-Business Suite release 12 on Solaris 10 / Linux / Windows Environments.
Performing the Single node, two node and Multi node installations on different environments.
Administrating the oracle database and applications with the AD utilities. Adautocfg, adaimgr, adadmin, adpatch, adrelink
Administrate the forms and reports using with AU utilities
administrating the AOL/FND for setup the new user set user and system privileges.
configuring the client connect to the applications through the Browser.
Apply the patches like patch, mini pack, maintains pack to fix the bug.
Perform the cloning for test and development purpose
Developing Forms as required by the Organization.
Running RMAN Backup
Tuning Buffer Related Issues for Efficient Performance
Monitoring Regularly ADDM Reports and resolving the Issues
Having One to One Meetings with Managers and Involving in Presentation of the developed softwares
Database Design & Management
Major Software/Systems Implementations and Upgrades
Systems Security & Disaster Recovery Planning
Testing/Scripting/Documentation
Created Complex reports.
Train users to use the tool and create Ad-hoc business objects Conduct gap analysis for the
business requirements
Designed security model for users to access the reports
Involved in the complete Data Warehouse design process.
Administered Oracle server by tuning security, monitoring databases and providing user administration.
Responsible for database availability, data integrity, technical maintenance and system troubleshoot. Developed. and maintained new user schema, roles, grants and synonyms.
Working Experience in RAC Database Instances
Working Experience on Oracle Application Server
Developing Forms as required by the Organization.
Running RMAN Backup
• Expertise Installing Oracle E-Business Suite release 12 on Solaris 10 / Linux / Windows Environments.
• Administrating the oracle database and applications with the AD utilities.
• Apply the patches like patch
• Perform the cloning for test and development purpose.
• Storage management, sizing the database objects, monitoring file Systems and tablespace growth.
• Resizing the SGA and tablespaces, added data files as when necessary.
• Developing, testing, continuously monitoring, and updating the Backup and Recovery strategy. This strategy includes all three types of backups like Logical (Export), Offline or Cold, Online or Hot Backups of tablespaces.
• Perform the Backup and Recovery.
• Having experience and Production Support a result oriented, self-motivated and well organized having individual abilities in Database Administration.
• Having Good experience in System administration Concepts.
• Installed the ORACLE 11G for SOLARIS 10 and applied the different version of the patch.
• Migrated the Oracle application schema into differential Oracle instance.
• Support the Oracle Application developer assorted issues on Dev, test and prod Environment.
• Migrated the oracle instance to another server including scripts and scheduled job.
• Administered Oracle server by tuning security, monitoring databases and providing user administration.
• Responsible for database availability, data integrity, technical maintenance and system troubleshoot. Developed. and maintained new user schema, roles, grants and synonyms.
• Working Experience in RAC Database Instances
• Developing Forms as required by the Organization.
• Running RMAN Backup
• Having One to One Meetings with Managers and Involving in Presentation of the developed softwares
• Installed and configured Oracle 9i/10g.
• Performs database performance tuning, monitoring & implements efficiency improvements.
• Managing the user privileges and access
• Carrying out performance tuning at the application and server level
• Taking backups of the different databases regularly
• Applying Patch to the production Database
• Running RMAN Back up
• Migrated the Oracle application schema into differential Oracle instance.
• Resolving Memory Related Issues like Cache Hit Ratio and space Utilization.
• Constantly interacting with the U.S Clients for resolving Database Related Issues
• Running and Analysing STATSPACK and AWR reports
Installed the oracle for windows version and ODBC driver and applied thedifferent version of the patch.
Migrated the Oracle application schema into differential Oracle instance.
Support the Oracle Application developer assorted issues on Dev, test and prodEnvironment.
Installed and configured Oracle 8i/ 9i/10g.
Migrated the oracle instance to another server including scripts and scheduled job.
Migrated Oracle Database from Oracle 8i to 9i.
Administered Oracle server by tuning security, monitoring databases and providing user administration.
Responsible for database availability, data integrity, technical maintenance and system troubleshoot.
Developed. and maintained new user schema, roles, grants and synonyms.
Educating the developers on the database related performance issues.
Carrying out performance tuning at the application and server level.
Performance analysis on long running transactions and optimizing the same.
Day to day administration and monitoring of Database Servers.
Access future information requirements in order to develop Long-range, comprehensive database plans.
Taking backups of the different databases regularly.
Develop policies and procedures, designed to ensure the integrity of database environment.
Promotes and recommends appropriate database software for new application systems.
Performs database performance tuning, monitoring & implements efficiency improvements.
Managing the user privileges and access.
Developed some projects which covers the entire inventory management and material management in various operating departments. All inventory details are stored in a centralized database which can be accessed by the entire organization. There are two subsystems namely Master Inventory Maintenance and Report/Archival system. The customer/supplier details and the stock informations are stored in the master database. This system also provides extensive reporting tools. creating reports which will be viewed by the top and middle management..
Educating the developers on the database related performance issues.
Carrying out performance tuning at the application and server level.
Performance analysis on long running transactions and optimizing the same.
Day to day administration and monitoring of Database Servers.
Access future information requirements in order to develop Long-range, comprehensive database plans.
Taking backups of the different databases regularly.
Develope policies and procedures, designed to ensure the integrity of database environment.
Promotes and recommends appropriate database software for new application systems.
Perfoms database performance tuning, monitoring & implements efficiency improvements.
Managing the user preivilages and access.
Manage assignments, schedules, and deliverables assigned to the project.
Training the students in softwares like C, C++, Cobol, Pascal, Oracle7.x and Etc.
The degree is shortly called as M.S which covers papers like Datastructures and designs,object oreinted programming,Java,Software Engineering,Networking and etc.
OCP certified 8i(Oracle Certified Professional) Oracle Database Administrator(DBA)
The name of the degree is called as BSc which covers all Softwares developing skills,Database structures and all related basics knowledge of computer