Senior Oracle DBA
AlRajhi Bank
Total years of experience :20 years, 5 Months
Plan, manage and execute the upgrades (version change, service packs and security patches) of supported Oracle databases
Install, configure, and upgrade database server software and related products installation
Actively participate in the installation, configuration, monitoring and maintaining of Oracle databases
Actively participate in on-call rotations for database support
Manage projects of a small to medium size
Establish and maintain sound backup and recovery policies and procedures
Participate in database restores/recoveries
Perform ongoing database security management
Define and maintain database standards for the organization to ensure consistency in server/instance/database/user creation
Create and maintain documentation for frequently performed tasks
Worked on Oracle Applications R12 with 11gR2 Database on IBM AIX.
Installation of Oracle Applications R12 on various platforms like Windows, IBM, Linux.
Installation of different versions of Oracle Database like 9i, 10g, 11g for development and test instances.
Cloning E-business suite installations.
Platform Migration from AIX 4.5 to AIX 5.3
Applying patches to E-business suite test and production installations for troubleshooting, adding new functionalities and release upgrades.
Designing, developing, documenting, and validating database backup and recovery plans in accordance with the business requirements.
Providing user-level system services such as setting up accounts, assigning passwords, and setting privileges.
Monitoring database system and applications performance including its integration with operating system usage, correcting and tuning abnormalities.
Providing technical support by troubleshooting and resolving database system, related operating system, and application problems.
Researching, evaluating, and documenting recommendations on database systems and applications to meet business requirements.
Maintaining a current knowledge of database systems, related networking technologies, operating systems, and applications
Installation of Oracle Applications Release 11i.
Upgrade from 11.5.9 to 11.5.10.2.
Cloning E-business suite Instance and database refreshes at regular intervals.
Applying patches to E-business suite test and production installations for troubleshooting, adding new functionalities and release upgrades.
Troubleshooting various applications and database performance issues.
Various day-to-day maintenance tasks using adpatch, adadmin, adsplice, adlicmg and adctrl for compiling objects, schemas, generating files, relinking, troubleshooting patching process, and licensing new products.
Oracle Applications System Administration tasks like creating users, responsibilities, registering custom applications, registering printers with Oracle E-Business Suite.
Troubleshooting Concurrent Manager issues.
Adding and Managing printers at OS level.
Purging log files created by various adadmin utilities such as adpatch, adadmin, adctrl at a regular interval.
Backups of database and applications file system.
Installing, Configuring and Maintaining Oracle Database Server.
Perform platform migration for Database 9i from windows to Linux.
Upgrade the database server from 9i to 10g.
Configured Dataguard (Physical Standby)
Patching Database Server with OPATCH utility.
Troubleshooting network issues related to OracleNet.
Monitoring database growth to avoid space related issues.
Performance Tuning and user support.
Configure RMAN Backup
Handling backups and periodical restores to check backup validity