Bapuji Malla

• Lead and manage a team of database administrators, providing guidance, coaching, and support to ensure their professional growth and development.
• Perform regular database maintenance tasks, including monitoring database performance, optimizing database configurations, and implementing backup and recovery procedures.
• Collaborate with other IT teams to ensure proper integration of databases with other systems and applications.
• Develop and implement database security policies and procedures to protect sensitive data and ensure compliance with industry regulations.
• Oversee the design, development, and implementation of database structures, ensuring efficient storage, retrieval, and processing of data.
• Conduct regular database performance tuning and optimization activities to ensure optimal system performance.
• Plan and execute database upgrades, patches, and migrations, minimizing downtime and ensuring data integrity.
• Develop and maintain documentation related to database administration processes, procedures, and configurations.
• Monitor database usage trends and forecast future database needs, collaborating with stakeholders to plan for database capacity and scalability.
• · Provisioning,Configuration and Administration of OCI Database Cloud Service(DBCS) and Autonomous Database(ADB)
• · Provided database consulting services for major global customers
• · Provided solutions for several production instances as per priority/severity.
• · Implemented several RAC and Dataguard systems.
• · Involved in end-to-end implementation of DBCS.
• · Helped customer to migrate from on-premises database to DBCS.
• · Helped customer to trouble shoot various database,cloud specific issues on DBCS.
• · Involved in Exadata implementation and migration.
• · Helped customer in service failover and switchover testing.
• · NON-ASM to ASM migration support.
• · NON-RAC to RAC conversion support.
• · Resolved several issues related to ADB, DBCS and EXADATA.

· Installation of Oracle 9i/10g,11gfor Production, Testing and Development environments.

· Managing Tablespaces, Datafiles, Control files, Redo Log files

· Creating Database objects, Users, Roles, Profiles for the databases.

· Controlling and monitoring user access to the database for new and existing databases.

· Troubleshooting general issues like DB connectivity issues, Users login issues, and database blocking session issues and database corruptions issues

· Worked on user managed backup strategies and Configured Recovery catalog for RMAN.

· Prepared backup strategy according to the Business Rule Specified by the company

· Uploaded the data between the databases using Export and Import Data pump Utilities refreshing Oracle Databases regularly

· Cloning of production database to the test environment using Recovery Manager (RMAN).

· Pointing time recovery using Flashback Database and normal cold/Hot Backup.

· Recover tables using Flashback recovery and Log miner utility.

· Refreshing the schema from PRODUCTION to DEVLOPMENT/UAT and Vice Versa.

· Refreshing the databases as per customer requirements using Cold Copy/Hot backup, Data pump.

· Configured ASM Instances and Migrated Non-ASM Databases to ASM databases Using RMAN

· Implemented Oracle Dataguard (Physical) standby databases With Data guard Modes Maximum (Performance/Availability/Protection).

· Configured DR setup (standby database) for Physical primary database.

· Verified Fail Over and Switch Over and also managing physical standby Database.

· Check for invalid objects after applying patches or DB refresh and compiling invalid objects.

· Performing regular activities like gathering statistics of Database, Rebuilding the Fragmented Indexes.

· Tune Memory structure like Shared Pool, Buffer Cache and Redo Log Buffers used keep pool and recycle pool for frequently access tables to improve performance

· Performance tuning using SQL TRACE, Tkprof, Explain plan, AWR

· Upgraded Oracle 9i release 2 to oracle 10g release 2 on Linux platform

· Upgraded Oracle 10G release 2 to oracle 11g on Linux platform

· Applying interim patches and patch set in Production, Development and UAT databases.

· Installation of Oracle 9i/10g,11gfor Production, Testing and Development environments.

· Managing Tablespaces, Datafiles, Control files, Redo Log files

· Creating Database objects, Users, Roles, Profiles for the databases.

· Controlling and monitoring user access to the database for new and existing databases.

· Troubleshooting general issues like DB connectivity issues, Users login issues, and database blocking session issues and database corruptions issues

· Worked on user managed backup strategies and Configured Recovery catalog for RMAN.

· Prepared backup strategy according to the Business Rule Specified by the company

· Uploaded the data between the databases using Export and Import Data pump Utilities refreshing Oracle Databases regularly

· Cloning of production database to the test environment using Recovery Manager (RMAN).

· Pointing time recovery using Flashback Database and normal cold/Hot Backup.

· Recover tables using Flashback recovery and Log miner utility.

· Refreshing the schema from PRODUCTION to DEVLOPMENT/UAT and Vice Versa.

· Refreshing the databases as per customer requirements using Cold Copy/Hot backup, Data pump.

· Configured ASM Instances and Migrated Non-ASM Databases to ASM databases Using RMAN

· Implemented Oracle Dataguard (Physical) standby databases With Data guard Modes Maximum (Performance/Availability/Protection).

· Configured DR setup (standby database) for Physical primary database.

· Verified Fail Over and Switch Over and also managing physical standby Database.

· Check for invalid objects after applying patches or DB refresh and compiling invalid objects.

· Performing regular activities like gathering statistics of Database, Rebuilding the Fragmented Indexes.

· Tune Memory structure like Shared Pool, Buffer Cache and Redo Log Buffers used keep pool and recycle pool for frequently access tables to improve performance

· Performance tuning using SQL TRACE, Tkprof, Explain plan, AWR

· Upgraded Oracle 9i release 2 to oracle 10g release 2 on Linux platform

· Upgraded Oracle 10G release 2 to oracle 11g on Linux platform

· Applying interim patches and patch set in Production, Development and UAT databases.