Customer Service Manager
Resume:
Organization
King Saud Medical City – KSA.
Lead Oracle Applications DBA- Solution Architect, Riyadh,
Saudi Arabia. (Transferable Iqama)
Summary
Having 15+ years of experience in ORACLE E-Business Suite – 11.5.10.2/12.0.6/12.1.3/12.2.2/12.2.5 environment Database version - 9.2.0.6/10.2.0.3/10.2.0.4/11.2.0.4/12.1.0.2 on Solaris, Linux and windows platform.
Worked as a solution architect, an oracle E-business suite database administrator and a trainer.
As a Lead DBA communicated with Client/pre-sales department regarding daily and weekly planning. Proficiency in analysis, design, development, testing, documentation and implementation of business applications and database.
Experienced in designing appropriate database models, constructs and feeds for multiple processes such as real-time pricing information, holdings, trade details, performance data and other market data.
Managed day to day activities and overall architecture of the entire database infrastructure environment: capacity planning, configuration and integration of several database and components to be managed with OEM 12c vendors’ products and technologies.
Monitored database and application performance, space management, and database optimization techniques. Implemented the cluster ware and grid infrastructure management tools like CRSCTL, CRS_STAT, OCRCHECK, OCRCONFIG and CLUVFY.
Designed solutions included with oracle E- business suite for managing complex networks. Configured private and public network architecture for oracle R12 implementation.
Led regular global team and stakeholder meetings to discuss and prioritize necessary enhancements to database environment and resolve issues such as security and proper use of database accounts and data by implementing separation of duties.
Provided detailed documentation of DBA procedures/operations, including a DBA run book focused primarily on DBA routine functions for proactively maintaining the corporate databases.
Well versed with all advanced features of Oracle including RAC, High availability, Replication Tools and Data Guard. Responsible for all aspects of Oracle database administration, security and data modeling as well as database development.
Extensive experience with Oracle Advanced Security Options like Oracle Database TS Encryption, DB column level Encryption, Data masking and strong authentication.
Troubleshooting OCR disk, voting disk and handling failed missing or offline cluster ware resources. Handled node reboots issue, hardware, storage and network problems. Performed backups with import/export tools, data pump, using RMAN scripts.
Having knowledge on business processes from a number of different areas such as telecom, banking, hospitality and financial services.
Coordinated with DBA, technical and functional team regarding Implementation plan. As per the Client requirement analyzed the Operating System compatibilities, hardware and oracle database pre-requisites.
Setup the database functional specifications address the business requirements and comply with architectural & technical constraints.
Interacted with other groups such as the development team, marketing team, customer service executive on new database designs and modifications to existing applications.
Installed high availability of connections with Transparent Application Failover (TAF) and Fast Connect Failover (FAN). Automated the environment for RAC database cloning, multimode to single node and single node to multi node.
Developed, planned, and coordinated disaster recovery testing for multiple applications. Implemented Goldengate replication to ensure high availability. Experienced in Security Administration and Space Management.
Design and developed suitable standby database data guard technique for oracle RAC database, Patching cluster ware and oracle server software. Performed the different types of patching mechanism before and after applying the patches.
Created oracle 11gR2 cluster databases in ASM. Upgraded RAC software, RDBMS software and oracle database from 10g to 11g.
Developed security procedures, including access control and user management. Verified oracle database consistency and replication of databases. Controlled and coordinated changes to the production/development/testing databases.
Implemented trust relationship at user and server levels. Performed hardware analysis (CPU/memory), I/O tuning at file system level, operating system tuning, application tuning and kernel tuning
Implement Oracle Advance Collections implementations project and provided all infrastructure support for Oracle Apps R12. Configured RAID levels using Solaris volume manager and secure shell (SSH). Monitored alert and trace files for oracle database troubleshooting result cache.
Communicated with Oracle financial and technical team for flex field issues like key flex filed, descriptive flex fields problems, compilation of flex fileds, issues regarding flex field tables like flex_id_flexes.
Monitored the Apache log files, concurrent manager log files, patch log files for application related issues.
Having Excellent Communication, Analytical, Interpersonal and Presentation skills.
Core Competencies
Industry competencies
Financial Services (QIT, QATAR PETROLIUM)
Telecom (STC, TELENOR, ZAIN MTC, VODAFONE)
Banking (CBI, SBI, ALAWWAL)
Automotive (ZOUJAJ)
Hospitality (KING SAUD MEDICAL CITY, SAUDI GERMAN HOSPITALS)
Others (TOYS R US, FORMFACTOR, APPLIED MATERIALS, VALSPAR, BLOOM ENERGY, TRANSGRID, NCH CORPORATION, SAFENET, INC, GENESIS, HEALTH CARE SYSTEMS)
Product competencies
Extensive knowledge of Core HR, Payroll, Self-Service, Discoverer and Performance Management
Process Competencies
Oracle E-Business Suite R11i and R12.
Oracle Database 9i, 10g and 11gR2, (RAC and Non RAC) environment.
Management of Technology
Organizational Change
Business Processes and strategy
Technologies and Methods
Tools
Oracle Applications Manager (OAM), putty and winscp
Programming Languages and Operating Systems
Pl/sql
Windows, Linux, Solaris and AIX.
Methods & Utilities
OUI, Rapidwiz, Rapid Clone, AD Utilities like adpatch, adctrl and adconfig.
Project Experience
Project/Role
Achievements
KING SAUD MEDICAL CITY (RIYADH)
Implementation of AP and PO (R12.1.3).
DB 12.1.0.2, EBS R12.1.3
Role: Lead DBA, Solution Architect.
Team Size: 6
Applications Version: 12.1.3
Database Version: 11gR2 & 12C
Database tier Operating System:
Windows 2008 R2
Application tier Operating System: Windows 2008 R2
Customer Staff size: Around 1000
Project duration: 16 months
Responsible for all aspects of Oracle database administration, security and data modeling as well as database development. Implemented Oracle Advance Collections implementations project and provided all infrastructure support for Oracle Apps R12.
Setup the database functional specifications address the business requirements and comply with architectural & technical constraints.
Interacted with other groups such as the development team, marketing team executive on new database designs and modifications to existing applications.
Managed day to day activities and overall architecture of the entire database infrastructure environment: capacity planning, configuration and integration of several database and components to be managed with OEM 12c vendors’ products and technologies.
Controlled and coordinated changes to the production/development/testing databases.
Monitored database and application performance, space management, and database optimization techniques
Performed Autoconfig Utility in the Apps Environment. Applied the Opatch at database server. Configured RAID levels using Solaris volume manager and secure shell (SSH). Monitored alert and trace files for oracle database troubleshooting result cache.
ALAWWAL BANK (RIYADH)
Implementation of Core HR and Payroll Management (R12.1.3).
Upgrade 11.5.10.2 to 12.1.3 on
Real Application Cluster environ-
ment.
Role: Lead Consultant, Solution Architect.
Team Size: 7
Applications Version: 11.5.10.2 & 12.1.3
Database Version: 11gR2
Database Size: 1TB
Database tier Operating System: IBM AIX 5.3
Application tier Operating System: IBM AIX 5.3
Customer Staff size: Around 1000
Project duration: 14 months
Customer went live on time for this short, 14 months long project despite their complex requirements. Led regular global team and stakeholder meetings to discuss and prioritize necessary enhancements to database environment and resolve issues such as security and proper use of database accounts and data by implementing separation of duties.
Upgraded the E-Business suite from 11.5.10.2 to 12.1.3 Applied HRMS patches on application node. Development of a performance management solution using the standard product.
Involved in the preparation and presentation of proposals Coordinating with DBA, technical and functional team regarding Implementation plan.
As per the Client requirement analyzed the Operating System compatibilities, hardware and oracle E-business pre-requisites. Controlled and coordinated changes to the production/development/testing databases.
Implemented trust relationship at user and server levels.
Performed hardware analysis (CPU/memory), I/O tuning at file system level, operating system tuning, application tuning and kernel tuning.
Interacted with other groups such as the development team, marketing team, customer service, executive on new database designs and modifications to existing applications. Developed and implemented security procedures, including access control and user management.
Qinvest Bank - Qatar
( HCL Technologies)
Oracle E-Business suite implementation 12.0.0/12.0.6 and 12.1.3 at Qinvest.
Role: Lead Consultant
Team Size: 10
Applications Version: 12.1.1& 12.1.3
Database Version: 10.2.0.4
Database Size: 2 TB
Database tier Operating System: Solaris 10
Application tier Operating System: Solaris 10
Customer Staff size: Around 2000
Interacted with other groups such as the development team, marketing team, customer service, executive on new database designs and modifications to existing applications. Developed and implemented security procedures, including access control and user management.
Verified oracle database consistency and replication of databases. Cloned the system as per the user requirement.
As a Lead DBA communicated with Client/pre-sales department regarding daily and weekly planning. Proficiency in analysis, design, development, testing, documentation and implementation of business applications and database.
Created oracle 11gR2 cluster databases in ASM. Upgraded RAC software, RDBMS software and oracle database from 10g to 11g.
Developed security procedures, including access control and user management. Verified oracle database consistency and replication of databases. Controlled and coordinated changes to the production/development/testing databases.
Implemented trust relationship at user and server levels. Performed hardware analysis (CPU/memory), I/O tuning at file system level, operating system tuning, application tuning and kernel tuning
Chamber of Commerce – Saudi Arabia
Oracle E-Business suite implementation 12.1.3 at Chamber of Commerce.
Role: Lead Consultant
Team Size: 15
Applications Version: 12.1.3
Database Version: 10.2.0.4
Database Size: 800 GB
Database tier Operating System: Solaris 10
Application tier Operating System: Solaris 10
Customer Staff size: Around 500
Customer went live on time for this short, 11 months long project despite their complex requirements.
Implemented E-Business suite R12.0.6 with Database 10.2.0.3. (Multi node Installation).
Implemented Discoverer setup using BI software
Content server setup on oracle 10giAS (10.1.3)
As per the Client requirement analyzed the Operating System compatibilities, hardware and oracle E-business pre-requisites.
Implemented trust relationship at user and server levels.
Performed hardware analysis (CPU/memory), I/O tuning at file system level, operating system tuning, application tuning and kernel tuning.
Performed hardware analysis (CPU/memory), I/O tuning at file system level, operating system tuning, application tuning and kernel tuning. Configured RAID levels using Solaris volume manager and secure shell (SSH).
Monitoring alert and trace files for oracle database troubleshooting result cache.
Designed solutions included with oracle E- business suite for managing complex networks. Configured private and public network architecture for oracle R12 implementation. Maintenance of objects, worker status through adadmin & adctrl utilities.
Provided training to the various clients and users based on their system requirements. Responsible for all aspects of Oracle database administration, security and data modeling as well as database development.
MTC Vodafone Project – Satyam Computer Services Ltd. Kenya
Oracle Database implementation 10.2.0.4 at MTC.
Role: Senior Consultant
Team Size: 50
Applications Version: 12.0.6
Database Version: 10.2.0.4
Database Size: 2 TB
Database tier Operating System: Solaris 10
Application tier Operating System: Solaris 10
Customer Staff size: Around 5000
Upgraded Database from 9i (9.2.0.6) to 10g (10.2.0.2) and applied interoperability patches for (AOL – Application Object Library).
Developed and implemented security procedures, including access control and user management. Verified oracle database consistency and replication of databases. Controlled and coordinated changes to the production/development/testing databases.
Performed Autoconfig Utility in the Apps Environment. Applied the Opatch at database environment. Provided detailed documentation of DBA procedures/operations, including a DBA run book focused primarily on DBA routine functions for proactively maintaining the corporate databases.
Well versed with all advanced features of Oracle including RAC, High availability, Replication Tools and Data Guard. Responsible for all aspects of Oracle database administration, security and data modeling as well as database development.
As per the Client requirement analyzed the Operating System compatibilities, hardware and oracle E-business pre-requisites.
Provided detailed documentation of DBA procedures/operations, including a DBA run book focused primarily on DBA routine functions for proactively maintaining the corporate databases.
National Factory for Glass Bottles – Zoujaj
Satyam Computer Services Ltd.
Saudi Arabia - Riyadh
Oracle E-Business suite implementation was in NFGB sector with Database Size of 800GB+ with RAID 5.
Role: Senior Consultant
Team Size: 7
Applications Version: 12.0.6
Database Version: 10.2.0.4
Database Size: 800 GB
Database tier Operating System: Linux
Application tier Operating System: Linux
Customer Staff size: Around 500
Upgraded the E-Business suite from 12.0.4 to 12.0.6. Applied HRMS patches on application node. Applied Saudi legislation patches on development and vision instances.
Interacted with other groups such as the development team, marketing team, customer service, executive on new database designs and modifications to existing applications. Developed and implemented security procedures, including access control and user management.
Relinking of application modules through adrelink utility Set the environment for Arabic Language support (Multi Language support architecture). Applied patches using adpatch utility. Maintenance of objects using adadmin utility. Maintenance of worker’s status using adctrl utility. Created Clone Applications as a User Trail Application testing and Training.
Interaction with Oracle Developers to assist them in annual Reports format. Communicated with Oracle financial and technical team for technical issues.
Applications and PMO (CBI)
TCS (Mumbai)
Role: Senior Consultant
Oracle Applications Version: 11.5.10.2
Number of Active Users: 1500
Database Version: 9.2.0.6
Database Size: 400GB+
Database tier Operating System: Linux 4.0E
Application tier Operating System: Linux 4.0E
Jinitiator: 1.3.1.21
JDK: jdk1.4
Created oracle 11gR2 cluster databases in ASM. Upgraded RAC software, RDBMS software and oracle database from 10g to 11g.
Developed security procedures, including access control and user management. Verified oracle database consistency and replication of databases. Controlled and coordinated changes to the production/ development /testing databases.
Maintenance of worker’s status using adctrl utility. Maintaining the instances with AD utilities like adadmin, adpatch, adctrl and adclone
Coordinating with DBA, technical and functional team regarding Implementation plan. As per the Client requirement analyzed the Operating System compatibilities, hardware and oracle E-business pre-requisites.
Performed Single Node, Multi node cloning (Multi to single node) activities by using Apps_tier and appl_top merge options
Developed and implemented security procedures, including access control and user management. Verified oracle database consistency and replication of databases. Controlled and coordinated changes to the production/development/testing databases.
Relinking of application modules through adrelink utility. Troubleshooting of corrupted/missing files like .fmx, conflict resolution problems – FNDCRM, recreation of appsutil dir.
Implement Oracle Advance Collections implementations project and provided all infrastructure support for Oracle Apps 11i. Configured RAID levels using Solaris volume manager and secure shell (SSH). Monitored alert and trace files for oracle database troubleshooting result cache. Monitoring the alert log files for database related issues
Professional Experience
Working as Lead Oracle Applications DBA at Ebttikar Technology Company Ltd. since February 2018 to till date.
Worked as Lead Oracle Applications DBA at E-Business Solutions Ltd. since January 2016 to January 2018.
Worked as a Solution Architect at Rimini Street Inc. since February 2013 to December 2015.
Worked as a Lead Consultant/DBA manager at HCL Technologies since August 2010 to December 2012.
Worked as Senior Consultant at Satyam Computer Services from January 2008 to July 2010.
Worked as Senior Consultant at Tata Consultancy Services (TCS) from November 2003 to December 2007.
Personal
Languages
Urdu: Fluent (mother tongue)
English: Fluent including business and negotiation
Arabic: Medium
Education
Master’s Degree in Computer Applications (MCA) from Kakatiya University, INDIA
Bachelor’s Degree in Computer Applications (BCA) – 2003 from Kakatiya University, INDIA
Personal
Indian
Marital status: Married
Interests: Meeting People, Technology and computers, traveling and sightseeing and reading.
Contact details
Riyadh, Saudi Arabia. (Transferable Iqama)
*******@*****.***
Curriculum Vitae
Mohammed Adil Ahmed
Email: *******@*****.***
Phone: 00-966-*********
595037697
Contact this candidate