Kalaiarasan K

PL/SQL Developer

Talent

ChennaiMember since August 22, 2026

Oracle DatabaseSybaseSQLPL/SQLDynamic SQL (EXECUTE IMMEDIATE)Stored ProceduresFunctionsPackagesTriggersCursorsException HandlingCollectionsBULK COLLECTFORALLSQL TuningQuery OptimizationEXPLAIN PLANDBMS_XPLANExecution Plan AnalysisIndexingPartitioningSybase-to-Oracle MigrationQuery ConversionData ValidationData ReconciliationUAT SupportProduction SupportIssue TroubleshootingRoot Cause AnalysisAgile

Hire this person

Send a job offer directly to this candidate

Oracle DatabaseSybaseSQLPL/SQLDynamic SQL (EXECUTE IMMEDIATE)

About

PL/SQL Developer with 4 years of experience in Oracle database development, SQL and PL/SQL programming, database migration, performance tuning, production support, and banking applications. Strong hands-on experience developing and optimizing complex SQL queries, stored procedures, functions, packages, and triggers. Experienced in Sybase-to-Oracle migration, query validation, data verification, reconciliation, execution plan analysis, indexing, partitioning, and troubleshooting database issues across UAT and Production environments.

Effective collaborator with business analysts, QA teams, and cross-functional stakeholders in Agile environments.

Experience

Senior Software Engineer at Buzzworks Business Services Pvt. Ltd. (2026-01 – 2026-06)

Focus: Sybase-to-Oracle Database Migration

Executed database migration activities by converting Sybase SQL queries, stored procedures, functions, and database objects into Oracle SQL and PL/SQL compatible syntax.
Performed query validation, data verification, and reconciliation to ensure data accuracy, consistency, and functional correctness after migration.
Maintained data integrity and optimized migrated SQL using EXPLAIN PLAN and query tuning techniques to support efficient execution.
Collaborated with business analysts, QA teams, and stakeholders during migration, testing, deployment, and validation activities.
Supported UAT and Production environments by investigating and resolving database issues while minimizing production impact.

Software Engineer / PL/SQL Developer at Inspirisys Solutions Private Limited (2022-08 – 2025-12)

Domain: Banking and Government Tax Payments

Developed and maintained PL/SQL stored procedures, packages, and triggers for banking and tax modules including CBDT, GST, and State Tax.
Implemented OTC Cash, Transfer, Clearing, and INET transaction functionalities across banking modules.
Optimized database performance using indexing, partitioning, Global Temporary Tables, and SQL tuning techniques.
Analyzed and improved SQL performance using EXPLAIN PLAN and DBMS_XPLAN to enhance database efficiency.
Provided production support by troubleshooting database issues and implementing fixes to maintain application reliability.