Senior PostgreSQL DBA for Cloud Migrations

ANIL KUMAR MARAM

Senior PostgreSQL Database Administrator AWS RDS Azure Database Cloud Migration

989-***-**** *********************@*****.*** linkedin.com/in/anil5434/ Atlanta, GA

PROFESSIONAL SUMMARY

Senior PostgreSQL Database Administrator with 7+ years of experience administering, optimizing, and supporting enterprise database environments across healthcare, banking, retail, telecom, and engineering domains. Strong expertise in PostgreSQL architecture, installation, configuration, patching, upgrades, performance tuning, query optimization, indexing, backup and recovery, disaster recovery, and production support.

Experienced with PostgreSQL, SQL Server, Oracle, AWS RDS, Azure SQL, and cloud database modernization across production and non-production environments. Skilled in PostgreSQL internals including WAL, MVCC, vacuum/autovacuum, execution plans, logical replication, streaming replication, and high-availability database operations.

Strong background in on-premises to cloud migrations, backup strategies, disaster recovery planning, failover validation, automation using Shell, Python, PowerShell, Terraform, and Ansible, and collaboration with application, DevOps, infrastructure, cloud, and security teams to improve database performance, reliability, scalability, and availability.

TECHNICAL SKILLS

Databases

PostgreSQL, Microsoft SQL Server 2016/2017/2019/2022, Oracle 12c, AWS RDS, Azure SQL Database, Azure Database for PostgreSQL

PostgreSQL Administration

Installation, Configuration, Patching, Upgrades, Database Refresh, User Management, Backup & Recovery, Disaster Recovery

PostgreSQL Internals

WAL, MVCC, Vacuum, Autovacuum, Memory Management, Query Planner, Execution Plans, Indexing, Tablespaces

High Availability & Replication

repmgr, Streaming Replication, Logical Replication, Failover, Node Recovery, Clustering, RPO/RTO, Business Continuity

Performance & Monitoring

Query Optimization, Index Tuning, EXPLAIN, EXPLAIN ANALYZE, Capacity Planning, pgAdmin, Prometheus, Grafana, Troubleshooting

Automation & Tools

Shell Scripting, Python, PowerShell, Terraform, Ansible, Git, Azure DevOps, ServiceNow, Jira, Linux, Windows Server, Agile, ITIL

PROFESSIONAL EXPERIENCE

Senior PostgreSQL Database Administrator Johnson & Johnson

05/2025 - Present

New Brunswick, NJ

Administered, configured, maintained, and optimized enterprise PostgreSQL database environments supporting healthcare, manufacturing, supply chain, ERP, and business-critical applications.

Managed PostgreSQL database administration activities across Production, QA, UAT, and Development environments, including installation, patching, upgrades, database refreshes, user management, and access controls.

Monitored PostgreSQL database performance using execution plans, indexing analysis, query tuning, vacuum/autovacuum review, memory configuration, and workload analysis to improve application response time.

Supported PostgreSQL high availability and disaster recovery solutions using streaming replication, logical replication, failover planning, node recovery, backup validation, and business continuity procedures.

Implemented and maintained backup and recovery strategies using native PostgreSQL utilities and enterprise backup processes to ensure data integrity, recoverability, and compliance readiness.

Supported on-premises to cloud database modernization initiatives involving PostgreSQL, AWS RDS, Azure Database services, SQL Server, and Oracle database platforms.

Troubleshot complex production issues related to database performance, replication lag, locking, connectivity, storage, failed jobs, and application query behavior.

Developed automation scripts using Shell, Python, PowerShell, and SQL to streamline database monitoring, health checks, maintenance tasks, backup validation, and operational reporting.

Partnered with application, DevOps, infrastructure, cloud, and security teams to review database changes, support deployments, optimize SQL code, and improve platform reliability.

Maintained operational runbooks, database standards, troubleshooting guides, recovery procedures, change records, and support documentation for enterprise database operations.

Participated in incident management, root cause analysis, change management, production support, on-call rotations, and continuous improvement activities to ensure database availability and stability.

