Senior Oracle PL/SQL and Database Performance Engineer

Rajani Konakanchi

737-***-**** ***************@*****.*** www.linkedin.com/in/rajani-konakanchi

Professional Summary

Senior Oracle PL/SQL Developer with 10+ years of experience in designing, developing, administering, and optimizing enterprise database solutions across Banking, Financial Services, Healthcare, Insurance, Retail, and Government domains. Strong expertise in PostgreSQL (4+ years), Microsoft SQL Server (4 years), Oracle Database (10+ years), and Ansible (3 years) with hands-on experience in database administration, performance tuning, query optimization, backup and recovery, database migrations, high availability, replication, and production support.

Experienced in installing, configuring, and administering PostgreSQL and SQL Server databases, optimizing SQL queries using execution plans, indexing, partitioning, AWR/ASH, EXPLAIN ANALYZE, and DMVs to improve database performance and scalability. Proficient in automating database provisioning, configuration management, deployment, and maintenance using Ansible Playbooks, Roles, Inventories, and Templates, integrated with Jenkins CI/CD pipelines.

Skilled in Oracle-to-PostgreSQL migration, AWS RDS administration, SQL Server database management, Shell scripting, Git, Jenkins, Linux/Unix environments, and troubleshooting critical production issues. Proven ability to deliver highly available, secure, scalable, and high-performance database solutions while collaborating with application, DevOps, and infrastructure teams in Agile environments.

KEY ACHIEVEMENTS

Improved batch processing performance by up to 60% through SQL tuning, indexing, and partitioning.

Developed and optimized 100+ Oracle PL/SQL packages, procedures, functions, and triggers.

Reduced SQL execution time by up to 40% through AWR/ASH analysis and execution plan optimization.

Successfully migrated Oracle database applications to PostgreSQL with minimal downtime.

CORE COMPETENCIES: PostgreSQL Administration • Microsoft SQL Server • Oracle Database • Oracle SQL • PL/SQL • PostgreSQL Performance Tuning • SQL Server Performance Tuning • Query Optimization • Database Administration • Database Engineering • Backup & Recovery • High Availability (HA) • Streaming Replication • Database Migration • Oracle-to-PostgreSQL Migration • Ansible • Database Automation • AWS RDS • Jenkins • Git • Shell Scripting • Linux/Unix • Production Support • Performance Monitoring • Disaster Recovery • Database Security • Agile Scrum

TECHNICAL SKILLS

Databases: PostgreSQL, Microsoft SQL Server, Oracle Database, Oracle SQL, PL/SQL, PL/pgSQL, T-SQL

Database Architecture: OLTP Systems, OLAP Systems, Data Warehousing

Programming & Scripting: PL/SQL, PL/pgSQL, Shell Scripting, T-SQL, Pro*C

ETL & Data Integration: Oracle Data Integrator (ODI), Informatica PowerCenter (Mappings, Workflows, Sessions), SQL*Loader

Performance Tuning: AWR, ASH, ADDM, Explain Plans, EXPLAIN ANALYZE, SQL Trace, SQL Plan Baselines, Indexing, Partitioning, VACUUM, ANALYZE, DMVs

Development Tools: TOAD, Oracle SQL Developer, SQL Developer Data Modeler, PL/SQL Developer, Oracle APEX, GitHub Copilot, ChatGPT

Cloud Platforms: AWS (RDS, S3), Azure Synapse, Microsoft Azure

Automation & Scheduling: Ansible (Playbooks, Roles, Inventories, Templates), Jenkins, Control-M, AutoSys, DBMS_SCHEDULER

Reporting & Visualization: Oracle BI Publisher (BIP), OTBI, Oracle Fusion ERP Reporting, Oracle Fusion HCM Reporting, Oracle Fusion Analytics, Oracle Reports, Tableau, Power BI

Version Control & Collaboration: Git, GitHub, Bitbucket, SVN, JIRA, Confluence

Middleware & Integration: Oracle ADF, REST APIs, JSON, JSON_TABLE, XML, XMLTABLE

Operating Systems: Unix, Linux, Windows, AIX

Methodologies: SDLC, Agile Scrum, Waterfall, Test-Driven Development (TDD)

Security & Backup: pg_dump, pg_restore, RMAN, Oracle Data Guard, Oracle TDE, Database Security, Role Management, Access Control, SOX, HIPAA

PROFESSIONAL EXPERIENCE

Project: - V3 Benefits Administration System (V3locity).

Role: Senior Oracle PL/SQL Developer. (AU Connects) Duration: Nov- 2025 – Present

Client: Vitech Systems Group (Majesco), USA.

