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.