KUMARSAI SOMARAJU
Summary
Having 1.8+ Years of experience as PostgreSql Database Administrator involved in backup and recovery methodologies, monitoring database performance. Having support & troubleshooting experience in 24x7 environments. Experience in PostgreSQL Server setup.
Overview
1
1
year of professional experience
Work History
PostgreSQL DBA
CHEMTROLS INFOTECH PVT.LTD
08.2022 - 12.2023
- Responsible for all backup, recovery, and upgrading of PostgreSQL databases
- Monitoring databases to optimize database performance and diagnosing any issues
- Performs quality control audits to ensure accuracy, completeness, and proper usage of data in tables and various support tools, such as database dictionaries
- Performing the database deployment based on the requirement from the application and client teams.
- Develops project plans for implementing database environments
- Provides input to technical projects and oversees the tactical aspects of all database related tasks
- Diagnoses, resolves and implements preventive measures to prevent problems for availability, recoverability and performance of all supported database environments
- Recommends and oversees implementation of database level configuration changes to optimize performance
- Ensures maintenance of physical integrity of all production databases
- Install, configure, test, monitor, upgrade, and tune new and existing PostgreSQL databases
- Tuning autovacuum parameters to ensure up to date table stats and reclaim space consumed by dead tuples
- Studied and stayed current on features and functionality of PostgreSQL
- Proactive managing standby replication methodologies like Streaming replication .
- Configuring log analyzation tools.
- Proactive in updating the latest security patches to database, which are provided by PostgreSQL open source community
Education
ECM - ELECTRONICS AND COMPUTERS ENGINEERING
KL University
Guntur, India04.2020
Skills
- TECHNICAL SKILLS:
- RDBMS: PostgreSQL from 94 to 96
- Languages: Shell scripting, PL/PGSQL
- Operating Systems: Linux, Unix, Windows
- Backups: Logical and Physical backups
- High Availability: Streaming replication
Timeline
PostgreSQL DBA
CHEMTROLS INFOTECH PVT.LTD
08.2022 - 12.2023
ECM - ELECTRONICS AND COMPUTERS ENGINEERING
KL University
Similar Profiles
Krushna BawalgeKrushna Bawalge
Application Support Engineer at Clover Infotech Pvt.LtdApplication Support Engineer at Clover Infotech Pvt.Ltd
Riju PalRiju Pal
Cluster Manager at Bizcrum Infotech Pvt.Ltd (Bijnis)Cluster Manager at Bizcrum Infotech Pvt.Ltd (Bijnis)
Aadi AdateAadi Adate
Graphic Designer at CLP Infotech PVT.LTDGraphic Designer at CLP Infotech PVT.LTD
Venkata PaletyVenkata Palety
Sr. PostgreSQL DBA, MySQL DBA, Mongo DBA, SQL Server DBA & Sr. Oracle Database Administrator at Cisco Systems IncSr. PostgreSQL DBA, MySQL DBA, Mongo DBA, SQL Server DBA & Sr. Oracle Database Administrator at Cisco Systems Inc
Richmond OpareRichmond Opare
Lead PostgreSQL DBA at Prudential FinancialLead PostgreSQL DBA at Prudential Financial