
Sajid Ali Saqfi
Oracle DBA EBusiness Suite Consultant RAC Exadata OCI
Habilidades

Revisa mis servicios

Experiencia laboral
Deputy General Manager Database
Pakistan International Airlines • Tiempo completo
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.
Senior Database Consultant
Freelancer • Trabajador autónomo
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.
Manager Database
Kohinoor Textile Mills Limited, Kohinoor Maple Leaf • Tiempo completo
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.