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.
