Sudeep T
Hyderabad
Summary
Having around 3.5 years of total experience and 2.8 years of experience in database admin experience in PostgreSQL, involved in backup and recovery methodologies, and monitoring database performance.
Overview
3
3
years of professional experience
4
4
years of post-secondary education
1
1
Language
Work History
PostgreSQL DBA
COLLABRIDGE
11.2022
- Installing and configuring PostgreSQL on various versions
- Designing of clusters, tables, schemas and roles
- Implementing backup and recovery using hot backup (logical &physical)
- Monitoring production PostgreSQL alert logs for database errors
- Monitor client connectivity using pg_hba.conf files
- Creating roles and granting permissions to users
- Monitoring tools and Application support
- Installing and configuring streaming replication
- Performing a switchover/failover by setting trigger file in recovery.conf file
- Analyzing active connections and providing suggestions for improvement
- Performing minor and major level upgradation.
Software Engineer
GLOBAL LOGIC INDIA PRIVATE LIMITED
04.2022 - 10.2022
- Installed PostgreSQL installation, Configuration on Windows and Linux
- Granting and revoking privileges to users on tables
- Verifying and analyzing logs regularly
- Finding fatal, error, warning and hints from logs and providing resolutions
- Finding a-optimized long-running queries
- Maintaining database by regular vacuum, analyzing operations
- Worked on normal files to Encryption format
- Monitoring load on PostgreSQL database server
- Verifying logical backups every day
- Configuring backup options using online backups
- PostgreSQL upgrades between various major/minor versions
- Synchronous/Asynchronous Replication
- Worked on Setup Streaming Replication.
Software Engineer
FIRSTZEN SOLUTIONS PRIVATE LIMITED
02.2020 - 04.2022
- Monitoring Disk spaces on all servers
- General Health of servers to identify Bottlenecks
- Performing Database maintenance activities like Backups, Restoring, Re-indexing.
- Automation of alerts by configuring Database Mail
- DB health checks & proactive measures using DBCC/DMV utilities
- Creating customized jobs to track database growth, blockings & long-running queries
- Managing Windows/SQL Cluster environment (Active/Active and Active/Passive)
- Involved in transferring logins between two production servers using transfer login script
- Configuring, maintaining, and troubleshooting Database Mirroring
- Configuring, maintenance, and troubleshooting Log shipping
- Creating Monthly reports to customer about status of databases
- Performed regular DBA jobs like Backups, Restores, Point in time Recovery, Database Consistency Checks, and Index Maintenance
- Supported 24
- 7 production servers and solved all kinds of issues
- Creating users and giving appropriate permissions
- Monitor status of maintenance Jobs.
Education
B.Tech - Information Technology
Jawaharlal Nehru Technological University Kakinada
Vijayawada 08.2012 - 12.2016
Skills
Red Hat Linux, Centos, and Windows
PostgreSQL 11x,12x,13x,14x,MySQLLinux
Backup and recovery
Personal Information
- Religion: Hindu
- Father's Name: Tripuraneni Venkatapathi Rao
- Date of Birth: 08/07/93
- Nationality: Indian
Disclaimer
I hereby declare that all the above information is correct to the best of my knowledge and belief.
Timeline
PostgreSQL DBA
COLLABRIDGE
11.2022
Software Engineer
GLOBAL LOGIC INDIA PRIVATE LIMITED
04.2022 - 10.2022
Software Engineer
FIRSTZEN SOLUTIONS PRIVATE LIMITED
02.2020 - 04.2022
B.Tech - Information Technology
Jawaharlal Nehru Technological University Kakinada
08.2012 - 12.2016
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse