Ankesh Barode

Background

About Ankesh Barode

A result oriented Oracle certified professional with over 11 years of experience as Oracle & Microsoft SQL DBA • Providing 24/7 production and development support on Oracle RAC, Oracle DataGuard, Oracle RAC-DG-RAC (MAA) • Proficient in Database Administration activities such as installation, database creation, sizing, backup & recovery, performance tuning, and capacity planning • Experience in query optimization, cloning, patching, database upgrade, database migration, database troubleshooting, and space management • Excellent experience as an Oracle DBA on various platforms such as Sun Solaris, HP-UX, Red Hat Enterprise Linux • Experience in the implementation of high availability, Maximum availability and Disaster recovery database solutions [ Oracle RAC, Oracle DataGuard, Oracle RAC-DG-RAC] • Experience in the database storage configuration and administration • Experience in Systems Analysis, Design and Data Modeling • Backup & recovery using RMAN and datapump • A good knowledge of Performance Tuning using EXPLAIN PLAN, SQL TRACE, AWR, ADDM, ASH reports • Proactive monitoring, identifying areas that need improvement in the database and application using AWR, ADDM and OEM Control • Experience with writing SQL Queries, PLSQL Stored Procedures, Functions and Database Triggers • Expertise on upgrading and patching of CRS, ASM and Oracle RDBMS • Proficient in implementing and maintaining database security (users, roles and privileges) • Strong analytical and problem-solving skills, great team player and has the ability to work independently • Regular meetings with Business users and partners for new tasks, issues and maintenance • Performance tuning using analyzing AWR, ADDM, ASH, database statistics, Database histograms, recommending tuning approaches, comparing plans, fixing plans • Performing database health-check for many customers on regular intervals • Assisting customers in implementing Oracle and Microsoft database best practices • Migration of databases from Oracle to MSSQL, Oracle to Postgres, MSSQL to Oracle, MSSQL to PostGres • Performing Sizing and capacity planning and designed the physical database architecture • Data Modelling,database architecture, creating all types of database objects, schemas • Analyzing MSSQL performance issues using SQL server dashboard and third party tools • Handling issues, escalations, resolving in timely manner, maintaining SLA’s, creating documents like RCAs and other reports as required • A good verbal and written communication skills