Senior PostgreSQL/Oracle Cloud Database Engineer

Lakshmi Kundrapu

Senior PostgreSQL/Oracle DBA / Cloud Database Engineer

*************@*****.*** +1-980-***-****

SUMMARY

Senior Database Engineer with 7+ years of experience in PostgreSQL and Oracle database administration, SQL development, and cloud-based data platforms.

Expert in heterogeneous (Oracle PostgreSQL) and homogeneous (PostgreSQL PostgreSQL / AWS) migrations, with strong hands-on experience in production support.

Strong experience implementing high availability and disaster recovery solutions using streaming replication, logical replication, replication slots, failover strategies and read replicas.

Hands-on experience with PostgreSQL ecosystem and third-party tools like Patroni,pgBouncer(connection pooling),pgBackRest and Barman (backup and recovery),pgAdmin(administration),Prometheus and Grafana (monitoring),pgBadger(log analysis).

Good knowledge on PostgreSQL internals like WAL mechanism,MVCC,vacuum processing, query planner and optimizer, connection handling and lock management.

Expertise in PostgreSQL performance tuning, query optimization using EXPLAIN ANALYZE, indexing strategies, vacuum and auto vacuum tuning, Wal management, backup and recovery, database installation and upgrade.

Experienced in database security administration, access control management and recovery during critical production installation.

Strong background in Oracle database administration, including RMAN backup strategies, AWR analysis, patching, and troubleshooting critical production issues.

Hands on experience in DevOps practices, including CI/CD pipeline implementation using Jenkins for database deployments and release automation.

Strong expertise in Infrastructure as Code (Iac) using Terraform for provisioning and managing AWS cloud services

Experienced in containerization and orchestration technologies such as Docker and Kubernetes for deploying and managing database workloads.

Proficient in automating database administration tasks using Python and AWS CLI to improve efficiency and reliability.

Experienced in designing AI driven database solutions including building AI agents for PostgreSQL to assist in query optimization, monitoring insights, and operational automation along with prompt engineering techniques to enhance developer productivity and database interaction workflow.

Proven ability to manage multi-terabyte databases, ensure high availability (99.99%), and quickly resolve complex production incidents.

Maintained runbooks and SOPS to standardize DBA operations and reduce repeat incidents.

SKILLS

Cloud Platforms: AWS RDS, Aurora PostgreSQL, EC2, DMS, VPC, IAM, S3 Extension.

Databases: PostgreSQL (9.x–15+), EDB Postgres, Oracle (11g, 12c) – Architecture, Administration, Performance Tuning

Cloud & DevOps: AWS (RDS, Aurora PostgreSQL, EC2, DMS, VPC, IAM, CloudWatch), Terraform (Infrastructure as Code), Kubernetes (StatefulSets, containerized DB workloads), Jenkins

Languages & Development: SQL (Advanced), PL/SQL (Basic), Bash Shell Scripting, CLI automation, Python.

Oracle PostgreSQL (ora2pg, MTK), Homogeneous: PostgreSQL PostgreSQL / AWS, Zero-downtime migrations using logical replication & AWS DMS

pgBackRest, Barman, PITR, WAL archiving, Oracle: RMAN (Full, Incremental, Archive log backups, Recovery)

High Availability & Replication: Patroni, pgpool-II, Streaming Replication, Replication lag troubleshooting & sync validation

Performance Tuning: EXPLAIN/ANALYZE, indexing, partitioning, AWR report analysis (Oracle), pg_repack, vacuum tuning, bloat management

Monitoring & Observability: Grafana, Prometheus, AWS CloudWatch, pgBadger, AWR

Security: RBAC, encryption, auditing, database hardening

Tools: pgAdmin, SQL*Plus, Jenkins, Git

Operating Systems: Linux, Unix

EDUCATION

Bachelors in electronics and instrumentation engineering April 2019, India

EXPERIENCE

Senior Software Engineer (DBA / Developer) Voya Financial Services Jun 2023 – Present, OH, Remote

•Managed PostgreSQL databases supporting OLTP workloads exceeding 2TB and 50K+ transactions per minute.

•Led heterogeneous (Oracle PostgreSQL) and homogeneous (PostgreSQL AWS) migrations.

•Hands on experience with upgrades of AWS RDS & Aurora databases.

•Implemented pgBackRest and Barman for enterprise backup and recovery strategies.

•Designed HA solutions using Patroni and pgpool-II with automated failover, resolved replication lag issues in real-time, ensuring master-slave synchronization.

•Proactively fixed wraparound risks and vacuum-related issues, preventing downtime.

•Performed advanced performance tuning using EXPLAIN, indexing, and partitioning.

•Acted as an escalation point for complex database incidents, including performance degradation. Failover events and recovery scenarios.

•Monitored PostgreSQL performance using pg_stat_statements and validated connection pooling behavior with PgBouncer.

