Amit Pawar

Background

About Amit Pawar

About Me: I am a seasoned Senior Oracle Database Administrator and Cloud Specialist with over 12 years of expertise in managing and optimizing mission-critical database environments across industries. My technical proficiency spans Oracle 11g 12c and 19c including advanced skills in Oracle RAC Data Guard ASM and RMAN where I’ve successfully implemented high-availability solutions and disaster recovery strategies that ensure business continuity. I have significant hands-on experience with Exadata (X4-2 X6-2 X8-2) driving database performance through advanced features such as Smart Scan Hybrid Columnar Compression (HCC) and Flash Cache. I am also proficient in Oracle Golden Gate for real-time data replication and PostgreSQL administration making me versatile in managing both relational and cloud-native database systems. My cloud expertise includes Oracle Cloud Infrastructure (OCI) and AWS where I’ve led large-scale cloud migrations network configurations and security implementations optimizing cloud performance and ensuring scalability. In addition I have automated routine DBA tasks using shell scripting reducing manual workload and improving efficiency. What I Bring: - Database Leadership: Led a team of DBAs in designing implementing and managing Oracle database systems ensuring 99.98% system uptime and significant cost reductions. - Exadata Specialist: Managed multiple Exadata platforms optimizing storage and performance and implementing features like Smart Scan and HCC for up to a 25% increase in I/O throughput. - Cloud Expertise: Successfully migrated on-premises databases to Oracle Cloud Infrastructure (OCI) leveraging cloud solutions to enhance scalability and security. - Automation & Optimization: Automated critical DBA tasks using shell scripting resulting in a 40% reduction in manual tasks and increased system performance. - Performance Tuning: Expert in using AWR ASH and SQL profiling tools for troubleshooting and performance optimization achieving a 20% boost in application performance post-upgrades. - Disaster Recovery & Security: Implemented Oracle Data Guard and RMAN-based strategies for disaster recovery and security ensuring a 99.9% data availability rate. Technical Skills: - Oracle DBA: Oracle 11g/12c/19c RAC ASM RMAN Data Guard - Exadata Administration: X4-2 X6-2 X8-2 - Cloud Platforms: Oracle Cloud Infrastructure (OCI) AWS Snowflake - PostgreSQL: Installation Configuration Backups - Replication: Oracle Golden Gate - Automation & Monitoring: Shell scripting AWR ASH SQL profiling