Ashu Jaiswal

About Ashu Jaiswal

The Database Administrator is responsible for the installation of the database environment and outputs. The DBA performs work on new project installations, Database release upgrades, and/or database performance management projects.* Worked in 24x7 production environment and provided on-call and day-to-day support* Exadata compute nodes,cell nodes,ibswitches software upgradation on 19.2.2 image (oel7).* Planning for preventive maintenance to work with Oracle support Ex-BBU replacement.* Quarterly rdbms and grid home bundle patching planning including old one-off\'s(conflict) and new requested patches to fix database and application side issues.* Installed and upgraded 18c grid infrastructure to 19c on Exadata on-premise machine.* Installed 19c RDBMS software along with 19.5 OCT2019 RU on Exadata machine X7-2,X8-2 full rack* Recently I have resized(increased) the /u01 lvm volume size online for X7 Exadata machine and X5 machine offline(LVDoraSYS1) to maintain multiple RDBMS version software (11.2.0.4,12.1.0.2,18.0.0.0 RU 7,19c )* Performs database installation.* Performs capacity planning for data storage.* Creates and modifies database tables and indexes.* Performs database backup and recovery.* Experienced with Dataguard setup, physical and Logical standby database creation* Performs database tuning.* Experience in capacity planning, space management, database upgrades/migration * Reports overall health status and performance of a database.* Maintains highly available database.* CRS resource management: Experienced in Adding/Deleting/Relocating Instances, DB, listener, nodeapps and Services* Managing OCR and Vote disk backup* Managing ASM instance, creating disk groups, add/delete disk* Golden Gate knowledge to configuring extract and replicate process and troubleshooting.* Analyze database failure and identifies corrective action.* Plans and implements database upgrades to new RDBMS versions.* Researches new RDBMS version and functionality, identifies risks and rewards.* Works with operating system to maintain database.* Develops and maintains monitoring solutions.* Executes operating system database testing.* Performs other responsibilities as needed.* Takes an active part in driving their Professional Development Plan (PDP) and career development.* Expert with OEM Grid Control.

Experience

1. Site Reliability Engineer

   Oracle

   Feb 2020 — Present · Bengaluru, IN

Skills

• Toad
• Sap Portal
• Oracle Enterprise Manager
• Unix
• Sql
• Linux
• Unix Shell Scripting
• Oracle Rac
• Public Speaking
• Disaster Recovery
• Sap Basis
• Oracle Exadata Admin
• Performance Tuning
• Oracle
• Oracle Asm
• Rman
• Customer Service
• Oracle Grid
• Backup & Restore
• Shell Scripting
• Goldengate
• Solaris