Summary
Overview
Work History
Education
Skills
Timeline
Generic

VENKATA CHANDANA

Northlake

Summary

Results-driven PostgreSQL Database Administrator (DBA) with 4+ years of experience managing and optimizing large-scale databases in banking, retail, and government sectors. Expertise in database administration, performance tuning, high availability, backup & recovery, and automation using Bash/Python. Adept at working with cross-functional teams, ensuring database security, and implementing cloud-based solutions.

Overview

4
4
years of professional experience

Work History

Database Administrator

State of Georgia
01.2024 - 02.2025
  • Maintained and optimized PostgreSQL databases supporting state-wide applications.
  • Designed disaster recovery solutions using Point-in-Time Recovery (PITR).
  • Improved query execution time by 40% through indexing and performance tuning.
  • Created detailed database documentation for ongoing DBA support.
  • Troubleshooting DB connectivity, login failure and permissions issues.
  • Monitoring all production servers, Implementing DR backup recovery testing.
  • Deploying DB maintenance jobs in newly build servers.
  • DB Creation, Object Creation, Login Creation, Role/user creation on SQL servers.
  • Experienced Azure SQL Database Administrator/Developer with expertise in designing, deploying, and managing cloud-based SQL solutions on Microsoft Azure.
  • Strong understanding of PaaS (Platform as a Service) and IaaS (Infrastructure as a Service) models for SQL workload
  • Extensive experience in writing and optimizing PL/SQL scripts and stored procedures, leveraging Oracle’s procedural capabilities in PostgreSQL via PL/pgSQL.
  • Proficient in migrating and adapting PL/SQL code to PostgreSQL, ensuring smooth transitions and maintaining performance.

PostgreSQL DBA Consultant

State of Kansas
02.2023 - 12.2024
  • Administered PostgreSQL 12/13 instances in on-premises and cloud (AWS RDS) environments.
  • Developed ETL pipelines to migrate data between PostgreSQL and other database systems.
  • Implemented partitioning strategies to improve query performance on large datasets.
  • Automated backup and restore processes to ensure 100% data availability.
  • Shrinking the DB files, DB rebalancing and patching the more production servers at a time.
  • Skilled in performance tuning, database migration, security, and high availability strategies for Azure SQL.
  • Strong command of MySQL architecture and best practices, supporting cross-database query optimization and performance tuning.
  • Leveraged MySQL’s features (e.g., replication, partitioning) in mixed database environments with PostgreSQL.

PostgreSQL Database Administrator

State of Florida
09.2022 - 02.2023
  • Provided PostgreSQL support and performance optimization for government applications.
  • Migrated legacy Oracle databases to PostgreSQL, reducing licensing costs.
  • Assisted in designing a high-availability architecture using PostgreSQL Logical Replication.
  • Monitored database health and query performance using pgBadger, Prometheus, and Grafana.

PostgreSQL DBA

Citibank
07.2021 - 08.2022
  • Managed large-scale PostgreSQL databases supporting financial applications.
  • Implemented query performance tuning strategies that improved database response times by 30%.
  • Designed and maintained Streaming Replication for high availability and disaster recovery.
  • Automated database maintenance tasks (index rebuilding, vacuuming) using Python and Bash scripts.
  • Ensured compliance with banking security standards by enforcing role-based access controls and SSL encryption.

Education

G.Narayanamma Institute Of Technology And Science
01.2019

Skills

  • PostgreSQL Installation, Configuration, and Upgrades
  • SQL & PL/pgSQL (Stored Procedures, Functions, Triggers)
  • Performance Tuning (Indexing, Query Optimization, Vacuum/Analyze)
  • High Availability & Replication (Streaming, Logical, Failover)
  • Backup & Recovery (pg_dump, pg_basebackup, PITR)
  • Security & Access Control (Roles, Authentication, SSL, Encryption)
  • Monitoring & Automation (pgBadger, Prometheus, Grafana, Python, Bash)
  • Cloud Database Management (AWS RDS, Azure PostgreSQL)
  • ETL & Data Migration (Oracle to PostgreSQL, pgLoader, FDW)
  • DevOps & CI/CD (Docker, Kubernetes, Ansible, Git, Jenkins)

Timeline

Database Administrator

State of Georgia
01.2024 - 02.2025

PostgreSQL DBA Consultant

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

Similar Profiles

CREATE PROFILE
VENKATA CHANDANA