SWATHI SOMA
Austin,USA
Summary
Database Administrator with extensive experience architecting, optimizing, and managing PostgreSQL and MSSQL environments. Skilled in large‑scale database migrations, high availability and disaster recovery engineering, and performance tuning across complex workloads. Strong background in automation using Python and shell scripting, cloud database management on AWS (EC2, RDS), and implementing secure, resilient, and scalable database solutions.
Overview
6
6
years of professional experience
Work History
Database Administrator
Infosys
Hyderabad, INDIA
12.2019 - 07.2023
- Administer, develop, test, and support PostgreSQL databases across Dev, QA, Beta, and Production environments, with additional experience managing MySQL where required.
- Design, implement, and maintain PostgreSQL database architectures, including configuration management, backup/recovery strategies, and environment provisioning.
- Install, configure, and maintain PostgreSQL and MySQL database instances, ensuring stability, performance, and adherence to organizational standards.
- Install and manage DBMS components, contributing to operational documentation, troubleshooting procedures, and daily maintenance workflows.
- Configure and manage PostgreSQL logical and physical backups, WAL archiving, and PITR to meet strict RPO/RTO requirements.
- Perform daily operational checks including error log reviews, health monitoring, resource utilization (CPU, memory, disk), replication validation, and OS‑level diagnostics.
- Develop, support, and optimize PostgreSQL databases, including replication setup, monitoring, and performance tuning.
- Monitor and optimize PostgreSQL performance, conduct capacity planning, and proactively address performance bottlenecks.
- Troubleshoot PostgreSQL and MySQL issues to ensure high availability, scalability, and uninterrupted service delivery.
- Collaborate with application teams to analyze upcoming builds/patches, assess database impact, and fine‑tune SQL queries for optimal performance.
- Support PostgreSQL and MySQL databases for in‑house and third‑party applications, ensuring seamless integration and reliability.
- Implement and maintain PostgreSQL cloud backup and monitoring solutions to ensure data protection and operational visibility.
- Maintain backup integrity, monitor system health, and troubleshoot performance issues to ensure optimal database and application performance.
- Prioritize and resolve client requests, manage daily tickets, and ensure SLA compliance across multiple environments.
- Plan and execute database changes with minimal downtime, continuously monitoring performance and resolving bottlenecks during and after deployments.
Associate Database Administrator
IBM
Hyderabad, INDIA
06.2017 - 11.2019
- Provided on‑call support for production and non‑production PostgreSQL environments.
- Assisted in deploying database changes during application releases.
- Installed, configured, and maintained PostgreSQL database instances for development, test, and production use.
- Created databases and updated access rules in the pg_hba.conf file.
- Created users and assigned roles and permissions based on project requirements.
- Monitored database performance and analyzed slow queries using tools like pg_stat_statements and PgBadger.
- Helped set up and monitor streaming replication between primary and standby servers.
- Applied routine patches and updates to PostgreSQL clusters.
- Supported PostgreSQL version upgrades under senior guidance.
- Performed physical backups using pg_basebackup and logical backups using pg_dump / pg_dumpall.
- Assisted in Point‑in‑Time Recovery (PITR) using base backups and archived WAL logs.
- Installed and configured required PostgreSQL extensions.
- Helped configure pgBouncer for connection pooling.
- Monitored database health, checked logs, and resolved basic performance issues.
- Followed backup and recovery procedures to ensure data protection.
- Responded to client requests, handled daily tickets, and ensured timely resolution.
- Planned and executed minor database changes with minimal downtime.
Education
Bachelor of Science - Computer Science
Masterji Degree And PG College
Hanamkonda, Telangana, IndiaMBA - Master of Business Administration
Talla Padmavathi College of Engineering
Kazipet, Telangana, IndiaSkills
- PostgreSQL Architecture, Installation & Configuration
- Logical & Physical Backups; Restoration & PITR
- Database Patching, Major/Minor Upgrades & Cloning
- Logical & Physical Replication (Streaming, Warm/Hot Standby)
- Performance Tuning & SQL Optimization
- Maintenance Operations (Re‑indexing, Vacuum, pg_repack)
- Log Analysis & Reporting (PgBadger)
- Connection Pooling with pgBouncer
- User, Security & Tablespace Management
- Database Automation & Workflow Optimization
- High Availability & Disaster Recovery Strategies
- Cloud Database Management (AWS EC2, RDS)
- Python & Shell Scripting for Automation
- Kubernetes for Containerized Deployments
- Relational Data Modeling & Database Development
- MySQL → PostgreSQL & Cross‑Platform Migrations
- Data Backup Solutions & Storage Virtualization
- Project Coordination & Problem Solving
Timeline
Database Administrator
Infosys
12.2019 - 07.2023
Associate Database Administrator
IBM
06.2017 - 11.2019
Bachelor of Science - Computer Science
Masterji Degree And PG College
MBA - Master of Business Administration
Talla Padmavathi College of Engineering