Ir para o conteúdo
País
Índia
Arranjo de trabalho
Tempo integral
Modelo de Trabalho
Híbrido
Assistência de realocação disponível
Não
Data de publicação
25-Jun-2025
ID da vaga
10085

Descrição e requisitos

 

Job Responsibilities

 

  • Manages design, distribution, performance, replication, security, availability, and access requirements for large and complex Oracle databases from version (11g,12c,19c and 21c (CDB/PDB and Standalone) on (Linux/AIX) Operating System.
  • Designs and develops physical layers of databases to support various application needs; Implements back-up, recovery, archiving, conversion strategies, and performance tuning; Manages job scheduling, application release, database change and compliance; Makes use of advanced database features such as partitioning, advanced compression, multitenant architecture, etc.
  • Design, implement and maintain automated infrastructure solutions using Infrastructure as Code tools like Ansible, Elastic and Terraform.
  • Develop and manage of Azure DevOps CI/CD pipelines to automate infrastructure deployments using Ansible and Elastic.Provides technical advice and mentoring to staff in all aspects of database management; Consults and advises application development teams on database security, query optimization and performance.
  • Troubleshoot and resolve, in conjunction with Operational/Customer DBAs, database application issues across production, test and development environments
  • Customer-facing position and may require interaction with senior customer leadership on matters concerning design, engineering, or functional areas
  • Identifies and resolves problem utilizing structured tools and techniques.
  • Writes scripts for automating DBA routine tasks and documents database maintenance processing flows per standards.
  • Participates in a 24X7 pager rotation, providing Subject Matter Expert support to the on-call DBA as needed
  • Identify, participate and resolve complex Root Cause Analysis (RCA)
  • Maintains, and administers data infrastructure security policies 
  • safeguarding information, evaluating existing data infrastructure security procedures and identifying new areas of risk.
  • Extensive knowledge of ServiceNow ticketing system. KB article creation and maintenance, and CMDB maintenance 
  • 7+ years of experience with Performance Tuning, physical database design, database programming skills, and shell scripting 
  • Working experience with Cloud infrastructure, Elastic, Ansible, data replication and project management
  • Working knowledge of other database technology such as UDB, Informix, PostgreSQL or MSSQL  preferred

 

Education, Technical Skills & Other Critical Requirement

 

Education

Bachelor’s degree in computer science, Information Systems, or another related field with 10+ years of IT and Infrastructure engineering work experience.

 

Experience 

(In Years)

10+ Years Total IT experience & 7+ Years relevant experience in Oracle database

 

Technical Skills

  • 7+ years of related work experience on Oracle 11g,12c, Oracle 19c  database administrator with specific knowledge on ASM, GoldenGate, Data Guard, RMAN, Patching, AND/OR Security ,Active Data Guard and data pump 
  • 6 years Unix, Linux and Windows operating systems and 3 year’s shell scripting.
  • Strong database analytical skills to improve application performance.
  • Management of database elements, including creation, alteration, deletion and copying of schemas, databases, tables, views, indexes, stored procedures, triggers, and integrity constraints
  • Engineering and support experience with PeopleSoft financials application databases and Goldengate replications. 
  • Should have strong knowledge in configuration and implementation Backup and recovery strategy as per Industry best practice using backup tools (RMAN, Data Pump, BCV and Rubrik)
  • Expertise in database performance tuning with hands on experience on AWR, ADDM, SQLTRPT skill.
  • Experience in Data guard configuration (DR) (Active 
  • Must have extensive experience in Database switchover and failover.
  • Strong Experience in Cloud computing (Azure, OCI)
  • Data security by managing roles and privileges to User and groups.
  • Strong knowledge in configuring and implementing data replication between complex databases using Goldengate.
  • Experience in installation and configuration of OEM Agent and monitoring.
  • Experience in working Ticketing tools (ServiceNow)
  • Understanding of modern IT infrastructure such as Cloud Architecture as well as Agile DevOps Framework.
  • Ability to organize tasks for self and others, prioritize and balance tasks, and lead complex projects
  • Excellent written and oral communication skills, including the ability to clearly communicate/articulate technical and functional issues with conclusions and recommendations to stakeholders.
  •  Strong Automation skills and programming such as Python and Ansible
  • Should have good experience in Database monitoring installation, configuration and monitoring using OEM and Elastic.
  • Ability to work 24*7 rotational shift to support for production, development, and test databases

 

Other Critical Requirements 

  •  OCP 12c/19c, Azure and OCI cloud certification preferable.
  • Should have Project management experience for creating and delivering Business solutions.
  • Demonstrate ability to work independently and in a team environment

 

 

 

 





 

Sobre a MetLife

Reconhecida na lista da revista Fortune das “Empresas Mais Admiradas do Mundo” de 2023, a MetLife, através de suas subsidiárias e afiliadas, é uma das empresas líderes mundiais em serviços financeiros; fornecendo seguros, anuidades, benefícios a funcionários e gestão de ativos para clientes individuais e institucionais. Com operações em mais de 40 mercados, ocupamos posições de liderança nos Estados Unidos, América Latina, Ásia, Europa e Oriente Médio.

Nosso objetivo é simples: ajudar nossos colegas, clientes, comunidades e o mundo em geral a criar um futuro mais confiante. Unidos por um propósito e guiados pela empatia, somos inspirados a transformar o próximo século nos serviços financeiros. Na MetLife, é #AllTogetherPossible. Junte-se a nós!