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 Required
- 5-8 years of professional work experience
- Extensive experience in application database administration
- Extensive experience in database performance tuning
- Experience implementing and supporting Oracle GoldenGate
- Experience managing and implementing successful projects
- Subject matter expertise in at least one area of application development
- Bachelor's degree, university degree, or equivalent experience
- Oracle 19c and Oracle 26ai experience
- RHEL8, Linux, MySQL, AWS, UDeploy, Liquibase, CyberArk, Autosys, Python, Ansible, and Shell scripting experience
- Experience with Oracle RAC, ASM, and ACFS
- Experience with CI/CD pipelines, SDLC, source control, and change control management
- Database design, data modeling, normalization, STAR schema, and RDBMS experience
- Data warehousing experience
- Leadership, communication, teamwork, ownership, and accountability skills
- Ability to adjust priorities quickly
- Demonstrated leadership and project management skills
- Master's degree
What We Do
Citigroup is a global diversified financial services holding company serving consumers, corporations, governments and institutions. It provides consumer banking and credit, corporate and investment banking, securities brokerage, trade and securities services, and wealth management. Operating across nearly 160 countries and jurisdictions, Citi aims to be a leading partner for institutions with cross-border needs, a global wealth manager, and a valued personal bank in the United States.
.png){kind=logo}
