Summary

Overview

Work History

Education

Skills

Websites

Core competencies

Timeline

Chandana Duggasani

Northlake,USA

Summary

Database Engineer / PostgreSQL DBA with 5 years of experience in SQL development, database reliability, and cloud database management (AWS, Azure). Strong expertise in query optimization, ETL pipelines, and performance tuning across PostgreSQL, SQL Server, and Oracle. Experienced in high availability, replication, automation, and production incident management. Proven ability to build scalable data systems, optimize database performance, and support mission-critical applications with high availability and low latency.

Overview

years of professional experience

Work History

DATABASE ADMINISTRATOR

State of Georgia

GEORGIA, USA

01.2024 - Current

Managed and optimized PostgreSQL databases supporting state-wide applications, improving query performance by 40%+ through indexing and query tuning
Designed and implemented disaster recovery solutions using PITR, ensuring data integrity and high availability
Built and optimized complex SQL queries, stored procedures, and PL/pgSQL functions for scalable data processing
Implemented database monitoring and alerting using Prometheus and Grafana, proactively resolving performance issues
Automated database maintenance tasks (backups, vacuuming, indexing) using Python and Bash scripts
Conducted root cause analysis (RCA) for production incidents and improved system reliability
Managed and maintained cloud databases on AWS RDS and Azure SQL, ensuring high availability and performance
Migrated and optimized PL/SQL workloads to PostgreSQL, ensuring seamless transition and performance stability
Collaborated with development teams to optimize data models and improve query efficiency

SQL DATABASE ADMINISTRATOR

State of Kansas

Kansas City, MO, USA

02.2023 - 12.2024

Administered PostgreSQL 12/13 databases in on-premises and AWS RDS environments, ensuring high availability and performance
Developed and maintained ETL pipelines for data migration and transformation across heterogeneous database systems
Implemented partitioning and indexing strategies, improving query performance on large datasets
Designed and optimized T-SQL queries, stored procedures, and views, enhancing data processing efficiency
Performed query tuning using execution plans, reducing latency and improving performance
Automated backup and restore processes, ensuring reliable disaster recovery and data availability
Monitored and resolved deadlocks, blocking, and performance bottlenecks in production systems
Managed database patching, storage optimization, and capacity planning across multiple production servers
Developed and optimized PL/SQL and T-SQL stored procedures, improving data processing efficiency across Oracle and SQL Server systems

POSTGRESQL DATABASE ADMINISTRATOR

State of Florida

Florida, USA

09.2022 - 02.2023

Provided PostgreSQL support and performance optimization for government applications, ensuring high availability and reliability
Migrated legacy Oracle databases to PostgreSQL, reducing licensing costs and improving system efficiency
Assisted in designing high-availability architecture using Logical Replication
Monitored database health and query performance using pgBadger, Prometheus, and Grafana
Built and validated ETL pipelines, performing data transformation, reconciliation, and ensuring data accuracy
Optimized large datasets using partitioning and indexing strategies, improving query performance
Administered and supported Oracle databases, including performance tuning, query optimization, and schema management
Migrated Oracle (PL/SQL) workloads to PostgreSQL, converting stored procedures and ensuring performance stability

POSTGRESQL DBA

Citibank

07.2021 - 08.2022

Managed large-scale PostgreSQL databases supporting financial applications, ensuring high availability and performance
Improved database response time by 30% through query tuning, indexing, and execution plan optimization
Designed and maintained streaming replication for high availability and disaster recovery
Automated database maintenance tasks (vacuuming, indexing, monitoring) using Python and Bash scripts
Ensured compliance with banking security standards by implementing role-based access control (RBAC) and encryption
Developed complex SQL queries to support financial data processing and reporting