Software Engineer – Oracle PL/SQL Developer
Accelya Airline Platform | Dec 2024 – Present
Project Context & Business Impact: Pioneered Accelya’s Airline-First Software Platform, trusted by 200+ global carriers—including Emirates, United Airlines, Swiss International Air Lines, Finnair, Virgin Atlantic, SAS, Flydubai, and Aeroméxico—to streamline end-to-end cargo operations and drive revenue growth through modular systems like SkyChain and Offer & Order.
Agile Delivery & Change Management: Handled 25+ Change Requests (CRs) and defect fixes within Agile sprints, coordinating across teams to ensure on-time delivery and zero post-deployment failures across TF, UAT, TRG, and PROD environments.
Security & Compliance (SSO/MFA): Engineered database-level Single Sign-On (SSO) and Multi-Factor Authentication (MFA) using schema objects, triggers, and PL/SQL modules; implemented fine-grained access control (FGAC) with VPD/DBMS_RLS to enforce dynamic row-level security and regulatory compliance.
PL/SQL Development & Modularization: Revamped 40+ parametrized, autonomous, and layered PL/SQL Packages, Procedures, and Functions with overloading, encapsulation, and PRAGMAs, delivering reusable, maintainable, and high-performance database solutions. Implemented Dynamic SQL using EXECUTE IMMEDIATE with bind variables to enable runtime handling of unknown tables and operations.
Performance Optimization & SQL Tuning: Spearheaded query and PL/SQL optimization using ASH, AWR, ADDM, and performance views (V$SESSION, V$SQL, V$LOCK), achieving 30–40% faster execution and resolving session/contention issues for high-volume workloads. Minimized SQL-PL/SQL context switching using BULK COLLECT, FORALL, and Global Temporary Tables (GTTs) for efficient batch processing.
ETL, Reporting & Data Handling: Accelerated data retrieval and reporting with Materialized Views (MViews) and Pipelined Table Functions; designed robust ETL pipelines using SQL*Loader, External Tables, and UTL_FILE for fast bulk loads, flat file processing, and error-free exports.
Automation & Job Scheduling: Orchestrated enterprise-level workflows using DBMS_SCHEDULER and Cron jobs, automating 90% of recurring tasks to reduce manual intervention and ensure consistent execution of critical system processes.
Audit & Trigger Management: Developed Audit, Security, Compound, and Instead-of triggers using PRAGMA AUTONOMOUS_TRANSACTION to ensure tamper-proof DML logging, enforce access control, and resolve mutating table issues, safeguarding transactional integrity.
Top comments (0)