Mayur Musale
Principal Infrastructure Engineer
CONTACT
EDUCATION
Master of Computer Application (MCA) Savitribai Phule Pune University, Pune 2014
Bachelor of Computer Science Solapur University, Solapur
2010
SKILLS
Databases:
Oracle 11g/12c/19c, Yugabyte, Mongodb
Oracle Utilities/Tools:
RAC, OEM 13c, RMAN, Dataguard, Datapump, ASM, Goldengate
Operating Systems: Linux, AIX, R12 Ticketing Tool: Remedy, JIRA
Certifications
Oracle Cloud Database Migration and
Integration 2022 Certified Professional
Oracle Autonomous Database Cloud 2021 Certified Specialist
Oracle Cloud Infrastructure Foundations 2021 Certified Associate
MongoDB Administration S1
Certification
ACHIEVEMENTS
- Spot Rewards, Kudos, accolades for outstanding performance.
- Client appreciation for preventing huge revenue losses.
PROFESSIONAL PROFILE - 8+ years experience in IT sector
- Oracle Database Administrator with 6+ years of experience in Production support, Disaster Recovery, Identity Access Management, Patching, Backup- Recovery, RAC, Goldengate.
- Initial exposure to Oracle Cloud Infrastructure (OCI), Pluggable databases, Yugabyte and MongoDB
- Qualified for UPSC Civil Services Personality Test, 2019
- Analyst with 2.10 years of experience in e-Commerce Operations & Competitive Pricing Analytics
WORK EXPERIENCE
Confidential
Principal Infrastructure Engineer
Pune - Fe6 2022 - Present
Disaster Recovery:
- Configuring and Monitoring dataguard via Dgbroker.
- Perform failover using Fast Start Failover (FSFO).
- Resolving lag using service name based incremental backup or standby rebuild.
Patching:
- Applying latest quarterly GRID and DB release update(RU) and JDK patches in rolling fashion. (Opatchauto to patch grid)
- Rollback of conflicting patches and applying bug patch.
Golden gate: Stop, start and check status of goldengate processes. Performance Tuning: Check and resolve high CPU utilisation, query slowness, blocking session, long running queries.
Database Decommission:
- Remove databases and their services from RAC cluster, OEM, Catalog db.
- Freeing up the disk space and network resources.
Confidential
Consultant
Mumbai - gfay 202Y - Fed 2022
- 24x7 Prod, UAT, Reporting support environments.
- Refreshing reporting database from Production using datapump.
- Creating and managing db links
- Performing RMAN L0-L1 and archive log backups manually or via crontab as per backup strategy.
- Monitoring Dataguard and resolving gaps.
- Creating new tablespace, adding datafiles, adding disks to disk group.
Confidential
DBA
Pune - March 2018 - Mav 2021
- User creation, granting quota, roles and privileges,
- Taking RMAN Backups on daily basis, Monitoring backup jobs.
- Database Refresh using Export/Import Data Pump.
- Generating AWR, ADDM and ASH reports.
- Applying released CPU, PSU and Database Release Update (RU) patches on databases in rolling fashion. (Opatchauto to patch grid)
- Rollback of conflicting matches and applying bu0 patch.
Confidential - Oct 2011 - Aug 2014
- Efficiently monitor, analyse e-commerce sites, pre-empt clients' product price and catalogue moves.
- Monitoring chat forums for discrepancies in pricing, content and web design to prevent revenue loss.