Chinmay Kumar

Experience

• 

  SHA Infotech Solution Pvt Ltd

  Jun 2020 - Sept 2022

  Oracle Database Administrator

  🔷Installation of Oracle Software Binaries for 19c,12c,11G,10G Versions 🔷Detailed Knowledge of Oracle Architecture. 🔷Good knowledge on using Data pump and Physical Backup's like COLD and HOT Backup Restore and Recovery in different scenarios. 🔷Creating and managing database configuration files. 🔷Managing Tablespaces for space management tasks. 🔷Creating and Managing Oracle Users 🔷Create and Managing Profiles for different application requirements. 🔷Monitoring Alert logs. 🔷Working with ASH, AWR, ADDR Reports to see the Top SQL. 🔷Manual Database creation in Oracle11g 🔷Basic knowledge on protection mode.🔷Automation of Database backup using shell script. 🔷DB link Creation & Password less connectivity.🔷Manual Database creation in Oracle11g,12c. Show less

• 

  RENOVISION AUTOMATION SERVICES PVT.LTD

  Sept 2022 - Oct 2023

  Oracle Database Administrator

  🔶Supporting as primary on-call DBA🔶Maintaining database health check reports🔶Stats Gathering of tables/schemas/database on weekly/monthly basis🔶Managing Tablespaces for space management tasks🔶Creating and Managing Oracle Users, privileges, Profiles for different application requirements🔶Monitoring Alert logs🔶Working with ASH, AWR, ADDR Reports to see the Top SQL🔶Performing DR Drill like switchover and failover🔶Performed database restoration activity🔶Experience in Troubleshooting Replication, rebuilt, sync Issues between Production & Standby Environments🔶Good experience in RMAN (Recovery Manager) backup with recovery catalog in 11g /12c/19c databases🔶Upgraded the Database from 11g to 12c and 12c to 19C🔶Performed routine checks of space utilization and adding space to database when it’s needed🔶Performed audit table truncate activity🔶Good experience in Database Upgradation, Migration, Patch Management🔶Good experience in Configuration and Management of Oracle ASM🔶Database bounce activity on a daily basis🔶Conversion of snapshot standby DB to physical standby DB and vice versa after activity in dataguard on a daily basis(MIS Refresh Activity)🔶Performed Index Rebuilding activity Show less

• 

  Techno Electric & Engineering Co. Ltd.

  Oct 2023 - now

  Assistant Manager

  🔍 Oracle RAC: 🔷Monitoring the health and performance of Oracle RAC clusters. 🔷Planning and executing upgrades and patching activities for Oracle RAC environments to maintain security and stability. 🔷Performing SGA Resizing Activity. 🔷Adding disks in Oracle Grid for proper functioning of database. 🔷Restoration of the database with the help of RMAN Utility tool and EXPDP/IMPDP. 🔷Performing defragmentation activity on tables with or without partitioning. 🔷Performing purging activity on tables monthly basis. 💻 SQL Developer: 🔷Writing and optimizing SQL queries for data retrieval, manipulation, and analysis using Oracle SQL Developer or similar tools.🔷Designing and implementing database schemas, tables, views, and stored procedures to support application requirements. 🔷Performance tuning SQL queries and database objects to improve overall system performance and response times. 🔷Managing database connections, sessions, and security settings within SQL Developer to ensure data integrity and confidentiality. 🔷Collaborating with analysts to troubleshoot SQL-related issues and optimize database performance.🐍 Python: 🔷Creating custom tools and utilities using Python libraries for sorting, splitting, merging, eliminating respective data from a file. 🔷Testing and Integrating Python scripts with existing monitoring systems.🐘 PostgreSQL: 🔷Creating and managing PostgreSQL databases, schemas, and users using pgAdmin or command-line tools like psql/SQLShell. 🔷Writing and executing SQL queries and scripts to perform data manipulation and database administration tasks. 🔷Monitoring database performance metrics such as CPU usage, memory usage, and query execution times. 🔷Configuring and managing database backups, replication, and high availability solutions to ensure data protection and business continuity. 🔷Troubleshooting database-related issues, including performance bottlenecks and connectivity problems. Show less