Vinsee Panwar
Pune
Summary
Efficient administrator eager to leverage knowledge in cloud-based database management systems. Skilled in database security, backup, recovery, high availability and disaster recovery scenario's. Team-oriented with strong work ethics.
Overview
10
10
years of professional experience
Work History
Senior Oracle DBA
Capgemini
2024.06 - Current
- Assisted in management and database administration of Oracle database applications on Exadata platforms.
- Routine health check, patching & bug fix as per Oracle Support Plan.
- Preparing Exadata patching using pre-check operation using patchmgr & gather environment info using Imageinfo, etc.
- Worked on open vulnerabilities to keep security component of Oracle Database Server up to date with latest components.
- Maintained all existing databases and new installations at current and stable production levels.
- Evaluated clients' needs and created plan of action to provide solutions.
- Identified key areas in need of improvement and implemented plans to rectify issues.
Technical Consultant
Computacenter
2022.09 - 2024.06
- 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.
Senior Oracle DBA
Accenture
2019.11 - 2022.09
- Migrating pluggable 18c to 19c databases
- Maintain SYNC between primary & standby databases using Data Guard
- Patching databases with latest path release
- Used Bitbucket and Ansible for automating migration task
- Installing new databases on Azure cloud
- Migrating data from on-premise to Azure VM's
- Releasing node once migration is completed for zero downtime change request
- Decommissioning of old databases and data once database migration gets completed
- Using ITSM tool for modification in change request and their subsequent task records
- Maintaining CMDB and CONTROL-M jobs.
Technical Service Engineer
Fujitsu
2018.10 - 2019.11
- Working in shared model interacting with each customer model, behavior, and priorities
- Daily incident monitoring and prioritize them to close within defined SLA
- Working on critical milestone databases for all environment 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 Datafile backups on OS
- Working on assigned RFC as per implementation plan approval in CAB meetings
- Database duplication, to produce new environment for UAT or Development
- Worked on applying PSU patching scheduled quarterly as per n-1 policy
- Worked on 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 in purging activity as per user requirement
- User management- Creating users, assign privileges, define roles, and assign profiles as per requirements
- Monitoring RMAN backups schedule at 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 searching user and object privileges and dependency.
Associate DBA
Perpetuuiti Technosoft
2016.11 - 2018.10
- DR Drill for single instance database
- Configuring RMAN policies for backup/restore
- Schema refreshment using export/import
- Adding and resizing Datafile
- Installation of Oracle database on various platforms like Linux/Windows
- DB link creation (oracle-oracle)
- ORACLE database upgrade from 10g to11g
- Creation of RAC DR (Standby database) from RAC Primary
- Creation of Standalone DR for RAC Primary
- Creating Disk Group on ASM, adding disks to ASM
- Apply quarterly PSU patches on RAC and single instance database
- Physical Standby creation for standalone/RAC database
- ASM management like addition or removal of disk in Disk Group
- Implementation of physical backups & Configuration of online (hot) and offline (cold) backup
- Export & Import.
Associate DBA
Softenger
2014.11 - 2016.11
- Worked 24x7 rotational as Oracle DBA
- Monitoring numerous databases hosted on various OS i.e., Windows, AIX & Linux servers
- DR Drill for single/ multiple instance databases
- Creating Data Guard configuration
- Applied various patch on database & involved in various OS patching activity
- Extending storage capacity by creating new Table Spaces, adding data files & ASM management
- Maintaining Load on Database Servers for Database performance using TOPAS, VMSTAT, PS & NETSTAT.
- Used tools like ADRCI, NETMGR, NETCA, SQL client, SQL developer and SQL loader at various time
- Supporting project using BMC Remedy tool, handling incident, problem, and change Management process
- Documenting, reviewing and approvals of database change at various levels.
Education
Bachelor of Technology - Electronics And Communications Engineering
Rajasthan Technical University
Udaipur, India10.2014
Skills
- Installation & supporting of Oracle database on operating systems like Linux, Windows, AIX and Solaris.
- Experience in creating & maintaining standby database for versions like 10g, 11g, 12c 18c & 19c.
- Experience in migrating on-premises to Azure VM with minimal downtime by using Oracle Data Pump, RMAN and Data Guard.
- Handling user AD-HOC requests, incidents, change requests and problem tickets using ITSM platforms Service Now, BMC Helix/ Remedy, HP quality center, Rally & Jira.
- Experience in handling Multi-Tenant architecture.
- Proactively monitored & diagnosed symptoms using OEM (Enterprise Manager) to significantly increase the probability of success.
- Apply quarterly PSU patches on RAC using rolling patching, single instance patching, OJVM patching and Golden Gate Homes patching.
- Experience in handling Exadata Infrastructure on X8M and X9M systems.
- Worked on troubleshooting of Golden Gate Classic Architecture for 19 & 12c.
- Experience in cloning pluggable database for migration/ upgrade.
- Worked on single node RAC & multiple node RAC environment.
- SQL tuning & troubleshooting using various tools like Explain Plan, Auto Trace, SQL Trace, TKPROF, AWR, ADDM, ASH & v$ performance views.
- Experience in configuring Data Guard Broker configuration.
- Extensively worked on RMAN backup & recovery strategies.
- Good knowledge of Active Data Guard, snapshot database & flashback feature.
- Experience in upgrading 11gR2 to 12cR1 & 12cR2 to 19c databases.
- Familiar with RAC commands: SRVCTL, CRSCTL, OCRCONFIG for cluster operations.
- Creating new RAC database & decommissioning as per project requirement.
- Creating RAC Disaster Recovery setup & testing it with project approvals.
- Worked on creating new Disk Groups on ASM & adding disks to ASM.
- Troubleshooting cases when standby configuration was not in synch with production database.
- Schema refreshment using EXPDP & IMPDP.
- Analyzing tables and indexes for better performance, rebuilding/reorganizing Indexes.
- Performing any corrective actions required to address errors raised in Logfiles.
- Capacity Planning for future database growth.
- Preparing plan of action & continuous service improvement plan for recurring Incidents/ alerts.
- Preparing Monthly Service Report (MSR) highlighting all activities for that month.
Languages
English
Hindi
Mewadi
Certificationsandachievements
- Star performer award for the December 2021.
- Got Kudos twice for customer service satisfaction by Fujitsu.
- Awarded from Softenger for successful DR Drill completion for critical databases.
- Completed Oracle certification as 1Z0-047 Oracle Database SQL Expert.
- Pursuing Oracle certified professional for Oracle DBA(OCP).
Educationqualification
Bachelor of Technology (B. Tech.) in Electronics & communication from RTU (Rajasthan Technical University) Kota, Rajasthan with 62.5% (2014).
Locationpreference
Pune
Professionalexperiencesummary
Having over 8 years of experience in the field of Oracle Database Administration and I am presently working with Computacenter as Technical Consultant.
Personal Information
Date of Birth: 05/26/90
Hobbies and Interests
- Running
- Travelling
- Watching & playing football
Timeline
Senior Oracle DBA
Capgemini
2024.06 - Current
Technical Consultant
Computacenter
2022.09 - 2024.06
Senior Oracle DBA
Accenture
2019.11 - 2022.09
Technical Service Engineer
Fujitsu
2018.10 - 2019.11
Associate DBA
Perpetuuiti Technosoft
2016.11 - 2018.10
Associate DBA
Softenger
2014.11 - 2016.11
Bachelor of Technology - Electronics And Communications Engineering
Rajasthan Technical University
Similar Profiles
Yasser IdrahouYasser Idrahou
Lead Software Engineer at CapgeminiLead Software Engineer at Capgemini
Sandeep KhadeSandeep Khade
Consultant at CapgeminiConsultant at Capgemini
Sindhu PriyaSindhu Priya
Team Leader - Service Delivery at CapgeminiTeam Leader - Service Delivery at Capgemini