Zum Hauptinhalt springen
Tushar Sharma

Tushar Sharma

Oracle Database Administrator

Talente
Munich, Kreisfreie Stadt München, Oberbayern50 EUR/StundeMitglied seit 13. November 2024
·

Dienstleistungen beauftragen

Fordern Sie unverbindlich ein Angebot an

solution designdatabase administrationdatabase migrationoracle integration cloud deploymentsoracle golden gatejenkinslinux shell scriptsoracle database administratoransible

Über

Strong 11 years experience in Oracle 19C/12C/11g database, PL/SQL, Mongo, MySQL, Azure, PostgreSQL, Linux, CentOS, Oracle Exadata and Oracle Cloud Integration.

  • Operating systems: All flavours of Unix with specialization of Linux (CentOS, Red-Hat, Solaris & Ubuntu), IBM AIX and Windows.
  • Database size: 5 TB to 25 TB.
  • Skillset: Database Administration, Solution design, Database Migration and manageability for enterprise Applications in Datacentre, Oracle Integration Cloud Deployments.
  • Playbook configuration using ansible and Jenkins.
  • Certifications: OCA, OCP, OCE and ITIL

Berufserfahrung

Database Administrator 06/2022 – present

Verimatrix GmbH, Ismaning, Deutschland

  • Responsible for handling and governing database versions of Oracle Exadata, Mongo, Oracle, MySQL, PostgreSQL on Linux, Solaris and CentOS platform.
  • Hands on experience in Aure Cloud integration with migration.
  • Working experience in PL/SQL infrastructure. Performance tuning with modifying different db objects.
  • Hands on experience with Integration frameworks offered by OIC to integrate with Oracle Cloud SaaS (ERP, EPM) applications
  • End to End Database Migration from On-Prem to Cloud Infrastructure including Virtual Network Design
  • Taking part in project implementation meetings, sales and operation of projects within the organisation.
  • Responsible for Database Administration, Solution design, Database Migration and manageability
  • Installed, configured administration of data replication solutions using Oracle Golden Gate 19C/12C/11g and worked with logdump, blowfish encryption, initial load, performance and tuning.
  • Worked on replication and upgrade production databases zero downtime with Oracle Golden Gate.
  • Takes care of L3 troubleshooting for Oracle Database 19C/12C/11g, Golden Gate, RAC and Dataguard, Attunity AWS migration tool, Attunity Migration Tool,
  • Linux Shell scripts and python programming
  • Monitoring and troubleshooting the Single Instance Database and RAC Database Performances through Database Tuning, System Tuning and Application Tuning using EXPLAIN PLAN, STATSPACK, AWR, ADDM, DBMS_SYSTEM, SQL ADVISOR, DBMS_STATS, TKPROF.

Rollout Engineer (Oracle) 01/2021 – 06/2022

European Computers Telecom, München, Deutschland

Client Projects: Deutsche Telekom, Virgin Media, Nokia, DTMS.

  • Installed, configured administration of data replication solutions using Oracle Golden Gate 19C/12C/11g and worked with logdump, blowfish encryption, initial load, performance tuning.
  • Working and administration of Azure cloud integration.
  • In-depth understanding of data structure, joins, indexes for performance tuning.
  • Responsible for administration of Oracle Exadata databases and technical troubleshooting.
  • Takes care of L3 troubleshooting for Oracle Database 19C/12C/11g, Golden Gate, RAC and Dataguard, Attunity.
  • End to End Database Migration from On-Prem to Cloud Infrastructure including Virtual Network Design, routing rules, security groups, Instance creation, and database deployment.
  • Knowledge and hands on experience with Integration frameworks offered by OIC to integrate with Oracle Cloud SaaS (ERP, EPM) applications.
  • Responsible for Database Administration, Solution design, Database Migration and manageability.
  • Worked on replication and upgrade production databases zero downtime with Oracle Golden Gate.
  • Takes care of L3 troubleshooting for Oracle Database 19C/12C/11g, Golden Gate, RAC and Dataguard, Attunity AWS migration tool.
  • Attunity Migration Tool, Linux Shell scripts for RMAN backup,
  • Managing Postgre and mysql database.

Senior Software Engineer (Oracle) 04/2020 – 12/2020

Gemini Solutions, Delhi, IN

Client Project: PIMCO, USA

  • Installation and administration of Oracle 12c/11g RAC database and Oracle Exadata. Technical troubleshooting.
  • Responsible for database design and database manageability according to clients need.
  • Hands on experience working with Oracle Integration Cloud
  • Responsible for end to end Oracle ERP Cloud integration project.
  • Hands on experience with Integration frameworks offered by OIC to integrate with Oracle Cloud SaaS (ERP, EPM) applications
  • Backup and Recovery of RAC database from media failure and instance failures. Tune instance recovery and configuration of RMAN for the RAC environment.
  • End to End Database Migration from On-Prem to Cloud Infrastructure including Virtual Network Design, routing rules, security groups, Instance creation, and database deployment.
  • Installation and administration of Oracle 12c/11g RAC database on Linux servers’ version 5 and 6.
  • Backup and Recovery of RAC database from media failure and instance failures. Tune instance recovery and configuration of RMAN for the RAC environment.
  • Analysis Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) for Single Instance Database and RAC Database.
  • Installation and administration of Physical Standby Disaster Recovery Databases.
  • Hands-on experience in setting up & managing Oracle Standby Databases using RMAN utility and Datapump utility, for both Physical and Logical supported by DATAGUARD.

