Senior PL/SQL Database Developer and Cloud Migrations

Name: Manmayee Lenka

Mobile: +1-669*******

Email ID: ********.*****@*****.***

Professional Summary: Accomplished Senior Database Developer with 13+ years of expertise in PL/SQL development using DB like Postgres and Oracle, and cloud database migrations (AWS & Azure). Proficient in designing robust ETL pipelines, cloud-native data solutions, and leading high-impact migration projects. Proven success in leading cross-functional teams and delivering scalable, performance-optimized solutions aligned with business objectives. Experienced in implementing data governance frameworks and building conceptual, logical, and physical data models.

progressive experience in enterprise data architecture, ETL development, and cloud data platform modernization across diverse domains including healthcare, banking, manufacturing, and automotive.

Expertise in Informatica PowerCenter, Informatica IICS, and Talend, with a strong focus on designing and implementing robust, scalable ETL pipelines to support large-scale data transformation and ingestion needs.

Hands-on experience in cloud migration projects, including AWS (RDS, DMS, SCT) and Azure SQL Database, with successful execution of critical database transformations and re-platforming from on-premises systems (Oracle, SQL Server, DB2, PostgreSQL) to cloud-native environments.

Proficient in PL/SQL, SQL, T-SQL, and complex query performance tuning strategies including indexing, partitioning, and optimization to handle OLTP/OLAP workloads efficiently.

Hands-on experience in Oracle to PostgreSQL database modernization, including schema conversion using Ora2Pg, PL/SQL to PL/pgSQL conversion, SQL remediation, performance tuning, and post-migration validation for enterprise applications.

Extensive experience in conceptual, logical, and physical data modeling using ERWIN, applying normalization, star, and snowflake schemas for reporting and analytics platforms.

Demonstrated leadership in managing end-to-end data migration initiatives, coordinating with cross-functional teams, mentoring junior developers, and ensuring timely, quality-driven deliveries.

Adept in automation and scripting using Python and Shell scripting for data validation, process orchestration, and monitoring.

Technical Skills:

Category

Skills

Languages

SQL, PL/SQL, T-SQL, Python (basic), PL/pgSQL

Databases

Oracle, PostgreSQL, MS SQL, DB2, MariaDB

ETL Tools

Informatica PowerCenter, IICS, Talend

Cloud Platforms

AWS (DMS, SCT), Azure SQL Database

Tools

SQL Developer, PGAdmin, DBeaver, SSMS, REST APIs, Ora2Pg

Scheduling/Jobs

Autosys, Talend TAC

DevOps/Tracking

Git, JIRA, Agile Central

Modeling

ERWIN

Methodologies

Agile, Waterfall

Data Governance

Metadata management, Data quality, Compliance support

Data Modeling

ERWIN, Normalization, Star/Snowflake schemas

Education and Certifications:

B.Tech in Information Technology from Biju Patnaik University of Technology, Odisha 2009.

AWS Certified Solutions Architect – Associate

AWS Cloud Practitioner.

Professional Experience:

Project 1: Audi – Centralized Hosting Cloud (CHC) Migration

Client: Audi AG 2023 –2025

Role: Senior Database Developer

Domain: Automotive / Cloud Data Modernization

Project Description: The Audi-CHC (Centralized Hosting Cloud) initiative was a large-scale, multi-phase cloud migration and modernization program aimed at transitioning critical enterprise databases and ETL workflows from on-premise data centers to a cloud-native environment on AWS. The program's primary objectives were to reduce infrastructure overhead, improve scalability, enhance data security, and enable seamless integration with advanced analytics and governance platforms.

Roles & Responsibilities:

Conducted comprehensive assessment of legacy Oracle databases, identifying dependencies, customizations, and performance bottlenecks to determine cloud readiness.

Led end-to-end migration efforts of over 20+ TB of enterprise data from on-prem Oracle to AWS RDS (Postgres) using AWS DMS (Database Migration Service) and AWS SCT (Schema Conversion Tool) ensuring zero data loss and minimal downtime.

Conducted Oracle to PostgreSQL migration assessments by analyzing database schemas, PL/SQL objects, dependencies, data types, and application compatibility.

Utilized Ora2Pg to automate schema extraction, migration assessment, SQL conversion, and database migration reporting, reducing manual conversion effort.

Converted Oracle PL/SQL packages, stored procedures, functions, triggers, and cursors into PostgreSQL PL/pgSQL while preserving business logic and application functionality.

Migrated Oracle database objects including tables, indexes, constraints, views, sequences, and materialized views to PostgreSQL environments.

Performed SQL remediation by replacing Oracle-specific syntax with PostgreSQL equivalents, including NVL COALESCE, DECODE CASE, SYSDATE CURRENT_TIMESTAMP, ROWNUM LIMIT/ROW_NUMBER, and CONNECT BY Recursive CTE.

Resolved Oracle-specific object compatibility by redesigning Packages into PostgreSQL schemas and functions, converting Oracle Sequences to PostgreSQL SEQUENCE/GENERATED AS IDENTITY, and handling ROWID alternatives using CTID where applicable.

