Senior Oracle Technical Consultant
ITWORX
Total years of experience :21 years, 0 Months
In addition to previous responsibilities:
- Planning customer's Oracle databases migration to cloud. Include understanding databases architecture, Integrations with other databases/systems and deciding the correct service to choose for each database (PaaS or IaaS).
- Lowering customer's Oracle databases footprint, by analyzing databases option and choosing the correct edition between standard and enterprise . Consolidating databases according to size, resource utilization, character set ...etc .
- Planning backups for data centers and VLDB (Very Large DataBases) to reduce backup time and resource consumption
- Understand client's business processes and suggest improvements whenever possible.
- Identify client's database issues and suggest fixes and enhancements.
description for all the jobs in ITWorx
Manage and handle development for capacity allocation, backup strategy and security policy
Administer, install and troubleshoot issues for Oracle Application Server and Oracle 10g on Linux, UNIX and Windows platforms
Manage technical issues related to oracle database, applications and tools used in the development process
Support Oracle service for internal and external support requests
Administer DBA and Data Warehousing Database
Operate system troubleshooting, performance tuning on Patch installation, Windows, UNIX and Linux version upgrades for issues related to Database
Responsible for database performance tuning, security, capacity planning and space management
Working and installing distributed and replicated systems
Plan and implement backup and recovery strategies
Provide 24/7 support for critical database issues.
Review and provide consultancy regarding database design and Microsoft SQL development for ITWorx engineers by giving intensive training.
Utilize ITWorx hardware resources.
Helping ITWorx Onsite Managers on all Oracle related issues on different projects.
Manage projects on client side as installing, patching, deployment, maintenance troubleshooting errors.
Securing application server and database for Clients “Vodafone & Arab National Bank”
Support Oracle service for internal and external support requests
Install and administrate Physical Data Guard on 10G and 11G
Implement Oracle advanced Replication
Install Oracle on SUN CLUSETER (Active-Passive)
Design and implement oracle security
Row-level security with Virtual privet database
Oracle label Security
Fine-Grained Access
Installing and configuring Golden Gate between Oracle/Oracle and MSSQL/Oracle
Con’d: ITWORX work description
Write Advance PL/SQL programs (Procedures, functions and package) to support our client's needs
Distributing all oracle related issues between team members and make sure all client request are handled and all customer are satisfied
Help production DBA on client database to achieve maximum database performance.
Installing oracle RAC 10G on Linux environments
Work with developers in the application design phase for better application performance
Responsible for quality audit reviews and project conformance
Identifying time needed for different oracle support issues.
Identifying effort needed for different oracle support issues.
Direct communication with customer for solving database related problems
Consultation to help the customer decide on a database technology that best fits his needs
Responsible for developing and tracking the oracle support effort for project issues schedule it according to the work load and priorities.
Responsible for Development, Test, Staging and production database for ITWorx clients
Managing Tasks between team members according to different areas of knowledge and practices
Oracle DBA Nov. 2005 - Aug. 2006
Connection IBM Authorized training Center, Tanta, Egypt
Title: IT Instructor Jan. 2004 - Mar. 2005
Duties (Courses Overview)
* SQL/PLSQL Introduction to Oracle (Oracle8i)
* Oracle Administration DBA (Oracle8i)
* Oracle Backup & Recovery (Oracle8i)
* Oracle Performance & Tuning (Oracle8i)
* Oracle Network Administration (Oracle8i)
* SQL Introduction to Oracle (Oracle9i)
* Oracle Administration Fundamentals I (Oracle9i)
* Oracle Administration Fundamentals II (Oracle9i)
* Oracle Performance & Tuning (Oracle9i)
* Programming Microsoft SQL server
* Administrating Microsoft SQL server
* Querying Microsoft SQL server
Millennium Computer Company
Title: Technical Support Jun. 2000 - Mar. 2002
Duties
* Installing networks client-server AND peer-peer On Windows platform (professional advance server, server Building DC, Intranet and servers)
* Assembling computers
* Software installation
* Troubleshooting Hardware, software, and network problems
Oracle Certified Database Administrator (ORA-DBA) 2004 Covering the following subjects: OCA: * Introduction to Oracle9i: SQL (1Z0-007) * Oracle9i Database Fundamental I (1Z0-031) OCP: * Oracle9i Database Fundamental II (1Z0-032) * Oracle9i Database Performance Tuning (1Z0-033 Arab Academy for Science & Technology (AAST), Alexandria, Egypt
Degree in English major
American University in Cairo (CACE), Egypt Pascal Programming System Analysis & design Visual Basic Data Structures Assembly Language