MetLife

Position Summary

The Oracle Database Administrator at level GG 10 is responsible for the design, implementation, and support of database systems for applications across the Enterprise. The Database Administrator is a part of the Database end to end delivery team working and collaborating with Application Development, Infrastructure Engineering and Operation Support teams to deliver and support secured, high performing and optimized database solutions. The Database Administrator specializes in the Oracle database platform with the knowledge of PeopleSoft Financial applications and Goldengate replication.   

Job Responsibilities

• Manages design, distribution, performance, replication, security, availability, and access requirements for large and complex Oracle databases from version 11g to 19c (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.
• Participates in the design, implementation and maintenance of automated infrastructure solutions using Infrastructure as Code tools like Ansible, Elastic and Terraform.
• Participates in the develop and management of Azure DevOps CI/CD pipelines to automate infrastructure deployments using Ansible and Elastic.
• Identifies and resolves problem utilizing structured tools and techniques.
• Provides technical assistance and mentoring to staff in all aspects of database management; Consults and advises application development teams on database security, query optimization and performance.
• Writes scripts for automating DBA routine tasks and documents database maintenance processing flows per standards.
• Participate in basic 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.
• working knowledge of ServiceNow ticketing system, KB article creation and maintenance, and CMDB maintenance 
• 4+ 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

Education, Technical Skills & Other Critical Requirement

Education

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

Experience 

(In Years)

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

Technical Skills

Other Critical Requirements 

• Automation tools and programming such as Python and Ansible.
• Monitoring the database using Elastic and Oracle Enterprise monitoring (OEM)
• OCA or OCP 19c and above certification preferable
• Excellent written and oral communication skills, including the ability to clearly communicate/articulate technical and functional issues with conclusions and recommendations to stakeholders.
• Prior experience in handling state side and offshore stakeholders
• Experience in creating and delivering Business presentations.
• Demonstrate ability to work independently and in a team environment
• Ability to work 24*7 rotational shift to support for production, development, and test databases