Home

About Me

Technically-sophisticated professional with extensive experience in updating server security, executing routine back-ups, and designing and implementing tests of the system to address issues with accessing data

Adept at leading the planning, designing, developing, testing, and deploying efficient solutions within Oracle EBS system, in order to satisfy strategic, financial, and operations needs of the organization.
Skilled in planning and managing successful projects, mitigating risks, controlling costs, and directing project teams. Instrumental in monitoring routine maintenance of system, implementing the ERP systems, and approving budget.
Proven success in analyzing business processes/process re-engineering and recommending solutions. Deft at establishing IT service continuity management strategies, disaster recovery plans and associated test procedures of each critical functional area of the organization.

Age: 37
Residence: Pakistan
Freelance: Available
Address: Karachi, PAKISTAN

My Services

Oracle E-Business Suite Upgrade

Oracle E-Business Suite Migration

Oracle Database Upgrade or Migrate

Oracle Maximum Availability Architecture

Performance Evaluation

Pricing

Hire Me On Upwork

$ 35 Hour

Database Administration
Oracle E-Business Suite Administration
Configuration, Administration, Cloning, Patching, Migrating, Support, Maintenance, Monitoring, tuning and capacity planning, User Management, Backup/Recovery Management

Order Now

Hire Me on Fiverr

$ 35 Hour

Database Administration
Oracle E-Business Suite Administration
Configuration, Administration, Cloning, Patching, Migrating, Support, Maintenance, Monitoring, tuning and capacity planning, User Management, Backup/Recovery Management

Order Now

Hire Team

$ 40 Hour

Database Administration
Oracle E-Business Suite Administration
Configuration, Administration, Cloning, Patching, Migrating, Support, Maintenance, Monitoring, tuning and capacity planning, User Management, Backup/Recovery Management

Order Now

Resume

Experience

2024-

Senior Apps DBA

Private Contractor

My role includes infrastructure support, capacity planning, installation, configuration, database design, and migration, up gradation, performance monitoring, security, database backups, data recovery plan, and procedures including application server administration

2022- 2024

Senior Apps DBA

Computer & Systems Engineering Company

My role includes infrastructure support, capacity planning, installation, configuration, database design, and migration, up gradation, performance monitoring, security, database backups, data recovery plan, and procedures including application server administration

2020-2021

Lead Infrastructure Consultant

ITANZ Group

Managed Oracle cloud infrastructure, compute, storage, networking, connectivity, and edge service, database management, analytics, integration, and Oracle weblogic clustering environment over Oracle Cloud IAAS. Collaborated with the Oracle corporation staff for offering technical support to diagnose and troubleshoot common problems.

2020 - 2022

Professional Freelancer

Upwork Inc.

Collaborated with Clients for the Task Related to Oracle Database, Oracle E-Business Suite, Oracle Cloud Infrastructure, Oracle Weblogic

2015-2020

Assistant Director (Databases)

Pakistan Civil Aviation Authority

Managed ERP for implementing the structures effectively, while limiting the resources consumed in the planning process. Improved IT/business processes and investigations to resolve the user’s issues as well as offered user’s training to help the user in operating the system in efficient way.

Education

2008 - 2011

Newports Institute Of Communication & Economics

Pakistan

Newports Institute Of Communication & Economics offers a B.S. in Computer Science.

Certificate

2013

Oracle University

USA

Oracle E-Business Suite R12 Financials Certified Expert Consultant, PAYABLES

Certificate

2013

Oracle University

USA

Oracle E-Business Suite R12 Financials Certified Expert Consultant, PAYABLES

Certificate

2014

Oracle University

USA

Oracle E-Business Suite R12 Applications Database Administrator Certified Professional

Certificate

Skills

Oracle Expertise

Oracle Databases
Oracle E-Business Suite
Oracle Weblogic
Oracle Cloud Infrastructure
Oracle Database Appliances

Languages

English

System

Linux

90%
Microsoft

75%
SOLARIS

65%
AIX

60%

Knowledge

Installation/Configuration
Capacity Planning
Data Recovery Plan
Oracle Database Migration and Upgrade
Oracle ERP Migration and Upgrade
Linux and Windows management
Performance Evaluation

Works

Projects

Oracle Cloud Infrastructure Projects

Content

Oracle E-Business Suite Upgrade Project

