Omar AlJohar

Senior Manager IT Operations, The Saudi British Bank (HSBC), Riyadh, Saudi Arabia Mar 2015 - Present
Inducted as TADAWUL & Tivoli Systems Administrator, crafted an upward growth curve to merit promotion to the position of Senior Manager IT Operations.

Designation Chronology:
 Mar 2015 - Present: Senior Manager IT Operations
 Aug 2014 - Mar2015: Acting Sr. Manager Technical Services
 Jan 2010 - Aug 2014: Database Administration Manager
 Mar 2009 - Jan 2010: Asst. Database Administration Manager
 Apr 2006 - Mar 2009: Senior Oracle Database Administrator
 Oct 2002 - Apr 2006: TADAWUL & Tivoli Systems Administrator

Responsible on different teams that mange, lead and control bank infrastructure such as Middleware, Storage, IBM iSeries and Database Services.

Key Responsibilities -Database Administration Manager:
• Providing administrative, technical and people leadership for multiple, diverse projects and supporting enterprise systems infrastructure including SAS products, database infrastructure and oracle application servers (Oracle Middleware Fusion).
• Managing the database administrators team, 24x7 availability of mission critical databases in Production environments and helping achieve a state-of-the-art environment that meets current and future business objectives.
• Providing technical support for the enterprise database environment including setting up infrastructure strategies, technology policies, introducing best practices and preventing business impacting outages.
• Offering strategic inputs in evergreening projects for database infrastructure, Oracle Application server and SAS Products and implementing new technologies for improved availability and performance.
• Overseeing the whole gamut of activities including licensing, agreements and contracts as well as management of SLA's, evergreening, re-engineering, capacity planning, vendor risk management for Oracle, DB2, MS SQL, Sybase and SAS.
• Understanding database structures, theories, and practices, to include Installation, configuration, upgrades and migration whilst constantly optimizing performance and maximizing investment in IT.
• Managing PCI points and audit points related to database platforms and deploying transparent database encryption (TDE) against Oracle and MS Sql 2008.

Key Responsibilities -Database Administration Manager:- Continued:
• Deploying Oracle 11gR2 infrastructure including 8 RAC and 8 single nodes in linux platforms (redhat and SUSE). Upgrading Oracle databases to 11gR2 databases in existing AIX infrastructures for mission critical services.
• Supporting upgrades for DB2 databases from db2 v9.1 to db2 v9.5 and db2 v9.7, Oracle Application Servers 10gR1 and 10gR2 to Oracle Middleware Fusion 11gR2 and engineering critical patch update (CPU) and patchsets against Oracle and fix packs against db2 and service pack against MS SQL. Built patches sheet for bugs.
• Increasing high availability of Call Center service by re-engineering the DB2 database infrastructure by separating the infrastructure of Central province and eastern province call centers.
• Migrating Oracle, db2, MS Sql databases to consolidated environments to reduce the cost and administration complexity as well as shifting databases from old Clarion SAN (Thik LUNS) to new VMAX SAN (Thin LUNS).
• Ensuring high availability and resilience solution for database platforms with RAC, HACMP for DB2, Data Guard, SAN Replication and migrating databases from MS SQL2005 to MS SQL 2008.
• Providing a full range of data management and analytical services including database design & build, analysis & insight and campaign production/management.

Key Projects to Credit:
• Evergreening Project
• Built new infrastructures for Oracle, DB2, MS SQL Server and Sybase
• Sarie DRC implementation, installing Sybase Replication Server and DRC server, Setting up Sybase replication, encrypting the link, etc
• Up-gradation of SAS Server and SAS BASE from 9.1 to 9.3 and SAS EG from 4.1 to 4.3 (client based to be packaged and pushed through SMS software distribution)
• Call Center high availability project
• Database storage migration from SAN to another SAN.
• Implementation of SAS Enterprise Miner

Key Responsibilities as Asst. Database Administration Manager:
• Managed (onshore and offshore) Oracle, db2 and MS Sql DBA's for all assigned projects.
• Oversaw the platform, day to day requests, long term projects, and strategy for Oracle, DB2and MS SQL DBA's and recommended most efficient ways for database design and usage.
• Incorporated enhancements in existing systems by analyzing/ identifying areas for modification by automating and controlling procedures using Grid control, shell scripts for housekeeping, corrective action, healthcheck, maintenance, etc.
• Served as focal point for managing the backup and recovery for production and UAT environments including backup and recovery policy setting, automation scripts, documentation, restoration test in test server.
• Developed methodology for the ongoing assessment of database performance through BMC Patrol, Quest tools or Grid Control for effective monitoring and proactive action.
• Managed infrastructure design and implementation for consolidation and high availability solutions to increase the reliability and availability and to reduce the cost and administration complexity.
• Liaised vertically and horizontally with varied technical resources to formulate a concise and effective techno- managerial support infrastructure.
• Researched/ analyzed latest technological advancements and used the potentials of the same for responding to special needs of the organization.

