Experienced Database Administrator with over 2 years of expertise in managing Oracle and PostgreSQL databases. Adept at database upgrades, migrations, performance tuning, and ensuring data integrity and recovery. Skilled in troubleshooting database issues and improving efficiency for enterprise applications. Currently managing databases for Ultimatix, the core portal of Tata Consultancy Services.
• Manage and maintain databases under Ultimatix, the core portal of TCS.
• Perform Oracle and PostgreSQL database upgrades, migrations, and Defragmentation in oracle.
• Conduct routine maintenance activities such as vacuuming, cloning, and Tablespace expansion.
• Execute data dumps and ensure proper recovery of backup procedures to safeguard against data loss.
• Monitor alerts and emails, troubleshooting database issues as needed.
• Optimize performance by reducing archives and addressing long-running queries.
• Test and validate stored procedures manually to ensure accuracy and reliability.
• Collaborate with teams to address performance bottlenecks and database inconsistencies.
• Execute PR DR Sync to ensure seamless disaster recovery and data synchronization.
• Apply regular patching activities to maintain database security and performance.