Oracle DBA
Cognizant
Zurich, Zurich, Switzerland
vor 2 Tg.

The DB Administrator is responsible for day-to-day support / maintenance of the DB infrastructure. The role is accountable for providing L2 / L3 technical support, from incident and problem managed to stability initiatives, life cycle projects and other BAU tasks which includes liaising with Engineering, partnering with peer teams Unix and Storage.Key Responsibilities :

  • Perform troubleshooting and diagnostic analysis of issues during production outages and provide resolution or workaround quickly to mitigate business impact. Help identify root cause.
  • Perform maintenance activities on the infrastructure during regular planned dates and during scheduled major maintenance weekends
  • Partner with peer operations team, Storage, Networks, Unix and application support during production problems and on assigned projects as required
  • Perform above tasks while at the same time adhering to project policies around incident, problem and change management and best practices
  • Exposure to work in a Critical and Complex Environment.
  • Database Life Cycle management project Deployment, Configuration, Migration and Decommission.
  • End to End Planning, co-ordination and execution of the projects individually as per the timelines.Skills :
  • Data Center knowledge with respect to set up of new RAC, Data Guard, backups and DR tests.
  • Experience in handling multi-terabyte databases on various Oracle version 9i, 10g, 11g, 12c, 18c over different OS platforms (mainly Solaris and Linux).
  • Skills to support 1st Level Support Team, server teams, Storage and users for BAU day-to-day support.
  • Extended support on weekends, Quarterly Maintenance Window, DR tests, Power downs and other major activities.
  • Hands on experience in using RMAN (Full, incremental and archive backups), clone methodology (normal / duplicate), refresh using RMAN and good knowledge of using DISK and TAPE level backups.
  • Hands on experience in configuring and troubleshooting standby databases. Mandatory to have worked on Data Guard setup to do switchover, failover operations.
  • Working knowledge of configuring and troubleshooting Oracle Streams.
  • Hand on experience in configuring and troubleshooting Oracle RAC (single node, multi-node).
  • Working knowledge in using GRID control to manage large databases.
  • Hands on experience in troubleshooting production database performance issues, long running jobs.
  • Hands on experience in query tuning, Optimizer concepts, knowledge of statistics, plan basics and advisor knowledge.
  • Hands on experience in using EXP and DATAPUMP technology to do the schema / table / database refreshes.
  • Hands on knowledge on ASM storage to be able to troubleshoot diskgroup / disk issues.
  • Melde diesen Job
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Bewerben
    E-Mail
    Klicke auf "Weiter", um unseren Datenschutz-und Nutzungsbestimmungen zuzustimmen . Du kriegst außerdem die besten Jobs als E-Mail-Alert. Los geht's!
    Weiter
    Bewerbungsformular