Saad Lodhi

(MOB) +923********* adi1if@r.postjobfree.com

SUMMARY

With 7+ years of progressive experience currently working as Oracle DBA, Oracle RAC DBA, Oracle EBS 11i/R12 DBA, PeopleSoft DBA, SQL Server, and Applications Server Administrator.

Oracle Consultancy & Oracle Operations on-call 24/7 support, troubleshooting, tuning and maintaining highly available IT infrastructures on various platform environments and a proven track record of working on several variants of UNIX, strong understanding of command-line tools and database technologies such as:

Operating Systems: - Oracle Unbreakable Linux 4.x, 5.x & 6,7, Sun Solaris 9,10,11, Red hat Linux, Windows,

AIX 5L And HP-UX 11.11

High Availability: - Oracle Real Application Clusters 10g/11g/12c Family, Oracle Golden Gate.

Disaster Recovery: - Oracle Data Guard 9i, 10g, 11g, and 12c Family

Databases: - Oracle databases 9i,10g,11g r1 & r2,12c Family.

E-Business Suite: - EBS-11i, EBS-R12

Application Server: - Oracle Weblogic 10g, 11g, IBMWebsphere

Proficient in handling multiple roles independently: Oracle Core DBA, Oracle RAC DBA and Oracle Apps DBA Middleware Administrator with good Unix/Linux Administration skills.

Work Experience

Premier Systems (Pvt) Limited

August-2018 to Date

Sr. Oracle Consultant

EFU Life Assurance

March-2018 to July

Deputy Manager

DB-M/W-App

Synergy Computers (Pvt) Limited

May 2013 – March 2018

Oracle Consultant

OraCITI Institute

March 2011 – April 2013

Computer Lab In-charge

Academic Qualifications

Masters Computer Science (M.C.S) Passing Year 2017 Grade. 2.8 GPA

Bachelor of Commerce (B.com) Passing Year 2007 Grade. 2nd division

Intermediate Computer Science Passing Year 2004 Grade. C

Matriculation Passing Year 2002 Grade. B

Professional Certifications

1. Oracle Database 10g Administrator Certified Associate (OCA)

Oracle Corporation

2. Oracle Database 10g Administrator Certified Professional (OCP)

Oracle Corporation

3. Oracle Database 11g Administrator Certified Professional (OCP)

Oracle Corporation

4. Oracle Cloud Infrastructure Foundations 2020 Certified Associate

Oracle Corporation

5. Oracle Cloud Infrastructure 2019 Certified Architect Associate

Oracle Corporation

6. Oracle Cloud Infrastructure 2019 Certified Architect Professional

Oracle Corporation

7. Oracle Autonomous Database Cloud 2019 Certified Specialist

Oracle Corporation

8. Oracle Exadata Database Machine and Cloud Service 2017 Implementation Essentials.

Oracle Corporation

Training Attended

1. Oracle Database 10g Administration

2. Oracle Database 11g Administration

3. Linux Essentials (RH033)

4. Linux Administration (RH133)

5. Oracle E-Business Suite R12 Applications Database Administration

6. Oracle Business Intelligence 11g Implementation Bootcamp

7. Oracle Solaris 10 Operating System Essentials

8. Oracle Solaris 11 Operating System Essentials

9. VMware vsphere5

10. WebLogic Administration 11g

11. Oracle Golden Gate 12c.

12. OCI

13. Oracle Autonomous Database

14. Oracle Advance Security

Hands-on Experience

Design and Proposing solution to Oracle customers as per their business requirement

Installing and Configuring Oracle Products I.e. Databases, Middle tier, E-Business suite on different Platform

Problem diagnosing/analyzing and fix them

Manage application/software patches (patch set, interim patches, and Critical patches)

Data migration/upgraded from 8i to 9i/10g/11g and from 9i to 10g/11g using different methods.

Tune databases using utlbstat, utlestat (8i), Stats pack (9i) and AWR (10g &11g) reports to maintain performance and find out performance drop causes.

Planning and implementation of Database Backup and Recovery (Cold backup, hot backup, Incremental backup using RMAN, Exp/Imp, Expdp/Impdp, and user manage backup/recovery) approach.