Environment: Oracle 19c, Oracle SQL, PL/SQL, PostgreSQL, Microsoft SQL Server, AWS RDS, Ansible, Jenkins, Git, UNIX/Linux, Shell Scripting, Oracle BI Publisher, OTBI, Oracle APEX, Azure Synapse.

Responsibilities:

Designed and developed complex PL/SQL packages, procedures, functions, triggers, views, and dynamic SQL modules supporting high-volume enterprise applications.

Optimized complex SQL queries using AWR, ASH reports, execution plans, indexing strategies, and SQL tuning techniques, reducing execution time by up to 40%.

Developed and enhanced Oracle Application Express (APEX) web-based database applications, including forms, reports, validations, and database-driven functionality integrated with Oracle PL/SQL.

Developed and maintained Oracle PL/SQL functions, stored procedures, packages, triggers, views, and database objects supporting high-volume enterprise applications.

Analyzed business requirements and business rules and translated user requirements into technical specifications and Oracle PL/SQL application solutions.

Performed logical and physical data modeling for enterprise database applications, designing relational database structures to support business requirements.

Evaluated requests for new database objects and data elements, ensuring data integrity, consistency, and minimal redundancy across enterprise databases.

Collaborated with Business Analysts, Developers, and QA teams to assess the impact of database changes on enterprise applications and downstream systems.

Led Oracle-to-PostgreSQL database migration activities, converting PL/SQL packages, procedures, functions, and database objects into PL/pgSQL while maintaining data integrity and application performance.

Installed, configured, and administered PostgreSQL databases in AWS RDS environments, performing database provisioning, user management, backup validation, and routine maintenance.

Optimized PostgreSQL query performance using EXPLAIN ANALYZE, indexing strategies, partitioning, VACUUM, and ANALYZE to improve application response times.

Supported PostgreSQL database upgrades, patching, migration, and version upgrades while minimizing application downtime.

Configured and monitored PostgreSQL backup and recovery processes using pg_dump and pg_restore.

Participated in PostgreSQL Streaming Replication, High Availability (HA), failover validation, and disaster recovery activities.

Monitored PostgreSQL database health, capacity planning, locking, blocking, and long-running queries while troubleshooting production issues.

Developed and optimized Microsoft SQL Server T-SQL stored procedures, views, functions, and complex queries supporting enterprise applications.

Performed SQL Server performance tuning using SQL Server Management Studio (SSMS), Dynamic Management Views (DMVs), execution plans, indexing strategies, and statistics.

Performed SQL Server backup, restore, index maintenance, statistics updates, and routine database health monitoring.

Supported SQL Server production environments by troubleshooting performance bottlenecks and optimizing database workloads.

Developed Ansible playbooks to automate PostgreSQL database provisioning, configuration, deployment, and environment setup.

Automated PostgreSQL configuration management using Ansible roles, inventories, templates, and reusable playbooks.

Integrated Ansible automation with Jenkins CI/CD pipelines to streamline database deployment and configuration activities.

Automated PostgreSQL user creation, role management, permission assignments, backup scheduling, and configuration updates using Ansible.

Collaborated with application, DevOps, and infrastructure teams to ensure database availability, performance, security, and production stability.

Monitored 24 7 production batch schedules, responded to production control notifications, investigated failed jobs, and resolved operational issues within SLA timelines.

Created and maintained production environment runbooks, technical documentation, batch operation procedures, troubleshooting guides, and issue-resolution documentation using UNIX Shell scripting to support production operations.

Investigated production incidents, performed root cause analysis (RCA), and implemented permanent fixes for recurring database issues.

Managed source code using Git and supported CI/CD deployments through Jenkins pipelines.

Project: - Arex Application (Payments Product).

Role: Senior Oracle PL/SQL Developer. Duration: Aug 2024 – June-2025

Client: Al Ansari Financial Services, UAE.

Environment: Oracle PL/SQL, SQL Developer, UNIX Shell, AWS RDS, Azure Synapse, Tableau, Power BI, GIT, JIRA, Jenkins, Jules CI/CD, Confluence.

Responsibilities:

Led database development activities for enterprise payment processing applications.

Reviewed database code, mentored junior developers, and ensured adherence to database development standards and best practices.

Provided technical recommendations during solution design, estimated development effort, and supported project planning to ensure timely delivery of project milestones.

Designed scalable PL/SQL packages, procedures, triggers, functions, and materialized views supporting payment workflows.

Improved SQL performance through indexing, query optimization, optimizer hints, and execution plan analysis.

