Swapnil N. Kumbhare
Pune
Summary
Dynamic database professional with extensive experience at Tata Consultancy Services, excelling in Oracle database management and disaster recovery. Proven expertise in RMAN and Data Guard, ensuring high availability and performance. Strong analytical skills complemented by effective collaboration with cross-functional teams to drive successful data-oriented projects.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Assistant Consultant
Tata Consultancy Services
Nagpur
05.2023 - Current
- Working in 24x7 production environment and provided on-call and day-to-day support. Monitor production, Pre-production and development database servers.
- Primarily responsible for the stability of the production system for various versions of oracle databases.
- Provides hands-on technical expertise, provides senior-level technical guidance to the team, project leaders, and other teams as required.
- Work closely with multiple application development teams to implement and support data-oriented development efforts.
- Responsible for database upgrades, performance monitoring, installations, managing replications, diagnosing system problems, disaster recovery testing and maintaining user accessibility.
- Monitoring database backup status daily, and resolving backup-related issues.
- Managing daily ticket, Change Request, incident management through the Service-now tool.
- Performing schema and export / import with data pump utility, Configured RMAN recovery catalog database.
- Monitor all the in-house databases using OEM 13c.
- Backup and Recovery Planning for database using RMAN utility of Oracle to maintain database availability.
- Worked on patching of standalone database as well as RAC grid and RAC database.
- Worked on Database cloning through RMAN cloning, Cold backup and Import/Export.
- Performed database upgrade from version 12.2.0.1 to 19c.
- Upgraded RAC grid and database upgrade from 12c to 19c.
- Configured from scratch and maintain RAC and ASM storage.
- - Monitor and maintain health of Exadata components including compute nodes, storage cells, and InfiniBand switches using OEM and EXACHK.
- Coordinate with Oracle support for SRs and ASRs, assisting in diagnostics and log collection.
- Execute standard operating procedures for ILOM access, node reboots, and disk replacements.
- Assist in quarterly patching activities by preparing systems, verifying prerequisites, and performing post-patch validations.
- Generate and analyze EXACHK reports, flagging deviations and initiating corrective actions.
- Maintain SOX compliance documentation and support audit activities for database and infrastructure components. - Manage and troubleshoot Exadata Cell and Database servers, including Grid Disks and Flash Cache.
Database Administrator
TEKsystems
Pune
10.2022 - 05.2023
- Daily Monitoring of Oracle Database through crontab script and OEM database checklists in form of report.
- Installed database binaries and create database as per business requirement. Monitoring of space related issues and tablespaces.
- Monitoring of daily database backup RMAN, export/import.
- Adding datafiles, resizing datafiles, rename data file etc. to databases as per requirement. User/schema creation and granting privileges.
- Managing ASM storage.
- Restore production database backup on test environment. Creating and managing standby database.
- Administration skills in Data guard like Resolve archived log shipping gap etc.
- Monitor Standby Databases to protect enterprise data from failures, disasters, errors, and corruptions.
- Installation and configuration of Oracle 19c/12c/11g data guard, switchover and failover.
- Resolve archived log shipping gap etc. in data guard. Ensuring health of standby database.
- Adding disk group in ASM Team.
Senior Software Engineer
Wipro Limited
Pune
04.2019 - 09.2022
- Monitor all the in-house databases using OEM 13c.
- Backup and Recovery Planning for database using RMAN utility of Oracle to maintain database availability.
- Hands-on experience on patching of standalone database as well as RAC grid and RAC database.
- Hands-on experience on Database cloning through RMAN cloning, Cold backup and Import/Export.
- Performed database upgrade from version 12.2.0.1 to 19c.
- SQL
- Plus: Command-line interface for executing SQL commands.
- RMAN (Recovery Manager): For backup and recovery tasks.
- Toad for Oracle: A popular database management tool for development and administration.
- Data Guard: For disaster recovery and high availability setups.
- Oracle Data Pump: For fast data export and import.
Associate Consultant
Teradata
Pune
10.2017 - 03.2019
- Managed AWS RDS, EC2, S3, VPC environments.
- Conducted Teradata administration & backup optimization.
- Create/manage users, roles, profiles, and access rights. Work with security admins to enforce logon/logoff policies.
- Allocate and monitor permanent, spool, and temporary space using views like DBC.DiskSpace.
- Create/manage databases, tables, views, macros, stored procedures, UDFs, journals, and query logs.
- Use ARC utility and permanent journals for data archive, restore, and recovery.
- Handle system restarts, default settings, and periodic maintenance tasks.
Database Administrator
Mphasis (Fore Brain Technologies Payroll)
Pune
06.2015 - 09.2017
- Logical backups using Traditional import, export and DATAPUMP.
- Monitoring Alert logs for any errors, problems or processes running.
- Creating and managing tablespace, user account, Roles, Profiles etc.
- Generating AWR, ASH, ADDM report, Explain Plan for DB performance evaluation.
- Data Guard Management - Checking lagging status, removing lagging of archives, checking processes like RFS/MRP, Archives Management.
- Monitoring the operating system response in terms of CPU usage, disk space, and swap space by using various UNIX utilities like VMSTAT, TOP, TOPAS.
- Database Migrations and Upgrades.
- Patch Management.
- Data Integrity and Consistency Checks.
- Security Management.
- Backup and Recovery.
- Database Monitoring and Health Checks.
Education
Oracle DBA Certification Course -
Focus Institute Pune
01.2014
Bachelor of Engineering - Information Technology
01.2013
Skills
- Oracle database management (10g-19c)
- PostgreSQL administration
- Teradata analytics
- Change request management
- Audit compliance
- Problem solving
- Effective communication
- Team collaboration
- Change management
- RMAN and Data Guard
- OEM monitoring tools
- AWR performance tuning
- Linux systems administration (RHEL, AIX)
- Windows operating systems
- ServiceNow ticketing system
- HPSM9 support management
- BMC Remedy ITSM
Certification
- Oracle Certified Associate (OCA)
- AWS Solutions Architect - Associate
- Microsoft Azure Fundamentals DP-300
Locations
- Pune, Maharashtra
- Nagpur, Maharashtra
Core Skills
Oracle (10g-19c), PostgreSQL, Teradata, AWS (RDS, EC2, S3, VPC), RMAN, Data Guard, OEM, AWR, Linux (RHEL, AIX), Windows, ServiceNow, HPSM9, BMC Remedy
Timeline
Assistant Consultant
Tata Consultancy Services
05.2023 - Current
Database Administrator
TEKsystems
10.2022 - 05.2023
Senior Software Engineer
Wipro Limited
04.2019 - 09.2022
Associate Consultant
Teradata
10.2017 - 03.2019
Database Administrator
Mphasis (Fore Brain Technologies Payroll)
06.2015 - 09.2017
Oracle DBA Certification Course -
Focus Institute Pune