Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

Syed Saad Ali

Oracle ACE Pro

Oracle Solution Architect

Oracle E-Business Suite

Oracle Cloud Infrastructure

Oracle Fusion Middleware

Oracle Database Administration

Oracle Weblogic Administration

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: 36
  • 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
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
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

Resume

Resume
Experience
Senior Apps DBA
2022- Present
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
Lead Infrastructure Consultant
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.
Professional Freelancer
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
Assistant Director (Databases)
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
Newports Institute Of Communication & Economics
2008 - 2011
Newports Institute Of Communication & Economics
Pakistan

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

Certificate
Oracle University
2013
Oracle University
USA

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

Certificate
Oracle University
2014
Oracle University
USA

Oracle E-Business Suite R12 Applications Database Administrator Certified Professional 

Certificate
Oracle University
2011
Oracle University
USA

Oracle Database 11g 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

Blog

July 23, 2018 JSP error Request URI:/OA_HTML/RF.jsp java.lang.NoClassDefFoundError
APPS DBAErrors/Workarounds-ApplicationsOracle APPS DBA

ERROR

JSP Error:
Request URI:/OA_HTML/RF.jsp
Exception:
java.lang.NoClassDefFoundError

JSP Error:
Request URI:/OA_HTML/AppsLocalLogin.jsp
Exception:
java.lang.NoClassDefFoundError

(more…)

December 1, 2017 Enabling About This Page Link in Oracle Apps R12
APPS DBAInstallations/Configurations-Applications

Enabling About This Page Link in Oracle Apps R12

If You need to Enable About This Page Link in Oracle Apps, you need to set the following Profile Options from System Administrator Responsibility

  • Personalize Self-Service Defn = YES
  • FND: Personalization Region Link Enabled = YES
  • Disable Self-Service Personal = NO (Only at Site)
  • FND: Diagnostics = Yes

Note: These Profile Options can be set on Site Level or User Level.

 

 

 

December 1, 2017 How to View Concurrent Request Output on Browser
APPS DBAInstallations/Configurations-Applications

How to View Concurrent Request Output on Browser

Step 1. Go To System Administrator Responsibility select Profile>System

 

 

Step 2. Search the Profile option ‘Viewer:%’ 

 

Step 3. Set the profile Viewer: Application for Text to Browser at Site Level.

 

 

 

 

December 1, 2017 ORA-20002: Version of statistics table APPLSYS.FND_STATTAB is too old
Errors/Workarounds10gErrors/Workarounds11gErrors/Workarounds12cOracle Database Material

ERROR

ORA-20002: Version of statistics table APPLSYS.FND_STATTAB is too old

(more…)

December 1, 2017 ORA-12899: value too large for column “APPLSYS”.”FND_PROFILE_OPTION_VALUES”.”PROFILE_OPTION_VALUE”
APPS DBAErrors/Workarounds-Applications

ERROR

ORA-12899: value too large for column “APPLSYS”.”FND_PROFILE_OPTION_VALUES”.”PROFILE_OPTION_VALUE”

(more…)

December 1, 2017 Useful Commands For Unix Operating System
APPS DBAInstallation/Configurations10gInstallation/Configurations11gInstallation/Configurations12c

Useful Commands For Unix Operating System

 

1.Deleting files older than N number of days ?

find . -name ‘*.trc’ -mtime +[N in days]  -exec rm {} \;  
Command will delete files older then N days in that directory

 

2.Copying file keeping timestamp preserve

cp -ip file.txt file_txt_bkp

 

3.Listing files modified in last N days

find . -mtime -<ndays> -exec ls -lt {} \;

 

4.Sorting files based on Size of file ? 

ls -l | sort -nrk 5  | more
du -sm *|sort -nr|head -10 

 

5.Finding CPU & Memory detail 

->cat /proc/cpuinfo  (CPU)
->cat /proc/meminfo (Memory)
->topas

 

6.Finding if any service is listening on particular port or not ?

netstat -an | grep {port no}  

 

7.Finding Process ID (PID) associated with any port ?

lsof | grep {port no.}  
lsof should be installed and in path.Many times it will be installed eith root user.Make sure you have that permission

 

9.Finding a pattern in some file in a directory ?

grep pattern  file_name  ( find pattern in particular file )
grep -i pattern  file_name (find pattern ignoring the case)

 

10.Create symbolic link to a file ?

ln -s  pointing_to_original_file  symbolic_link_name

example
 ln -s /home/text.txt test.txt

 

11.History of command executed in UNIX 

fc -l 
fc -e – ls ( Would execute the last ls command.) 
History command will also do the same
history

 

12. Compressing a big file

zip -r new.zip new
or
compress file_name

 

13.Creating a tar file

tar -cvwf file.tar file.txt

 

14.Extracting the files from a tar file

tar -xvwf myfile.tar(System would unarchive (untar) the myfile.tar file into the current directory.)
tar -xvwzf myfile.tar.gz(System would unarchive (untar) the myfile.tar.gz file in the current directory.)

 

14.Extracting a gz file?

Use guzip command as follows:
gunzip file.gz
OR
gzip -d file.gz

 

15.Extract a tar.gz or .tgz file?

Files with extension tar.gz or .tgz are tar files compressed with gzip. On Unix system extract them with following command:
gunzip < file.tar.gz | tar xvf –
gunzip < file.tgz | tar xvf –

If you have GNU tar (Linux system) you can use the z option directly:
tar xvzf file.tar.gz
tar xvzf file.tgz

 

16.Using mailx command

echo “This is going to be body of the mail” |mailx -s “Subject:Testing” “false@gmail.com”

 

17.Checking the file system free and used space

df -gt 

 

 

Contact

Get in Touch
  • Address: Karachi, PAKISTAN
  • Email: askme@SyedSaadAli.com
  • Phone: +92-300-026-5668
  • Freelance: Available
Contact Form