Blog

August 2, 2017 Query to Monitor RMAN Backups

AppsDBA ScriptsDatabase ScriptsScripts

SELECT Count(*)
FROM v$backup_async_io
WHERE status = ‘IN PROGRESS’;

(more…)

August 2, 2017 Query to Check Oracle Database Growth

AppsDBA ScriptsDatabase ScriptsScripts

This Query Calculate the Datafile Growth on a Yearly Basis

(more…)

August 1, 2017 Find the Org and Organization mappings

AppsDBA ScriptsScripts

SELECT

ood.organization_code Warehouse_code,

ood.organization_name Warehouse,

ood.operating_unit OU_ID,

hou.name OU_Name,

hle.name Legal_entity,

hle.set_of_books_id,

gsob.name SOB

FROM

org_organization_definitions ood,

hr_operating_units hou,

hr_legal_entities hle,

gl_sets_of_books gsob

WHERE

ood.operating_unit = hou.organization_id

AND hou.legal_entity_id = hle.organization_id

AND gsob.set_of_books_id = hle.set_of_books_id

August 1, 2017 How to add System administrator responsibility from backend

APPS DBAAppsDBA ScriptsOracle APPS DBAScripts

Syntax:

fnd_user_pkg.addresp(username => v_user_name
,resp_app => ‘SYSADMIN’
,resp_key => ‘SYSTEM_ADMINISTRATOR’
,security_group => ‘STANDARD’
,description => ‘Auto Assignment’
,start_date => SYSDATE – 10
,end_date => SYSDATE + 1000);

Usage:

BEGIN

fnd_user_pkg.addresp (‘OPERATIONS’,’SYSADMIN’,’SYSTEM_ADMINISTRATOR’,’STANDARD’,

‘Add Sysadmin Responsibility to OPERATIONS user using pl/sql’, SYSDATE, SYSDATE + 100);

COMMIT;

DBMS_OUTPUT.put_line (‘Responsibility Added Successfully’);

EXCEPTION

WHEN OTHERS

THEN

DBMS_OUTPUT.put_line ( ‘ Responsibility is not added due to ‘ || SQLCODE || SUBSTR (SQLERRM, 1, 100));

ROLLBACK;

END;

August 1, 2017 How Extract the trace file of a concurrent program

APPS DBAInstallations/Configurations-ApplicationsOracle APPS DBA

Step 1. Setup the profile value at user level with the following value

Profile name: “Initialization SQL Statement – Custom”

User: [%User Name from which Concurrent program Runs%]

Profile value:

BEGIN FND_CTL.FND_SESS_CTL(”,”,’TRUE’,’TRUE’,”,’ALTER SESSION SET TRACEFILE_IDENTIFIER = abc MAX_DUMP_FILE_SIZE = 5000000 EVENTS =’||””||’ 10046 TRACE NAME CONTEXT FOREVER, LEVEL 12’||””);END;

Step 2. Find out where the trace file resides in the DB.

Goto Help -> Diagnosics -> Trace.

enable trace.

popup will show the server path where the trace will get create. Usually .trc file will get created in DB server.

The file path may be say “/u01/app/oracle/admin/prod/udump/PROD_ora_15698_abc.trc”.

the path will be stored along with the trc file name. Usually the value in the profile value TRACEFILE_IDENTIFIER=AKONDURU is used in the trace file naming

Step 3. Now we have enabled trace for your user.

Step 4. Login to the DB server. extract the file and convert to readable format.

Go to the following path in the DB server -> ‘/u01/app/oracle/admin/PROD/udump/’. Now, You have to convert it (tkprof) to make it readable. Use the following command to do so.

tkprof (input).trc output.txt EXPLAIN=()

where input.trc is the trace file and output.txt is in readable format

Step 5. After you get the trace file. make sure to remove the profile value that you have set for the profile : “Initialization SQL Statement – Custom”.

August 1, 2017 EBS 12.2.4 application tier autoconfig fails with following error

APPS DBAErrors/Workarounds-ApplicationsOracle APPS DBA

ERROR

Oracle EBS 12.2.4 application tier autoconfig fails with following error.
(more…)

Contact

Get in Touch

Address: Karachi, PAKISTAN
Email: askme@SyedSaadAli.com
Phone: +92-300-026-5668
Freelance: Available

Contact Form