AbdelFattah ElMasry
Sr.Oracle Database Administrator
Oracle
DBA
RAC
44 years old
Driving License
Banha Egypt
Employed
Available
Certified Oracle Database administrator (DBA) with more than 12 years strong experience in IT field, Extensive experience in planning, installing, Patching, configuring, and administering multiple Large Oracle databases in a LINUX platforms and MS Windows server ,Considerable experience in dealing with technical and performance issues, and a thorough knowledge of the process and procedures of the corporate environment
Head of Oracle Database Administrator Section
Sigma Securities
Since January 2014
Full-time
Giza
Egypt
- Manage Oracle database administration assignments for diverse financial clients. Enhance database performance, perform restores, implement recovery procedures, handle performance tuning and conduct regular system backups. Ensure technical and functional designs meet business requirements.
- Duties:
- Working on live systems managing large databases to provide 24/7 support of production database services to ensure the highest standards of availability, resilience, integrity and performance required
- Served as DBA or project lead in the completion of medium to large scale implementations, managing projects from business requirements analysis to solutions delivery and support.
- Managed thousands of data-integration projects for financial services firm that consolidated information from accounting applications, third-party market data, and internal equities/fixed income applications.
- Developed and tested storage strategies and disaster-recovery plan for the operational database, delivering a solution that guaranteed recovery performance and high availability.
- Create and managed large size Oracle 10g / 11g RAC databases on RH (6.4) servers consist of 4 nodes with shared storage designed for ASM disks.
- Create and managed Oracle RAC physical standby database for disaster purpose.
- Create and managed Development and test environment.
- Monitoring the performance of all critical databases find out and tune all performance. Related bottlenecks (OS parameters, SQL tuning, PLSQL tuning and Database parameter tuning) using (AWR, ASH, ADDM, oracle tuning pack, oracle grid control).
- Support application team in development and test phase for all projects
- Make needed upgrade for database and cluster.
- Motivating the team to achieve high standards and targets.
- Dealing with and resolving problems and issues which arise and implementing new initiatives.
Oracle Database Administrator Team Leader
Silicon Expert - Division of Arrow (USA)
May 2011
to December 2013
Full-time
Cairo
Egypt
- Lead team of 6 resources to achieve business targets, preparing daily workloads for staff & coordinating the daily allocation of work and Handling new client inquiries plus daily technical tasks.
- Duties:
- • Creating and managing a huge database.
- • Perform Oracle Server database administration duties including configuration, installation, troubleshooting database systems, account management, backup and recovery, data, schema changes.
- • Improve and maintain the database (schemes, tables, procedures and permissions).
- • Work with application & database developers to develop and implement solutions.
- • Provide and design a complete high availability solution for arrow project using Oracle 11g RAC plus Active Data Guard replication.
- • Design, support the Performance test, High availability test and Disaster recovery test For RAC, DR site.
- • Apply Oracle Database patches (HOT & COLD).
- • Enhance the DB structure and performance by using the partitioning technique.
- • Monitor existing Oracle databases database storage needs and perform fine-tuning to ensure the databases are running efficiently.
- • Perform modifications to Oracle environments to support changes to the applications, reporting requirements, and user requests.
- • Monitor, troubleshoot and optimize database ensuring high-performance Manage DB replication
Oracle Database Administrator Consultant / Instructor
Global Knowledge
July 2006
to May 2011
Full-time
Cairo
Egypt
- Performing database consultation tasks for different GK customers. Consultation work involves all database administration, Oracle Data Guard implementation, Import/Export utilities for making logic backups ,Configuring RMAN to take full and incremental backups on different platforms, implementing Automatic storage management on different platforms, Install setup and configure Oracle 10g RAC and Data Guard running against Microsoft Windows 2003 Server / Red Hate with Oracle clusterware RAC environment
Project Team Leader/Office Instructor
Synergy Professional Services
July 2005
to July 2006
Full-time
Cairo
Egypt
- Manage Smart School Project, a team of 40 Instructors/Consultants responsible for Office Training and professional services
-
Oracle 10g Database Administration
Advanced
-
Performance Tuning & Capacity Monitoring
Good
-
Data Backup & Recovery
Good
-
Standby/Failover Administration
Good
-
Oracle RAC & ASM Administration/Installation
Advanced
-
Consultation with development teams
Advanced
-
Database-Backed Web Solutions
Advanced
-
SQL Tuning in an Oracle Environment
Good
