Saumitra Kumar

Upgrade oracle database 12c to 19c

Convert Non-CDB to PDB

Oracle data guard implementation and troubleshooting

DB migration from oracle 9i/10g/11g/12c to 19c and migration of on-prem DB's to OCI or AWS

Managing AWS RDS and EC2 instance

Golden gate implementation and troubleshooting

Golden gate initial load

Golden gate performance tuning

Installed and configure PostgreSQL on Linux

DB migration from oracle to postgresql

Postgresql DB memory tuning

Installed and configure MYSQL DB on Linux

Experience with replication configuration in MySQL

Proficient in writing and optimizing SQL statements

• Implemented capacity planning strategies, optimizing resource allocation and preventing system overloads.
• DB migration from oracle 9i/10g/11g to 12c
• DB migration from oracle to postgresql
• Postgresql DB creation and administration
• Postgresql DB optimization
• MYSQL DB creation and administration
• Experience with replication configuration in MySQL
• MYSQL DB optimization

• Implemented capacity planning strategies, optimizing resource allocation and preventing system overloads.
• Streamlined backup processes, ensuring timely recovery in case of data loss or system failure.
• Assisted in migrating databases to newer versions or alternate platforms, minimizing disruption to business operations.
• Managed user accounts within the Oracle Database environment, granting appropriate permissions while adhering to security protocols.
• Reviewed database design to recommend enhancements or improvements.
• Standby database creation using active data guard
• Export/Import activity
• DB upgrade
• · Database and SQL tuning to improve performance of loads.
• Developing Unix shell scripts and SQL scripts to carry out routine checks on databases. This includes checking whether all databases are running, listener is running, Unix error messages, disk space Contacting Oracle Corporation for technical support.

Creating and maintaining users profile on oracle database.

Export and Import in oracle database 10G/11G

Creating & Managing active standby database.

Oracle database creation.

Monitoring and optimizing performance of database Planning for backup and recovery of database.

RMAN Backup and restoration of oracle database

• Troubleshot database issues to create and resolve trouble tickets.
• Monitored and analyzed database activity to identify and prevent incidents and recommend performance improvements.
• Implemented capacity planning strategies, optimizing resource allocation and preventing system overloads.
• Streamlined backup processes, ensuring timely recovery in case of data loss or system failure.
• Reduced downtime by proactively monitoring and addressing potential issues with the Oracle Database system.
• Modified databases to meet needs and goals determined during planning process.