SUMMARY:

• A competent professional with 6 + years of experience in Oracle Database Administration, MySQL, Postgre SQL, MS SQL Server .
• A competent professional with 4 + years of experience in Oracle Database Administration Instructor.
• Professional experience in different aspects of Oracle Apps Database Administrator/System Administrator of Oracle Application Server 10g, Weblogic 11g and EPS R12
• Proficient in database administration involving in installation, configuration, tuning and migration of databases along with database design and management.
• Deft in operating database administration under multi - platform environments, including installation and configuration of software, maintenance and disaster recovery management.
• Skilled in migration of databases from older to new version with different platforms and upgrading Databases with patch sets.
• 24x7 on-call Production support for database activities.
• Responsible for the 24/7 support of Oracle Database services to ensure the highest standards of availability, Flexibility, integrity, security and performance required by business systems .
• Responsible for Installation, configuration, deployment and administration of Oracle Database and Real Application Cluster (RAC) on different nodes with Automatic Storage Management (ASM) on Linux .
• Managing Database unknown errors using MOS .
• Manage Multiple Database servers on different Sites .
• Managing database administration related functions involving in i nstallation, configuration, up grading and patching of Oracle server software and hardware.
• Installing, Upgrading and managing RAC with ASM .
• Managing standby Databases (Data Guard) .
• Handling disaster recovery management, supervising technical team to restore database during system failure. Database / SQL tuning, performance monitoring and troubleshooting.
• Managing physical and logical structure of database; bullet proofing the database.
• Making and implementing backup and recovery strategies using RMAN & user managed.
• Loading data into database using export and import.
• Transporting data between databases; assessing current and future storage requirements.
• Building test database.
• Maintaining user connectivity and configuration.
• Looking after patch installation and security management.
• Handling Disaster Recovery Management; supervising technical team to restore database during system failure.
• Resolving database startup problems and database re-organisation.
• Maintaining availability of database by designing backup and recovery strategies.
• Collection of Statistics
• Develop Shell scripts for automated backups
• Monitor Database space usage and Tablespace Growth
• RMAN backup, restoration, recovery, duplication of database.
• Configuration of RMAN backup and schema wise logical backups
• RAC administration, ASM Administration and Performance Tuning (I/O, SQL Tuning)
• Troubleshooting and Resolving RAC issues using OS utilities, OS messages, database waits, tracing and tuning database SQLs.
• Providing In-Depth Upgrades and Migration Solutions using Oracle Golden Gate Technology .

AREAS OF EXPERTISE:

• Oracle Database 9i, 10g, 11g and 12c
• Oracle Database Vault
• Oracle RAC, ASM
• Oracle Golden Gate
• Oracle Data Guard
• Oracle Upgrades/Migrations
• Oracle Database Masking
• Oracle Audit Vault
• Oracle Database Security
• Oracle Enterprise Linux
• Red Hat Enterprise Linux
• Windows Server
• Oracle Solaris
• Linux Centos
• SQL
• Shell Script
• Application server 10g
• Weblogic 11g
• Oracle E-Business Suite R12
• Implementation
• Project Coordination
• Testing
• Design
• End User Training
• Documentation

WORK EXPERIENCE:

Confidential

Senior Database Administrator

Responsibilities:

• Maintaining the 24/7 Mission critical Production Oracle Database on Linux and windows.
• Responsible for tens of projects including Planning, design, implementation, Installation, Migration of different RDBMS including 10g, 11g databases, cluster, Data guard on different platform .
• Managing Storage through ASM (Automatic Storage Management).
• Cloning Oracle RAC 11gr2 to single node .
• Verify the availability of all the instances.
• Backup, Maintenance, Recovery and Tuning of company’s database.
• Check for RMAN backup logs for any errors.
• Check Alert Log files for “ORA” errors.
• Truncate listener logs if size exceeds 300MB.
• Check the Servers for any space constraints.
• Sizing Memory Components from performance point of view.
• Check the databases for any INVALID Objects and rectify the problem.
• Check tablespaces for any space problems and their growth patterns.
• Database Upgrade from 11.2.1, 11.2.2 to 11.2.3 on RHEL 5 .
• Applying Database patches(Patch sets and PSUs)
• Database Cloning as per requirement.
• Re-organisation of database objects.
• Gathering database statistics.
• Database Export & Import.
• Check DBMS JOB for any broken or failed jobs.
• Setting up new users Managing User Responsibilities.
• Backup Oracle Database on Tape Drive vie HP DATA Protector.
• Backup MYSQL DATABASES.
• Sanity Backup to check if the backup is recoverable or not .
• Managing Oracle Database RAC with ASM instances .
• Create user and grant privilege in MYSQL Database .
• Apply Patches & Bugs Fixes on Oracle Database .

