Manjula Yandapalli

• Worked in 11g/12c clustered environment with high availability.
• Worked extensively on DB version upgrades, migrations and patching in both stand-alone and clustered environments. . Installed and configured Oracle on various operating systems for OLTP (Online Transaction Processing) and Data Warehouse environments.
• Implemented Disaster Recovery (DR) High Availability Oracle solutions by installing, configuring and maintaining Data Guard and RAC databases on various platforms.
• Proficient in using Flash-Back Recovery and perform manual recoveries by using RMAN managed backups with/without catalog, archive logs, cold and hot backups, full backups, incremental and cumulative backups.
• Experienced in using Oracle cloud control 12c/13c for monitoring, managing and maintaining Oracle Databases.
• Monitor and optimize the performance of the databases using AWR/ADDM tool using Oracle Cloud Control.
• Implemented Oracle TDE to provide transparent encryption of stored data.
• Modified database structures including tablespaces, tables and various objects as well as configuration and storage allocation to support application enhancement.
• General DBA Support that involved various usage monitoring, table/index rebuilds and reorganizations etc.
• Assisted in designing conceptual, logical and physical data models. . Test and promote Quest SHAREPLEX replication tool between different instances for High Availability.
• Created, scheduled, and worked on database maintenance tasks that involved upgrades, patching, table/index analysis, index rebuild, materialized views refresh, DB exports and regular day to day tasks.
• Monitor production databases with Oracle Enterprise Manager (OEM) to troubleshoot and diagnose database issues.
• Provide technical research, development, and consulting services to support department applications.
• Control, design, upgrade, and integration of complex Oracle Database systems
• Provide advanced problem resolution support and diagnosis.

• Installing, troubleshooting, operating, testing, planning, configuring and Tuning 9i,10g, and 11g Databases.
• Worked in RAC, 11g migrations, upgrades, CPU (Critical Patch Upgrades) patching, ASM and Data Guard
• Monitoring space usage and ASM administration using ASMCMD command. Adding disk to disk groups and performing ASM disk group rebalance when required. Good hands-on experience in Oracle Grid Infrastructure by using SRVCTL and CRSCTL commands to start, stop, configure, modify and verify the cluster resources.
• Extensive experience recovering with RMAN on Real Application Cluster and standalone databases. Recovered several databases when UNDO, TEMP, SYSTEM table spaces and Control Files got corrupted.
• Clone Databases using RMAN Backups. . Monitoring Day to Day Backups, Log's recovering them as per the requirement. Utilized LOG MINER Technology applied Application Database Transactions on other Databases.
• Successfully implemented oracle 11gR2 Physical Standby database using Oracle Data guard in high availability configuration . Extensive experience as 24x7 DBA supporting multiple clients, attending Incidents and Normal/Emergency changes. All the activities were documented with details that got delivered to customers. 9i,10g/11g, IBM AIX, Linux Sun Solaris, SQL, PL/SQL, TOAD, UNIX Windows XP, SQL Navigator, SQL* Loader, RMAN

