Senior Oracle Dev and DBA Lead Vice President

Job description

The Applications Development Technology Lead Analyst is a senior level position responsible for establishing and implementing new or revised application systems and programs in coordination with the Technology team.

The overall objective of this role is to lead applications systems analysis and programming activities.



**Responsibilities:**



+ 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

+ Resolve variety of high impact problems/projects through in-depth evaluation of complex business processes, system processes, and industry standards

+ Provide expertise in area and advanced knowledge of applications programming and ensure application design adheres to the overall architecture blueprint

+ Utilize advanced knowledge of system flow and develop standards for coding, testing, debugging, and implementation

+ Develop comprehensive knowledge of how areas of business, such as architecture and infrastructure, integrate to accomplish business goals

+ Provide in-depth analysis with interpretive thinking to define issues and develop innovative solutions

+ Serve as advisor or coach to mid-level developers and analysts, allocating work as necessary

+ Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's 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.



**Qualifications:**



+ 10+ years of relevant experience in Apps Development or systems analysis role

+ Extensive experience system analysis and in programming of software applications

+ 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.



**About the Role**



We are looking for a highly skilled and hands-on Software Engineer to drive modern engineering practices and technology transformation within our teams.

You will play a critical role in designing, developing, and maintaining scalable, high-quality software solutions while ensuring best-in-class engineering standards, including trunk-based development, test automation, security, and modern ways of working.



This role requires deep expertise in developing, designing, tuning and supporting prod/non-prod Oracle databases for franchise critical application in the Markets Technology.

This is a critical role, the candidate will be working on fast-paced, highly visible and challenging project.



**Core Skills:**



+ 10+ Yrs Hands on experience in Development / Design, Data Model, Performance tunings and troubleshooting across leading Databases.

+ 8+ Yrs Hands on experience in Development, Design, Data Model, Performance tunings in Oracle Databases in large scale data centric applications.

+ Hands on experience in Oracle Goldengate.

+ Experience with Data Management - data strategy, migration, masking, archival etc.

+ Good knowledge of Unix/shell scripting.

+ Exposure of Microservices, AI tools, big data, Hadoop, AWS S3

+ Well versed with SDLC – Agile methodology, Scrum ceremonies and Jira.

+ Utilize in-depth knowledge and skills across multiple Applications Development areas to provide technical oversight across systems and applications.

+ Excellent troubleshooting and analytical skills, should be able to provide evaluative judgment based on analysis of factual data in complicated and unique situations.

+ Defining standards negotiating with external parties when necessary.



**DBA skill:**



+ DB schema & Environment stability Management for both non-prod and prod databases.

+ Proactively monitor the DB health and take appropriate actions timely manner using tools & techniques.

+ Review and implement various strategies for betterment and Data strategy

+ Adoption of new tools and technologies

+ Recommend / provide necessary technical advisory.

+ Introduce appropriate features in Oracle for betterment.

+ Co-ordinate Application team, DBA, Oracle teams for timely solutions for critical / unknown issues.

+ Run various reports (AWR, advisory) for monitoring and control



**Management Skill:**



+ Experience in managing both functional and non-functional requirements

+ Strong analytical and problem-solving skills to validate and prioritize requirements.

+ Release management, pro-active and re-active skills

+ Schema & Data Management

+ Environment and Stability Management

+ Capacity Management

+ Tech advisory within and beyond teams

+ Risk management - identify, assess, prioritize and mitigate in timely manners.



------------------------------------------------------



**Job Family Group:**



Technology

------------------------------------------------------



**Job Family:**



Applications Development

------------------------------------------------------



**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 (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.

Required Skill Profession

Other General