Confidential

Database Administrator

Responsibilities:

• Configure, troubleshoot, Maintain and Monitor Billing System Databases under SUN UNIX Salaries With SUN Cluster Software Technology.
• Install Oracle 11G under RHEL 6.3 for Reporting System .
• Provide Support to critical Systems that must be available 24/7 .
• Configure the backup Strategies (HOT & COLD Backups).
• Responsible with Billing Team for implement new Provisioning setup requests for Billing System.
• Backup, Maintenance, Recovery and Tuning of company’s database.
• Check for RMAN backup logs for any errors.
• Admin for Oracle Application Server (tabs 6.10 & 6.11 ) and Oracle Portal Application .
• Publish some report on net vie Discoverer .
• Daily Support for CCR & CSR .
• Check Alert Log files for “ORA” errors.
• Truncate listener logs if size exceeds 300MB.
• Sizing Memory Components from performance point of view.
• Check the databases for any INVALID Objects and rectify the problem.
• Check tablespaces for any space problems and their growth patterns.
• Database Cloning as per requirement.
• Re-organisation of database objects.
• Gathering database statistics.
• Database Export & Import.
• Check DBMS JOB for any broken or failed jobs.
• Setting up new users Managing User Responsibilities.

Confidential

Database Administrator

Responsibilities:

• Install Windows Server 2008 .
• Install MYSQL Database and Application (Knowledge Tree).
• Create User and Group and assign permission to user.
• Backup and restore in MYSQL Database.
• Migrate the data from SQL Server to MYSQL Database.
• Training all Staff in MOI (Ministry of Interior) .
• Install and Configure archiving System in MOI (install MYSQL Database and Knowledge Tree Application
• And migrate the data from SQL Server to MYSQL Database ) .
• Install and Configure the Reporting System (Migrate the data from Oracle 10g running on windows Server 2008
• 700GB approx in size To Oracle 11g under RHEL 6.3 ),
• The implementation was done vie using Rman, Datapump, Cross platform
• Transportable Tablespaces .
• Reconfigure the Oracle Portal with new Reporting System .
• Cloning Oracle Database 11gr2 RAC and ASM to Oracle 11g one node under file system .
• Upgrade Oracle database from 11.2.2 to 11.2.3 under OEL5.6
• Migrate the all 2012 CDRs from IN Database to Billing Database vie using the exp and imp tolls .
• Install and configure the weblogic 11g and Migrate the oracle application server 10g to weblogic 11g and deploy all fmb from OAS 10g to weblogic 11g .
• Oracle 11gr2 RAC and ASM 2nodes installation and configuration under RHEL 6.3 for the Mediation Systems and insert all CDRs from source (AAA, HLR, IN ) To Billing database vie using the sql loader tolls .
• Planning and Implementing Physical Standby Data Guard 11g for Billing System .
• Migrate all the Billing Databases RAC ASM 11gR2 3.5 TB Data from HP EVA Storage to
• HP 3PAR Storage, The Migration was done with zero downtime .
• Worked part time with System Admin Team to extend Zain Iraq Storage and backed up their Databases .
• MySQL Database Upgrade From 5.1 To 5.5 in Linux System .
• MySQL Database Cluster Installation and Configuration under RHEL 6.3 .
• Planning and Implementing MySQL Database Replication between Main And DR site .
• Database Upgrade from 11g to 12c with 1minute downtime using Golden Gate Technology .