Redesigned Oracle Autonomous Transaction logic using PostgreSQL-compatible transaction management and application-controlled commit strategies.

Optimized PostgreSQL database performance using EXPLAIN ANALYZE, indexing strategies, VACUUM, ANALYZE, and query tuning techniques.

Performed comprehensive data validation, reconciliation, and post-migration performance benchmarking to ensure data integrity and functional consistency between Oracle and PostgreSQL.

Collaborated with application development teams to resolve database compatibility issues and support seamless Oracle-to-PostgreSQL application migration with minimal downtime.

Environment: AWS, RDS (Postgres), DMS, SCT, EC2, S3, VPC, IAM, CloudWatch, IICS, Cloud Mapping Designer, Monitor, Taskflows, Oracle 12c, MariaDB, PostgreSQL, SQL, PL/SQL, Shell Scripting, Git, JIRA, Confluence, AWS CloudWatch, IICS Control Hub, GDPR, TDE, RBAC, Agile Scrum.

Project 2: CIBC – Cloud Data Modernization Initiative

Client: CIBC (Canadian Imperial Bank of Commerce) 2022 – 2023

Role: Senior Database Developer

Domain: Banking / Financial Services / Cloud Modernization

Project Description: The CIBC Cloud Data Modernization Program was a strategic initiative aimed at migrating legacy on-premise SQL Server databases to Microsoft Azure SQL Database to enhance system performance, scalability, cost efficiency, and ensure alignment with CIBC’s cloud-first enterprise strategy. The project involved complex mission-critical financial systems, demanding strict compliance with data privacy, auditability, and security regulations including SOX and PCI-DSS.

Roles & Responsibilities:

Conducted detailed discovery and assessment of over 50+ SQL Server instances, analyzing schema complexity, linked servers, stored procedures, jobs, and data volumes for Azure migration readiness.

Led the end-to-end schema and data migration process using Azure Data Migration Assistant (DMA) and Azure Database Migration Service (DMS), ensuring minimal disruption to business applications.

Developed custom PowerShell and T-SQL scripts for pre-migration validation, automated schema comparison, and post-migration reconciliation, streamlining manual checks.

Designed and implemented Azure SQL elastic pools, hyperscale databases, and performance tiers based on resource utilization trends to optimize costs and scale dynamically.

Integrated role-based access controls (RBAC), transparent data encryption (TDE), and auditing policies into the Azure platform to meet internal security guidelines and external regulatory compliance (SOX, PCI).

Collaborated with DevOps engineers and application owners to validate database connectivity, functionality, and performance across pre-prod and post-prod environments.

Led performance benchmarking and tuning, optimizing execution plans, indexing strategies, and partitioning logic for improved query performance in the new environment.

Enabled automated deployment pipelines using Azure DevOps CI/CD for version-controlled rollout of database objects, views, procedures, and data masking logic.

Set up geo-replication, automated backups, failover groups, and zone-redundant architectures to meet high availability (HA) and disaster recovery (DR) requirements.

Maintained detailed runbooks, change control logs, and cutover plans to support production migration activities and ensure audit traceability.

Migrated over 100 databases with zero data loss and less than 2 hours of downtime for mission-critical systems, using online migration and replication techniques.

Delivered a 40% reduction in database maintenance costs by moving from on-premise SQL Server to Azure PaaS and eliminating hardware dependencies.

Boosted query performance by 25–30% through targeted index optimization, schema refactoring, and workload-driven tuning.

Streamlined delivery through CI/CD pipelines, reducing manual deployments by 80% and improving release frequency.

Achieved audit-readiness for all cloud-hosted databases with full traceability, encryption, and logging as per CIBC’s compliance framework.

Environment: Microsoft Azure, Azure SQL Database, Azure DMS, Azure Monitor, Azure Storage, DMA, Azure Database Migration Service, T-SQL, PowerShell, SQL, PL/SQL, Azure DevOps, Git, CI/CD Pipelines, ARM Templates, RBAC, TDE, Audit Logging, SOX, PCI-DSS, Microsoft SQL Server, Azure SQL, Azure Hyperscale, JIRA, Confluence, SharePoint, Agile Scrum.

Company: GE

Client: GE Power, India. 2017 – 2022

Role: Database Developer

Project Title: Integrated Costing System (ICS)

Project Description: The Integrated Costing System (ICS) is a strategic module within the Costing & Price Analytics suite developed for the CAE team under PM&A. ICS serves as a centralized data platform consolidating cost data from multiple manufacturing and enterprise systems such as Propcost, PCS, eSuccess, and PLM. The system empowers business users with real-time cost visibility across plants and lifecycle stages, enabling faster ITO (Inquiry to Order) decisions and enhancing GE Power’s competitive pricing capabilities.

Roles & Responsibilities:

Developed scalable ETL pipelines using Informatica to extract and integrate data from multiple disparate source systems.

Designed and implemented data models using star schema principles, building fact and dimension tables to support enterprise-wide costing analytics.

