freiberufler Oracle Database Administrator auf freelance.de

Oracle Database Administrator

zuletzt online vor wenigen Tagen
  • auf Anfrage
  • 1140 Wien
  • Europa
  • ta  |  en  |  de
  • 09.03.2024

Kurzvorstellung

As Oracle Database Administrator, i will configure and maintain db

Qualifikationen

  • oracle
  • Oracle (allg.)
  • Oracle Data Guard
  • Oracle Database
  • Oracle Database Appliance (ODA)
  • Oracle Grid Engine
  • Oracle Multitenant
  • Oracle RAC (Real Application Clusters)
  • Oracle RMAN (Recovery Manager)

Projekt‐ & Berufserfahrung

DBA Lead (Festanstellung)
Intellect Design Arena, Chennai
2/2022 – offen (2 Jahre, 2 Monate)
Banken
Tätigkeitszeitraum

2/2022 – offen

Tätigkeitsbeschreibung

Oracle Database support.

Eingesetzte Qualifikationen

Oracle Database

Technical Specialist (Festanstellung)
HCL, Chennai
9/2020 – 2/2022 (1 Jahr, 6 Monate)
Fertigungsindustrie
Tätigkeitszeitraum

9/2020 – 2/2022

Tätigkeitsbeschreibung

working on database technical support

Eingesetzte Qualifikationen

Oracle Database

Database Consultant (Festanstellung)
Capgemini Ltd, Chennai
9/2018 – 9/2020 (2 Jahre, 1 Monat)
Banken
Tätigkeitszeitraum

9/2018 – 9/2020

Tätigkeitsbeschreibung

Oracle DB support

Eingesetzte Qualifikationen

Oracle Database

Database Administrator (Festanstellung)
Wipro Ltd, Chennai
7/2014 – 9/2018 (4 Jahre, 3 Monate)
Banken
Tätigkeitszeitraum

7/2014 – 9/2018

Tätigkeitsbeschreibung

 Installation and configuration of Oracle 9i ,10g, 11g ,12c database and RAC setups in AIX, Linux and Windows Platforms
 Performing RMAN backups of full database, Incremental backups and archive logs.
 Monitoring databases using OEM 12C and adding/removing nodes in OEM.
 User administration – roles, privileges, security, backup and restoration activities
 Creating and maintaining Partition, Sub partition tables and indexes.
 Database Start-up and Shutdown / RAC startup and shut down
 Scheduling Daily and Weekly Schema and logical backups using Expdp and Impdp utilities
 Generating AWR , ADDM and Stats pack reports for trouble shooting and diagnosis
 Configuring Data guard for physical standby database and synchronizing with production database
 Conducting Disaster recovery (DR-DRILL) for all production databases once in a quarter.
 Administering ASM instances , adding , rebalancing disks in event of Space Crunch
 Doing Structural modifications of tables based on the requirements & usage, Manage changes of database triggers, procedures & functions, Defining indexes on tables based on the relationship and queries defined as per the procedures provided by the Bank / Application vendor
 Purging data in production tables on Weekly and Monthly Frequencies to control database growth
 Compressing tables in Hist database using OLTP Advances Compression techniques
 Configuration of LISTENER and TNSNAMES & Troubleshooting
 Troubleshooting and preparing Root Cause Analysis for major Production database issues
 Rolling Forward standby databases using incremental backup strategy to resolve archive log backlog issues
 Cloning databases for development environment using RMAN backup, restoration and duplicate database techniques.
 Creating ACFS file systems for string Non-db files and for Golden gate configurations.
 Having hands on experience in Golden gate technology and monitoring.
 Performing daily Stage backups for application team.
 Performance tuning and Security Management (access privileges)
 Table space management by adding data files in ASM and Raw file systems
 Removing fragmentation from tables by table movement, table shrink and export methods
 Proactive monitoring of alert log and user trace files for identification of ORA-errors
 Raising Service request with Oracle Corporation and providing requested data for analysis.
 Gathering Schema level statistics and Table level statistics using DBMS_STATS package.
 Checking the data file consistency using DB verify utility
 Backups and Tapes handling using Tivoli Storage Manager.
 Performing Database backup and recovery in Microsoft SQL database server

Eingesetzte Qualifikationen

Oracle Database

Zertifikate

AWS Certified Solutions Architect - Associate
2023
Microsoft Certified Azure Database Administrator Associate
2022
Microsoft Certified Azure Data Fundamentals
2022

Weitere Kenntnisse

Master in Computer Applications

Persönliche Daten

Sprache
  • Tamil (Muttersprache)
  • Englisch (Fließend)
  • Deutsch (Gut)
Reisebereitschaft
Europa
Arbeitserlaubnis
  • Europäische Union
Home-Office
bevorzugt
Profilaufrufe
1055
Alter
34
Berufserfahrung
11 Jahre und 7 Monate (seit 08/2012)
Projektleitung
10 Jahre

Kontaktdaten

Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.

Jetzt Mitglied werden