Assistant Manager - Technology Services

Description and Requirements
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

• 4+ years of related work experience with application database implementation; knowledge of all key Oracle utilities such as SQLPLUS, RMAN, OEM, Data Pump, Active Data Guard and OID.
• 2+ years Unix and Linux operating systems and 1 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.
• Extensive experience in Backup and recovery (Data pump, RMAN, Rubrik).
• Good knowledge in performance tuning with hands on experience on AWR, ADDM, SQLTRPT skill.
• Experience in Data guard configuration (DR).
• Experience in Database switchover and failover.
• Working knowledge in Cloud computing (Azure, OCI)
• Data security by managing roles and privileges to User and groups.
• 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.

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

About MetLife
Recognized on Fortune magazine's list of the 2025 "World's Most Admired Companies" and Fortune World's 25 Best Workplaces™ for 2024, MetLife , through its subsidiaries and affiliates, is one of the world's leading financial services companies; providing insurance, annuities, employee benefits and asset management to individual and institutional customers. With operations in more than 40 markets, we hold leading positions in the United States, Latin America, Asia, Europe, and the Middle East.
Our purpose is simple - to help our colleagues, customers, communities, and the world at large create a more confident future. United by purpose and guided by empathy, we're inspired to transform the next century in financial services.
At MetLife, it's #AllTogetherPossible . Join us!
#BI-Hybrid