Vijai Kumar
Lead Postgres DBA
Delhi
Summary
Skilled in database administration with 8 + experience in ensuring data accuracy and security, as well as managing performance and improving processes. Possess strong technical abilities in PostgreSQL database, and data migration strategies. Successfully enhanced system efficiency and reliability through proactive database optimization and maintenance practices. Fostered teamwork and collaboration to meet tight deadlines and address challenging IT issues effectively. Skilled in database administration with relevant experience in ensuring data accuracy and security, as well as managing performance and improving processes. Possess strong technical abilities in PostgreSQL and Informix databases, and data migration strategies. Successfully enhanced system efficiency and reliability through proactive database optimization and maintenance practices. Fostered teamwork and collaboration to meet tight deadlines and address challenging IT issues effectively.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Postgresql DBA Lead
TCS India Pvt Ltd
07.2023 - Current
- Installation and Configuration of PostgreSQL.
- Managed and supported a large PostgreSQL database, including backups, restores, monitoring, and performance tuning.
- Created automated scripts to back up the database nightly, and restore it in case of failure or migration to new hardware.
- Implemented an alerting system using Nagios for critical issues, such as disk space depletion or high CPU usage by processes on the server.
- Designed and implemented a process to migrate all existing databases from one version of PostgreSQL to another without downtime during business hours.
- Troubleshot problems related to the database software or hardware, and provided solutions that improved the overall reliability of the database infrastructure.
Postgresql DBA Lead
Accenture Pvt Ltd
Noida
11.2023 - 07.2024
- Installation and Configuration of PostgreSQL.
- Managed and supported a large PostgreSQL database, including backups, restores, monitoring, and performance tuning.
- Created automated scripts to back up the database nightly, and restore it in case of failure or migration to new hardware.
- Implemented an alerting system using Nagios for critical issues, such as disk space depletion or high CPU usage by processes on the server.
- Designed and implemented a process to migrate all existing databases from one version of PostgreSQL to another without downtime during business hours.
- Troubleshot problems related to the database software or hardware, and provided solutions that improved the overall reliability of the database infrastructure.
Sr Software Engineer
Vitrana Pvt Ltd
Noida
08.2023 - 10.2023
- Installation and Configuration of PostgreSQL 9.6/10 to 14 on Centos 6/7
- Installation of PGADMIN on window
- User management (creating users assigning Roles & Privileges)
- Performed Streaming on PostgreSQL 9.6/10 and 11
- Basic level of performance tuning, Query Optimization and Performance monitoring using tool such as PGAdmin
- Monitoring Alert Log, scheduled jobs and troubleshooting database problems
- Identifying slow queries
- Identifying fragmented indexes and rebuilding indexes
- Monitoring daily backups
- Major/minor version up gradation of databases
- Backup/restore using pg_dump, pg_dumpall, pg_basebackup
Postgres SQL DBA
Estel Technology
Gurgaon
04.2021 - 08.2023
- Installation and Configuration of PostgreSQL 9.6/10 to 14 on Centos 6/7
- Installation of PGADMIN on window
- User management (creating users assigning Roles & Privileges)
- Performed Streaming on PostgreSQL 9.6/10 and 11
- Basic level of performance tuning, Query Optimization and Performance monitoring using tool such as PGAdmin
- Monitoring Alert Log, scheduled jobs and troubleshooting database problems
- Identifying slow queries
- Identifying fragmented indexes and rebuilding indexes
- Monitoring daily backups
- Major/minor version up gradation of databases
- Backup/restore using pg_dump, pg_dumpall, pg_basebackup
Postgres SQL DBA
PAYTM
01.2019 - 04.2021
- Installation and Configuration of PostgreSQL 9.6/10 and 11 on Centos 6/7
- Installation of PGADMIN on window
- User management (creating users assigning Roles & Privileges)
- Performed Streaming on PostgreSQL 9.6/10 and 11
- Good Knowledge of SQL Queries
- Basic level of performance tuning, Query Optimization and Performance monitoring using tool such as PGAdmin
- Monitoring Alert Log, scheduled jobs and troubleshooting database problems
- Working knowledge of Backup and recovery at Table, Schema and Database Level
- Troubleshoot PostgreSQL service outages as they occur, including after-hours and weekends
- Identifying slow queries
- Identifying fragmented indexes and rebuilding indexes
- Monitoring daily backups
- Major/minor version up gradation of databases
- Providing backend support to the Client
- Resolving daily routine alert error
- Backup/restore using pg_dump, pg_dumpall, pg_basebackup
Postgres SQL DBA Associate
Mo-De India Pvt.Ltd
12.2016 - 09.2018
- Install, Manage and configure postgresql Database
- Clients consist of Reliance India, Tata India, Airtel Nigeria, Airtel, Glo-Ghana, Chad-Airtel, South-Africa-MTN, Kenya-YU, Liberia-MTN, Nairobi-Airtel
- Installing, Creating database and managing replication
- Managing disk space of database
- Performing backup and recovery
- Database query management
- Performing vacuum
- Manage database (SQL) query and make daily bases reports
- Configuring alerts on Zabbix to monitor various production servers
- Scheduled automatic report And task
- User/Access management on oracle/Postgres DB
Education
Master of Computer Applications - Computer Science
UPTU
Noida ,Uttar Pradhesh 07-2015
Bachelor of Computer Applications - Computer Science
CCS University
Noida, Uttar Pradhesh 07-2012
Skills
- POSTGRESQL
- Performance Tuning
- Backup / Restore
- EDB
- BARMAN
- Automation
- REPMGR
- PITR
- HA configuration
- AWS
- INFORMIX
- BASH
- LINUX
- UBUNTU
- WINDOWS
Certification
Oracle Certified Associate
Personal Information
- Total Experience: 8+ Years' experience
- Date of Birth: 07/10/92
Timeline
Postgresql DBA Lead
Accenture Pvt Ltd
11.2023 - 07.2024
Sr Software Engineer
Vitrana Pvt Ltd
08.2023 - 10.2023
Postgresql DBA Lead
TCS India Pvt Ltd
07.2023 - Current
Postgres SQL DBA
Estel Technology
04.2021 - 08.2023
Postgres SQL DBA
PAYTM
01.2019 - 04.2021
Postgres SQL DBA Associate
Mo-De India Pvt.Ltd
12.2016 - 09.2018
Oracle Certified Associate
Master of Computer Applications - Computer Science
UPTU
Bachelor of Computer Applications - Computer Science
CCS University
Similar Profiles
Jaisilon KanchiJaisilon Kanchi
Assistant Manager of Operations at TCS India Pvt. Ltd.Assistant Manager of Operations at TCS India Pvt. Ltd.
Ravi KumarRavi Kumar
QA Analyst at IBM India Pvt Ltd.QA Analyst at IBM India Pvt Ltd.
Raghu EswaraiahRaghu Eswaraiah
Software Development Engineering Manager at IQVIA RDS (India) Private LimitedSoftware Development Engineering Manager at IQVIA RDS (India) Private Limited