AVINASH S.

AVINASH S.

Oracle Database Administrator

Kolkata , Singapore

Experience: 9 Years

AVINASH

Kolkata , Singapore

Oracle Database Administrator

26880 USD / Year

  • Immediate: Available

9 Years

Now you can Instantly Chat with AVINASH!

About Me

Around 8 years of experience in Oracle Database Administration Experience in Oracle Golden Gate Implementation/Maintenance Experience in Implementing Replication between on-premises and DBCS using GGCS Experience in Oracle Cloud Services, ExaCM. Good...

Show More

Portfolio Projects

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

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

Description

My roles and responsibilities in the project: 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. Configured IORM and Instance caging 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 its using Smart Scan or not.

Show More Show Less

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

Description

Leveraging deep integrations into retailers point-of-sale systems, Incomm provides connectivity to a variety of service providers that allow consumers to conduct everyday business at more than 500,000 points of retail distribution. Whether those consumers are activating prepaid products, paying bills, enjoying real-time discounts through a membership card, purchasing digital goods in-store or adding funds to an online account, Incomm is there to provide unique gift-gifting opportunities, cater to on-the-go shoppers, deliver added value through loyalty programs and serve cash-based consumers. My roles and responsibilities in the project: 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 PLSQL blocks. Tuning Queries, SQL, PLSQL. 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

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

Description

Sweden Project includes all the Sweden Customer databases which logica supports from offshore. This project has its own Ticketing tool (Service Center) & Multicenter (Servers monitoring and for taking control). All customer servers are listed into Multicenter from which the logins, alert details and all other details related to the server can be found.

Show More Show Less

Description

Sanofi S.A. is a French multinational pharmaceutical company headquartered in Gentilly, France, as of 2013 the worlds fifth-largest by prescription sales. Below were my roles and responsibilities: 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. Ensuring regular RMAN backups & archive backups to the Networker Backup Server. Installation and Creation of Prod, Dev and Test environments

Show More Show Less