Writing poem
Sagar Dayama
Database Administrator
Hyderabad,TG
Summary
Experienced Database Administrator with 17 years in Oracle DBA and 4 years in PostgreSQL DBA. Expertise includes managing Oracle databases across multiple versions and utilizing replication tools like Data Guard and GoldenGate. Skilled in health checks, user management, backup and recovery, and tablespace management to enhance database performance and security. Leverages UNIX knowledge and shell scripting to optimize operations.
Overview
3
3
Languages
18
18
years of professional experience
2
2
Languages
Work History
Oracle and Postgresql DBA
Zensar Technologies
06.2023 - Current
- Supported Oracle databases ,Goldengate, postgresql(EDB) DBs
- Supported 40 + replication including bidirectional and unidirectional.
- Monitored Goldengate replication, identifying and resolving issues to ensure data integrity and availability.
- Goldengate failover using AGCTL for maintenance.
- Implemented health check scripts to monitor replication
- Tuned performance of Golden Gate replication, enhancing data transfer efficiency and reducing latency.
- Integrated new tables into the Extract and Replicat groups.
- Worked on Tablespace Re-Orgs to reclaim space and improve the performance.
- Interacted with Oracle Support for technical assistance requests (TARs) and Service requests (SR’s).
- Worked on the TNS issues in the client servers and database servers.
- Backups using Import/Export and Datapump at schema level.
- Creation of users and giving the required grants.
- Promotion of database objects from lower environments to production.
- Monitoring the Mount points(Disk) for space issues and solving them
- Monitoring Alert logs for any errors, problems or processes running.
- Worked on some performance related issues at database level and sql level.
- Created SQL baselines for problematic queries.
- Have good experience in doing dataguard switchovers.
- Having Good knowledge on Postgresql architecture
- Worked on Vacuum-Reindexing-Analyzing the databases in postgres.
- Worked on EDB Backup and Recovery tool (BART)
- Experience in Backup and Recovery using PG_DUMP.
- Handling Streaming replication of EFM/non EFM enabled applications
- Rebuilding standby Db's during replication breakdown
- Have good knowledge on PEM (Postgres Enterprise Manager)
- Initiating bridge calls whenever required.
- Making monthly roster, checking the status report of all the team members.
- Provided database management services for American Express.
- Functioned in roles of Oracle DBA, PostgreSQL DBA, and Goldengate administrator.
- Employed by Zensar Technologies to manage database systems.
- Focused on database management in travel and financial services.
- Managed databases in Oracle, PostgreSQL, and Goldengate environments.
- Duration: Jun 2023 to Till date.
Oracle and Postgresql DBA
Tata Consultancy Services
04.2012 - 06.2023
- Supported Oracle databases ,Goldengate, postgresql(EDB) DBs
- Supported 40 + replication including bidirectional and unidirectional.
- Monitoring goldengate replication and troubleshooting issues.
- Goldengate failover using AGCTL for maintenance.
- Implemented health check scripts to monitor replication
- Tuning the performance of the Golden Gate Replication
- Incorporated new tables into the Extract and Replicat groups.
- Executed Tablespace re-organizations to reclaim space and enhance database performance.
- Interacted with Oracle Support for technical assistance requests (TAR’s) and Service requests (SR’s).
- Worked on the TNS issues in the client servers and database servers.
- Backups using Import/Export and Datapump at schema level.
- Creation of users and giving the required grants.
- Promotion of database objects from lower environments to production.
- Monitoring the Mount points(Disk) for space issues and solving them
- Monitoring Alert logs for any errors, problems or processes running.
- Worked on some performance related issues at database level and sql level.
- Developed SQL baselines for optimization of problematic queries.
- Have good experience in doing dataguard switchovers.
- Having Good knowledge on Postgresql architecture
- Worked on Vaccum-Reindexing-Analyzing the databases in postgres.
- Utilized EDB Backup and Recovery tool (BART) for efficient database backup and recovery management.
- Experience in Backup and Recovery using PG_DUMP.
- Handling Streaming replication of EFM/non EFM enabled applications
- Rebuilding standby Db's during replication breakdown
- Have good knowledge on PEM (Postgres Enterprise Manager)
- Initiating bridge calls whenever required.
- Making monthly roster, checking the status report of all the team members.
- Engaged with American Express as a client.
- Functioned in multiple roles: Oracle DBA, Postgresql DBA, and Oracle Goldengate.
- Employed at Tata Consultancy Services.
- Specialized in travel and financial services sector.
- Utilized Oracle (9i to 19c), Postgresql, Oracle Goldengate, shell scripting, and Ansible in the work environment.
- Employed from October 2013 to present.
Oracle DBA
Tata Consultancy Services
04.2012 - 09.2013
- Effective in Handling the Oracle tasks like:
- Executing the Change Control Requests as per the change window.
- Working on incidents which come in our queue to fix the issues.
- Monitored goldengate replication and troubleshot issues to ensure data integrity and system reliability.
- Started and stopped Golden Gate replication processes to ensure data flow.
- Implemented health check scripts to monitor replication
- Tuning the performance of the Golden Gate Replication
- Resolving the Replication lag related issues
- Integrated new tables into the Extract and Replicat groups.
- Checking for the synchronization between the tables
- Executed tablespace re-organizations to reclaim space and enhance database performance.
- Interacted with Oracle Support for technical assistance requests (TARs) and Service requests (SR’s).
- Worked on the TNS issues in the client servers and database servers.
- Backups using Import/Export and Datapump at schema level.
- Creation of users and giving the required grants.
- Promotion of database objects from lower environments to production.
- Monitoring the Mount points(Disk) for space issues and solving them
- Monitoring Alert logs for any errors, problems or processes running.
- Worked on some performance related issues at database level and sql level.
- Created SQL baselines for problematic queries.
- Have good experience in doing dataguard switchovers.
- Having Good knowledge on Postgresql architecture
- Worked on Vacuum-Reindexing-Analyzing the databases in postgres.
- Worked on EDB Backup and Recovery tool (BART)
- Experience in Backup and Recovery using PG_DUMP.
- Managed streaming replication processes for EFM and non-EFM applications to maintain data integrity.
- Rebuilding standby DBs during replication breakdown
- Have good knowledge on PEM (Postgres Enterprise Manager)
- Initiated bridge calls to facilitate communication among team members during critical issues..
- Making monthly roster, checking the status report of all the team members.
- Worked with Ameriprise Financials Inc. to support database operations.
- Role: Oracle Core DBA
- Organization: Tata Consultancy Services
- Domain: Finance Services
- Environment: Oracle 9i,10g,11gr, Linux,AIX,Solaris SparcSun Solaris, HP-UX and Windows
- Worked in Oracle database administration from April 2012 to September 2013.
Oracle DBA
Infogain India Pvt Ltd
06.2011 - 04.2012
- Effective in Handling the Oracle tasks like:
- Creating Databases in all the flavours of Unix and also on windows using DBCA.
- Installation of RAC database in 11.2.0.1 and 11.2.0.2.
- Monitoring dataguard and goldengate replication and troubleshooting issues.
- Monitored dataguard and goldengate replication, troubleshooting issues to maintain data integrity and availability.
- Worked on the TNS issues in the client servers and database servers.
- Backups using Import/Export and Datapump at schema level.
- Performed capacity planning to identify future resource needs for database systems.
- Installation of oracle software and creation of database using the PTC’s software.
- Installing clients on windows OS.
- Need to mount the ISO images on all platforms for PTC’s product testing.
- Monitoring the Mount points(Disk) for space issues and solving them
- Monitoring Alert logs for any errors, problems or processes running.
- Resolved performance-related issues at database level, enhancing system responsiveness.
- Interacted with Oracle Support for technical assistance requests (TAR’s) and Service requests (SR’s).
- Collaborated with PTC Pvt Ltd to deliver tailored database solutions.
- Served as Oracle Core DBA, managing database performance and reliability.
- Organization: Infogain India Pvt Ltd
- Contributed to product development by optimizing database functionality.
- Managed databases across multiple environments such as Oracle 9i, 10g, and various operating systems.
- Worked from June 2011 to April 2012, contributing to several database projects.
Oracle DBA
Wissen InfoTech Pvt Ltd
10.2009 - 05.2011
- Effective in Handling the Oracle tasks like:
- Production Support for Oracle 9i/10g Databases.
- Physical Database Backup and Recovery (hot and cold backups), Logical Backup and using Import and Export.
- Worked on Oracle Enterprise Manager (OEM) used to schedule the database backups and handle the failed backups through OEM, used to extract the AWR and ADDM reports and generating the definitions of tablespaces and objects in OEM. Configuring the databases and applying monitoring templates through OEM.
- Monitoring Alert logs for any errors, problems or processes running.
- Created various database objects, including tables, indexes, and views, to support application functionality.
- Executed scripts for developers and provided log files of the executed scripts.
- Creation of table spaces, user maintenance, database security imposition by creation and granting of roles and privileges.
- Creation of Database objects.
- Monitored tablespace to identify trends and proactively adjusted datafiles by adding and resizing as needed.
- Monitoring the Mount points(Disk) for space issues and solving them
- Involved in scenarios where we brought up the database after they got crash.
- Interacted with client and team to resolve queries effectively and maintain project alignment.
- Executed Oracle Home and client installations to facilitate effective database management and access.
- Performed Refresh Activity for Databases from Production to Development, Testing Environment.
- Database Re-organization (Database, Tablespace, Tables etc.): Re-Org is done from time to time for the primary storage objects like tables, indexes.
- Client: GE Medical Systems (Client) WI, USA
- Role: Oracle Core DBA
- Organization: Wissen InfoTech Pvt Ltd
- Domain: HealthCare
- Environment: Oracle 9i, 10g, Linux, Sun Solaris, HP-UX and Windows
- Duration: Oct 2009 to May 2011.
Tech support executive
Wipro BPO Pvt Ltd
10.2008 - 09.2009
- Assisted in conducting load tests to evaluate system performance.
- Collaborated with CCT team to resolve production-related issues.
- Served as Oracle Core DBA for GE Medical Systems, optimizing database performance.
- Role: Oracle Core DBA
- Organization: Wissen InfoTech Pvt Ltd
- Domain: HealthCare
- Environment: Oracle 9i, 10g, Linux, Sun Solaris, HP-UX and Windows
- Duration: Oct 2008 to Oct 2009.
Education
Master of Computer Science -
Aurora Degree And P G College
Hyderabad01-2008
Skills
Proficient in Oracle database versions 9i to 19c
Database management
Backup and recovery
Database monitoring
PostgreSQL administration
Proficient in multiple operating systems
Interests
Timeline
Oracle and Postgresql DBA
Zensar Technologies
06.2023 - Current
Oracle and Postgresql DBA
Tata Consultancy Services
04.2012 - 06.2023
Oracle DBA
Tata Consultancy Services
04.2012 - 09.2013
Oracle DBA
Infogain India Pvt Ltd
06.2011 - 04.2012
Oracle DBA
Wissen InfoTech Pvt Ltd
10.2009 - 05.2011
Tech support executive
Wipro BPO Pvt Ltd
10.2008 - 09.2009
Master of Computer Science -
Aurora Degree And P G College
Managerial Skills
- Capable of taking the responsibility of the Shift.
- Capable of leading a team.
- Good Interpersonal and effectiveness skills.
- Good at analyzing the documents.
Software
Oracle
Postgres
Oracle goldengate
Personal Profile
- Date of Birth: July 9, 1984.
- Nationality: Indian.
- Address: #11-1-804, Komatkunta, Seetarambagh, Hyderabad-500006
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Accomplishments
- Received promotion to associate consultant within 5 years.
Languages
English
Advanced (C1)
Hindi
Bilingual or Proficient (C2)