Developed advanced PL/SQL components utilizing Collections, Bulk Processing, and Dynamic SQL.

Worked closely with business users and vendor teams to gather requirements and deliver database enhancements.

Supported production deployments, performed data fixes, and resolved high-priority production incidents.

Developed ETL routines and data transformation logic supporting financial reporting.

Designed and optimized complex SQL and Analytical SQL queries for data aggregation, analytical reporting, and business intelligence requirements to support business decision-making.

Developed and maintained Tableau dashboards and visualizations to support financial reporting, payment analytics, operational monitoring, and business decision-making.

Created Tableau worksheets, dashboards, filters, parameters, calculated fields, and interactive visualizations using data sourced from Oracle and SQL databases.

Developed complex SQL queries and data preparation logic to provide optimized datasets for Tableau reporting and dashboard development.

Collaborated with business users and reporting teams to gather requirements, translate business needs into Tableau dashboards, and deliver actionable analytics.

Optimized Tableau data sources and underlying SQL queries to improve dashboard performance, data refresh efficiency, and reporting responsiveness.

Created database objects including tables, indexes, sequences, materialized views, and synonyms.

Integrated Azure cloud services and AWS RDS databases into enterprise applications.

Developed and maintained SQL Server database objects including stored procedures, views, functions, and performance-tuned queries.

Monitored SQL Server database performance and implemented indexing and query optimization strategies to improve application response times.

Maintained technical documentation and participated in Agile ceremonies.

Participated in designing multi-tier enterprise applications by integrating Oracle PL/SQL database components with application and reporting layers to support scalable business solutions.

Project: Deal Accounting Support (Expense Recovery Platform).

Role: Senior PL/SQL Developer. Duration: May 2023 – Aug 2024. (Accenture/TeamLease Client)

Client: Bank of America.

Environment: Oracle PL/SQL, SQL Developer, SQL*Loader, UNIX Shell, AWS RDS, PostgreSQL, Power BI, GIT, JIRA, Jenkins, Jules CI/CD, Confluence.

Responsibilities: -

Designed and maintained enterprise Oracle and PostgreSQL database applications supporting financial accounting systems.

Developed Oracle Application Express (APEX) applications for internal reporting and data maintenance using forms, reports, interactive grids, and PL/SQL processes.

Built APEX components integrated with Oracle PL/SQL packages, procedures, and database objects to support financial applications.

Performed PostgreSQL database performance tuning using execution plans, indexing, and query optimization techniques.

Supported PostgreSQL production environments by troubleshooting locking, blocking, long-running queries, and database performance issues.

Developed and optimized SQL Server T-SQL stored procedures, views, functions, and complex queries supporting financial accounting applications.

Performed SQL Server performance tuning using execution plans, indexing strategies, DMVs, and query optimization techniques.

Supported SQL Server backup, restore, index maintenance, and statistics updates to ensure database reliability and performance.

Worked with PostgreSQL system catalogs and monitoring views to analyze database activity and optimize workloads.

Assisted in PostgreSQL backup, recovery, and maintenance activities to support production databases.

Participated in the end-to-end implementation of Oracle Retail Merchandising System (RMS), including requirements analysis, technical design, development, testing, deployment, and post-production support.

Developed and optimized database solutions supporting high-volume OLTP transactions and OLAP reporting workloads.

Developed reusable PL/SQL packages, procedures, functions, triggers, and PostgreSQL database objects.

Developed reusable PL/SQL utility packages and database components to standardize common functionality and improve development efficiency.

Optimized SQL and PL/SQL code using AWR, ASH, execution plans, indexing, and query tuning techniques, reducing batch execution time by up to 30%.

Recommended and implemented SQL and PL/SQL tuning strategies to improve application performance, scalability, and overall business process efficiency.

Used Oracle Enterprise Manager (OEM) to monitor database performance, analyze long-running sessions, monitor tablespace utilization, and troubleshoot production issues.

Developed ETL processes involving data extraction, cleansing, transformation, and loading from multiple source systems.

Diagnosed and resolved production issues while ensuring high application availability.

Supported database backup and recovery activities, monitored database health, and collaborated with DBA teams to maintain business continuity and disaster recovery readiness.

Assisted in developing Ansible playbooks for database deployment, configuration management, and environment provisioning.

Automated routine database maintenance activities using Ansible and Shell scripting, reducing manual effort and deployment errors.

Created unit test cases and supported system integration testing activities.

Collaborated with cross-functional teams to deliver production-ready database solutions.

Managed AutoSys job scheduling, database maintenance, and production support activities.

Participated in code reviews and implemented database performance improvements using Oracle tuning tools.

