Oracle Applications DBA

Citi; Chennai; In loco; INR 2.400.000 - 4.000.000; Tempo pieno

Descrizione del lavoro

Citi in Chennai, India, seeks an Applications DBA Intermediate Analyst to support the enterprise data architecture and MRD framework. The role focuses on database and application enhancements with a strong emphasis on Oracle 19c/26ai, GoldenGate, and performance tuning.

The incumbent will work within a cross-functional team to manage data models, deployment pipelines, and high-availability services, while ensuring adherence to SDLC and change control processes.

Competenze

• 5-8 years of work experience.
• Extensive experience in Application DBA, performance Tuning and GoldenGate implementation.
• Experience in managing and implementing successful projects.
• Subject Matter Expert (SME) in at least one area of Applications Development.
• Ability to adjust priorities quickly as circumstances dictate.
• Demonstrated leadership and project management skills.
• Consistently demonstrates clear and concise written and verbal communication.

Mansioni

• Drive changes to the existing Data Model (Logical & Physical), Implement Changes, build deployment packages using CI/CD pipelines and promote them to higher environments (UAT, Production and Cob) following SDLC.
• Excellent understanding on Database concepts including Procedures, Triggers, Packages, Database Constraints, Indexes, Table statistics using Oracle 19c and 26ai.
• Should be able to help in finding current performance bottlenecks and provide solutions to improve performance
• Review AWR, ADDM, ASH and other performance reports and provide performance enhancement solutions.
• Working knowledge of Linux Redhat, File System, Cluster Management(RAC) and Oracle ASM & ACFS.
• System analysis and design skill with knowledge of data flow diagrams, data dictionary techniques, case tools, Entity relation Modeling, design Technique etc
• Database Design Skill including normalization theory, STAR Schema Design and Data Modeling tool with proven experience of Process, Data flow and forward/reverse engineering of logical/physical RDBMS layout
• Change Control Management Skills using Source Control System
• Experience of working in a team that delivers a high availability service.
• Ensure weekend activities complete successfully through assignment, coordination, oversight and validation.
• Experience with Oracle Golden Gate 12c/19c/26ai implementation and support.
• Experience with building Database warehouse Solution.
• Extensive experience with Database compression and purging techniques.

Conoscenze

Leadership

Communication

Team player

Ownership & accountability

Formazione

Bachelor’s degree/University degree or equivalent experience

Master’s degree preferred

Strumenti

Oracle 19c

Oracle 26ai

RHEL8

MySQL

AWS

UDeploy

Liquibase

CyberArk

Autosys

Python scripting

Ansible

Shell scripting

Descrizione del lavoro

• Oracle 19c, Oracle 26ai, RHEL8, MySQL, AWS, UDeploy, Liquibase, CyberArk, Autosys, Python Scripting, Ansible, Shell scripting.

Architecture

Event Master Central is Citi’s centralized corporate action event repository and distribution platform that consolidates corporate action announcements and notifications from various vendors with cross-business operational process. As a critical pillar within the Master Reference Data (MRD) and the broader Citi Enterprise Data Organization (EDO), our team is responsible for modernizing and managing the end-to-end lifecycle of corporate Action events across the enterprise. The Applications DBA Intermediate Analyst is a mid level position responsible for providing Application Database support to the entire reference data application teams for database & application enhancements.

Responsibilities

• Drive changes to the existing Data Model (Logical & Physical), Implement Changes, build deployment packages using CI/CD pipelines and promote them to higher environments (UAT, Production and Cob) following SDLC.
• Excellent understanding on Database concepts including Procedures, Triggers, Packages, Database Constraints, Indexes, Table statistics using Oracle 19c and 26ai.
• Should be able to help in finding current performance bottlenecks and provide solutions to improve performance
• Review AWR, ADDM, ASH and other performance reports and provide performance enhancement solutions.
• Working knowledge of Linux Redhat, File System, Cluster Management(RAC) and Oracle ASM & ACFS.
• System analysis and design skill with knowledge of data flow diagrams, data dictionary techniques, case tools, Entity relation Modeling, design Technique etc
• Database Design Skill including normalization theory, STAR Schema Design and Data Modeling tool with proven experience of Process, Data flow and forward/reverse engineering of logical/physical RDBMS layout
• Change Control Management Skills using Source Control System
• Experience of working in a team that delivers a high availability service.
• Ensure weekend activities complete successfully through assignment, coordination, oversight and validation.
• Experience with Oracle Golden Gate 12c/19c/26ai implementation and support.
• Experience with building Database warehouse Solution.
• Extensive experience with Database compression and purging techniques.

Essential :

• Oracle 19c, Oracle 26ai, RHEL8, MySQL, AWS, UDeploy, Liquibase, CyberArk, Autosys, Python Scripting, Ansible, Shell scripting.
• Leadership skills, Great communication, Team player, Ownership & Accountability.

Qualifications:

• 5-8 years of work experience
• Extensive experience in Application DBA, performance Tuning and GoldenGate implementation.
• Experience in managing and implementing successful projects
• Subject Matter Expert (SME) in at least one area of Applications Development
• Ability to adjust priorities quickly as circumstances dictate
• Demonstrated leadership and project management skills
• Consistently demonstrates clear and concise written and verbal communication

Education:

• Bachelor’s degree/University degree or equivalent experience
• Master’s degree preferred

This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.

Job Family Group:

Technology

Job Family:

Architecture

Time Type:

Full time

Most Relevant Skills

Please see the requirements listed above.

Other Relevant Skills

For complementary skills, please see above and/or contact the recruiter.

Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law.

If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review Accessibility at Citi.

View Citi’s EEO Policy Statement and the Know Your Rights poster.