Oracle Database Administrator

Overview

LTIMindtree Limited is an Indian multinational information technology services and consulting company. A subsidiary of Larsen & Toubro, the company was incorporated in 1996 and employs more than 90,000 people.

Job Description

  • Oracle Certified DB Professional (OCP) with more than 5-8 years’ experience with Oracle Database Administration, preferably in a lead role for P3 Grade.
  • Oracle Certified DB Professional (OCP) with more than 3-5 years’ experience with Oracle Database Administration, for P2 Grade
  • Experience should include DB design (modelling and normalization), capacity planning, performance tuning, storage management, back-up and recovery, managing schemas, report generation and DB clustering technologies.
  • Strong practical experience of ORACLE in a production RAC (ASM) environment (11gR2 / 12cR2).
  • Experience with an organization with a key reliance on 24x7 reliability on its database
  • Creates and maintains all databases required for development, testing, education and production usage
  • Performs the capacity planning required to create and maintain the databases. The DBA works closely with system administration staff
  • Plans and implements backup and recovery of the Oracle database
  • Controls migrations of programs, database changes, reference data changes and menu changes through the development life cycle.
  • Implements and enforces security for all of the Oracle Databases.
  • Performs database re-organizations as required to assist performance and ensure maximum uptime of the database.
  • Puts standards in place to ensure that all application design and code is produced with proper integrity, security and performance. The DBA will perform reviews on the design and code frequently to ensure the site standards are being adhered to.
  • Evaluates releases of Oracle and its tools, and third party products to ensure that the site is running the products that are most appropriate. Planning is also performed by the DBA, along with the application developers and System administrators, to ensure that any new product usage or release upgrade takes place with minimal impact.
  • Provides technical support to application development teams. This is usually in the form of a help desk. The DBA is usually the point of contact for Oracle Corporation.
  • Enforces and maintains database constraints to ensure integrity of the database.
  • Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.
  • Troubleshoots with problems regarding the databases, applications and development tools.

Skills & Requirements

DBA should possess a sound understanding of the business. DBA should have sound communication skills with management, development teams, vendors, systems administrators and other related service providers. Must be a self-starter with a strong attention to detail. Possess excellent written and verbal communication skills in English Possess excellent time management skills: (keeping deadlines, meeting goals, multitasking, coordinating tasks…) Possess excellent organizational skills: (following direction, analysis, assessment, evaluation, documentation, reporting, attention to detail…) Solid understanding of ITIL and LEAN operating model. Must be a self-starter with a strong attention to detail.