•Troubleshoot database performance issues involving blocking,deadlocks,long-running queries, CPU/memory pressure and I/O bottlenecks using wait stats and execution plans

•Built monitoring dashboards using Grafana and Prometheus.

•Integrated CloudWatch alerts for proactive monitoring.

•Strengthened database security, auditing, and access control and led database hardening, including auditing,RBAC,SSL/TLS configuration and Active directory integration.

•Collaborated with platform teams supporting PostgreSQL workloads deployed in Kubernetes environments.

•Led development of Python automation for Oracle and PostgreSQL administration (backups, health checks, user and space management), cutting manual DBA workload and reducing recurring production incidents across 7 years of 24x7 environments.

•Spearheaded the migration of legacy database workloads to AWS Aurora PostgreSQL, ensuring data integrity and minimal application downtime during the transition.

•Implemented CI/CD pipelines using Jenkins to automate database deployment, schema migrations and release validation across environments.

•Utilized AWS CLI to manage RDS and Aurora PostgreSQL instances including snapshot creation, automated backups, scaling and failover operations.

•Developed and maintained Terraform scripts to provision and manage AWS infrastructure, including RDS, EC2, VPC and IAM resources

•Configured AWS Aurora Global Databases to provide low latency reads and robust disaster recovery capabilities across multiple geographic regions.

•Implemented advanced monitoring and alerting using CloudWatch and Performance Insights to track CPU usage, memory consumption, and disk I/O metrics.

•Integrated the aws_s3 extension to facilitate efficient data import and export operations directly between Aurora and Amazon S3 buckets.

•Orchestrated regular disaster recovery exercises to validate point-in-time recovery (PITR) and cross-region failover procedures for production environments.

•Managed IAM roles and database permissions to enforce the principle of least privilege and ensure secure data access across all environments.

Software Engineer (DBA / Developer) Infosys Aug 2022 – Mar 2023, India

•Hands on experience with setting up, monitoring and maintaining PostgreSQL instances.

•Hands on experience with implementing and maintaining PostgreSQL backup and recovery processes.

•Managed PostgreSQL environments and resolved replication lag issues, ensuring synchronization between master and standby.

•Query and system-level performance analysis like diagnosing slow queries, optimizing execution plans.

•Managed database parameters, memory tuning and instance configuration.

•Identified and fixed vacuum and wraparound issues, improving database stability.

•Implemented monitoring solutions and proactively resolved performance bottlenecks.

•Designed and maintained database objects such as tables,indexes,views and materialized views for performance and scalability.

•Wrote reusable scripts for data extraction, transformation and reporting, supporting application and analytics needs.

•Designed and optimized AWS Aurora clusters using multi-AZ deployments and read replicas for high availability, performance, and cost efficiency.

•Automated routine tasks using shell scripting and cron jobs.

Software Engineer (DBA) TCS May 2019 – Jul 2022, India

•Oracle DBA Responsibilities:

•Installed, configured, and upgraded Oracle databases (11g, 12c).

•Strong understanding of Oracle architecture (SGA, PGA, background processes, memory structures).

•Performed export/import (Data Pump) for data migration and backup purposes.

•Managed database patching and upgrades ensuring system stability.

•Configured and maintained RMAN backups (Full, Incremental, Archive logs).

•Performed Point-In-Time Recovery (PITR) and recovery operations.

•Implemented basic disaster recovery concepts and strategies.

•Analyzed AWR reports to identify and resolve slow-performing queries.

•Monitored and analyzed alert logs and trace files for troubleshooting.

•Handled tablespace management, storage issues, and capacity planning.

•Resolved database down issues, listener problems, and connectivity issues.

•Managed users, roles, and privileges ensuring secure access control.

•Actively worked on production tickets, troubleshooting, and resolving critical issues.

•PostgreSQL Responsibilities:

•Managed PostgreSQL databases including installation, upgrades, and maintenance.

•Worked on many incidents and closed many tickets and helped in resolving issue in short period of time

•Performed or developed assigned tasks using established procedure, policies and process

•Monitor alerts of database and take quick actions accordingly

•Creation and management of roles and support to users

•Performed backup and recovery operations (PITR, WAL management).

•Used pg_repack for performance improvement and bloat removal.

•Prepared documents and presentations wherever possible and gave knowledge sessions

•I like to solve problems this attitude played a major role in our project on troubleshooting production issues in critical situations and received many appreciations from clients as well as from our functional bodies

•Proactively picked many tasks and learned disaster recovery, master/slave.

•Responsible for weekly backup and hot backup

•Worked on storage management and tablespace issues

•Hands on Expertise on dblink setup from oracle to postgres and postgres to postgres

•Performed backup/restore activities and cloned many databases.

•Worked closely with the development team for monitoring, optimizing, tuning the databases, and promoting process improvement.

•Performed vacuum activities on tables in postgresql.

Contact this candidate