Key Project To Credit:
• Implemented Oracle Maximum Availability Architecture (MAA) for Internet Banking (Sabbnet) database infrastructure ( RAC-RAC with Veritas Cluster FileSystems in Solaris SPARC platform using Data Guard.

Key Responsibilities as Senior Oracle Database Administrator:
• Oversaw all aspects of data storage, maintenance, access and security, consolidated the database with different Oracle versions (8i, 9i, 10g) to various Oracle 10gR2 RAC’s or Single node database environments running on AIX.
• Executed new Oracle RAC and Standalone infrastructures for various projects like Open2 (ATM System), Tadawul, Takaful, etc
• Fine-tuned database and system attributes to ensure maximum performance, scalability & high-availability by standardized backup policy to use hot RMAN Backup across all Bank’s Oracle installations.
• Configured Oracle 10gR2 Enterprise Manager Grid Control to use it for administration, monitoring, corrective action, jobs scheduling and automation in addition to administering Oracle data guard in DRC for high-availability.
• Deployed, operated, managed Oracle databases (8i/9i/10g) and Application Servers (9i/10gR1/10gR2) and directed patches, administration in development, test and production environments.
• Performed tuning for Oracle databases like index re-creation, table rebuild, index rebuild, stored outlines creation for execution plan stability, SGA resizing, PGA resetting, Undo/rollback segments, redo logs size, etc. utilizingOEM (Oracle Enterprise Manager), StatsPack, AWR, ADDM, etc for performance tuning
• Managed testing plan for Oracle-SAN Replication and developed disaster recovery solutions using data guard and SAN replication.
• Directed Tadawul Historical database Project and developed shell scripts for jobs automation, operational menu, backup, SQL-Loader, etc.

Projects to Credit:
• TADAWUL DB Project (OracleRAC 10g/AIX)
• Compliance DB Project (Oracle10g/Solaris)
• Open2 DB Project (OracleRAC 10g/AIX)
• Multiple RAC Consolidated envs (OracleRAC 10g/AIX)
• Multiple Single Node Consolidated envs. (Oracle10g/AIX)
• Oracle Disaster Recovery Project using SAN Replication (for all environments)
• User Acceptance Test (UAT), stress test, production: Open2, Takaful, IPO, CAMP, GHRS, SISL, Charge Back

Key Responsibilities as TADAWUL & Tivoli Systems Administrator:
• Performed system administration tasks including monitoring, maintenance, performance optimization, troubleshooting and production support for TADAWUL projects and Tivoli System.
• Managed all phases of project life cycle, liaising with project/core team leads and other key development partners to synchronize planning across design, development, testing, implementation, and post-production support.
• Assured performance and integration with other systems, designed backup and recovery scripts including scripts in RMAN, user management, daily hot backup and weekly cold backup, storage management, and automation process.
• Providing technical leadership for TADAWUL System including Oracle database, Oracle application server and HP-UX OS and tuned production and development environment utilizing OEM (Oracle Enterprise Manager), StatsPack, Utlbstat.sql/Utlestat.sql, TKPROF, etc.
• Monitored temporary segments, Index reorganization in Oracle 8i/9i, build & released of schemas, maintained the database changes and extended my support to production DBA team during the rollout of change requests and rebuilding indexes for defragmentation and managing log files by adding new log files or increasing their sizes.
• Administered TADAWUL FIX Engines like Message engine, Market data feed, MQ, etc and managed Patchset and patches against Oracle 8i and 9i.
• Implementation of Tivoli Project, performed the DB2 health check and capacity planning in Tivoli and Installed agents on targets for Tivoli monitoring.
• Implementation of Tivoli Project, performed the health check and capacity planning in Tivoli and Installed agents on targets for Tivoli monitoring.

Key Projects to Credit:
• TADAWUL System
• Implementation of Tivoli Project
• Tadawul Infrastructure Reengineering
• Tadawul Database Server Migration from Win to HP-UX
• Tadawul Application Server Migration from Win to HP-UX
• Tadawul FIX Engines from Win to HP-UX
• LoadRunner - an automated performance and testing product for examining system performance while generating actual load