SUMMARY

• A highly qualified, goal - oriented information technology professional with 12+ years extensive experience in Infrastructure Systems, Database Administration, Database Architect with OLTP and Data Warehouse systems, coordinated efforts between diverse groups ex: Network & Systems & Developers Teams.
• An adaptable leader rapidly learning new technologies and stays abreast of trends in the industry to place the company at the confidential of technology and increase productivity and profitability.

AREAS OF EXPERTISE

• Professional and administrative support in Areas of Network, Database, Developing, OS services and business applications.
• Responsible of Systems and Programming Action Requests by preparing Service design and program specification documents and Environments.
• Performs coding and debugging, unit and system testing, and implementation and documentation activities;
• Analyzes and evaluates existing data processing procedures and makes recommendations to improve division operations affiliated with a specific system under study defines problems, prepares Solutions flow chart.
• Knowledge of cloud based computing such as Microsoft Azure, AWS.
• Experience with migrating applications from client-server to n-tier and/or web-based web-scale cloud computing architecture.
• Dealing with web server, SQL and/or Non-SQL database server and networking technologies for data access and security.

TECHNICAL SKILLS

Databases: Oracle 6,7,3,8i,9i,10g,11g,12c - MS SQL 2000,2005,2008,2012 - IBM DB2- MYSQL-Mongo DB-DERBY-Postgre SQL

Oracle Engineering Systems: Exadata - Exalytics -Supercluster

Operating Systems: Linux, HP UX, AIX, Windows, Sun Solaris, Windows, MacOS, iOS, Android, UNIX

ERP Applications: SAP R3, Oracle EBS 12.1.3

Modeling Tools: Erwin, Oracle Designer, Visio

Development Tools: Toad, Sql Navigator, Oracle SQL Developer, Oracle Application Express

Developing Languages: JAVA, Servlet, JSP, JSF, SAP ABAP,Oracle PL/SQL,SQL,perl,SWIFT,C++,Javascript,powershell

Scripting: PowerShell scripting and Unix shell

Other Tools: Oracle Grid Control, Oracle Recovery Manager, Oracle Essbase, Oracle BI APPS, ODI, Oracle Gateway

Reporting: Jasper Soft IREPORT, OBIEE

PROFESSIONAL EXPERIENCE

Database Administrator

Confidential

• Oracle database Patching and migration from different oracle Releases.
• Queiries Performance Tuning provide a high avilabilty solutions for database and application systems provide a plans for database migration and designs to be integrated with AWS RDS

DBA/MW SENIOR MANAGER

Confidential

• I managed DBA and Middleware teams of seven where we were responsible from creation to administration of confidential databases/Middleware hosted in Bank Main Site Datacenter and Disaster Datacenter. This gave me the opportunity to work in many different kinds of environments and manage multiple DBA and MW resources.
• Conflict resolution between team members and with other teams Setup Crisis calls and ensured outage situation is resolved as soon as possible with coordination with Other teams (System & Network &Storage) such as DB Storage growth, memory growth.
• Involved in development proposals for IT Infrastructure Plans .
• Tuning Database Queries/Reports and Middleware Services Response Time Example: DB Query from 12 min to 3 secs - Web Service from 60 secs to 2 sec.
• Different systems performance testing using HP Load Runner (Core Banking), JMeter, SOAP UI
• Disaster Site consistency with the Main Site in Area of DB’s and MW’s Services (25 Oracle DB including the core banking DB with size 18 TB - 123 MS SQL DB 2TB - 7 Oracle Middleware Env.
• Data Replication from different Database Systems Using Golden Gate 12c for Egypt Visa Processing/checking system.
• Install and configure Oracle E-business suite Patching, Migration from 12.0 to 12.1.3 on High Availability from DB side and the Application Side.
• Migrate Oracle EBS 12.1.3 to Oracle EBS 12.2 WebLogic based architecture. install golden gate management pack and golden gate studio in Egypt visa system.
• Golden Gate configuration in Unidirectional and both-directional replication for the same database and heterogeneous databases/systems.
• Golden gate conflicts resolution implementation using timestamp, Quantitative and trust source.
• System automation Using Puppet over Linux and Cron jobs for the Banking EOD cycle

Senior Supervisor (Database and middleware SME )

Confidential

• Subject matter Expert for database and middleware team as a team leader (6 persons) in the mentioned areas which consist of two teams: One for Databases and other for Middleware.

Supervisor (senior dba )

Confidential

• Migrated all oracle DB’s on Windows (different releases) databases to oracle 11.2.0.4 RAC On RHEL6 over a period of three months.
• Configured Oracle Data guard.
• Installed Oracle Cloud Control 12 C.
• Managed MS SQL server Databases.
• Implemented and Building the Middleware Layer in the Bank.
• Built the e-banking system Audi Online (FCDB) which served 75K Online client account.
• Built RMAN backup and recovery process.
• Worked on Capacity Planning, Space Management, Security Management, Auditing, Shell scripting, Memory and Performance Tuning.

principle systems engineer

Confidential

• Problems Analyst and solver for database or any integrating application
• Confidential Disaster Site Administrator.
• Technical support in DB’s and OS’s.
• Developed a database replication monitor program by java
• Developed a FIX program (convert from PL/SQL to JAVA)
• Developed ATM machine client handler in Cairo bank. installed Microsoft Exchange Server 2007/2010/2013.
• MS. Exchange Migration from 2010 to 2013.
• Oracle Forms /Reports Migration from 6i to 10g.
• Installed Microsoft TMG 2010.
• Replicate the Army Clubs Data in both directions central to/from clubs using Oracle Golden Gate 11g.