Badges
Certifications
Work Experience
AWS DBA
Cognizant Technology Solutions• October 2022 - July 2023
• Extensive experience in finding bottlenecks to optimize database performance on the AWS Cloud. • Provided day to day support to system users, sharing knowledge worth employees on troubleshooting and problem-solving protocols. • Achieved efficiency and reduced redundancy by automating repeatable tasks with shell scripting. • Availed tracking tools like JIRA. • Data Refresh using data pumps. • Have hands on with Shareplex as a tool for replication and possess firm understanding of its architecture.
Oracle Database Administrator
Tata Consultancy Services Ltd• May 2019 - September 2022
• Strong knowledge on ORACLE utilities like EXPLAIN PLAN, AUTOTRACE, SQL TRACE, TKPROF, AWR and performance views. Diagnose and present effective solutions for application and database performance issues supported by empirical evidence. • Well versed with 11G Architecture, Multitenant Architecture (19C), Data Guard Architecture and Golden Gate Architecture. • Perform database patch analysis, install and resolve patch install issues. • Used monitoring tools like OEM, Solarwinds and ticketing tools like BMC Remedy Ticketing System and Service Now. • Experience with Oracle DB Enterprise features like Oracle Grid/ASM, Data Guard (Physical/Logical/Standby), RAC, RMAN of dynamic troubleshooting and requirement traceability skills and experienced in interacting with Clients, Business Analysts, leads, and UAT Users. • Hands on experience on mock drill of Disaster Recovery (DR). • Offered technical guidance and advised users of alternative approaches when troubleshooting.
Education
UEM, Kolkata
Computer Science & Engineering, B.Tech• August 2015 - April 2019
I was placed in first class with distinction. My GPA was 9.08
Links
Skills
patra_abhirup13 has not updated skills details yet.