Rajasekhar Reddy Email & Phone Number

Seattle, Washington, United States

• Consult for optimal design of database environments, analyzing complex distributed production deployments, and making recommendations to optimize performance• Architecting advanced database architectures for web-scale and enterprise applications to achieve simplicity, massive scale, resiliency and maintainability• Setting-up and configuring database architectures based on best practices• Automating deployment, configuration and operations of the architectures• Responsible for Migrating Non-Exacc Oracle Servers to Exadata Cloud@Customer X7-2, X8-2 Quarter Rack.• Responsible for Planning, Designing, and Migrating the Database as per the business requirements to the Exacc environment.• Responsible for Planning, Installation, Configuration, Monitoring, and Deployment of database Exacc environment.• Responsible for upgrading 11g, 12c Database to 19c in Exacc Environment. • Hands-on experience building an Exacc VMs Machine from the Scratch as per the business requirements. • Converting Non-PDB Databases to PDBs and plugging into the CDB on Exadata Cloud@Customer X7-2.• PDB Cloning on the Container Databases on Exadata Cloud@Customer X7-2.• Setup a Dataguard, DG Broker configuration on the Exadata Cloud@Customer X7-2.• Hands-on experience in Applying Grid, VM OS, and Database Patches on the Exadata Cloud@Customer X7-2.• Hands-on experience in Administration and Maintenace on Exacc Cloud Environment. • Hands-on experience in Migrating the Exacc Database from X7-2 to X9M-2.• Hands-on experience in building a new VM Cluster, and building the Exacc Environment from the scratch.

Seattle, Washington, United States

• Responsible for Installation/Configuration and Troubleshooting Oracle schema, tables, and indexes as per the application requirements and setting up the replication using Oracle Golden Gate (uni-directional, bi-directional).• Responsible for troubleshooting the oracle golden gate like process failures, Trail-file Issues, Synchronization Problems, Startup problems on the source and target system, and Database configuration and availability issues.• Responsible for assisting the application team in executing DML, and DDLs on the golden gate database.• Responsible for configuring OGG for initial data load for configured tables, and adding new tables to the existing environment in the dev/test and prod environment.• Responsible to establish and maintain sound backup and recovery policies and procedures using RMAN.• Responsible for managing and supporting all Production, Development, Perf, CAT, and Staging instances of Oracle Version 10g,11g,12c, 18c, and 19c Database. • Responsible for RAC, ASM cluster Installation, Administration, and Maintenance. • Responsible for Database upgrades from older version databases latest version. (11g to 12c, 12c to 19c).• Responsible for performing SQL Query Optimization, database tuning, and performance monitoring.• Responsible for Administering Maintaining and Configuring the High availability of solutions(RAC, Oracle Dataguard, Oracle Golden Gate, and the annual DR setup) etc., • Responsible for Applying Database PSU Patch on the RAC, Standalone database using opatch utility.• Performing Schema Refresh Periodically using EXPDP/IMPDP, as needed for Application Team.• Responsible for Converting the Physical Standby Database to Snapshot Standby to allow the application team for their release testing whenever needed/or during Annual DR testing.

Greater Hyderabad Area

• Installation and Applying Oracle CPU patches, Creation, configuration of Oracle databases in both RAC and Non-RAC database environments.• Installation of Oracle Enterprise Manager Grid Control for efficient Monitoring all the RAC and Non-RAC Databases. Setting Metrics Thresholds and Policies in Grid Console.• Monitoring High Availability of RAC Databases Servers, configuring users and E-mail notifications from Oracle Enterprise Manager Grid Control to Outlook and Handheld devices.• Performing Query tuning and Database Tuning.• Troubleshooting the daily Production/Development/Test environment problems.• Schema Migration and Tables Migration from QA to Production and Database refresh from Production to QA / Development environments. Database cloning using RMAN scripts.• Maintenance of Production / Staging/ development Databases.• Migration of Oracle 11.1.0.7 database on windows to Oracle 12.1.0.2 on OEL 6x.

Hyderabad, Telangana, India

• Taking care of tablespace related issues like increasing the storage parameter values, resizing the datafiles, adding new datafiles etc.• Creating different users and granting them appropriate privileges and roles• Cloning the database for Testing and Reporting Purpose.• Configured and maintaining Data Guard (Physical Standby database) for the production database and tested for Switchover, activating the standby to primary.• Developed PL/SQL code to capture encryption and scramble credit card and SSN table data activities by scheduling an automated job. Partitioned large tables to enhance faster querying.• Tuning of memory, SQL statements & handling performance tuning issues. Implement appropriate database and operating system audits as a major part of a system security methodology. Monitoring performance using AWR, ADDM reports and resolve locks on database and enable auditing for critical DDL operations• Refresh stage and UAT databases from production using Mviews, data pump and RMAN methods.• Encrypting database exports and RMAN backups, Oracle SQL*Net network traffic and setup SSL based authentication for network data.• RAC Database has been implemented and tested for TAF and RMAN backup in RAC, Load balancing.