MetLife

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