Shyam Reddy

Junior Oracle Database Administrator at Infolob Solutions, Inc.
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Hyderabad, Telangana, India, IN
Languages
  • English Full professional proficiency
  • Telugu Native or bilingual proficiency
  • Hindi Professional working proficiency
Skills

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • Oracle Cloud Infrastructure 2019 Certified Architect Professional
    Oracle
    Jul, 2020
    - Nov, 2024
  • Oracle Cloud Infrastructure Foundations 2020 Certified Associate
    Oracle
    Jul, 2020
    - Nov, 2024
  • Oracle Autonomous Database Cloud 2019 Certified Specialist
    Oracle
    May, 2020
    - Nov, 2024
  • Oracle Autonomous Database Specialist.
    Oracle

Experience

  • Infolob Solutions, Inc.
    • United States
    • IT Services and IT Consulting
    • 1 - 100 Employee
    • Junior Oracle Database Administrator
      • Aug 2018 - Present

       Hands on experience on monitoring Databases. Committed team player with excellent customer orientation. Outstanding logical & problem resolving skills. Oracle performance tuning analysis using Statspack/AWR/ADDM/ASH reports. Good exposure knowledge in applying patches to the database like PSU patches Proficient in UNIX/Linux Operating systems. Quick adaptability to new technologies & Zeal to improve technical skills. Having expert knowledge in Configuring and maintaining RMAN. Provided 24X7 on call support. Dataguard Setups, fixing bugs, applying Patches, Managing ASM Databases, Performance issues on RAC Databases. Upgraded Oracle 11.2.0.3 database to Oracle 11.2.0.4 database manually/DBUA.  Collecting and generating hourly stats by AWR Report whenever there are performance issues. Coordinating with other teams like testing / Developers for fixing up issues. Creating Oracle Service Request with Metalink for ORA-600/7445 error and other Generic issues. SQL Quarantine - Starting Oracle 19c, SQL Quarantine features helps to prevent reuse of same execution plan which was terminated by resource managers due to resource limits. This will help not to run the rouge queries again on the database if the resource manager is active.

  • Att Solutions Pvt Ltd
    • India
    • IT Services and IT Consulting
    • 1 - 100 Employee
    • Oracle Database Administrator
      • Jan 2015 - Jul 2018

       Successfully implemented and managing Physical Standby Database using Oracle DATAGAURD feature for Disaster Recovery. Expertise in performing Switch Over and Switch Back activity from production to standby. Create databases for development, testing and production (including RAC databases and NON-RAC databases). Communicating with the Client Technical/Service Leads and satisfying the Client needs yet to their requirements. Resolving On–Call issues including Monitoring, Ticket resolution and Work/ Change requests. Extensive hands on experience on recovery of data block corrupted databases using RMAN. Performing Refresh activities from Production to Staging/development using RMAN and Data pump.  Scheduling and managing crontab Jobs. Managing Archive logs and Full Back up by RMAN. Moving or backing up old archives with RMAN if File system is filled. Identifying and improving poorly performing SQL Statements, adjusting the most important optimizer parameters.  Migrating database from Non RAC to RAC Environment, cross plat form migration. Enabling archive log and flash back database. Rebuilding standby database using production backup and making sure DR and PROD are in sync after change. Managing Physical structure of Oracle database like Data files, Redo log files, Control files. Monitoring the growth of Tablespaces and taking proper actions. Trend Analysis of Database for future need of space. Maintaining security and integrity of database of database systems

    • Network Engineer
      • Sep 2013 - Dec 2014

       Establish a network management strategy and solution according to business and operational needs and standards for customer requirements.  Maintaining KPI’s SSSR, RRC CSR, VDR, HOSR etc. Maintaining the RF KPIs above the defined threshold through field optimization and parameter Optimization for LTE and VOLTE. Coordination with Survey team for New Site identification for capacity & coverage improvement, RF site survey approval/disapprovals. Manage site process and review milestone (RFE, RFR, RFS)  Responsible for VIP customers 4G coverage solution through Wi-Fi, Small Indoor /Outdoor cell in Hotspot area.4G Cluster optimization and new sites test follow up (SFT). Planning and prediction for new Outdoor (Macro, Micro and Pico (Small Cells)) and Indoor (IBS) sites based on traffic dimensioning and survey. Analyze customer complains & take necessary actions to resolve.  Provide Feedback for site planning, in-building solutions planning & optimization. New sites planning with respect to coverage holes and capacity enhancement purpose. Periodical Drive/walk test of Macro site, small cell & Wi-Fi.

Education

  • Jawaharlal Nehru Technological University
    Bachelor's degree, Electrical, Electronics and Communications Engineering
    2009 - 2013
  • Pragathi Vidyalayam
    SSC, MAths
    2005 - 2007

Community

You need to have a working account to view this content. Click here to join now