Summary
Overview
Work History
Education
Skills
Languages
Technicalsummary
Personal Information
Timeline
Generic
Soujanya Reddy

Soujanya Reddy

Hyderabad

Summary

PostgreSQL DBA with 3+ years of experience on AWS cloud (RDS/Aurora Postgres). Expertise in PostgreSQL installation, configurations, backup & restore, high availability, security, performance tuning, user maintenance, PITR, and upgradation. Proficient with backup and recovery using hot and cold physical backup and recovery, traditional utilities like Pg_dump, pg_dumpall, pg_basebackup, and pg_restore. Knowledgeable in incident, change, and problem management processes. Experienced in database server setup, high availability, hot-streaming replication. Effective at managing and maintaining database operations utilizing Amazon RDS, ensuring optimal performance, high availability, and scalability. Skilled in Amazon Web Services (AWS) including EC2, RDS, S3, AMI, IAM, VPC, Auto Scaling, and CloudWatch.

Overview

3
3
years of professional experience

Work History

PostgreSQL DBA

Sanofi
  • Install and configure PostgreSQL using source code, RPM, and one-click installation
  • Perform backup and recovery of PostgreSQL databases
  • Configure PEM (Postgres Enterprise Manager) and PG_Admin tools
  • Maintain and optimize database and application performance through tuning
  • Handle database logical and physical backups
  • Apply database patches and upgrade databases
  • Refresh Test, Dev, and QA environments with the latest data from production
  • Generate database log analysis reports using pg_badger
  • Perform maintenance activities such as statistics collection, vacuuming, and reindexing
  • Attend weekly and scheduled meetings
  • Ensure DB availability, security, and reliability
  • Install customized extensions like Pg_stat_statement, postgres_fwd, pg_buffercatche
  • Manage capacity for effective resource utilization.

PostgreSQL DBA

Innosoft Datalinks Pvt Ltd
01.2021 - Current
  • Monitor and maintain databases for optimal performance and availability
  • Create RDS instances, enable backups, enhanced monitoring, performance insights, and create CloudWatch alerts
  • Prepare weekly and monthly reports for capacity planning
  • Provide 24x7 production database on-call support
  • Schedule maintenance jobs (analyze, vacuum, vacuum full, reindex)
  • Ensure DB availability, security, and reliability
  • Configure and schedule backups of PostgreSQL databases
  • Configure PEM (Postgres Enterprise Manager) and PG_Admin tools for database connectivity from client locations
  • Generate database log analysis reports using pg_badger to identify and tune resource-intensive queries
  • Experience in IAM user creation and CLI setup
  • Maintain and optimize database and application performance through tuning
  • Provide application deployment support
  • Create and manage scheduled jobs using crontab for automated task execution
  • Configure VPC settings and manage S3 buckets for cloud storage solutions
  • Apply database patches and upgrade databases from lower to higher versions
  • Perform database maintenance activities, including statistics collection, vacuuming bloated tables, and reindexing
  • Install customized extensions like Pg_stat_statement.

Education

BCom Computers -

Hindu Degree College for Women
01.2006

Skills

  • Ensuring high availability and replication
  • Managing backups, recovery, and security
  • Monitoring and maintaining database performance
  • Troubleshooting database issues
  • Effective communication skills

Languages

English
Hindi
Telugu

Technicalsummary

Windows, Linux RHEL, PostgreSQL 10, PostgreSQL 11, PostgreSQL 12, PostgreSQL 13, PostgreSQL 14, AWS (Aurora, RDS), PG_Admin, DBeaver, pgwatch2

Personal Information

Title: Database Administrator

Timeline

PostgreSQL DBA

Innosoft Datalinks Pvt Ltd
01.2021 - Current

PostgreSQL DBA

Sanofi

BCom Computers -

Hindu Degree College for Women

Similar Profiles

CREATE PROFILE
Soujanya Reddy