Summary
Overview
Work History
Education
Skills
Websites
Core competencies
Timeline
Generic

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

5
5
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

Education

MASTER'S - COMPUTER SCIENCE

University of Central Missouri
Missouri City, MO
05-2021

G.Narayanamma Institute of Technology And Science
Hyderabad
07-2019

Skills

    Databases: PostgreSQL, SQL Server, Oracle, MySQL
    Query Languages: SQL, PL/pgSQL, T-SQL, PL/SQL
    Cloud: AWS RDS, Azure SQL Database
    Monitoring: pgBadger, Prometheus, Grafana
    ETL & Migration: pgLoader, FDW
    DevOps: Docker, Kubernetes, Jenkins, Git
    Scripting: Python, Bash

Core competencies

  • SQL Development & Query Optimization
  • Database Reliability Engineering (DBRE)
  • PostgreSQL / SQL Server / Oracle Administration
  • ETL Development & Data Validation
  • Cloud Databases (AWS RDS, Azure SQL)
  • Performance Tuning & Indexing
  • High Availability & Disaster Recovery
  • Monitoring & Automation

Timeline

DATABASE ADMINISTRATOR

State of Georgia
01.2024 - Current

SQL DATABASE ADMINISTRATOR

State of Kansas
02.2023 - 12.2024

POSTGRESQL DATABASE ADMINISTRATOR

State of Florida
09.2022 - 02.2023

POSTGRESQL DBA

Citibank
07.2021 - 08.2022

G.Narayanamma Institute of Technology And Science

MASTER'S - COMPUTER SCIENCE

University of Central Missouri
Chandana Duggasani