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.

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.
• 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.
• 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.

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.

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.