Ramy Barty

DB2 & Oracle Database AdministratorFull Time

• Job Details: Work Freelance as Oracle Database Administrator.I have experience more than 5 years.  Install Oracle Database 11G R2 over Windows & Linux OS.  Configuring Database Server parameters.  Monitor & Tune Database parameter & SQL statement to improve overall Database Performance.  Backup (FULL , Incremental , Cumulative Incremental Backup) & Restore Database.  Use RMAN for plan backup and recovery and Oracle Enterprise Manager (OEM)  Managing Database Security ( Users & Roles & Profiles ).  Export and Import Database using SQL Loader and Data PUMP.  Install & Configure Oracle Real Application Cluster (RAC).  Install , Manage Grid Infrastructure And ASM.  Install & Configure Oracle Dataguard  Join IBM as IBM DB2 DBA Admin and work as outsource at CIB bank. My job role is supporting and maintaining IBM DB2 over various Operating System ( Windows & AIX ) at CIB customer site.  Installing & updating & migrating IBM DB2.  Configure DB2 incremental/Delta incremental/Full Online & Offline backup / restore through TSM Server.  Export / Import at table level or the whole database between databases over different OS platform.  Configure Authentication & Authorization Security.  Integrating DB2 with Windows Active Directory to centralize user repository.  Configure DB2 Auditing.  Configure DB2 federation.  Configure DB2 Replication.  Configure DB2 Monitoring & Tuning using Quest SpotLight tool and DB2 command line for DB objects and DB & DBM configuration.  Maintenance database for best practice.  Partition large tables and create recommended indexes to improve performance.  Solve Performance Problems like high CPU or Memory utilization.  Detect bad SQL and coordinate with Developer to solve problems.  Detect Deadlock and TimeOut Errors and coordinates with Developer to solve These problems.  Configure High availability disaster recovery (HADR) and configure it with Tivoli System Automation (TSA) for automatic failover.  Configure High availability with HACMP using shared storage disk.  I have experience at IBM DB2 PureScale for installing and configuring Over AIX Operating system.  Integrating IBM DB2 PureScale with HADR for extreme Availability and disaster recovery.

ECM DB2 CM & FileNet AdministratorFull Time

• Job Details: Join Petropel project as Enterprise content manager (ECM) Administrator for IBM DB2 content manager Enterprise Edition.Installing, upgrading, migrating DB2 and Websphere application server and DB2 CM and moving data from old DB2 CM to new DB2 CM,making document routing (workflow), integrating DB2 content manager Enterprise Edition with LDAP (Active Directory) and making replication between two resource manager.  Join Egypt Insurance corporation project as Enterprise content manager (ECM) consultant to integrate application to work with webservices.  Join CIB project as SameTime administrator. SameTime software used for instant messaging, audio video chats, making groups and broadcast, allow group administrator to upload resource to groups and allow who has access to these resources, save audio video session and making telephony call through internet.  Installing, configuring, updating, making High Availability and Disaster Recovery  Implementation for IBM FileNet P8 Enterprise Content Management.  Installing, configuring and updating IBM content navigator.  Installing, configuring WorkPlace and WorkPlaceXT.  Installing, configuring IBM Case Manager.  Installing security certificate at Websphere application server and IBM HTTP server to work with HTTPS protocol.  Installing, configuring, managing Oracle Database.  Installing, configuring, managing Oracle RAC.