Oracle PL/SQL & Database Performance Architect

RAKESH IMMANUEL TAMIL SELVAN

TECHNOLOGY LEAD

Irving, TX 75039 945-***-**** ***************@*****.*** PROFESSIONAL SUMMARY

Accomplished ETL, ELT, Oracle PL/SQL Lead and Database Architect with over 17 years of expertise in designing, developing, and optimizing mission-critical, high- volume transactional database architectures for enterprise leaders including Honeywell, Epsilon, and Infosys.

Core Strength & Expertise:

Advanced specialist in Oracle SQL & PL/SQL engineering, specializing in complex stored procedures, packages, triggers, dynamic SQL, and high-impact performance tuning. Proven track record of diagnosing bottlenecks and optimizing complex queries using AWR, Explain Plan, and TKPROF to dramatically reduce latency and ensure system scalability.

Technical Lead: Expertly integrates backend database logic with robust ETL/ELT pipelines, utilizing tools like Fivetran HVR (CDC) and SSIS. Proficient across diverse database landscapes (PostgreSQL, T-SQL). Adept at automating complex database workflows via Python and Shell Scripting while maintaining rigorous SIT/UAT governance and 100% data integrity.

SKILLS

Core Competencies

Languages & Tools: SQL, PL SQL, T-SQL, Shell Scripting, Python, JIRA, GIT, Bitbucket

Databases: Oracle (Expert PL/SQL), SQL Server, PostgreSQL (Basics).

ETL/ELT & Replication: HVR Fivetran (CDC), Talend, Unix Shell Scripting, SSIS.

Performance Tuning: Partitioning, AWR, EXPLAIN PLAN, SQL Trace, Optimizer Hints.

Orchestration & Automation: Digdag, Python, Embulk (Basics). TOOLS

Tools & Platforms

Database & Development Tools: TOAD, SQL Developer, PgAdmin 4, SSMS, SQL Navigator

ETL, ELT & CDC Integration: Talend, HVR Fivetran, Embulk.

Scripting & Terminal Utilities: Putty, Super Putty, WinSCP, FileZilla, Win Merge

Version Control & DevOps: Microsoft VSS, GIT, Bitbucket, Azure

Project & Agile Management: JIRA, MS Office

BI & Visualization: Power BI, Tableau

WORK HISTORY

Technology Lead, 09/2025 - Current

Infosys Limited – Richardson, TX

Client - Verizon

High-Performance Backend Architecture: Architected mission-critical PL/SQL frameworks for real-time payment processing, utilizing advanced optimization techniques such as BULK COLLECT with dynamic LIMIT clauses and FORALL binding to ingest and validate high-velocity data streams from Fivetran HVR staging tables, achieving sub-second transactional latency.

Scalable Memory & Collection Management: Developed modular, enterprise- grade PL/SQL packages leveraging Nested Tables and Associative Arrays (INDEX BY PLS_INTEGER) to handle complex, multi-tier financial data transformations, significantly reducing context-switching overhead between the SQL and PL/SQL engines.

Complex Parsing & Transactional Logic: Engineered high-complexity PL/SQL stored procedures and packages to parse, validate, and transform raw payments data; designed robust transactional controls and autonomous logging mechanisms to guarantee 100% data fidelity for mission-critical financial calculations.

Bi-Directional Sync & Replication Governance: Co-architected a high- complexity, bi-directional data flow using Fivetran HVR between SQL Server and Oracle RDS; authored custom database triggers and PL/SQL conflict-resolution logic to ensure real-time data consistency and manage a dual-active "Keep-Alive" database strategy.

Multi-Stage ETL/ELT Pipeline Engineering: Designed an integrated data pipeline using Talend to ingest raw financial data from disparate flat files into Oracle staging schemas, subsequently utilizing PL/SQL processing layers to refine and automatically push synchronized datasets downstream into PostgreSQL databases for reporting.

High-Volume CDC Optimization: Fine-tuned database structures, partitioning strategies, and indexing methodologies within the Oracle landscape to handle massive Change Data Capture (CDC) workloads generated by HVR hubs across Dev, QA, and Production environments.

Data Integrity & Validation Frameworks: Programmed automated PL/SQL verification scripts and reconciliation packages to cross-validate data integrity between Oracle and PostgreSQL, streamlining System Integration Testing (SIT) and User Acceptance Testing (UAT) during major enterprise database migrations. Database Developer, 01/2025 - 09/2025

Epsilon – Irving, TX

Client - Nissan

Complex Analytical SQL Engineering: Authored highly complex, multi-stage SQL queries leveraging advanced analytical tools—including Window Functions

