Adil Sultan

Dba (Oracle & Sql Server) @Omantel

AB, CA

Hands on experience, to perform database administration tasks on production environment including installation, configuration, upgrades, patches, migration, backup, recovery and DB performance tuning.• Creation of database, table spaces, tables, indexes, setting privileges and user logins.• Continuous monitoring of performance during peak and non-peak loads.• Taking backups on scheduled time and monitoring scheduled backups and recoveries.• Database backup Both Logical and Physical using RMAN.• Diagnosed Oracle bugs and coordinating with Oracle support to resolve them in timely manner.• Database tuning by generating explain plans for long-running queries, creating indexes on columns to improve performance.• Set up and manage database security by creating new users, roles, profiles, and provide required user privileges in development and production environments for implementation and maintenance of user security.• Applying upgrade patches, maintenance and interim patches on databases servers.• Restore and Recovery of database in case of database crash, disk/media failure.• Migrated databases from 11g, 12c to 19c using utilities like export/import, data pump and cold backup strategy.• Database monitoring/maintenance, replication process and performance tuning are done using OEM.• Standby Database using Oracle Data Guard for Disaster recovery.• Migration of Databases from different Oracle versions.(11G to 12C to 19C)• Experience working with SQL, PL/SQL coding, stored procedures, functions, packages and triggers.• Experienced in DB migration procedures and scripts, developed templates that include check list for migrating the databases.• Management of schema objects, partitioning of tables, indexes and performing SQL loader jobs for loading data from flat files. • Design GUI Application Using Oracle Forms, Reports for Oracle ERP.• Create mappings using transformations to load the data into the target DB.

Virtual University

Master's Degree

Preston University

BS(CS) Bachelor of Science in Computer Science.