Skip to content

Narala Mahesh Naidu

Oracle-to-PostgreSQL Migration Engineer • Andhra Pradesh, India • m**************@gmail.com • +91*******714 • drivetube.ai/•••••

Professional Summary

Oracle-to-PostgreSQL Migration Engineer with 5.1 years of experience designing, migrating, optimizing, and supporting enterprise database applications across Healthcare and Banking domains using Oracle, PostgreSQL and AWS database migration tools.

Technical Skills

Databases: Oracle 11g,Oracle 12c,Oracle 19c,PostgreSQL 17,Amazon RDS for PostgreSQL,SQL
Cloud and DevOps: Ansible,AWS VPC,AWS CloudWatch,Linux
Data and Analytics: SQL*Loader,UTL_FILE,Data Validation and Checksums
Tools and Methodologies: AWS Database Migration Service,AWS Schema Conversion Tool,Ora2Pg,Git,Bitbucket,pgAdmin 4,psql,DBeaver,TOAD,Agile Scrum
Skills: PL,pgSQL
Administration and Monitoring: pg_stat_statements,pg_dump,pg_restore,CloudWatch
Performance and Tuning: EXPLAIN ANALYZE,Execution Plan Analysis,Indexing Strategies
Job Scheduling and Automation: DBMS_SCHEDULER,pgAgent,AutoSys
Operating Systems: Windows

Work Experience

Microkey Software Technologies Pvt Ltd
Andhra Pradesh, India
Consultant
April 2024 – May 2026
Worked at a software solutions provider delivering database migration and modernization services; led Oracle-to-PostgreSQL migration for a large healthcare HMS on AWS RDS.
Tech Stack: Oracle 19c, PostgreSQL 17, AWS Database Migration Service, AWS Schema Conversion Tool, Amazon RDS for PostgreSQL, Ora2Pg, pgAdmin 4, DBeaver, pg_stat_statements, AWS VPC, AWS CloudWatch, Git, pgAgent, Linux, Windows
  • Planned and executed Oracle 19c → Amazon RDS PostgreSQL migration for a hospital management system using AWS SCT and AWS DMS, configuring Full Load + CDC to achieve near-zero downtime while preserving transactional integrity.
  • Assessed schemas and converted Oracle objects (tables, views, indexes, sequences, constraints, synonyms, materialized views) using Ora2Pg and manual refactoring to ensure functional parity in PostgreSQL.
  • Refactored complex PL/SQL packages, procedures, functions and triggers into PL/pgSQL, removing Oracle-specific constructs and validating logic via unit tests and source-to-target verification.
  • Tuned PostgreSQL query performance using EXPLAIN ANALYZE, pg_stat_statements and revised indexing strategies to reduce query latency and improve overall throughput for EMR and billing workflows.
  • Implemented role-based access controls and least-privilege models, coordinated secure connectivity using AWS VPC, and supported HIPAA/GDPR-aligned controls during migration and cutover.
  • Authored migration runbooks, rollback procedures, and operational playbooks; managed changes with Git and coordinated cutover activities with application, QA and infrastructure teams.
Infosys Limited
Andhra Pradesh, India
Technology Analyst
October 2022 – March 2024
Worked at an IT services firm delivering database development and support for banking clients; contributed to enterprise risk assessment and regulatory reporting systems.
Tech Stack: Oracle 19c, PL, SQL, TOAD, Bitbucket, AutoSys, Ansible, Windows, Linux, Jira
  • Developed and maintained Oracle PL/SQL packages, stored procedures, functions and views to support enterprise risk assessment and regulatory reporting for banking data platforms.
  • Designed ETL logic in PL/SQL for ingesting and transforming large datasets from multiple source systems, ensuring data conformance for downstream analytics and reports.
  • Implemented advanced PL/SQL constructs (BULK COLLECT, FORALL, collections, dynamic SQL) to optimize batch processing and reduce ETL window times for nightly jobs.
  • Performed SQL and PL/SQL performance tuning using Explain Plan and execution plan analysis, and implemented indexing strategies to improve report generation throughput.
  • Automated and monitored scheduled jobs using AutoSys and DBMS_SCHEDULER to improve SLA adherence and reliability of regulatory report runs.
  • Investigated and resolved production incidents and data quality issues within SLA timelines; prepared deployment scripts, release notes and handover documentation.
