Senior Oracle PL/SQL Developer & Tuner

ANUSHA GUDURU

Senior Oracle PL/SQL Developer • Database Engineering & Performance Tuning

12+ Years Enterprise Database Experience • Oracle 11g / 12c / 19c

*********@*****.*** • +1-647-***-****

PROFESSIONAL SUMMARY

•Senior Oracle PL/SQL Developer with 10+ years of hands-on experience designing, developing, optimizing, and maintaining enterprise database solutions for clients across property tax, ERP, supply chain, and telecommunications domains.

•Strong expertise across the full SDLC — requirements gathering, design, development, testing, deployment, release management, and production support — collaborating closely with application developers, business analysts, and cross-functional teams.

•Deep command of Oracle 11g, 12c, and 19c, with proven delivery of stored procedures, packages, functions, triggers, views, indexes, constraints, and materialized views supporting large-scale enterprise workloads.

•Advanced PL/SQL skills including dynamic SQL, ref cursors, table partitioning, bulk collect, collections, table functions, and structured exception handling for high-performance, fault-tolerant data processing.

•Strong background in query optimization and performance tuning using Explain Plan, Optimizer Hints, SQL Trace, TKPROF, AWR reports, and execution plan analysis to identify and resolve database bottlenecks.

•Solid understanding of database design, normalization, and indexing concepts, with expertise in data modelling (ER diagrams, data flow diagrams, data dictionaries) to enforce data integrity, security, and consistency.

•Hands-on experience with data migration techniques, performing bulk data loading and replication using SQL*Loader, External Tables, materialized views, and Oracle-supplied packages (DBMS_SQL, DBMS_JOB, DBMS_SCHEDULER, UTL_FILE).

•Working knowledge of UNIX/Linux commands and shell scripting for executing SQL tasks, batch processing, and job automation; experience with CI/CD using Jenkins and version control tools (Git, SVN, PVCS, Kintana).

•Exposure to cloud platforms including Oracle Cloud Infrastructure (OCI), AWS, and Azure, and delivery experience in Agile/Scrum environments using JIRA and Rally with formal code review and coding-standards governance.

•Built Oracle Forms & Reports, Oracle ADF interfaces, and Jasper Reports to fulfil client and ad-hoc reporting requirements; experienced mentoring junior developers and authoring technical documentation for database objects and processes.

TECHNICAL SKILLS

Databases: Oracle 11g, 12c, 19c (also 8i / 9i / 10g); Oracle SQL, PL/SQL, Advanced PL/SQL, Stored Procedures, Packages, Functions, Triggers

Programming: SQL, PL/SQL, Shell Scripting, Batch Scripting, Java (working knowledge)

Performance Tuning: Explain Plan, Optimizer Hints, SQL Trace, TKPROF, AWR Reports, Indexing Strategies, Table Partitioning, Query Optimization

ETL & Data Migration: SQL*Loader, External Tables, Materialized Views, DBMS_SCHEDULER, DBMS_JOB, DBMS_SQL, UTL_FILE, Bulk Collect, Ref Cursors

Reporting & UI: Oracle Reports, Oracle Forms, Oracle ADF, Oracle APEX (exposure), Jasper Reports

Tools: TOAD, SQL Developer, PL/SQL Developer, Golden Benthic, SQL*Plus, Source Tree

DevOps & Version Control: Jenkins, Git, SVN, PVCS, Kintana, JIRA, Rally

Operating Systems: Linux, UNIX, Windows

Cloud (Exposure): Oracle Cloud Infrastructure (OCI), AWS, Microsoft Azure

Methodologies: Agile / Scrum, SDLC, Code Reviews, Release Management

WORK EXPERIENCE

Tyler Technologies Toronto, Canada Apr 2022 – Present

Senior Software Engineer — Oracle PL/SQL Developer

Property tax and CAMA platform — enterprise database engineering

•Serving as Senior PL/SQL Developer on a major CAMA (Computer-Assisted Mass Appraisal) property tax platform, collaborating with the Product Owner, business analysts, and cross-functional teams to gather requirements, design scalable database solutions, and prepare technical documentation for database objects and processes.

•Designed and developed Oracle PL/SQL packages, stored procedures, functions, triggers, views, indexes, and tables aligned with normalized data models, ensuring data integrity, security, and consistency across reporting and transactional workloads.

•Performed extensive query optimization and database performance tuning using Explain Plan, Optimizer Hints, indexing strategies, partitioning, and DBMS_SCHEDULER to improve throughput on large datasets and reduce response times for critical reports.

•Created and customized 40+ Oracle Reports and delivered 30+ report enhancements to meet client-specific assessment and valuation requirements.

•Improved existing code performance across views, triggers, and procedures, and automated sequential job execution using DBMS_SCHEDULER, reducing data processing time by 40%.

•Troubleshot production issues and provided timely resolution of database-related defects, partnering with the support team to triage backlog items and deliver fixes through structured release management.

•Collaborated with Implementation Consultants to deliver training sessions on new enhancements, ETL flows, and reporting updates.

•Participated in code reviews, mentored junior developers, and enforced adherence to PL/SQL coding standards and database development best practices.

•Built Oracle Forms and Reports to fulfil ad-hoc and client-driven requirements for property valuation, assessment, and tax administration.