• Install, configure, and support Oracle Database (Release 10g/11g) for Dev, QA, Staging, UAT and Production environments.
• Monitoring all the databases for tablespaces and OS disk space usage and add space as necessary. . Installed the Grid Control agents on all the DB servers to better monitor the performance and gather a lot other metrics for the target databases.
• Executing Database script for scheduled releases on all the database environments.
• Refresh the data from Prod to UAT/Staging/QA databases on need basis using expdp/impdp and RMAN utility.
• Identifying the long running queries from Grid control monitoring and working with Development team to get the explain plan for such long-running queries and suggest a preferred query hint or any other query changes to make the query faster.
• Expertise in configuring and Implementing Encryption & Compression in 11g . Writing Unix Shell script to track and monitor database alerts and scheduled the scripts
• Configured, implemented, Upgraded 10g/11g RAC with GPF's file system on AIX servers. . Extensively Used Explain Plan, SQL Trace, AWR, ADDM and ASH reports to Monitor Performance Tuning. . Interacting with the users and troubleshooting the problems involved with the development of stored procedures, triggers and with the privileges. . Scheduled scripts to monitor each of the RAC nodes and to detect any RAC hang check.
• Used expdp and impdp commands for database back-up and refresh activities.
• Created automated scripts to make hot snapshot backup and RMAN backup (both Full & Incremental) for the Oracle database.
• Created physical Data Guard for Production database for the purpose of datacenter move (HDC to CDC) . Executed the backup/recovery drill by recovering a copy of the database from the hot backup and documenting the steps.
• Created database monitoring jobs through UNIX shell scripts and scheduled the scripts through cron job . Writing Technical Specification Document (TSD) and oracle stored procedure for new client's Migration project.
• Created and maintained read-only users for non-dev databases and scheduled jobs to set read-only access for new tables.
• Extensively worked on Oracle stored procedure, function, package, trigger and other oracle objects
• Developed scripts to create table, view, materialized views, external table, index, sequence, synonyms, grant privilege along with the DB storage clause, wherever required. . Extensively worked on many database development tools such as TOAD, SQL Navigator, and PL/SQL developer.
• Worked on optimizing new and existing SQL queries by creating index and Materialized views.
• Expertise with Partitioning of very large tables AIX, Solaris, XP, Navigator

• Install, configure and support Oracle Database (Release 10g) on all the environments.
• Installed Oracle Cluster ware CRS, Clustered Install of Oracle 10g, applying patch in clustered environments, created database / instances using DBCA on a four-node cluster, troubleshooted RAC at OS / OCR / CRS / DB Level.

. Installed the Grid Control agents on all the DB servers to better monitor the performance and various other metrics for the target database.
• Executing Database script for scheduled releases on all the database environments.
• Refresh the data from Prod to UAT/Staging/QA databases on need basis using expdp/impdp utility.
• Identifying the long running queries from Grid control monitoring and working with Development team to get the explain plan for such long-running queries and suggest a preferred query hint, indexes, materialized views to make the query faster. . Installed and configured 10g Real Application Cluster (RAC) and added 2 Nodes to make it a 6 Node RAC. Maintaining large OLTP databases on RAC Environment. . Added and relocated the OCR Mirror and Voting Disks to existing RAC Setups to prevent Single Point of failure and scheduled & tested their physical and logical backups. . Did Extensive Performance Tuning of RAC Databases including Interconnect Tuning too.
• Implemented Oracle Data Guard 10g (Logical and Physical) as Oracle's data protection, High Availability and disaster recovery solution. . Writing Unix Shell script to track and monitor database alerts and scheduling the scripts through grid control servers.
• Used export and import commands for database back-up and refresh activities.
• Create hot snapshot backup and RMAN backup (both Full & Incremental) for the Oracle database. . Added new instances to the cluster DB and removed instance from the cluster. . Experience in working with CRS related commands. . Extensive Performance Tuning, Memory (SGA) Tuning, Locks and Latch resolution in DBBC and Shared pool. Monitoring and optimizing the Performance of the database using AWR/ADDM tools, STATSPACK & TKPROF.
• Created database monitoring jobs through UNIX shell scripts and scheduled the scripts through cron job
• Writing Technical Specification Document (TSD) and oracle stored procedure for new client's Migration project.
• Created and maintained read-only users for non-dev databases and scheduled jobs to set read-only access for new tables.
• Extensively worked on Oracle stored procedure, function, package, trigger and other oracle objects for Canvas projects (such as, new client migration and data archival job).
• Developed scripts to create table, view, materialized views, external table, index, sequence, synonyms, grant privilege, DBMS jobs including the storage clause, wherever required. . Extensively worked on many database development tools such as TOAD, SQL Navigator, and PL/SQL developer.