Troubleshooting advance database problems i.e. internal errors, data guard errors.

Providing DB level support to Burj Bank.

Providing DB level support to United Energy Petroleum

Providing Oracle PeopleSoft Database support to Dow Medical collage

Providing Oracle EBS support to Soneri bank

Installed and Configured 10g RAC using a RAW file system on SUN Solaris 10 in Training

Installed and Configured 10g RAC using OCFS2 and ASM file system on Oracle Linux for Pakistan Navy

Installed and Configured 11g RAC using ASM file system on Oracle Linux in the Production environment for DIB

Configured and Implemented Oracle data guard 10g using manual and data guard Broker method with

Fast-start failover and observer (in 10g) options for around five customers.

Configured 11g Active Data Guard for Burj Bank and two other customers

Configured and Implemented Oracle data guard 11g for UAT environment with advanced option i.e. active data guard, compression, and snapshot database.

Have used advanced database option i.e. RMAN encrypted backup.

Technical assistance for tuning, Backup & Recovery issues.

Good knowledge of Oracle Golden Gate 11g.

Oracle Enterprise Manager cloud control 12c, and 13c.

WebLogic Server 11g

VMware VSphere

Oracle Exadata x2 Database administration at EFU General Insurance.

Prepare S.L.A for customers as per their needs.

Prepare R.F.P to participate in new project leads.

Interact with customers and principles for smooth support.

Install and Configure SQL Server Database.

Install and Configure My SQL Database.

Jboss EAS installation and configuration and provide support.

Oracle Projects Deployment/Implementation

1.Atlas Asset Management - Oracle Database 10 Migration from Linux 4.7 32-bit to Linux 5.6 64-bit

2.Sanofi Aventis – Oracle Database 9i upgrade 11gR2

3. Karachi Gym Khana - Oracle Real Application Cluster 10g Configured on Linux 5.4 64-bit

4. Burj Bank - Configured Oracle Physical Standby Data Guard 11gR2 on Linux 5.8

5. United Energy Petroleum - Oracle Database 10g Migration from Windows Server 2003 to Linux 5.8 64-bit

6. Soneri Bank – Oracle-E-Business Suite Administration, Migration (Datacenter migration)

7. ISL/IIL - Oracle E-Business Suite Administration, Migration RHEL Linux 4.7 32-bit to OEL Linux 5.8 64-bit

8. Dubai Islamic Bank – 11g RAC (Real Application Cluster) on Linux 6.

10. Dubai Islamic Bank SAS AML (Anti Money Laundry) system deployment with SAS Team.

11. Database 11gr1 upgrade to 11gr2 at E.O.B.I.

12. Performance tuning of Oracle APEX.

13. Resident Eng. for Flex cube application and middleware at HBL.

14. Prepare database data analysis and reports.

15. Provide Analytics reports.

16. Migration from Oracle Exadata x2 Database 11g to Oracle Database Appliance 12c (ODA)

17. Deployed Oracle Engineered System Supercluster M-8 at the Ministry of Defense Pakistan.

18. Oracle Engineered System Exadata v2 Migrate Database 11.2.0.3 to Oracle

Engineered System Exadata x7-2 production and D.R site in U Micro Finance Bank.

19. Deployed Oracle audit vault and database firewall in U Micro Finance Bank.

20. Deploy Transparent data encryption in U Micro Finance Bank.

21. Deplay TLS security for oracle database 11g and 12c at bank islami

22. Deply Oracle Transparent data encryption at bank islami.

Personal Biodata

Father’s Name Raffat Mohiuddin khan Lodhi

Marital Status Married

Date of Birth 29 Jun 1984

Present Address House# r7, row3 block e N.C.E.H Society Gulshan e Iqbal block 10 a

Current Location Karachi - Pakistan

Nationality Pakistani

Notice Period/Joining 1 Month

Total Years of Experience 7+ Years

Relevant Experience 7 Years

Skype I. D csaad.khan

Official Notice period 1 Month

Contact number +923*********

Contact this candidate