Sr Oracle Database Developer - VP (Hybrid)

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

• 6-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.

• Expert in the relational databases like Oracle 19c, PostgreSQL
• Strong skills in SQL, PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views, Materialized Views, Temporary Tables, Partitions
• Knowledge of tools like SQL Developer, TOAD, DB Visualizer, SQL*Loader
• Experience in troubleshooting performance issues, debugging, performance tuning, explain plan, indexes, hints
• Experience with Archiving, Star/snowflake schemas, Analytical functions, ETL, data conversion, migration, consolidation
• Experience in database design, logical and physical data models, normalization, ER modeling, data flow diagrams
• Preferred knowledge of AWS, PostgreSQL and data migration from on-prem Oracle database to AWS PostgreSQL as well as from on-prem Oracle database to AWS Oracle database.

Required: US Green card holder or US Citizen