The Applications DBA Lead Analyst is a senior level position responsible for providing Application Database support to the entire reference data applications for database &amp; application enhancements. The overall objective of this role is to lead application database administration, architect resilient database solutions and performance tuning efforts. Responsibilities:<ul><li>Able to make changes to the existing Data Model (Logical &amp; Physical), Implement Changes, build deployment packages using CI/CD pipelines such as LightSpeed and promote them to higher environments (UAT, Production and Cob) following SDLC using Release on Demand.</li><li>Excellent understanding on Database concepts including Procedures, Triggers, Packages, Database Constraints, Indexes, Table statistics using Oracle 19c and 23ai.</li><li>Experience in designing, architecting and implement resilient database solutions.</li><li>Should be able to help in finding current performance bottlenecks and provide solutions to improve performance</li><li>Review AWR, ADDM, ASH and other performance reports and provide performance enhancement solutions.</li><li>Working knowledge of Linux Redhat, File System, Cluster Management(RAC) and Oracle ASM &amp; ACFS.</li><li>System analysis and design skill with knowledge of data flow diagrams, data dictionary techniques, case tools, Entity relation Modeling, design Technique etc</li><li>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</li><li>Change Control Management Skills using Source Control System </li><li>Experience of working in a team that delivers a high availability service.</li><li>Ensure weekend activities complete successfully through assignment, coordination, oversight and validation.</li><li>Experience with Oracle Golden Gate 12c/19c/23ai implementation and support.</li><li>Experience with building Database warehouse Solution. Extensive experience with Database compression and purging techniques.</li><li>Experience with MSSQL, mongoDB and postgres will be an added advantage. Partner with multiple management teams to ensure appropriate integration of functions to meet goals as well as identify and define necessary system enhancements to deploy new products and process improvements</li><li>Resolve variety of high impact problems/projects through in-depth evaluation of complex business processes, system processes, and industry standards</li><li>Provide expertise in area and advanced knowledge of applications programming and ensure application design adheres to the overall architecture blueprint</li><li>Utilize advanced knowledge of system flow and develop standards for coding, testing, debugging, and implementation</li><li>Develop comprehensive knowledge of how areas of business, such as architecture and infrastructure, integrate to accomplish business goals</li><li>Provide in-depth analysis with interpretive thinking to define issues and develop innovative solutions</li><li>Serve as advisor or coach to mid-level app DBAs and developers, allocating work as necessary</li><li>Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firms reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency.</li></ul> Qualifications:<ul><li>6+ years of relevant experience in Application DBA.</li><li>Extensive experience in Application DBA, performance Tuning and GoldenGate implementation.</li><li>Experience in managing and implementing successful projects</li><li>Subject Matter Expert (SME) in at least one area of Applications Development</li><li>Ability to adjust priorities quickly as circumstances dictate</li><li>Demonstrated leadership and project management skills</li><li>Consistently demonstrates clear and concise written and verbal communication</li></ul>Additional Skills:<ul><li>Oracle database architecture/Data Guard</li><li>Performance tuning and troubleshooting</li><li>Oracle Advance compression</li><li>Oracle partitioning &amp; purging</li><li>Database Encryption</li><li>GoldenGate knowledge -&gt;Nice to have</li></ul>Education:<ul><li>Bachelor’s degree/University degree or equivalent experience</li><li>Master’s degree preferred</li></ul>This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.Essential :Oracle 19c/23ai, RHEL7/8, GoldenGate 19c/23c, MySQL, PostgreSQL, Sybase, MS SQL Server, AWS, UDeploy, Lightspeed, TPAM, CyberArk, Autosys, Python Scripting, Ansible, Shell scripting, PL/SQL, T-SQL, mongoDB, ServiceNow.Leadership skills, Great communication, Team player, Ownership &amp; Accountability.------------------------------------------------------Job Family Group: Technology------------------------------------------------------Job Family:Applications Development------------------------------------------------------Time Type:Full time------------------------------------------------------Primary Location:Tampa Florida United States------------------------------------------------------Primary Location Full Time Salary Range:$113,840.00 - $170,760.00 In addition to salary, Citi’s offerings may also include, for eligible employees, discretionary and formulaic incentive and retention awards. Citi offers competitive employee benefits, including: medical, dental &amp; vision coverage; 401(k); life, accident, and disability insurance; and wellness programs. Citi also offers paid time off packages, including planned time off (vacation), unplanned time off (sick leave), and paid holidays. For additional information regarding Citi employee benefits, please visit citibenefits.com. Available offerings may vary by jurisdiction, job level, and date of hire.------------------------------------------------------Most Relevant Skills Please see the requirements listed above.------------------------------------------------------Other Relevant Skills For complementary skills, please see above and/or contact the recruiter.------------------------------------------------------Anticipated Posting Close Date:Sep 19, 2025------------------------------------------------------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 <a href="https://www.citigroup.com/citi/accessibility/application-accessibility.htm" target="_blank">Accessibility at Citi</a>. View Citi’s <a href="https://www.citigroup.com/global/eeo-aa-policy" target="_blank">EEO Policy Statement</a> and the <a href="https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12ScreenRdr.pdf" target="_blank">Know Your Rights</a> poster.