Oracle Applications DBA

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.

Skills
Python, Linux, AWS, CI/CD, MySQL, Ansible, Data Modeling, Project Management

Experience
5-8 yrs

Work arrangement
Hybrid