Oceaneering Application Administrator II - Oracle in Chandigarh, India

Company Profile

Oceaneering is a global provider of engineered services and products, primarily to the offshore energy industry. We develop products and services for use throughout the lifecycle of an offshore oilfield, from drilling to decommissioning. We operate the world's premier fleet of work class ROVs. Additionally, we are a leader in offshore oilfield maintenance services, umbilicals, subsea hardware, and tooling. We also use applied technology expertise to serve the defense, entertainment, material handling, aerospace, science, and renewable energy industries.

Position Summary

This position is in IT Technical Platform - Administration team which is responsible for creation, maintenance and Support for Databases like Oracle 11g, 12c, MySql, MS SQL Server, Mongo DB. We also manage enterprise Applications which include Peoplsoft FSCM, HRMS, Business Intelligence. We are slowly and surely transitioning into a Devops and Dataops team with adoption of Release Management tools, Monitoring and Automation tools.

The current position is an administration position responsible for performing standard Database and Application Administration tasks which include Monitoring, Performance Monitoring and Recommendations, Implementations, troubleshooting.

Oracle/MYSQL/MSSQL DBA's are part of Technical Platform - App Admin team in Oceaneering and are responsible for ensuring 24 / 7 availability of critical database and application systems for the organization.

Duties & Responsibilities

ESSENTIAL Support and manage Oracle 11g/12c RAC databases in a Unix and Linux environment

  • Experience in setting up and supporting HADR - Active and Physical Dataguard
  • Thorough knowledge of Oracle OEM, ASM, Datapump, Partitioning, Materialized views.
  • Ability to proactively identify, troubleshoot and resolve live database systems issues using tools like OEM
  • Experience in database migration from one platform to another, patching, upgrade, data loading, security, capacity planning, performance monitoring and tuning
  • Experience in Performance Tuning, Query Optimization, Performance Monitoring, SQL Profiler and other related monitoring and troubleshooting tools.
  • SQL Development ability to write and troubleshoot SQL Code and design (stored procedures, functions, tables, views, triggers, indexes, constraints)
  • Upgrade and implementation planning and advice on Patch Management
  • Experience in other database technologies SQL Server 2012/2014, MYSQL.
  • Working experience of Unix and Linux operating systems
  • Clear understanding of Database Architecture, Operating Systems, Client/ Server Architecture, Middleware and Hardware (Servers, SAN, Network)
  • Ability to collaborate effectively with other operational support teams and vendors to support the service.
  • Knowledge of Python will be a huge plus.

NON-ESSENTIAL

  • Demonstrate ownership and good skills on problem management, problem solving and prevention of SLA breach under Incident / Problem Management processes
  • Work towards individual goals aligned with department and organizational objectives.
  • Should be open to travel as per business needs
  • Comply to organizational HR policies and procedures.
  • Ensuring all contracting and procurement activities are conducted in accordance with policy and ethical and business practices.

Safety

Ensure that the Safety policies and procedures are understood and adhered to so far as is reasonably practicable in order to ensure a safe working environment.

Other

Carry out work in accordance with the Company Health, Safety, Environmental and Quality Systems.

Perform the assigned tasks with due diligence regarding the Integrated Management Systems on the Company.

Eliminate waste of whatever form, to suggest the use of more environmentally friendly substances and practices and contribute to the continuous improvement of the environment.

Reporting Relationship

*. *

  • Manager - Application Administration

Qualifications

REQUIRED

  • Full Time Graduates / Post Graduates in: BE / BTech / ME / MTech / MSc / MCA / MCM / MS

  • Demonstrate good written and verbal communication skills in English language

  • Experience Range: 3 - 6 years

  • Oracle Certification/Technology Certification

DESIRED

  • Oracle Certified Professional in Database Technology

  • Working knowledge of Python

  • Working knowledge "R" programming

  • Experience with distributed Source Code tools like Git

Knowledge, Skills, Abilities, and Other Characteristics

An individual should demonstrate following competencies & qualities to be able to perform this role successfully:

  • Ability to collaborate effectively with other operational support teams and vendors to support the service.

  • Demonstrate good written and verbal communication skills in English language

  • Teamwork & Interpersonal skills

  • Analytical, problem solving & decision making skills

  • Organizing & planning skills

Working Conditions

This position is considered OFFICE WORK which is characterized as follows.

  • Almost exclusively indoors during the day and occasionally at night

  • Occasional exposure to airborne dust in the work place

  • Work surface is stable (flat)

Physical Activity/Requirements

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

This position is considered LIGHTwork.

OCCASIONAL

FREQUENT

CONSTANT

§ Lift up to 20 pounds

§ Climbing, stooping, kneeling, squatting, and reaching

§ Lift up to 10 pounds

§ Standing

§ Repetitive movements of arms and hands

§ Sit with back supported

Closing Statement

We offer a competitive salary, a comprehensive benefits package, relocation support and the opportunity to advance in an international company. To apply, click 'Apply Now'.

Job Title: Application Administrator II - Oracle

Location: Chandigarh, India

Job ID: 12944

Regular/Temporary: Regular

Full/Part Time: Full-Time