Summary
Overview
Work History
Education
Skills
Personal Information
Disclaimer
Timeline
Work Availability
Generic

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

undefined

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

Similar Profiles

CREATE PROFILE
Sudeep T