Over 8+ years of industry experience in Oracle & PostgreSQL & MYSQL worked extensively in production and development environments. A good team player with excellent communication and interpersonal skills. Alternately work independently and take leading responsibilities to achieve objectives. Professionally prospect to work in line with clients and winning client’s confidence. Adaptable to work in any kind of environment and to take up challenges.
Hi, I’m
SUDHEER LINGAMPETA
Database admin
Kamareddy
Summary
Overview
9
years of professional experience
Work History
GarminHyderabad
Senior Database Administrator
03.2022 - Current
Job overview
Tecnics
Senior Member Technical
06.2018 - 02.2022
Job overview
ADP INDIA PVT LTDHyderabad
Senior Member Technical (Oracle DBA)
06.2015 - 06.2018
Job overview
- Client : ADP INTERNAL
- The Project is to maintain and administer 6, 00,000 clients data stored in 35,000 databases
- The databases are located in Roseland USA
- Responsibilities:
- Installation & Configuration PostgreSQL
- Schema handling in PostgreSQL
- Database user roles and Security related permission
- User creation, object Backup & Restore
- Creating and Managing PostgreSQL Databases
- PostgreSQL Index Management
- PostgreSQL Error handling
- Backup, Recovery and PITR
- Monitoring disk usage
- PGAdmin monitoring
- Transferring Data on client requirements
- Moving Transaction Logs
- Migrations from postgresql to postgresql
- Upgrades from minor versions to higher versions
- Londsite replication
- Streaming replication
- Pg_logical monitoring
- High Availability Failover Replication
- DR Replication monitoring and configuration
- 24/7 Production support for critical and highly visible databases
- Worked on database Monitoring, Database backup using expdp and RMAN, Database refreshes and restorations
- Worked on Oracle RAC 10g,11g,12c Databases
- Worked on Standby databases
- Worked on golden gate replication, For production to lower environments replication
- Worked on OEM grid 10g,11g,12c,19c
- Worked on oracle database patching on RAC systems
- Very good technical skills in RMAN, Performed database recovery and restorations to a particular point of time and as per client requirements
- Worked on object management in database involving tables rebuild and index creations to improve performance
- Worked with oracle support for ORA-600 errors and ORA-4031 errors for memory related issues
- Worked on user management which involves user creations and granting appropriate roles to users, Tablespace creations and datafile addition and undo retention issues and redolog resizing to avoid frequent checkpoint issues
- Gathering stats on tables on a periodical basis to improve performance and Generating AWR Reports to resolve user performance issues and enabling trace for a particular session for debugging
- Worked on storage migrations and deployments
- Effective handling of bridge calls in resolving the issue
- Creation of oracle objects as per application team's request
- Managed appropriate use of free space within tablespaces, reclaimed space whenever possible
- Reorganized tables and indexes within databases when needed
- Understanding the execution plans of top sql statements by using execution plan
- Generating and analyzing AWR report for database performance monitoring
- Worked on Remedy Incident Management tool and Service now Tool for ticket management
- ACHIEVEMENTS
- Received ‘STAR OF THE YEAR’ -2021,22 for the highest number of closing the tickets
- Received my moment awards from clients for Proactive solutions and resolutions on backup failures
- Received best supporting team of the year award in FY 19-20
- Received several appreciations from clients and application teams for successful delivery
- Successfully completed AWS CLOUD certification -2023
Education
MALLAREDDY INSTITUTE OF SCIENCE&TECHNOLOGY
Bachelor of Technology from CSE
01.2013
University Overview
GPA: 71
Skills
- Database Administration
- Cloud services : AWS
References
References
REFERENCES
Will be furnished upon request.Languages
Languages
Additional Information
Additional Information
- Installing PostgreSQL V10,11,12,13,14 on windows Installing PostgreSQL V10,11,12,13,14 on Linux,ubuntu Configuration of PostgreSQL as per the requirement Creating and managing database objects like tables,functions,views,and indexes. Creating users with restricted access with required privileges. Hands on Routine maintenance task in PostgreSQL Worked on Pg_Repack in postgresql Backup strategies in PostgreSQL Database backups using Pg_basebackup on Linux. Worked on backup tool Barman. Daily backup schedule using pgdumpall Restoring PostgreSQL databases using Pg_restore utilities. Upgrade strategies in PostgreSQL Worked on Point-In-Time-Recovery(PITR) . Very good Knowledge and working experience on Pgadmin 4 Interface. Worked on PostgresSQL Replications like Streaming replication , Logical Replication Worked on Postgresql Migrations .
Timeline
Senior Database Administrator
Garmin
03.2022 - Current
Senior Member Technical
Tecnics
06.2018 - 02.2022
Senior Member Technical (Oracle DBA)
ADP INDIA PVT LTD
06.2015 - 06.2018
MALLAREDDY INSTITUTE OF SCIENCE&TECHNOLOGY
Bachelor of Technology from CSE
Similar Profiles
Dorota SkoropadDorota Skoropad
Returns Team Leader at GarminReturns Team Leader at Garmin
Michael CarverMichael Carver
SMT Operator at GarminSMT Operator at Garmin
Vada NortonVada Norton
Aviation Product Support Specialist 2 at GarminAviation Product Support Specialist 2 at Garmin
Ravi TeralaRavi Terala
Lead Analyst/Manager Global ERP at GarminLead Analyst/Manager Global ERP at Garmin
ANIL KUMAR MANDAANIL KUMAR MANDA
Senior Software Developer at Dolf Technologies Pvt LtdSenior Software Developer at Dolf Technologies Pvt Ltd