Microkey Software Technologies Pvt Ltd
Andhra Pradesh, India
System Engineer
April 2021 – September 2022
Delivered database development and reconciliation solutions for banking clients; supported net-banking settlement and reconciliation processes for transaction systems.
Tech Stack: Oracle 12c, SQL*Loader, PL, SQL, DBMS_SCHEDULER, UTL_FILE, Git, Windows, Linux
  • Developed and maintained Oracle SQL and PL/SQL objects to support net-banking settlement, reconciliation and settlement workflows (NEFT, IMPS, RTGS) ensuring transaction accuracy.
  • Built high-throughput data ingestion using SQL*Loader for large volumes of transaction files and ensured consistent load performance during peak processing windows.
  • Implemented audit triggers and used PRAGMA AUTONOMOUS_TRANSACTION to capture transaction history and ensure independent audit logging without impacting primary transactions.
  • Automated reconciliation and batch processing using DBMS_SCHEDULER to coordinate daily settlement jobs and reduce manual intervention in reconciliation cycles.
  • Created PL/SQL programs using UTL_FILE to generate reconciliation and settlement reports in CSV/Excel formats for downstream reconciliation and reporting teams.
  • Performed SQL tuning and PL/SQL optimization through Explain Plan, query refactoring and indexing; supported production troubleshooting and incident resolution.

Projects

MediCore HMS – Hospital Management System
Tools Used: Oracle 19c, PostgreSQL 17, AWS DMS, AWS SCT, Amazon RDS for PostgreSQL, PL, pgSQL, pgAdmin 4, pg_stat_statements
  • Migrated on-premise Oracle 19c HMS to Amazon RDS PostgreSQL for Apollo Hospitals using AWS SCT for schema conversion and AWS DMS for data migration with Full Load + CDC.
  • Converted database objects and refactored complex PL/SQL logic into PL/pgSQL, addressing differences in types, sequences and materialized view behavior.
  • Migrated and validated large LOB data (CLOB/BLOB) using optimized DMS LOB settings; performed row-count, checksum and source-to-target reconciliations.
  • Optimized critical queries and implemented indexing strategies using EXPLAIN ANALYZE and pg_stat_statements to improve EMR and billing performance.
  • Supported cutover, UAT and post-migration validation; prepared rollback procedures, runbooks and documentation for production operations and compliance.
Enterprise Risk Assessment and Regulatory Reporting System
Tools Used: Oracle 19c, PL, SQL, TOAD, Bitbucket, AutoSys, Ansible
  • Built and maintained PL/SQL packages and ETL routines to aggregate multi-source data for enterprise risk calculations and regulatory report generation.
  • Implemented performance improvements using BULK COLLECT and FORALL to accelerate large data transformations and shorten nightly processing windows.
  • Created audit and validation procedures to ensure data quality and regulatory compliance in reporting outputs.
  • Automated job scheduling and monitoring using AutoSys to ensure timely report generation and consistent SLA compliance.
  • Worked with cross-functional teams to investigate and resolve production issues impacting regulatory report accuracy and delivery.
Net Banking Settlement and Reconciliation Management System (RMS)
Tools Used: Oracle 12c, SQL, PL, SQL*Loader, DBMS_SCHEDULER, UTL_FILE
  • Developed PL/SQL programs to validate and reconcile NEFT, IMPS and RTGS transactions for net-banking settlement processes.
  • Implemented high-volume data loads via SQL*Loader and ensured transactional integrity during ingestion.
  • Created audit triggers and used autonomous transactions for independent audit logging of critical reconciliation steps.
  • Automated reconciliation jobs using DBMS_SCHEDULER to streamline daily settlement cycles and reporting.
  • Generated reconciliation reports and exports using UTL_FILE for downstream processing and audit reviews.

Education

Swarnandhra Engineering College, JNTU Kakinada
Bachelor of Technology (B.Tech) • Andhra Pradesh, India

Powered by Drivetube · Create your own profile at drivetube.ai