Project: Evo Brix X™ – MMIS Claims & Provider Management Platform.

Role: Senior Oracle PL/SQL Developer. (Enhops Solutions). Duration: Feb 2022 – May 2023

Client: CNSI.

Environment: - Oracle SQL, PL/SQL, PostgreSQL, AWS, OIA, XML, UNIX, Shell Script, PostgreSQL, JSON, XML, GIT, JIRA, Confluence

Responsibilities:

Developed high-performance PL/SQL modules supporting healthcare claims processing systems.

Migrated Oracle database components to PostgreSQL while ensuring data consistency.

Implemented partitioning, indexing, compression, and SQL optimization strategies to improve database performance.

Developed Shell Scripts for database automation and batch processing.

Utilized Ansible playbooks to automate database configuration, application deployment support, and server administration activities across development and testing environments.

Worked with Ansible inventories, roles, templates, and variables to standardize deployment processes.

Built SQL*Loader interfaces for daily bulk data imports.

Supported AWS-hosted Oracle environments and production deployments.

Participated in code reviews, troubleshooting, and release management.

Project: - Retail Merchandising Support (RMS).

Role: - Oracle PL/SQL Developer / Retail ERP Specialist. (Influxarena Technologies Pvt Ltd). Duration: - Sep 2016 – Jan 2022

Client: - HBC, USA.

Environment: Oracle SQL, PL/SQL, SQL*Loader, Pro*C, UNIX Shell script, Control-M, Autosys, SVN.

Responsibilities: -

Designed and maintained Oracle Retail database applications supporting pricing, inventory, purchasing, and merchandising operations.

Developed Oracle Application Express (APEX) web-based applications for internal business users, creating forms, interactive reports, dashboards, validations, and database-driven workflows.

Integrated Oracle APEX applications with Oracle PL/SQL packages, procedures, functions, and database objects to automate business processes.

Customized Oracle APEX security, navigation, and page components to support business requirements and improve user experience.

Improved batch processing performance by 60% through SQL optimization, indexing, and partitioning.

Automated Control-M and DBMS_SCHEDULER workflows, reducing manual intervention and improving operational stability.

Analyzed SQL, PL/SQL, and UNIX shell scripts to troubleshoot batch failures, optimize processing performance, and support production incidents.

Monitored and supported scheduled Oracle Retail batch programs and interface processes using Control-M and AutoSys, troubleshooting failed jobs and resolving production issues to maintain timely processing.

Developed UNIX Shell scripts to automate batch execution, database processing, file handling, validation, and production support activities.

Developed materialized views and partitioned tables supporting large-scale retail datasets across 500+ stores.

Designed and maintained materialized views to support efficient data replication and synchronization across distributed database environments.

Integrated warehouse management systems with third-party logistics providers for shipment tracking and invoice reconciliation.

Developed and supported robust database interfaces for seamless data exchange between enterprise applications using PL/SQL, SQL*Loader, and database integration techniques.

Prepared functional and technical design documents for Oracle Retail enhancements, interfaces, and batch processes based on business requirements.

Designed and maintained relational database structures, ensuring data integrity, normalization, and optimal database performance.

Coordinated with application developers and business users to evaluate database changes and implement enhancements with minimal impact to existing systems.

Worked with business users to understand business rules and requirements and translated functional requirements into technical specifications, PL/SQL solutions, and database enhancements.

Prepared and maintained technical documentation and production support procedures for Oracle Retail batch programs, interfaces, database processes, and troubleshooting activities.

Developed data validation and audit mechanisms to ensure inventory accuracy.

Supported production environments and resolved database performance bottlenecks.

Monitored and supported Oracle Retail batch programs and interface processes, ensuring successful execution, data integrity, and timely issue resolution.

Project: Prepaid Card Processing System (PPH with Multi-Currency Functionality).

Role: Oracle PL/SQL Developer Duration: Oct-2015 to Aug-2016.

Clients: YCS.

Environment: Oracle SQL, PL/SQL, SQL*Loader, Shell Scripting, TOAD SVN.

Responsibilities: -

Developed Oracle PL/SQL packages, procedures, functions, triggers, and database objects for prepaid card processing.

Supported multi-currency payment processing enhancements and foreign exchange functionality.

Performed unit testing, integration testing, debugging, and production support.

Developed Shell Scripts for batch execution and daily transaction processing.

Converted business requirements into technical specifications and implemented database solutions.

Monitored daily batch jobs and resolved production issues within SLA timelines.

EDUCATION:

Master of Computer Application (MCA) from Acharya Nagarjuna University in 2011.

Contact this candidate