Prem Kumar Kola
Melbourne,VIC
Summary
PostgreSQL Database Administrator with expertise in enhancing database performance and implementing effective backup solutions at Winfo Solutions. Proficient in Linux and Windows environments, with strong skills in monitoring tools such as Grafana and Prometheus. Experienced in ensuring data integrity and providing technical support and training to users. Recognized for high productivity, SQL optimization, database security, and effective problem-solving abilities.
Overview
4
4
years of professional experience
1
1
Certification
Work History
PostgreSQL Database Administrator
Winfo Solutions
07.2022 - 06.2025
- Optimized database performance for critical applications through tuning and strategic adjustments.
- Implemented robust backup and recovery solutions to maintain data integrity.
- Monitored security protocols and access controls to safeguard sensitive information.
- Developed automated scripts for routine data maintenance and comprehensive reporting.
- Collaborated with development teams to create efficient and scalable database structures.
- Conducted data quality audits to identify and rectify inconsistencies or errors.
- Provided technical support and training sessions for users on database systems.
- Assisted in system upgrades and migrations to improve overall database functionality.
Database Administrator
DXC Technology
Bangalore
08.2021 - 07.2022
- Worked as a Database Administrator for DXC Technology, Bangalore from Aug 2021 to till July 2022.
Education
Bachelor of Engineering - C.S.E
Nagarjuna College of Engineering and Technology
Bangalore01.2021
Skills
- PostgreSQL database management
- Linux and Windows operating systems
- PgAdmin and Linux tools
- Database utilities
- Monitoring with Grafana and Prometheus
Certification
- AZ-900 – Microsoft Certified Azure Fundamentals
- AZ-104– Microsoft Certified Azure Administrator Associate
- AZ-305– Microsoft Certified Azure Solutions Architect Expert
- DP-300– Microsoft Certified Azure Database Administrator Associate
Projects
Project Name: TGG & JB hi-fi, Role: Team Member, Tools: Pgadmin, Psql, Putty, Azure, Technical Environment: Postgres 13.11,13.14, Red hat 7, Linux,Azure Postgres database servers, Project duration: Oct 2022 to till now, Responsibilities: Creation of users and roles based on the requirement. Worked on PostgreSQL Data export and Import operations. Worked on Database services stopping and starting activities. Working on Objects management. Working on database connection management. Working on implementing vacuum and analyzing process on user defined tables and system defined tables. Having experience on backup and restore. Configuration of Read replica for production. Configuration of Logical replication 24/7 End to End Production database support., Azure Responsibilities: Creating Postgres flexible Instances using ARM Templates. Creating snapshot backups and Automated backups configuration. Parameter group creation and altering parameter values. Monitoring Azure Postgres instance resource utilization from Azure Metrics. Log monitoring using log Analytics. Instance start/stop/restart. Creating Databases/Schemas by accessing the Azure Postgres instance from terminal server. Performing logical backups for database and schemas.
Disclaimer
I hereby declare that the information furnished above is true to the best of my knowledge. Date: (Kola Prem Kumar)
Timeline
PostgreSQL Database Administrator
Winfo Solutions
07.2022 - 06.2025
Database Administrator
DXC Technology
08.2021 - 07.2022
Bachelor of Engineering - C.S.E
Nagarjuna College of Engineering and Technology
Similar Profiles
Barasha BharaliBarasha Bharali
RPA developer at Winfo SolutionsRPA developer at Winfo Solutions
Brudhavanam Sai Narayana MurthyBrudhavanam Sai Narayana Murthy
Junior Oracle Developer at Winfo SolutionsJunior Oracle Developer at Winfo Solutions
BARASHA BHARALIBARASHA BHARALI
RPA developer at Winfo SolutionsRPA developer at Winfo Solutions
KARISHMA PHERWANIKARISHMA PHERWANI
Marketing & Customer Engagement Assistant at Burgers and Dreams (Boss Burger)Marketing & Customer Engagement Assistant at Burgers and Dreams (Boss Burger)
Ashina SethiAshina Sethi
Senior Test Analyst at United EnergySenior Test Analyst at United Energy