IT Infrastructure Manager
Jadwa Investment
Total years of experience :25 years, 3 Months
Enterprise Infrastructure, Project management, IT Systems Management, change management, team building, mentoring and coaching managing high-end projects and providing high tech infrastructure solutions.
Responsibilities:
• Responsible for administering organizational infrastructure as well as IT Systems, and BSD.
• Spearheaded the facility operations management for IT Systems to support company technology roadmap.
• Developing processes to ensure that infrastructure is configured and managed in a manner that is robust and stable at all times to ascertain high level of service availability/quality.
• Directing IT projects, delineating project objectives, establishing milestones, monitoring adherence to master plans/schedules, as well as identifying and allocating resources to ensure project completion as per established plans.
• Planning, organizing and managing the team and overall operations to ensure stable organizational IT infrastructure, including developing, maintaining and supporting Oracle Databases, Applications and E-Business Suite ERP environment; in addition to the Unix and Linux solutions.
• Overseeing the operations of IT Systems and Production environment, ensuring regular system checks and preventive maintenance to ensure optimum system performance.
• Coordinating with all IT sections to meet client requirements in the minimal coast and optimal quality.
• Assign resources and contract vendors for IT projects and support services.
• Review contracts and Licenses scheme and provide less-cost alternatives.
• Explore different Business Continuity Plans with IT Disaster Recovery Services for the business departments and top management.
• Recruiting staff and proffering technical trainings and workshops for new/less experienced employees.
Key Projects:
• IT Infrastructure Optimization
• E-Forms Workflow System
• EBS Leave Management System
• Assets Management System
• Wealth Management (CRM)
• Wealth Management Consolidated Client Statement
Providing the core Oracle DBA and Applications DBA technical expertise by managing a 24 x 7 customer operations that support the Saudi, GCC, and International Stock Market. Contribute to the instance provisioning, architecting, reviewing of change requests (including configuration changes, patch management, proactive and preventive maintenance), technical delivery of upgrades and technical assistance to team members.
Responsibilities:
• Performs patching/fixing, upgrading services for customers when needed
• Sustained upgrading of technical and professional skills
• Develops written materials, reference guides and manuals on complex technical subjects to create a Hosting Knowledge based
• Independently engages and communicates with Customer or Oracle Contacts
• Analyzes systemic problems and defining technical solutions for hosted services
• Performs Solution Validation Analysis
Key Projects:
Maintain more than 18 oracle instances clustered over 7 servers from different platform (HP superdome 11.23, and HP Blade Linux Redhat4) that supports the trading activity of Saudi and GCC market in addition to the International Stock market. Managing 400 GB database in a native Oracle environment using latest technology such as Automatic Storage Management (ASM), Oracle Clusterware (CRS); integrated with HP Data Protector Backup management tool. 10gR2 Databases are the backend for the Tradenet application running on 6 Oracle Application Servers.
Nevertheless, for the internal Corporate Finance and HR, responsible for an ERP application distributed over 3 Oracle E-Business Suite Servers.
Performing several database administrations and re-engineering functions, developing technical solutions to business problems using ample performance tuning expertise.
Responsibilities:
- Design and Implement High Availability Oracle database solutions
- Install and configure Oracle Real Application Clustered solutions
- Upgrade Oracle database from 9i single Instance to 10g RAC multi-instances
- Tuning the performance of Oracle database to enhance the response
Key Projects:
- Design and Implement High Availability Oracle 10g RAC clustered solution in Al-Noor Hospital, Upgrade Existing single-instance Oracle 9i database to Oracle 10g Rel.2 RAC clustered and migrate the database to the new oracle version over HP-UX Itanium platform. Reconfigure the client-server application to utilize the RAC features such as Load balancing and Connection Failover by enable the TAF techniques to meet business objectives.
- Contracting with HP to Audit and Evaluate SABIC Oracle Database accessed by SAP ERP application to find out the bottlenecks of customer database that causes performance slowness or any security holes that may available for any threats to assure the customer business continuity. Auditing database also analyze the resources consumption, usage, and utilization.
Applies a very high degree of expertise and specialized knowledge of Very Large Database (VLDB) management techniques which facilitate and expedite the usability, consistency, accuracy, integrity, security, timeliness and availability of telecom data regardless of environment or platform.
Responsibilities:
- Managing 3.2 TB RAC Clustered Database on SUN 15k servers
- Maintaining more than 2000 partitions contains more than 5 billion records
- Tuning the queries hitting the database to assure the fast access in sub-sec
- Uploading several hundred millions records daily using different fast techniques
- Maintaining partitioned indexes and rebuilding them online in parallel, periodically
- Integrating with other heterogeneous databases like DB2, Informix, and Teradata
- Writing Shell and PL/SQL Scripts to automate some database jobs like Partitions recycling (drop the old unusable partitions and create new set of them), Gathering Statistics for the stale objects statistics, and Archiving old data in different Tablespaces.
Key Projects:
- Building the Operational Data Store (ODS) environment part of the Enterprise Data Integration (EDI) for the STC Company that stores the main components of the Telecom Business functions including Calls Details Records (CDR) for GSM and Land Line, Billing Information and Prepaid Tracking (Sawa) from different sources like ICMS, CompTel, Doc1 and PPAS systems. ODS provides online data for several business units in STC like Fraud Management System, Revenue Assurance, Customer Relation Management (CRM), Data Warehouse, Corporate Web Site, and MyLink. ODS had been implemented using the latest Oracle database technologies like External Tables, Bulk Collect, Change Data Capture (CDC), Direct Upload, Tables and Indexes Partitioning, Oracle Enterprise Manager, and Load Balancing over the RAC Clustered Nodes
- Administering the pre-paid to pre-paid Sawa Balance Transfer (P2P) RAC clustered database running on SUN 25k servers
Responsibilities:
- Completing functional requirements of data models and database designs, estimating work and producing related documentation.
- Building system architecture, conducting performance optimization and configuration management routines. Providing consultations to external associates, recommending system & process improvements.
- Installing and maintaining the full package of ORACLE Applications 11i with a multi-tier server’s architecture. Creating database instances and migrating data from different repository files.
- Managing a 24*7 operational support model around HP UNIX systems and clustered servers. Analyzing and resolving problems associated with server hardware and applications software.
- Performing upgrades, staging and stress testing, backup and contingency recovery planning.
Key Projects:
- Assigned by HP to configure Oracle 9i for the Ministry of Hajj. Successfully mounted the database on MC-ServiceGuard clustering software and conveyed application support expertise to the client.
- Completed an effective failover process installing Oracle FailSafe engine, configured Oracle & MS SQL 2000 instances to serve several applications running in Jeddah Girls Education Center.
- Rendered expert DBA services migrating existing architecture to Sun Spark and Oracle 9i for Al-Alamiah Bab Al-Umra.
- Challenged to install IBM products on HP-UX, developed systemized nodes for DB2, resolved character conversion issues and incorporated an IBM application within a record time of 8 days.
- Planned and executed the migration of a repository to a clustered solution on Mid Range HP 9000 for Al-Noor Hospital with zero deficiencies.
- Controlled central operations, replicating data from 25 remote database servers, ensured high availability and provided technical support.
Committed to a principal Oracle DBA role, applied efficient practices to administer information security, data integrity and optimal performance over Windows 2000 and HP UX 11.00 platforms.
Responsibilities:
- Interfaced with users to identify data requirements, collection and access rules. Architected system interactions and supported Oracle products.
- Proved extensive knowledge of data modeling, SQL and UNIX scripting, worked with application code and tested Transact-SQL queries.
- Handled Oracle 11i deployments from start-to-finish. Prepared mount points, invoked shell automotive scripts, resolved conflicts and eliminated configuration errors.
- Expertly migrated MS SQL 2000 Databases to Oracle solving data-types variations and unformatted character conversions within limited timeframes.
- Developed specifications to install upgraded instances of database and safeguard older versions avoiding conflicts in port connections. Followed best practices and documented guidelines for maneuvering live systems.
- Executed troubleshooting and batch processing enhancements. Accountable for backup and recovery planning.
Systems Development:
Worked with a team accountable for custom development, interfaces and conversions on Oracle implementations. Rolled-out a Help Desk Application with complete workflow processes, and Book Keeping Stores System.
- Responsible for designing and writing components for system conversions including: extraction, transformation, and loading of data between legacy systems and Oracle, archiving and producing reporting programs.
- Liable for testing and debugging all functional modules, adhering to quality criteria and ensuring smooth transition to production environment.
- Rendered professional technical support to clients, shared knowledge and field experience to provide them with a shorter learning curve in supporting applied systems.
Imparted knowledge on Oracle Application Developer 2000 and Oracle 8.x Database Administration as an instructor in the Learning Center at New Horizons.
- Led workshops on Database design and implementation including file processing and search methods.
- Delivered a comprehensive curriculum with the objective of empowering students preparing for certification exams.
- Introduced basic concepts in Oracle data organizing and information processing and presented methods and practices of a professional programmer.
Managed the physical development and data modeling of software applications on Oracle Developer 2000 versions: 5.5, 6, and 6i.
- Established systems logical design including database scheme, wrote components, user interfaces and debugged fully programmed modules using PL/SQL scripting code by developing an airline application for the Civil Aviation Authority.
- Successfully completed assignments within defined functionality, assumed the responsibility of deployments to production systems ensuring proper security and user accessibility restrictions where followed.
Completed 3 Oracle certifications: - May 2001: OCP Oracle 8i Database Administrator (DBA) - Jan 2001: OCP Internet Application Developer Rel. 6/6i - Jan 2001: OCP Application Developer Rel. 2
PROFESSIONAL TRAINING: - HP-UX MC/ServiceGuard Cluster Manager - Oracle 10g SQL Tuning - Oracle 10g Real Application Cluster (RAC) - HP-UX System/Network Administration - Oracle Database Administration - Oracle Supervision - Oracle Developer/2000 Reports 2.5 - Oracle Developer/2000 Forms I 5 Rel. 2.1 - Oracle Developer/2000 Forms II 5 Rel. 2.1 - SQL and PL/SQL - Advanced Course In Visual Basic 6.0 - UNIX Sun Solaris (Administration) - UNIX Sun Solaris (Commands) - C and C++ - Windows NT 4.0 Administration - Essential Networking