Badges
Certifications
ANURAGKUMARJOY has not earned any certificates yet.
Work Experience
Senior Oracle DBA
Tata Consultancy Services• September 2015 - Present
Currently working with Tata Consultancy Services as Technical Lead (Lead Oracle DBA) with more than 7.8 + years’ experience and part of a team supporting 700+ critical production environments Provide 24*7 support critical production oracle database environments As Lead Oracle DBA supporting Oracle database versions 10g/11g/12c/18c RAC and Non-RAC, installation, configuration, administration, performance tuning, User Management, Backup & Recovery Manage daily database health checkup and maintenance plan activities including daily activities, backups, indexing, integrity and consistency checks, ASM disk addition, Standby DB GAP issue, DB space issue Taking Ownership and good skills on problem management, problem solving and prevention of SLA breach under Incident / Problem Management processes Participate with project team in the implementation of new projects, release, analyzing performance, Schema/DB refresh and recommending solutions to enhance performance of database Supporting global (USA) Clients and work in a global team, interacting/coordinating with onsite members Good understanding of DB performance tuning reports/tools, AWR, ADDM, Tkprof, explain plan, traces, plan management using OEM 12c/13c (Oracle Enterprise Manager) Ability to proactively identify, troubleshoot and resolve live database issues using DB tools Experience in Database Performance tuning including SQL query tuning, Instance tuning and High Availability Technology RAC (Real Application Cluster), Goldengate, database refresh/cloning etc. Experience in maintain and develop backup/recovery procedure and dealing with critical and non-critical loss for Oracle databases for online and offline (hot & cold backup) backups using RMAN (Recovery Manager) database utility also good knowledge of various restore and recovery scenarios Solid experience in database upgrade, migration, installation, patching, datapump, export, import, security, capacity planning, performance monitoring and tuning Experience in setting up and supporting oracle Active standby and Physical standby Dataguard Experience in opening SR and work with oracle technical support team on critical DB issue Experience in DB patching SIHA, RAC oracle database using Opatch & Oracle Fleet Management Service Now tool using for Ticket Management, Incident, Task Management, Change Management Experience in installing oracle agent, adding, removing, discovering, configuring database target in OEM Experience in Goldengate installation, troubleshooting live issues Manage meeting & Escalation with onshore/offshore team members Hands on experience in Postgres DB, Mongo DB, MySQL
Education
Gautam Buddh Technical University, Lucknow
Computer Science & Engineering, B.Tech• July 2007 - June 2010