Avinash S.

Avinash S.

Exadata DMA & Oracle DBA

, Singapore

Experience: 9 Years

Avinash

Exadata DMA & Oracle DBA

26880 USD / Year

  • Immediate: Available

9 Years

Now you can Instantly Chat with Avinash!

About Me

I am a core Oracle DBA with a good experience  on other RDBMS like postgreSQL and mySQL. Overall i have around 9 years of experience.

...

Show More

Portfolio Projects

DBS Bank Exadata Support

Company

DBS Bank Exadata Support

Description

  • Performing Image upgrade of the Exadata Machines.
  • Checking the status of Cell Disks and Raising SR if Disk falls to POOR PERFORMANCE state
  • Migrated Databases from X3 to X7 machines.
  • Upgraded Databases from 12c to 19c.
  • Applying interim patches to Oracle Home.
  • Upgrading OEM 13.2 to 13.3 and deploying plugins.
  • Implementing ISCD on O.S as well as Databases as per the bank’s policies.
  • Troubleshooting Network issues in the X7 Machine at the Data-Centres.
  • Exadata machines maintenance and management experience.
  • Configuring Backup I.P, NTP servers in the Exadata boxes.
  • Solid skills to configure Exadata to meet company internal security requirement.
  • Hands-on experiences in software and firmware maintenance of both the Database and Storage servers in the Exadata database machine including upgrades and patching.

Show More Show Less

Voya Financials Inc

Company

Voya Financials Inc

Description

  • Monitoring Exadata Db-Servers and Cell-Servers, InfiniBand and Admin Switches using OEM, CellCLI and DCLI.
  • Running Health check, ExaChk and SunDIAG Reports.
  • Checking out the effectiveness of Flash Cache.
  • Applying Bundle Patches, One-Off Patches.
  • Performing Image upgrade of the Exadata Machines.
  • Checking the status of Cell Disks and Raising SR if Disk falls to POOR PERFORMANCE state
  • Participated in half-yearly Emergency Preventive Maintenance activity.
  • Checking out for the queries whether it is using Smart Scan or not.

Show More Show Less

Tools

Toad

Incomm Holdings Inc.

Company

Incomm Holdings Inc.

Description

  • Performing Load testing for SQL Queries and tuning the Queries when required.
  • Deploying SQL Queries called as ‘Rule Query’ in the Production UI.
  • Scheduling and Maintaining jobs using PL\SQL blocks.
  • Tuning Queries, SQL, PL\SQL.
  • Implemented TDE in Oracle 11gR2.
  • Implemented Data Redaction in Oracle 12c.
  • Upgrading databases from 11.2.0.4 to 12.1.0.2.

Show More Show Less

SANOFI AVENTIS

Company

SANOFI AVENTIS

Description

  • Analysis of the specifications provided by the clients
  • Administrating Exadata Servers
  • Handling Incident tickets to ensure 24x7 database availability
  • Implementing change requests in plan time.
  • Coordinating with clients & other team to fulfill their requirements.
  • Identifying blocking users in application transaction
  • Creating Users with quota Management and assigning the relevant profiles
  • Granting specific privileges and roles to the users
  • Implemented invalid login attempts auditing
  • Re-organization of tables and logical structures to remove fragmentation
  • Resolved oracle performance issues involving disk I/O, CPU Usage, Query tuning.
  • Performed capacity planning in order to be ready for space requirements
  • Trouble shooting databases issues to be in-line with SLA.

Show More Show Less