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 explicit 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.
📌 Oracle Applications DBA (India)
🏢 Citi
📍 India