Sr. Database Administrator
Etisalat
مجموع سنوات الخبرة :23 years, 6 أشهر
Responsible for Administering and Maintaining Oracle 10g/11g/12c Cluster Databases.
1. Installation of Oracle 12c/11gr2/10gr2 RAC on Solaris and their maintenance.
2. Migration of Data from Old to New Version.
3. Installation and configuration of Oracle 10g RAC on Windows servers.
4. Installing and configuring MS SQL Server clusters (2005 and 2008).
5. Configuring RMAN Backups for Oracle Databases.
6. Implementation of Advanced Replication and Oracle Streams between Oracle Databases.
7. Setting up Grid Control for all Internet Databases.
8. Managing large partitioned tables and periodically archiving data from these tables.
9. Frequent use of Oracle Data Pump to move data.
10. Configuring Materialized Views.
11. Migrating OCR, Vote disk and ASM devices to new SAN.
12. Involved in Provisioning Storage on EMC Clariion and VNX SAN.
13. Experienced in working with EMC backup software, Networker 8.2
14. Part of Cloud Team which is involved in implementation of Public/Private Cloud for Etisalat Customers, in coordination with Accenture.
Worked as Head of Migration Project and successfully completed migrating Oracle 10g databases (Data warehouse) to Oracle 10g Release 2 RAC on a 2 node Sun Cluster.
Responsibilities at Digital Processing Systems Inc. included:
• Report optimizations.
• Index rebuilds.
• Creating Range/Hash/Composite/List Partitioned Tables.
• Managing partitions of partitioned tables (Adding/splitting/dropping).
• Creating and managing Materialized views and Mview logs.
• Space Management for 5 Terabyte Production Database.
• Working with Raw files.
• Configuring backups using RMAN.
• Writing/Editing Sql loader control files for data loads.
• Worked on a data Encryption project.
• Installation of Oracle software on Unix and NT platforms.
• Created multiple database instances on Unix and Windows Operating Systems.
• Entirely responsible for maintaining the Production, Test and Development databases of the company, which includes the following :
Managing files of a database.
Creation of tablespaces and data files.
Setting storage parameters for tablespaces.
Managing schema objects.
Estimating storage parameters for tables, indexes.
Gathering table growth statistics and preparing scripts for reorganizing them.
Managing rollback segments.
Creation and setting storage parameters of rollback segments.
Altering rollback segments and assigning large batch transactions explicitly to bigger rollback segments.
Monitoring rollback segment growth.
• Managing users by assigning them privileges through roles, and quotas.
• Creating profiles for resource management.
• Configuring datafiles and monitoring their growth.
• Reorganizing Datafiles and Tables.
• Performing daily Hot backups and export backups through shell scripts run by cron jobs.
• Securing database access through Privilege, Role and Resource Management.
Assigning System and Object Privileges to users and roles.
Creating and Assigning roles.
Managing system resources through profiles.
• Tuning the INIT.ORA parameters from time to time for performance enhancement and other necessary operations.
• Monitoring the performance of the database and tuning the database when required.
Tuning SQL statements by running EXPLAIN PLAN.
Tuning Memory.
Monitoring locks and latches on system resources.
• Have implemented 2-tier, 3-tier and 4-tier Advanced Replication between Distributed Databases on Sun Servers, and highly experienced in troubleshooting Replication issues.
• Experienced in Partitioning large tables across physical disks to increase throughput for heavy transactional applications.
• Extensively using V$ views for performance monitoring.
• Installation of Oracle software on Unix and NT platforms.
• Created multiple database instances on Unix and Windows Operating Systems.
• Entirely responsible for maintaining the Production, Test and Development databases of the company, which includes the following :
Managing files of a database.
Creation of tablespaces and data files.
Setting storage parameters for tablespaces.
Managing schema objects.
Estimating storage parameters for tables, indexes.
Gathering table growth statistics and preparing scripts for reorganizing them.
Managing rollback segments.
Creation and setting storage parameters of rollback segments.
Altering rollback segments and assigning large batch transactions explicitly to bigger rollback segments.
Monitoring rollback segment growth.
• Managing users by assigning them privileges through roles, and quotas.
• Creating profiles for resource management.
• Configuring datafiles and monitoring their growth.
• Reorganizing Datafiles and Tables.
• Performing daily Hot backups and export backups through shell scripts run by cron jobs.
• Securing database access through Privilege, Role and Resource Management.
Assigning System and Object Privileges to users and roles.
Creating and Assigning roles.
Managing system resources through profiles.
• Tuning the INIT.ORA parameters from time to time for performance enhancement and other necessary operations.
• Monitoring the performance of the database and tuning the database when required.
Tuning SQL statements by running EXPLAIN PLAN.
Tuning Memory.
Monitoring locks and latches on system resources.
• Have implemented 2-tier, 3-tier and 4-tier Advanced Replication between Distributed Databases on Sun Servers, and highly experienced in troubleshooting Replication issues.
• Experienced in Partitioning large tables across physical disks to increase throughput for heavy transactional applications.
• Extensively using V$ views for performance monitoring.
Bachelor in Commerce, then specialization in IT, as Oracle Database Admin.