Environment: Oracle 19c, Oracle 12c, PL/SQL, SQL*Plus, TOAD, SQL Developer, Oracle Reports, Oracle Forms, DBMS_SCHEDULER, Performance Tuning (Explain Plan, Hints, AWR), Git, JIRA, Agile/Scrum, Linux, Windows

CMiC (Computer Methods International Corp.) Toronto, Canada Nov 2020 – Mar 2022

Application Developer — Oracle PL/SQL & ADF

Construction ERP — Financials and Asset Management modules

•Worked as an Application Developer in an Agile cross-functional team on the Financials and Asset Management modules of CMiC's construction ERP, contributing to both new development and enhancement projects.

•Led the migration of an Oracle Forms application to the Oracle ADF framework using Oracle PL/SQL, Java, and Jasper Reports, including data migration scripts, schema redesign, and validation to preserve data integrity across legacy and target databases.

•Engaged with clients throughout the full delivery lifecycle, from requirements gathering through solution delivery and post-deployment support.

•Partnered with customers and the Level 1 support team to triage functional and technical defects, logging, prioritizing, and tracking issues through JIRA.

•Conducted usability testing to validate that delivered ERP features met end-user needs and facilitated clarification of ambiguous requirements with business stakeholders.

•Operated within an Agile/Scrum environment, managing user stories, sprints, and tasks through JIRA, and supporting database deployment and release activities using version control tools (PVCS, SVN).

Environment: Oracle PL/SQL, Oracle 11g/12c, Java, Oracle ADF, Jasper Reports, PVCS, SVN, JIRA, Agile/Scrum, Oracle Forms

JDA Software Pvt. Ltd. India Sep 2014 – Apr 2018

Senior PL/SQL Developer

JDA Platform / Foundation — supply chain and planning applications

•Actively involved in the complete development cycle for the JDA Platform / Foundation product, including planning, analysis, design, development, testing, and implementation across supply chain and planning applications.

•Implemented Oracle sequences to auto-generate unique keys, supporting primary and foreign key constraints during large-scale data conversions and migrations.

•Developed and modified stored procedures, packages, functions, and triggers — including dynamic creation of database objects based on user inputs via PL/SQL — for data conversion and platform extension scenarios.

•Generated DDL scripts for new database objects (tables, views, sequences, functions, synonyms, indexes, triggers, packages, and stored procedures) and managed schema evolution across environments.

•Created and modified scripts using SQL*Plus, PL/SQL, and SQL*Loader for high-volume data conversions and bulk loads.

•Optimized procedures and SQL queries for maximum efficiency, employing Oracle Hints for rule-based optimization and fine-tuning PMM (Promotions Management Module) packages to enhance performance.

•Created indexes to eliminate full table scans and built views to simplify complex queries, improving overall application response time.

•Designed data models and analysed object dependencies using design specifications; documented user requirements, technical specifications, and reporting manuals.

•Participated in unit testing, prepared test case documents, and supported defect resolution through cursors, exception handling, and PL/SQL debugging.

Environment: Oracle 9i/10g/11g, SQL*Plus, PL/SQL, Advanced PL/SQL, TOAD, SQL*Loader, Windows 2000, Performance Tuning, Oracle Hints

Tech Mahindra India May 2011 – Sep 2014

PL/SQL Developer

Client: Cisco — Hierarchy Management Platform

•Developed data migration modules, ETL workflows, and multiple PL/SQL APIs for the Cisco Hierarchy Management Platform — the single source of truth for Cisco's enterprise hierarchies — supporting governed, scalable hierarchy data exposure as a service.

•Designed and maintained database objects including tables, views, materialized views, sequences, indexes, and collections to support enterprise-scale hierarchy classification.

•Built complex PL/SQL packages, procedures, functions, and triggers using bulk collect, cursors, ref cursors, exception handling, and bulk operations for high-throughput data processing.

•Optimized and fine-tuned PL/SQL code for large-scale data processing and loading, using SQL*Loader for efficient bulk imports.

•Created robust error-handling frameworks and user-managed error tables to improve debugging, traceability, and operational support.

•Authored advanced SQL queries involving joins, inline views, subqueries, and analytical functions for complex reporting and integration scenarios.

•Monitored, scheduled, and managed database jobs to ensure reliable and timely data operations across distributed environments.

•Performed unit testing (UTC, UTR), defect resolution, and root-cause analysis to validate and improve system performance.

•Prepared detailed functional and technical design documents; collaborated with Data Architects to design database structures and generate scripts for enterprise data models.

•Supported code deployment and version control using Kintana, PVCS, and SVN.

Environment: Oracle 11g, SQL Developer, TOAD, Golden Benthic, Advanced PL/SQL, SQL*Loader, Kintana, PVCS, SVN

CERTIFICATIONS

•ITIL Foundation Level Certified

•Information Security Compliance

•Code of Conduct Certification

•Solution Investment Policy Curriculum

AWARDS & RECOGNITION

•BRAVO Award — recognition for rapidly mastering new technologies and delivering under tight timelines.

•Promoted to Team Lead band within 2 years of joining.

•Multiple client appreciations and certificates of appreciation for on-time delivery of critical modules.

EDUCATION

•Bachelor of Technology in Computer Science, JNT University Hyderabad (2007 – 2011)

Contact this candidate