Senior Software Support Engineer (Oracle) 07/2018 – 03/2020

R Systems, Delhi, IN.

Client Project: Attunity, Israel.

  • Perform the proficient role in providing L3 level support, that requires Database Administration, maintenance and troubleshooting on the databases with Oracle releases 10g/11g/12c in 24x7 rotational shift support.
  • Working on Oracle Cloud Infrastructure intensively for customers.
  • Responsible for end to end Oracle ERP Cloud integration with Integration frameworks offered by OIC to integrate with Oracle Cloud SaaS (ERP, EPM) applications.
  • Installation, upgrade and administration of Oracle 11g and 12c databases through GUI &silent mode.
  • Installation and administration of Oracle 12c/11g RAC database on

Linux servers’ version 5 and 6.

  • Backup and Recovery of RAC database from media failure and instance failures. Tune instance recovery and configuration of RMAN for the RAC environment.
  • Monitoring and troubleshooting the Single Instance Database and RAC Database Performances through Database Tuning, System Tuning and Application Tuning using EXPLAIN PLAN, STATSPACK, AWR, ADDM, DBMS_SYSTEM, SQL ADVISOR, DBMS_STATS, TKPROF.
  • Performance tuning in single instance and RAC database environment.
  • Installation and administration of Physical Standby Disaster Recovery Databases.
  • Hands-on experience in setting up & managing Oracle Standby Databases using RMAN utility and Datapump utility for both Physical and Logical supported by DATAGUARD.
  • Attending client meetings on webex and over Lync chat call or skype for day to day planning and making strategy to implement it.
  • Meeting clients to review SLAs on daily, weekly and monthly basis.

Senior Operation Professional (Oracle) 04/2016 – 06/2018

IBM, Delhi, IN.

Client Project: State Street Corporation, USA.

  • Designed, installed, and configured high-performance active/active data replication solutions using Oracle Golden Gate 11g/12c replication for RAC and Standalone Database.
  • Administration of Azure Cloud database. Troubleshooting and manageability.
  • Responsible for end to end Oracle ERP Cloud integration.
  • Experience in Oracle Cloud Integration (OIC) with Oracle SaaS applications.
  • Installed, configured and administer oracle cloud grid control 12c and deployed agent monitor targets and setup dynamic group and matrix and polices.
  • Linux Shell scripts for RMAN backup, databases and monitor physical standby databases.
  • Installation, upgrade and administration of Oracle 11g and 12c databases through GUI &silent mode.
  • Monitoring and troubleshooting the Single Instance Database and RAC Database Performances through Database Tuning, System Tuning and Application Tuning using EXPLAIN PLAN, STATSPACK, AWR, ADDM, DBMS_SYSTEM, SQL ADVISOR, DBMS_STATS, TKPROF.
  • Performance tuning in single instance and RAC database environment.
  • Hands-on experience in setting up & managing Oracle Standby Databases using RMAN utility and Datapump utility for both Physical and Logical supported by DATAGUARD.

Oracle Database Engineer 07/2015– 03/2016

Mahindra Comviva, Delhi, IN.

Client Projects: Reliance, MTS, Russia

  • Installation, maintenance and support of Oracle Golden Gate 12c database on the production environment.
  • Installation, upgrade and administration of Oracle 11g and 12c databases through GUI & silent mode.
  • Installation and administration of Oracle 12c/11g RAC database on Linux servers’ version 5 and 6.
  • Backup and Recovery of RAC database from media failure and instance failures. Tune instance recovery and configuration of RMAN for the RAC environment.
  • Analysis Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) for Single Instance Database and RAC Database.
  • Performance tuning in single instance and RAC database environment.
  • Installation and administration of Physical Standby Disaster Recovery Databases.
  • Hands-on experience in setting up & managing Oracle Standby Databases using RMAN utility and Datapump utility, for both Physical and Logical supported by DATAGUARD.
  • Database cloning to a different Unix Server, through user managed cloning, Database Cloning from hot & cold backups, RMAN database cloning to same/different servers.
  • Diagnose database & application performance issues and using explain plan, TKPROF, AWR to generate reports for checking Performance.

Senior Associate 03/2013– 03/2014

iGATE, Delhi, IN.

Client Projects: Royal Bank of Canada

  • Monitoring and maintaining computer systems and networks.
  • Talking staff or clients through a series of actions, either face-to- face or over the telephone, to help set up systems or resolve issues.
  • Proactively Monitoring file system growth, Alert Log and Archive Destination.
  • Taking HOT and COLD backups using RMAN.
  • Database cloning to a different Unix Server, through user managed cloning, Database Cloning from hot & cold backups, RMAN database cloning to same/different servers.
  • Diagnose database & application performance issues and using explain plan, TKPROF, AWR to generate reports for checking Performance.

Client Technical Support Associate 11/2011– 02/2013

Dell, Delhi, IN.

Client Projects: Dell

  • Proactively Monitoring file system growth, Alert Log and Archive Destination.
  • Taking HOT and COLD backups using RMAN.
  • Installing and configuring computer hardware operating systems and applications.
  • Monitoring and maintaining computer systems and networks.

Ausbildung

Bachelor of Engineering (2006 -2011)

ITILv3 Foundation (2013)

Oracle Certified Associate (2018) Oracle Certified Professional (2018)

Project Management Professional Training (2020)

Oracle GoldenGate Certified (2023)

SAP Activate Methodology Training (2023)

Bewertungen