(PARTITION BY, LEAD/LAG, RANK), Common Table Expressions (CTEs), and complex hierarchical joins—to slice and dice over 15 years of historical customer data spanning vehicle sales, service histories, active loans, and lease agreements.

Targeted Marketing Audience Segmentation: Translated intricate corporate business rules into robust SQL logic to segment millions of customer records into high-yielding target audiences. Delivered precise, clean data outputs tailored for Nissan's seasonal marketing campaigns (Winter, Spring, Summer, and Fall), directly driving dealership engagement.

Unix Shell Scripting & ETL Pipeline Ingestion: Developed a suite of enterprise-grade Unix Shell Scripts (bash/ksh) to automate the extraction and loading of incoming customer datasets into Linux-based target structures (Stage, Raw, and Transactional tables), serving as the core engine for daily data ingestion.

Query Performance Tuning & Optimization: Deeply analyzed query execution plans, optimized indexing strategies (Bitmap, B-Tree, and Function-Based), and refactored resource-heavy SQL blocks to maintain high-speed performance and sub-minute execution times during daily high-volume data refreshes.

PII Security & Privacy Engineering: Built data-masking and hashing logic directly into data-delivery SQL views to safeguard Personally Identifiable Information (PII), ensuring that all customer data outputs shared with marketing teams complied strictly with data privacy governance policies.

Automated Pipeline Monitoring & Shell Triage: Formulated shell scripts with built-in error handling, automated log file parsing, and system alert loops to proactively monitor daily data health and accelerate defect resolution during high- volume data load failures.

Light Orchestration (Embulk & Digdag): Configured and maintained lightweight Embulk plugins for bulk data transfers parallelized alongside the core SQL pipelines, utilizing Digdag to orchestrate and track basic execution schedules on Linux.

Senior IT Architect / Senior Oracle PL SQL Lead, 05/2015 - 11/2024 Honeywell – Bangalore

Client: Honeywell

Aerospace DB Data Modeling: Led the architectural design of mission-critical financial applications, creating specialized data models to track and analyze complex project costs, including Material, Labor, Non-Labor, and Travel expenses.

Performance Engineering / SQL Optimization : Optimized performance for report generation modules involving TBs of data using advanced techniques such as Table Partitioning, Materialized Views, AWR analysis, and Debugging/Tuning via TkProf and Explain Plan.

Advanced Oracle PL/SQL Engineering: Developed robust, reusable packages, functions, and stored procedures for high-volume transactional systems using Bulk Collect, FORALL, Analytic Functions, and advanced collection types like Nested Tables and Varrays.

Agile Leadership: Served as Scrum Master, facilitating ceremonies (Sprint Planning, Daily Stand-ups, Retrospectives), managing the product backlog, and breaking project epics into implementable user stories.

DevOps & Standardization: Implemented CI/CD practices for database deployments and standardized processes, including PL/SQL coding standards, migration checklists, and naming conventions to improve delivery velocity.

System Integrity: Applied dimensional modeling and database normalization techniques to support scalable data warehouse solutions while ensuring 100% compliance with security protocols and governance standards. Senior Application Engineer, 08/2014 - 04/2015

Manpower Services India Pvt. Ltd (Honeywell On Contract) – Bangalore

Designed and optimized PL/SQL procedures and functions to support Java- based applications with efficient data access and business logic execution.

Created robust SQL queries and views for seamless integration with Java services, ensuring consistent data retrieval and performance.

Collaborated with Java developers to define database interfaces, troubleshoot query performance, and align PL/SQL logic with application workflows.

Implemented exception handling and dynamic SQL in PL/SQL to support flexible, parameterized operations triggered by Java components.

Supported backend development by tuning SQL queries and PL/SQL blocks used in JDBC calls, improving response times and reducing load on the database. Senior Developer, 05/2009 - 07/2014

New age Software Solutions Pvt. Ltd. – Chennai

Developed and maintained PL/SQL procedures, functions, and triggers to support Oracle Forms-based ERP modules across finance, HR, and supply chain domains.

Integrated SQL queries and PL/SQL logic with Oracle Forms for seamless data validation, form-level processing, and dynamic user interactions.

Tuned backend SQL and PL/SQL code to improve performance of Oracle Forms screens, reducing load times and enhancing user experience.

Collaborated with functional teams to translate ERP requirements into efficient PL/SQL routines and reusable database components.

Supported ERP customizations and enhancements by extending Oracle Forms with PL/SQL-driven business rules and data workflows. EDUCATION

Bachelor of Engineering: Information Technology, 12/2008 Karunya Institute of Technology - India

Higher Secondary School: High School, 03/2003

St. Peter's Higher Secondary School - India

Secondary School: Middle School, 03/2001

St. Xavier's Higher Secondary School - India

Contact this candidate