Environment: PostgreSQL, PostgreSQL Administration, WAL, MVCC, Vacuum, Autovacuum, Streaming Replication, Logical Replication, repmgr, Backup & Recovery, Disaster Recovery, pg_dump, pg_restore, pg_basebackup, EXPLAIN, EXPLAIN ANALYZE, Index Tuning, Query Optimization, Microsoft SQL Server 2019/2022, Oracle 12c, AWS RDS, Azure SQL Database, Azure Database for PostgreSQL, pgAdmin, Prometheus, Grafana, Shell Scripting, Python, PowerShell, SQL, Terraform, Ansible, Git, Azure DevOps, ServiceNow, Jira, Linux, Windows Server, Agile, SDLC, ITIL, Incident Management, Change Management, Problem Management, Business Continuity, On-Call Production Support.

Senior PostgreSQL Database Administrator JPMorgan Chase

06/2022 - 03/2025

Plano, TX

Administered, monitored, and optimized enterprise PostgreSQL database environments supporting core banking, payments, treasury, credit risk, financial reporting, and high-volume OLTP applications in a 24 7 production environment.

Managed PostgreSQL database administration activities across Production, QA, UAT, and Development environments, including installation, configuration, patching, upgrades, database refreshes, user management, and access controls.

Performed PostgreSQL performance tuning by analyzing execution plans, query behavior, indexing strategies, vacuum/autovacuum processes, memory settings, locks, replication lag, and workload patterns.

Supported high availability and disaster recovery solutions using streaming replication, logical replication, repmgr clustering, failover planning, node recovery, backup validation, and business continuity procedures.

Implemented backup and recovery processes using native PostgreSQL utilities and enterprise backup methods to support data protection, point-in-time recovery, and recovery testing.

Supported on-premises to cloud database migration and modernization initiatives involving PostgreSQL, AWS RDS, Azure Database services, SQL Server, and Oracle database platforms.

Troubleshot complex production issues involving database performance degradation, slow queries, locking, blocking, replication failures, storage constraints, connectivity issues, and failed database jobs.

Automated database health checks, monitoring, maintenance, backup validation, operational reporting, and deployment support using Shell scripting, Python, PowerShell, SQL, and enterprise scheduling tools.

Partnered with application development, DevOps, infrastructure, cloud, cybersecurity, and business teams to review database changes, optimize SQL code, support releases, and improve database reliability.

Maintained database standards, operational runbooks, troubleshooting guides, recovery procedures, RCA documentation, change records, and knowledge-sharing materials to support compliance and operational excellence.

Participated in production support, on-call rotations, incident management, problem management, change management, release management, root cause analysis, and continuous improvement of database operations.

Environment: PostgreSQL, PostgreSQL Administration, WAL, MVCC, Vacuum, Autovacuum, Streaming Replication, Logical Replication, repmgr, Backup & Recovery, Disaster Recovery, pg_dump, pg_restore, pg_basebackup, Point-in-Time Recovery, EXPLAIN, EXPLAIN ANALYZE, Index Tuning, Query Optimization, Microsoft SQL Server 2019, Oracle 12c, AWS RDS, Azure SQL Database, Azure Database for PostgreSQL, pgAdmin, Prometheus, Grafana, Shell Scripting, Python, PowerShell, SQL, Terraform, Ansible, Git, Azure DevOps, ServiceNow, Jira, Linux, Windows Server, Agile, SDLC, ITIL, Incident Management, Change Management, Problem Management, Release Management, Business Continuity, On-Call Production Support.

Database Administrator Walmart

05/2021 - 05/2022

Bentonville, AR

Supported enterprise SQL Server environments for Walmart's retail, e-commerce, inventory management, supply chain, and point-of-sale (POS) applications across Production, QA, UAT, and Development environments.

Planned and executed database migration projects from on-premises SQL Server environments to AWS RDS for SQL Server, ensuring minimal downtime and data integrity.

Worked closely with application developers and DevOps teams to support CI/CD database deployments, schema versioning, and release automation using Azure DevOps and Git.

Designed and implemented database partitioning, compression, and archival strategies to improve query performance and efficiently manage large transactional datasets.

Optimized ETL workloads by collaborating with data engineering teams, reducing batch processing time and improving data availability for business reporting.

Configured and monitored AWS RDS parameter groups, option groups, snapshots, maintenance windows, Multi-AZ deployments, and storage auto-scaling.

