Resume

Sign in

Customer Service Manager

Location:
Riyadh, Riyadh Province, Saudi Arabia
Posted:
January 03, 2018

Contact this candidate

Organization

Royal Cyber – KSA.

Lead Oracle Applications DBA- Solution Architect, Riyadh,

Saudi Arabia. (Transferable Iqama)

Summary

Having 13+ 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.

Having knowledge on business processes from a number of different areas such as telecom, banking, hospitality and financial services.

Coordinating 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.

Controls the information technology systems to meet the user requirements. Estimates the cost of systems and prepares the cost benefit analyses. Provided training to the various clients and users based on their system requirements.

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.

Performed backup and recovery of OCR disks, manually or auto backup, exporting OCR, recovering OCR from exports.

Implemented backup and recovery of Voting disk, adding and removing voting disks.

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.

Performed System Administrator tasks like-

Creating Application users, Monitoring users, Application Module profile settings, custom profile settings, core activities of concurrent manager issues, printer setup.

Well versed with all advanced features of Oracle including RAC, GoldenGate, Replication Tools and Data Guard. Knowledge of DB Tools/Utilities (e.g., Toad, Enterprise Manager, Utilities, SQL Developer).

Manage Oracle RAC database configurations utilizing GoldenGate and Data Guard to ensure maximum availability and data protection

Install, configure and support uni-directional and bi-directional Oracle-to-Oracle replicated environments utilizing GoldenGate.

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.

Responsible for all aspects of Oracle database administration, security and data modeling as well as database development.

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). Setting the environment for RAC database cloning, multimode to single node and single node to multi node.

Architected and 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.

Installed operating systems in the networked mode with ip address, subnet and DHCP. Worked with TCP/IP applications like ping, telnet, ftp, rcp and rsh.

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.

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.

Configured RAID levels using Solaris volume manager and secure shell (SSH). Monitoring 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.

Monitoring the Apache log files, concurrent manager log files, patch log files for application related issues.

Core knowledge in IBM DB2, MS SQL administration.

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 (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

Implementing Oracle eBusiness Suite R11i and R12

Implementing 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, winscp, ws-ftp32 and Sanovy.

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

ALAWWAL BANK (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: 4 months (with pending CRs probably extending it further)

The project is ongoing, and from a milestones point-of-view, UAT has been completed on time and preparation for PROD is ongoing.

Estimates the cost of systems and prepares the cost benefit analyses.

Responsible for all aspects of Oracle database administration, security and data modeling as well as database development.

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.

Designed solutions included with oracle E- business suite for managing complex networks. Maintenance of objects, worker status through adadmin & adctrl utilities.

Performed System Administrator tasks like-

Creating Application users, Monitoring users, Application Module profile settings, custom profile settings, core activities of concurrent manager issues, printer setup.

Controlled and coordinated changes to the production/development/testing databases.

Monitored database and application performance, space management, and database optimization techniques

National Insurance Company (HCL Technologies) RIYADH

Implementation of Core HR and Payroll Management (R12.2.5).

Upgrade 11.5.10.2 to 12.2.5 on

Real Application Cluster environ-

ment.

Role: Lead Consultant, Solution Architect.

Team Size: 30

Applications Version: 12.1.3 & 12.2.5

Database Version: 11gR2 & 12c

Database Size: 1TB

Database tier Operating System: IBM AIX 5.3

Application tier Operating System: IBM AIX 5.3

Customer Staff size: Around 5000

Project duration: 14 months

Customer went live on time for this short, 14 months long project despite their complex requirements.

Upgraded the E-Business suite from 12.1.3 to 12.2.5 Applied HRMS patches on application node.

Development of a performance management solution using the standard product.

Managing the second phase of the implementation of National Insurance Company

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 5000

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. Multi node to single node.

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.

Implemented the cluster ware and grid infrastructure management tools like CRSCTL, CRS_STAT, OCRCHECK, OCRCONFIG and CLUVFY.

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.

Communicated with Oracle functional and technical team regarding SR related activities.

Time management, strategic thinking, planning, budgeting, forecasting, people management, problem solving, decision making, and innovation Development of a performance management solution using the standard product.

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, 7 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.

Controls the information technology systems to meet the user requirements

Estimates the cost of systems and prepares the cost benefit analyses.

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.

Managing the second phase of the implementation of MTC Vodafone.

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.

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

Installation of E-Business suite R12.0.4 with Database 10.2.0.3.

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 workers status using adctrl utility. Created Clone Applications as a User Trail Application testing and Training.

Customize the system according to the user requirements. Without violating the Oracle application standards.

Interaction with Oracle Developers to assist them in annual Reports format. Communicated with Oracle financial and technical team for technical issues.

CBI (Central Bank of India) – TCS (Mumbai)

Implementation of Core HR and Payroll Oracle Applications 11.5.10. 2.

DBA support for Oracle Apps production instance, E-Business implementation was in CBI sector with Database Size of 700GB+.

Role: Senior Consultant

Team Size: 7

Applications Version: 11.5.10.2

Database Version: 10.2.0.2

Database Size: 700 GB

Database tier Operating System: Solaris

Application tier Operating System: Solaris

Customer Staff size: Around 1000

Creating Application users, Monitoring users. Relinking of application modules through adrelink utility.

Responsible for all aspects of Oracle database administration, security and data modeling as well as database development.

Setup the database functional specifications address the business requirements and comply with architectural & technical constraints.

Maintaining the instances with AD utilities like adadmin, adpatch, adctrl and adclone

Resolve the password related issues for application – database gateway user using .dbc file

Installed high availability of connections with Transparent Application Failover (TAF) and Fast Connect Failover (FAN).

Setting the environment for RAC database cloning, multimode to single node and single node to multi node.

Design and developed suitable standby database data guard technique for oracle RAC database.

Performed autoconfig Utility in the Apps Environment. Cloned applications – to generate year end reports. Interaction with Oracle Developers to assist them in annual Reports format.

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.

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

Applied patches using ADPATCH. Performed database and application cloning of production database on TEST environment to provide users the live data for testing purpose.

Maintenance of workers 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.

Create and assign the responsibilities to users

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.

Monitoring the alert log files for database related issues

TCS Apps COE, TCS (MUMBAI)

supported oracle apps 11.5.10.2 instance for TCS Centre of Excellence Implementation of 11i to R12

Role: Senior Consultant

Oracle Applications Version: 11.5.10.2 (Multi Node) R12

Number of Active Users: 150

Database Version: 9.2.0.6

Database Size: 400 GB

Database tier Operating System: Sun Solaris

Jinitiator: 1.3.1.21

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. Multi node to single node.

Compile the jsp pages using context file in application tier. Upgraded the file system as per the user requirement.

Communicated with Oracle functional and technical team regarding SR related activities.

Maintaining the instances with AD utilities like adadmin and adctrl.

Development of a performance management solution using the standard product.

Professional Experience

Working as Senior Oracle Applications DBA at Royal Cyber since April 2017 to till date.

Worked as a Solution Architect at Rimini Street Inc. since Feb 2013 to March 2016.

Worked as a Lead Consultant/DBA manager at HCL Technologies since Aug 2010 to Dec 2012.

Worked as Senior Consultant at Satyam Computer Services from Jan 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

Masters Degree in Computer Applications (MCA) from Kakatiya University, INDIA

Bachelors 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)

00-966-*********

ac3wbu@r.postjobfree.com



Contact this candidate