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
06.2024 - 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
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.
Senior Oracle DBA
Accenture
11.2019 - 09.2022
- 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
10.2018 - 11.2019
- 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
11.2016 - 10.2018
- 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
11.2014 - 11.2016
- 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
06.2024 - Current
Technical Consultant
Computacenter
09.2022 - 06.2024
Senior Oracle DBA
Accenture
11.2019 - 09.2022
Technical Service Engineer
Fujitsu
10.2018 - 11.2019
Associate DBA
Perpetuuiti Technosoft
11.2016 - 10.2018
Associate DBA
Softenger
11.2014 - 11.2016
Bachelor of Technology - Electronics And Communications Engineering
Rajasthan Technical University
Similar Profiles
Gokul MGokul M
Consultant at CapgeminiConsultant at Capgemini
Muthukumar TMuthukumar T
Consultant at CapgeminiConsultant at Capgemini
Subhankar KarmakarSubhankar Karmakar
Data Analyst at CapgeminiData Analyst at Capgemini