Operations Manager - Information Archtect ,Database
IBM
Total years of experience :29 years, 10 Months
Responsibilities:
~Oversee technical staff’s operations "Database, Infrastructure, development, BI and Epayment"
~Review all technician work documentation to ensure adequate information has been provided
~Assess technician’s performance and work to resolve performance inconsistencies
~Monitor systems feedback from customer sites and deliver/schedule services to resolve issues based on the level of service contracted by client.
~Driving continuous improvement of the operation and manage change effectively to form a winning team
~Ensuring employees actively meet and exceed customer requirements, service level agreements and our company goals
~Timely and efficient monitoring of key service delivery metrics and identifying any gaps or process improvement needed for quality metrics
~Ensuring all resources are allocated and managed based on workflow, service level agreements, and quality metrics
~Work with Sales to schedule technicians work load and client commitments
Achievements
• I have been recognized in the Manager's Choice Award - IBM 2016 program for the practice Put the Client First.
• Making a dramatically performance enhancement for the production database and application environments by decrease the utilization for the system with more than 80%.
• Enhance the process for generating and manipulate the 1.5 Million pension ATM/VISA card to be developed in 2 days only .
• Preparation for solid operation documentation .
-Acting as Database architecture manager for new product (ETHIX PLUS) to produce portable database across multiple DB engine (Oracle, Sybase, SQL Server, DB2).
-Involved in designing capacity plans, performance planning & space requirements
-Working on SQL tuning jobs for long-running and resource consuming reports
-Implementing high availability, cluster solution (Oracle RAC, Sybase Cluster) and disaster recovery plans to guarantee fault tolerance performance.
-Implementing Migration process from Sybase and SQL Server databases to Oracle 12c
-Working on comprehensive cost/ benefit analysis & preparation of business cases for new projects
-Participating in employee review & assessment processes
-Rendering process, data & object modeling in application & database environments including database design, development & enhancement. Managing & coordinating changes to existing applications
-Focusing on technical architecture analysis, design, development and enhancement
-Updating on industry leading information management technologies
-Developing costing proposals for projects, performing risk analysis and managing change control
-Involved in business analysis, business area assessment, user needs analysis and business systems design for major projects
Manage three technical sectors (system administration sector, database administration sector and network administration sector) with 10 technical professional DBA's, system administrators, Network administrators and system designers.
Cover more than 80 different sites in Ministry of defence.
Design capacity plan for the IT branches.
Performance planning & Space requirement.
Monitor and tune the database performance on all deferent aspects (OS tuning, Application tuning, Server tuning ...etc).
Extensive SQL tuning jobs for long-running and resource consuming reports.
Install and maintain different type of OS (UNIX, LINUX, and WINDOWS).
Develop health check plan for databases and operating system for each side.
Implement High IT Security standards and Policies using proactive security solutions.
Design high availability, cluster solution and disaster recovery plans for the departments to guarantee fault tolerance performance.
Web based portal services.
Reporting services.
Business Intelligence services.
Bulk loads and data migrations (using SQL*Loader, imp/exp, DataPump).
Administration and configuration of Web Logic Server.
Led a team of 4 technical professional DBA & designers across 4 database types (ORACLE, Sybase, SQL server, DB2)
Worked on bulk loads & data migrations (using SQL*Loader, imp/exp, DataPump)
Implemented & ensured compliance to high IT security standards & policies using proactive security solutions
Designed high availability, cluster solution & disaster recovery plans for the departments to guarantee fault tolerance performance
Focused on fine tuning of database (OS tuning, Application tuning, Server tuning ...etc) including SQL tuning jobs for long-running & resource consuming reports
Coordinated activities related to 3 medium project & 2 large projects
Developed & reviewed data model and application architecture. Rendered technical support to the development team
Defined standards for database, development naming and conventions
Involved in administration & configuration of Oracle Web Logic 11g and Oracle Application server 10g
Migration of Oracle 9i Database to Oracle 11g on AIX Unix on EGYPT POST through IBM Egypt
Application of Oracle Streams for Central Egyptian bank through E-Gabi
Installation of Oracle10g, 11g RAC over 15 times in different sites (UNIX, LINUX and WINDOWS) through multiple companies, Oracle database for multiple UNIX OS (AIX, SUN, HP), LINUX and Windows Server
Set up application tuning & SQL tuning for multiple sites through DMS & E-Gabi, Oracle9i, Oracle10g Data guard for multiple sites
Functioned as consultant for Al Borg Laboratory (Oracle 10g RAC), MISR TRAVEL (Oracle 10g), Middle East Company for Medicine
Developed backup & recovery strategy procedures (using OS scripts & RMAN) for multiple sites
Senior Oracle Developer and Product Leader in Data Management System (DMS)
Senior Oracle Developer and DBA in System Services & Consultancy Company
Developed 1 medium project & 2 large projects through a team of 8 technical professional DBA's and developers
Functioned as database & application designer, application DBA & senior developer using SQL/ PLSQL
Migrated 20+ applications from Oracle Developer 6i to Oracle Developer 10g
Developed & reviewed data model and application architecture
Rendered technical support to the development team
Worked as Oracle Developer involved in analysis & development of corporate database application
Created & maintained database structure for development purpose
Involved in bulk loads & data migrations (using SQL*Loader, imp/exp, DataPump).
Designed high availability, cluster solution & disaster recovery plans for the departments to guarantee fault tolerance performance
Managed database performance on various aspects (OS tuning, Application tuning, Server tuning)
Focused on SQL tuning jobs for long-running and resource consuming reports
Developed & reviewed data model and application architecture
Managed a team of 5 technical developers and DBAs
Functioned as database & application designer, application DBA & senior developer using Developer 2000
Reviewed data model and application architecture. Rendered technical support to the development team
Developed Oracle Applications using Oracle forms, report builder, using oracle designer as a case tool
Involved in analysis, development of corporate database application
Worked on SQL tuning jobs for long-running & resource consuming reports
Developed 3 medium projects, 2 large projects including develop & reviewed data model and application
Assisted in development of geographic information system (GIS) using ESRI ArcInfo software
Rendered support to system/application development & implementation
Involved in creating, publishing & managing ArcInfo Services in a test and production environment
Developed maps using mapping applications. Worked on GIS related tasks using ESRI's tools
Assisted other team members in support of existing GIS applications
Maintained updated knowledge of ArcMap, ArcCatalog and ArcInfo
Developed & published ArcGInfo. Maintained ArcInfo map caches
Worked on AML and avenue scripting