s
saqfi5555

Sajid Ali Saqfi

@saqfi5555

Oracle DBA EBusiness Suite Consultant RAC Exadata OCI

Pakistan
Inglese
Alcune informazioni sono riportate in lingua inglese.
Chi sono
Oracle Apps & Database consultant with 17+ years of hands-on experience running production Oracle E-Business Suite (R12.1/R12.2), RAC, Exadata, Data Guard and GoldenGate environments. I help companies with EBS installation, upgrades, patching, cloning, performance tuning, backup and recovery, security hardening and migration to Oracle Cloud (OCI). Oracle Cloud Infrastructure certified; currently leading Oracle ERP infrastructure at a national airline. Message me with your environment details before ordering and I’ll recommend the right approach.... Continua a leggere

Competenze

s
saqfi5555
Sajid Ali Saqfi
offline • 
Tempo di risposta medio: 1 ora

Consulta i miei servizi

Amministrazione database (DBA)
I will tune and troubleshoot your oracle database performance

Esperienza lavorativa

Pakistan_International Airlines

Deputy General Manager Database

Pakistan International Airlines • Full time

Dec 2019 - Present • 6 yrs 11 mos

Technical lead for Oracle ERP (E-Business Suite 12.2.5, multi-node) running on Exadata X5-2 and Exalogic X5-2 at the national airline. I lead the infrastructure and database work that keeps business-critical ERP systems available, fast and secure. Key responsibilities: - Administer Oracle RAC databases, Oracle WebLogic and multi-node EBS application tiers - Install, configure and manage Oracle Data Guard for disaster recovery - Set up Oracle Secure Backup and manage backup and recovery strategy - Administer Oracle Linux Virtualization Manager (OLVM) for compute, networking and storage provisioning - Configure SSL/TLS and manage certificate creation, installation and renewal - Implement Oracle security controls to reduce vulnerabilities and the risk of internal and external attacks - Technical lead for migrating ERP from Exadata/Exalogic to Oracle Cloud, including pre-migration planning, cloud strategy and migration strategy - Oracle licensing strategy and optimization: assess license usage across Enterprise Edition, RAC and Exadata, identify consolidation opportunities and avoid over- or under-licensing - Conduct Oracle EBS post-implementation reviews covering business blueprint, data migration, authorization and segregation of duties (SoD), and general IT controls Tools and technologies: Oracle Database 12c/19c, Oracle EBS 12.2, RAC, ASM, Data Guard, RMAN, Oracle Enterprise Manager (OEM), WebLogic, OLVM, Oracle Linux, SQL, PL/SQL, shell scripting. Focus areas: high availability, performance, security and minimal downtime.

Freelancer

Senior Database Consultant

Freelancer • Lavoratore autonomo

Mar 2020 - May 2024 • 4 yrs 2 mos

Provided remote Oracle E-Business Suite and database consulting to international clients, including production support for a microfinance bank running EBS 12.2.8. Key responsibilities: - Provided production support for Oracle EBS 12.2.8 modules: Payables (AP), Receivables (AR), General Ledger (GL), Cash Management (CM), Inventory (INV), Purchasing (PO), Fixed Assets (FA), Order Management (OM) and ASCP - Installed Oracle EBS R12.2.0 and upgraded the environment to 12.2.8 - Applied patches using online patching (adop), including RUP, AD/TXK and Opatch updates - Cloned production to create test and development environments - Troubleshot application and database issues and tuned performance using AWR and ADDM reports - Implemented security DBA controls and supported audit compliance requirements - Documented changes and delivered clear handover notes to client teams Tools and technologies: Oracle EBS R12.2, Oracle Database 11g/12c, RMAN, Oracle Enterprise Manager, SQL, PL/SQL, Oracle Linux. Delivered reliable remote support, working across time zones with the client's finance and IT teams.

Kohinoor_Textile Mills Limited, Kohinoor Maple Leaf

Manager Database

Kohinoor Textile Mills Limited, Kohinoor Maple Leaf • Full time

May 2015 - Apr 2020 • 4 yrs 11 mos

DBA and technical lead for Oracle Financials and Enterprise Asset Management (eAM) implementation at a large cement manufacturer, responsible for all Oracle databases and the E-Business Suite environment. Key responsibilities: - Led the upgrade of Oracle EBS from 12.1.3 to 12.2.7, then to 12.2.9, as the sole technical resource - Migrated the EBS system from 32-bit to 64-bit - Installed and administered EBS 12.1.3 with Oracle 11g, and EBS 12.2.8 with Oracle 12c - Implemented Oracle 11g Active Data Guard and Oracle GoldenGate 12c - Designed and ran backup and recovery using RMAN, including tape backups (Symantec Backup Exec and tape library) - Created and maintained development, test and production databases - Performed capacity planning, tablespace and disk management - Cloned production to test and development environments - Performed application and database performance tuning - Monitored systems with Oracle Enterprise Manager (OEM) and Oracle Applications Manager (OAM) - Implemented database security and managed user privileges - Virtualized servers using VMware ESXi - Controlled migration of code, database changes and menu changes through the development lifecycle - Developed reports for the Oracle Financials cycle - Provided technical and functional support through Oracle Support (SRs) Tools and technologies: Oracle EBS 12.1.3/12.2.x, Oracle 11g/12c, Data Guard, GoldenGate, RMAN, OEM, OAM, VMware ESXi, SQL, PL/SQL.