Created robust PL/SQL procedures and SQL scripts for complex data transformations, validation logic, and business rule implementation for Postgres DB.

Automated job orchestration for daily and weekly data loads using scheduling tools with built-in alerting and audit logging for monitoring.

Collaborated with business analysts and finance stakeholders to gather requirements, define source-to-target mappings, and standardize cost computation logic.

Integrated cost data from different plants into unified cost views to enable cross-plant and lifecycle-level cost analysis.

Enforced data quality checks, including row-level validations and reconciliation processes, to ensure high accuracy and reliability.

Delivered real-time visibility of total plant costs via a centralized data warehouse, replacing manual cross-system lookups and eliminating reliance on FINSUM for final cost aggregation.

Reduced ITO decision-making cycle by 40%, accelerating cost estimation and pricing responses in customer proposal phases.

Achieved data harmonization across 4+ legacy systems, boosting data accuracy, auditability, and reporting consistency for the pricing teams.

Supported executive dashboards in Power BI and Excel, delivering clean, performant, and trusted data marts for financial and strategic decision-making.

Environment: Informatica, PL/SQL, Oracle, SQL, Star Schema, Data Warehousing, ETL, Data Modeling, Power BI.

Company: Infosys

Client: Fidelity Investments, India. 2014 – 2017

Role: Database Developer

Project Title: Liberator

Project Description: Liberator is an enterprise-level metrics portal developed for Fidelity Investments, designed to aggregate operational data from multiple IT systems into a set of normalized, consistent data domains. The application provided a unified infrastructure to enable standardized data aggregation and reporting across technology and business domains, helping stakeholders with improved data visibility and decision-making capabilities.

Roles & Responsibilities:

Developed and maintained database components including Packages, Stored Procedures, Functions, and Triggers using PL/SQL to support robust backend processing.

Designed and implemented ETL mappings and complex data transformations using Informatica PowerCenter 9.0.1 for seamless data integration across systems.

Participated in Agile ceremonies, worked on project tasks and user stories using JIRA, and collaborated closely with cross-functional teams.

Managed and resolved change requests and production defects as part of the system maintenance and support lifecycle.

Authored and executed complex SQL queries for data profiling and validating data accuracy between source systems and the enterprise data warehouse.

Scheduled, monitored, and maintained ETL jobs using AutoSys, ensuring timely data loads and addressing any job failures or delays.

Developed custom reports in SQL and PL/SQL based on end-user requirements for operational metrics and performance tracking.

Streamlined the data flow architecture by integrating multiple IT systems into a single reporting layer, reducing reporting time and manual intervention.

Improved data quality and reliability by implementing comprehensive validation rules and reconciliation processes within the ETL pipeline.

Successfully supported multiple business domains by delivering tailored reports with precise and actionable metrics, enhancing operational transparency.

Environment: PL/SQL, Informatica PowerCenter 9.0.1, SQL, AutoSys, Data Warehousing, Agile, JIRA.

Company: Wipro

Client: Force Motors, India. 2013-2014

Role: Analyst Programmer

Project Title: Force Dealer Management System (FDMS)

Project Description: The Force Dealer Management System (FDMS) is a centralized application designed to streamline inventory, spare parts management, and dealership operations for Force Motors. The system involved heavy customization and support for legacy Oracle-based infrastructure.

Roles & Responsibilities:

Developed PL/SQL modules to automate inventory control and spares operations, enhancing operational efficiency.

Customized and maintained Oracle D2K reports for business users, enabling legacy report continuity with improved formatting.

Created and supported database links (DB Links) and external interfaces to integrate legacy systems with FDMS, ensuring consistent data flow across systems.

Enabled smooth data synchronization between legacy systems and FDMS, minimizing integration issues.

Reduced manual errors in spares tracking by introducing automated validation logic within PL/SQL modules.

Delivered performance-tuned reports that improved visibility into parts inventory and dealer performance.

Environment: PL/SQL, Oracle D2K, Oracle DB Links, Legacy System Integration.

Company: Wipro

Client: Mahindra & Mahindra, India. 2011 – 2013

Role: Analyst Programmer

Project Title: Dealer Management System (DMS)

Project Description: The Dealer Management System (DMS) for Mahindra & Mahindra was developed to manage automobile dealership operations covering parts, billing, and service modules. The application helped automate dealer-level operations and enabled real-time reporting for internal teams and partners.

Roles & Responsibilities:

Developed business-critical PL/SQL logic to manage operations in the parts, billing, and vehicle service domains.

Designed and normalized relational data models, significantly improving query performance and system responsiveness.

Maintained comprehensive technical documentation and ensured version control compliance across database artifacts.

Participated in database reengineering and enhancement initiatives to align with evolving business requirements.

Enhanced system scalability by redesigning poorly normalized tables into third normal form (3NF).

Reduced query response times by up to 30% through SQL tuning and indexing strategies.

Played a key role in migrating business logic from flat-file systems to relational PL/SQL-based modules, improving maintainability.

Environment: PL/SQL, Data Modeling, Database Optimization, Version Control.

Contact this candidate