Krunal Vyas
Summary
Highly-motivated employee with desire to take on new challenges. Strong work ethic, adaptability, and exceptional interpersonal skills. Adept at working effectively unsupervised and quickly mastering new skills.
Seeking suitable role where I can excel in my profession and contribute towards the growth of a multifunctional organization resulting increase in profits of the stakeholders both as an organization and an individual.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Lead Administrator
Wipro Limited
Pune
10.2023 - Current
- Monitored database performance and tuned accordingly.
- Performed backup and recovery operations using RMAN utility.
- Deployed patches and upgrades on existing installations as per best practices guidelines.
- Installed and configured Oracle Database software, components, and tools.
- Maintained database security by creating user accounts and profiles and granting appropriate privileges.
- Migration of database from using datapump utility
Application Database Administrator
IBM india
Pune
10.2021 - 10.2023
- Developed comprehensive documentation outlining processes and procedures related to cloud migrations.
- Assisted with the implementation of cloud migration strategies and architectures for clients.
- Provided support for production deployments after go-live as needed.
- Migrated existing databases from one platform to another with minimal downtime.
- Database migration from on-prem(AIX) to RDS using XTTS utility.
Oracle Core DBA
Infosense Pvt Ltd
Gandhinagar
04.2020 - 10.2021
- Extensive experience in mission-critical and 24/7 support of Oracle database installing, performance and tuning, architecture and feature recommendations.
- Experience in Administration of Oracle Databases 11g, 12c and 19c including maintenance, upgrades, patching, cloning, tuning, performance monitoring, installation, backup and restore.
- Solved problems related to installation, implementation, maintenance, and operations of database and related infrastructure components.
- Implemented high availability solutions such as Oracle Data Guard, FSFO.
- Used OEM for monitoring, diagnosing and resolving problems quickly.
- Upgradation of database from 12c to 19c using auto upgrade utility.
- OEM 13c agent deployment plus target addition and deletion on database servers.
- Creating and stopping blackout for database and nodelevel in OEM 13c.
- Server provision and deprovision using terraform and bitbucket codes.
Oracle DBA
FirstRand Service Pvt Ltd
Mumbai
02.2018 - 04.2020
- Support and implementation of oracle database software in banking domain.
- Execute deployments on Production and test databases.
- Installation of 12c database and grid software
- Schema/table refresh from production to UAT and vice versa
- Creation of clone with RMAN duplicate and masking data before release
- Table reorganization using table movement method and release wastedspace
- Migration of database from file system to ASM
Senior Consultant
Clover Infotech Pvt Ltd
Mumbai
10.2013 - 09.2017
- Several BFSI client management
- Extensive Technical exposure of oracle database software version on different flavour of Linux and windows.
- Provided technical support to users, troubleshooting issues related to the Oracle database environment.
- Configured tablespaces, datafiles, redo logs and other objects in an Oracle database environment.
- Monitoring disk space on Production, Standby and UAT databases
- Installation of oracle software such as Single instance , RAC , client.
- Manual Database creation on Linux and windows server.
- Schema refresh from production to UAT and vice versa
- Schema/table reorg using table movement/Expdp/Impdp
- Perform DR Drill i.e. Switchover and Switchback periodically as per client requirements.
- Dataguard creation of RAC database and Single instance database.
- ASM Diskgroup creation and management
- Node addition and deletion in RAC database version 11.2.0.4
- Creation of public and private database link.
Education
Bachelor of Engineering - Information Science
SCTIT
Bengaluru08-2013
Skills
Operating Systems : Linux, AIX, Solaris and Windows
- Database Version : Oracle 10g,11g,12c,18c,19c
- Tool/Utilities : RMAN, SQL*Loader, TOAD, Export/Import, ODBC, DBUA, DBCA, putty, Supper putty, SVN, Git, CyberArk
- Ticketing tool : CA service desk, RTC JAZZ, Jira, ServiceNow
- ASM
- Real Application Clusters
- Transportable tablespaces
- TDE
- OEM 13c
- Data Guard ,DGMGRL and FSFO
- Physical & logical Backup and Recovery
- Patching & upgrades
Certification
- Oracle Certified Associate -January’2021
- Google Cloud Digital Leader -January’2022
- Azure Fundamentals AZ-900 -April’2022
- AWS certified cloud practitioner - June’2022
Languages
Gujarati
First Language
Hindi
Proficient (C2)
C2
English
Upper Intermediate (B2)
B2
Timeline
Lead Administrator
Wipro Limited
10.2023 - Current
Application Database Administrator
IBM india
10.2021 - 10.2023
Oracle Core DBA
Infosense Pvt Ltd
04.2020 - 10.2021
Oracle DBA
FirstRand Service Pvt Ltd
02.2018 - 04.2020
Senior Consultant
Clover Infotech Pvt Ltd
10.2013 - 09.2017
Bachelor of Engineering - Information Science
SCTIT