Vinsee Panwar
Pune
Summary
Skilled in implementing innovative solutions and enhancing database security, ensuring peak operational efficiency.
Overview
11
11
years of professional experience
Work History
Senior Oracle DBA
Capgemini (Bayer AG)
Pune
06.2024 - Current
- Migrated 11g, 12c, 18c, and 19c Oracle databases to the Azure cloud.
- Core member of the migration team for architecting the migration smoothly, using Data Guard and Oracle ZDM.
- Assisted with Azure ASR and AVS migrations for the critical database.
- Assisted in the management and database administration of Oracle database applications on Exadata platforms.
- Routine health check, patching, and bug fix as per Oracle support plan.
- Preparing Exadata patching using pre-check operation with patchmgr, and gathering environment info using Imageinfo, etc.
- Worked on open vulnerabilities to keep the security component of the Oracle Database Server up to date with the latest components.
- Maintained all existing databases and new installations at current, stable production levels.
- Evaluated clients' needs and created a plan of action to provide solutions.
- Identified key areas in need of improvement, and implemented plans to rectify issues.
Technical Consultant
Computacenter (Matsercard)
09.2022 - 06.2024
- Experience in handling multitenant architecture.
- Experience in cloning pluggable database for migration/ upgrade.
- Worked on single node RAC & multiple node RAC environment.
- Worked on performance tuning using reports as ADDM, AWR & ASH.
- Experience in configuring Dataguard Broker configuration.
- Extensively worked on RMAN backup & recovery strategies.
- Worked on troubleshooting of Golden Gate Classic Architecture 19c & 12c.
- Good knowledge of Active Dataguard, snapshot database & flashback feature.
- Oracle database upgrade from 12c to 19c.
- Familiar with RAC commands: SRVCTL, CRSCTL, OCRCONFIG for cluster operations.
- Creating RAC Disaster Recovery setup.
- Creating diskgroup on ASM, adding disks to ASM.
- Apply quarterly PSU patches on RAC and single instance database.
- Schema refreshment using EXPDP/ IMPDP.
- Handling users AD-HOC requests, incidents, work order or problem tickets.
- Analyzing tables and indexes for better performance, rebuilding/ reorganizing Indexes.
- Preparing Monthly Service Report (MSR) highlighting all activities for that month.
- Provided expert guidance on database projects and solutions.
Senior Oracle DBA
Accenture (Amadeus, BT & Wella)
Pune
11.2019 - 09.2022
- Migrating pluggable 18c to 19c databases.
- Maintain SYNC between primary and standby databases using Data Guard.
- Patching databases with the latest path release.
- Used Bitbucket and Ansible for automating the migration task.
- Installing new databases on Azure Cloud.
- Migrating data from on-premises to Azure VMs.
- Releasing the node once the migration is completed for a zero-downtime change request.
- Decommissioning of old databases and data once the database migration is completed.
- Using the ITSM tool for modifications in change requests and their subsequent task records.
- Maintaining the CMDB and CONTROL-M jobs.
Technical Service Engineer
Fujitsu (Aurizon, QUU & COGC)
Pune
10.2018 - 11.2019
- Working in a shared model, interacting with each customer's model, behavior, and priorities.
- Daily incident monitoring and prioritizing them to close within the defined SLA.
- Working on critical milestone databases for all environments, i.e., production, staging, development, and standby databases.
- Database refreshes using import, export (schema, object, and full), or RMAN duplicate using backups.
- Involved in DR activity involving Data Guard switchover, switchback, or activating standby using data file backups on OS.
- Working on the assigned RFC, as per the implementation plan approval in CAB meetings.
- Database duplication, to produce a new environment for UAT, or development.
- Worked on applying PSU patching, scheduled quarterly, as per the n-1 policy.
- Worked on the database upgrade from 11.2.0.4 to 12.1.0.1 (release 1).
- Creating and altering primary database storage structures (tablespaces).
- Purging activity: Involve yourself in purging activity as per user requirements.
- User management: creating users, assigning privileges, defining roles, and assigning profiles as per requirements.
- Monitoring the RMAN backup schedule every Friday for Level 0 backups and Level 1 backups from every Saturday to Thursday, both manually and using Cron or Windows Scheduler.
- Compile invalid objects through UTLRP, or manually search user and object privileges and dependencies.
Associate DBA
Perpetuuiti Technosoft (Vodafone & Fiat)
Pune
11.2016 - 10.2018
- DR drill for a single-instance database.
- Configuring RMAN policies for backup and restore.
- Schema refreshment using export/import.
- Adding and resizing the data file.
- Installation of the Oracle database on various platforms, like Linux and Windows.
- DB link creation (Oracle-Oracle)
- ORACLE database upgrade from 10g to 11g & 11g to 12c.
- Creation of a Standalone DR for RAC Primary.
- Apply quarterly PSU patches on the RAC and single-instance database.
- ASM management, like the addition or removal of a disk in a Disk Group,
- Implementation of physical backups, and configuration of online (hot) and offline (cold) backup.
- Developed backup and recovery plans to safeguard company data assets.
Associate DBA
Softenger (Vodafone)
Pune
11.2014 - 11.2016
- Worked 24/7 rotationally as an Oracle DBA.
- Monitoring numerous databases hosted on various operating systems, i.e., Windows, AIX, and Linux servers.
- DR Drill for single/multiple-instance databases.
- Creating Data Guard configuration.
- Applied various patches on the database and was involved in various OS patching activities.
- Extending storage capacity by creating new tablespaces, adding data files, and ASM management.
- Maintaining load on database servers for database performance using TOPAS, VMSTAT, PS, and NETSTAT.
- Used tools like ADRCI, NETMGR, NETCA, SQL client, SQL Developer, and SQL Loader at various times.
- Supporting projects using the BMC Remedy tool, handling incident, problem, and change management processes.
- Documenting, reviewing, and approving database changes at various levels.
Education
Bachelor of Technology - Electronics And Communications Engineering
Rajasthan Technical University
Udaipur, India10.2014
Skills
- Oracle database management
- Cloning and standby database creation
- Performance tuning
- Azure VM migration
- ITSM platform expertise
- Multi-tenant architecture handling
- Enterprise Manager monitoring
- Quarterly patch management
- Exadata infrastructure management
- Golden Gate troubleshooting
- Pluggable database cloning
- RAC environment configuration
- SQL tuning and troubleshooting
- Data Guard Broker setup
- RMAN backup strategies
- Exadata vulnerability removal
- Oracle Cloud infrastructure
- Data Guard management
Personal Information
Date of Birth: 05/26/90
Hobbies and Interests
- Playing badminton
- Travelling
- Listening to songs
- Watching Premier League football
Education Qualification
Bachelor of Technology (B. Tech.) in Electronics & communication from RTU (Rajasthan Technical University) Kota, Rajasthan with 62.5% (2014).
Certifications & Achievements
- Brilliance Excellence Award by Computacenter for continuous service improvement
- Star Performer Award for December 2021 by Accenture
- Got kudos twice for customer service satisfaction by Fujitsu
- Awarded by Softenger for successful DR drill completion for critical databases
- Completed Oracle certification as 1Z0-047, Oracle Database SQL Expert
- Completed Microsoft Azure Fundamentals AZ-900 and pursuing Azure Solutions Architect AZ-305
Languages
English
Advanced (C1)
C1
Hindi
Advanced (C1)
C1
Timeline
Senior Oracle DBA
Capgemini (Bayer AG)
06.2024 - Current
Technical Consultant
Computacenter (Matsercard)
09.2022 - 06.2024
Senior Oracle DBA
Accenture (Amadeus, BT & Wella)
11.2019 - 09.2022
Technical Service Engineer
Fujitsu (Aurizon, QUU & COGC)
10.2018 - 11.2019
Associate DBA
Perpetuuiti Technosoft (Vodafone & Fiat)
11.2016 - 10.2018
Associate DBA
Softenger (Vodafone)
11.2014 - 11.2016
Bachelor of Technology - Electronics And Communications Engineering
Rajasthan Technical University