Amr Ismail Hassan

Consultant Oracle DBAFull Time

• Job Details:Acts as the first line of support for all Oracle Database Admins • Puts standards in place to ensure that all application design and code is produced with proper integrity, security and performance. The DBA will perform reviews on the design and code frequently to ensure the site standards are being adhered to. • Provides technical support to application development teams. The Senior DBA is usually the point of contact for Oracle Corporation. • Supervises & coordinates with the Technical Manager to ensure that the necessary operating system and server has been installed, prepared the customer environment and made all the necessary communications for the installation and set-up of the databases and the development tools and oracle required products. • Supervises & coordinates with the Project Managers to understand all the installation and set-up requirements as per the client contract, as well as the assigned time frame (as per the project plan), necessary for their installation of applications or implementation of oracle technology products. • Assists all Oracle Database Administrators if necessary, in all the technical installation, database set-ups, and installation of development tools to support the installation of the Oracle applications, in-house developed, and ready-made packages (as needed). • Undertakes all the database tuning and maintenance aspects, including the necessary database and development tool upgrades at the client site as well as internally, within the LoB. • Solves all problems at the customer site if necessary, communicated by the Project Managers of the LoB, during the warranty period or maintenance contract with the customer and prepares and submits the required customer call reports highlighting the status of the problem, to the Database Technical Manager

Oracle Database ConsultantFull Time

• Job Details:•Creates and maintains all databases required for development, testing, and production usage. •Performs the capacity planning required to create and maintain the Databases. •Performs ongoing tuning of the database instances. •Install new versions of the Oracle RDBMS and its tools and any other tools that access the Oracle database. •Plans and implements backup and recovery of the Oracle database. •Controls migrations of programs, database changes, reference data changes and menu changes through the Implements and enforces security for all of the Oracle Databases. •Performs database reorganization as required to assist performance and ensure maximum uptime of the database. •Puts standards in place to ensure that all application design and code is produced with proper integrity, security and performance. •Evaluates releases of Oracle and its tools, and third party products to ensure that the site is running the products that are most appropriate. Planning is also performed by the DBA, along with the application developers and System administrators, to ensure that any new product usage or release upgrade takes place with minimal impact. •The DBA is usually the point of contact for Oracle Corporation. •Enforces and maintains database constraints’ to ensure integrity of the database. •Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures. •Assists with impact analysis of any changes made to the database objects. •Troubleshoots with problems regarding the databases, applications and development tools. •Create new database users as required. •The DBA has ultimate responsibility for the physical database design

CIL DBA Supervisor Full Time

• Job Details:•Assess and develop long-term strategic goals for production database in conjunction with data owners and department managers. •Work with application development staff and quality assurance policies and procedures. •Create models for new database development and / or changes to existing ones. •Install and configure relevant network components to ensure database access as well as database consistency and integrity •Respond to and resolve database access and performance issues •Monitor database system details within the database including stored procedures and execution time, and implement efficiency improvement •Design and implement redundant system policies and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets. •Monitor, optimize and allocate physical data storage for database system. •Plan and coordinate data migrations between systems. •Develop, implement, and maintain change control and testing processes for modification to database. •Create, or support creation of, required reports in response to business user needs. •Conduct research and make recommendations on database production, services, protocols, and standards in support of procurement and development efforts. •Perform database transaction and security audits. •Establish appropriate end-user database access control levels. •Develop routines for end-user to facilitate best practices database use. •Manage and/or provide guidance to junior members of the team.