09 Nov
|
Citigroup
|
Chennai
**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 chance review_ _Accessibility at Citi (https://www.citigroup.com/citi/accessibility/application-accessibility.htm)_ _._ _View Citi's_ _EEO Policy Statement (https://www.citigroup.com/global/eeo-aa-policy)_ _and the_ _Know Your Rights (https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12ScreenRdr.pdf)_ _poster._ Citi is an equal opportunity and affirmative action employer. Minority/Female/Veteran/Individuals with Disabilities/Sexual Orientation/Gender Identity.
📌 Oracle Applications DBA (Chennai)
🏢 Citigroup
📍 Chennai