Developed PowerShell and T-SQL automation scripts to streamline environment provisioning, database health reporting, maintenance scheduling, and operational monitoring.

Performed database performance analysis using Extended Events, Query Store, and Dynamic Management Views (DMVs), identifying bottlenecks and recommending tuning strategies.

Collaborated with cybersecurity teams to implement database auditing, encryption, vulnerability remediation, and compliance controls for sensitive retail customer data.

Partnered with infrastructure and cloud engineering teams to optimize SQL Server resource utilization, storage allocation, and high-availability configurations across enterprise environments.

Environment: Microsoft SQL Server 2019, AWS RDS for SQL Server, Amazon EC2, SQL Server Management Studio (SSMS), T-SQL, Query Store, Extended Events, Dynamic Management Views (DMVs), PowerShell, Windows Server 2019, AWS CloudWatch, AWS Backup, AWS KMS, Git, Azure DevOps, ServiceNow, Jira, Active Directory, ITIL.

Database Administrator Vodafone Idea Limited

11/2020 - 04/2021

Hyderabad, India

Administered SQL Server 2017/2019 production databases supporting telecom billing, CRM, subscriber, and network management systems.

Configured and maintained Always On Availability Groups, Log Shipping, and Replication to ensure high availability and disaster recovery.

Performed SQL Server installation, configuration, cumulative updates, and version upgrades with minimal production downtime.

Monitored production databases using SSMS, SQL Profiler, DMVs, and PerfMon to proactively identify performance bottlenecks.

Optimized complex SQL queries, stored procedures, and indexing strategies, improving application performance.

Automated database administration tasks using PowerShell, T-SQL, and SQL Server Agent, reducing manual operational effort.

Coordinated production releases, schema deployments, and database migrations with development and infrastructure teams.

Performed database capacity planning, storage forecasting, and disaster recovery testing to ensure business continuity.

Environment: Microsoft SQL Server 2017/2019, SQL Server Management Studio (SSMS), T-SQL, SQL Server Agent, SQL Server Always On Availability Groups, Log Shipping, Transactional Replication, SQL Profiler, Dynamic Management Views (DMVs), DBCC CHECKDB, PowerShell, Windows Server 2016/2019, Performance Monitor (PerfMon), Active Directory, ServiceNow, Jira, Git, ITIL, Backup & Recovery, Disaster Recovery, Performance Tuning, Capacity Planning.

Associate Database Administrator Cyient Ltd

01/2019 - 10/2020

Hyderabad, India

Assisted in administering Microsoft SQL Server 2016/2017 and Oracle databases supporting enterprise engineering and business applications.

Performed daily database health checks by monitoring SQL Server services, backup status, database growth, disk space, and failed SQL Server Agent jobs.Managed Full, Differential, and Transaction Log Backups, performed database restores, and verified backup integrity to ensure recoverability.

Executed routine database maintenance activities, including index rebuilds, statistics updates, and DBCC CHECKDB to maintain database performance and consistency.

Assisted in creating and managing database users, logins, roles, and permissions while following organizational security policies. Monitored and optimized SQL queries, stored procedures, and indexes using SSMS, execution plans, and Dynamic Management Views (DMVs).

Created and maintained SQL Server Agent Jobs for scheduled backups, maintenance plans, and routine administrative tasks.

Collaborated with senior DBAs and application teams to troubleshoot production database issues, resolve incidents, and maintain operational documentation.

Environment: Microsoft SQL Server 2016/2017, Oracle Database 12c, SQL Server Management Studio (SSMS), T-SQL, SQL Server Agent, Oracle SQL Developer, Windows Server 2012 R2/2016, SQL Profiler, Dynamic Management Views (DMVs), DBCC CHECKDB, Backup & Recovery, Log Shipping, Replication, PowerShell, Performance Monitor (PerfMon), ServiceNow, Jira, Git, ITIL.

EDUCATION

Master of Science (M.S.) in Computer Science

Auburn University at Montgomery, Montgomery, AL

Bachelor of Technology (B.Tech.) in Computer Science & Engineering

SRKR Engineering College, Bhimavaram, India

Contact this candidate