Oracle DBA


Offered by:

Cognizant Technology Solutions AG

IT & Technology

Oracle DBALocation: Zurich, Switzerland but the position can be remote from anywhere in Switzerland (one day in the office in Zürich)Type: permanentNotice period: Maximum 2 months 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 kledge 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 kledge 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 kledge of configuring and troubleshooting Oracle Streams.
• Hand on experience in configuring and troubleshooting Oracle RAC (single node, multi-node).
• Working kledge 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, kledge of statistics, plan basics and advisor kledge.
• Hands on experience in using EXP and DATAPUMP technology to do the schema/table/database refreshes.
• Hands on kledge on ASM storage to be able to troubleshoot diskgroup/disk issues.Who we are?Cognizant (CTSH) is one of the world’s leading professional services companies, transforming clients’ business, operating and technology models for the digital era. Our industry-based, consultative approach helps many of the best-kn organizations in every industry and geography envision, build and run more innovative, efficient businesses.We engineer modern businesses to improve everyday life.