Senior Oracle Database Developer
Function: Compliance Technology
Reporting to: Markets Trade Surveillance UX manager
Overview of Citi:
Citi, the world leading global bank, has approximately 200 million customer accounts and a presence in more than 160 countries and jurisdictions worldwide. Citi provides consumers, corporations, governments and institutions with a broad range of financial products and services, including consumer banking and credit, corporate and investment banking, securities brokerage, transaction services, and wealth management. Citi enables clients to achieve their strategic financial objectives by providing them with cutting-edge ideas, best-in-class products and solutions, and unparalleled access to capital and liquidity.
Compliance Technology is building a sophisticated next generation surveillance solution on top of a distributed data platform. The Belfast team is the global centre for the creation of feature-based surveillance algorithms using cutting edge technologies and techniques.
The volume and variety of data involved in these surveillances and the complexity of the algorithms results in one of most challenging and appropriate use cases for big data technologies.
Role / Position Overview
The Snr Oracle Developer will work within the User Experience technology team in the Compliance technology department to deliver functionality for internal web applications. The successful candidate will have strong Oracle database design and development skills, a good understanding of optimized methods of large data volumes storage, partitioning and fast sorting and data retrieval techniques, and will be a flexible, motivated self-starter.
Assisting with the design and build of new Surveillance components using a variety of cutting edge technologies
Write enterprise-class reusable, testable, and efficient Oracle SQL queries, stored procedures and triggers
Write documentation specific to developed component implementations
Work with team members in the development effort so that a streamlined solution is implemented across the application stack
Collaborate with team with respect to coding standards, architecture, and continuous integration
Understand Business needs and processes; identify solutions, present and guide project team/sponsors in identifying best solution
Participate in Requirements Analysis; design Applications based on System Requirements and Architecture, prototype if necessary, develop, unit test and deploy applications
Champion efforts related to back end development and help establish new design patterns/elements across the department
Contribute to the enhancement of department application development/delivery standards, tools and processes
Provide production support that includes evaluate efforts, investigate cause and come up with solutions to address defects
Working with project managers and support teams to meet delivery targets
Mentoring and coaching more junior members of the development team
professional working experience in Information Technology
Comfortable working with large data volumes and be able to demonstrate a firm understanding of logical data structures and analysis techniques
Capable of assisting with the design of solutions and mentoring other developers within the same team
A confident SQL developer
Good knowledge in performance tuning, query optimization, database design and management
A keen understanding of software development lifecycle and methodologies (Agile, Waterfall, Iterative, Prototype)
Worked as part of a team in large, complex, mission critical environments
Proven track record on delivering software development project
Experienced with automated build and test processes within the Oracle space
Able to demonstrate expertise in identifying and resolving data quality issues
Experience with standard source control and development tools (GIT, SQL Developer)
Familiar with the financial services industry and/or regulatory environments
Experience with Java Web Technologies and Web Frameworks (Spring) is desirable
Experience working within a web based application is highly desirable
Good communication and a Collaborative mind-set
Expert level Oracle SQL*Plus, PL/SQL, Stored procedures and triggers
Working knowledge of data serialization formats (JSON / XML)
(Desirable) Java and Java Web Technologies
Knowledge of working in Cloud technologies
A strong degree in any mathematical subject including physics, mathematics, engineering or computer science
Exceptional candidates who do not meet these criteria may be considered for the role provided they have the necessary skills and experience.
Adept written and verbal communicator
Highly adaptable and be willing to mentor and train more junior team members
Organized and prepared to manage multiple parallel pieces of work
Prior experience working with remote teams
Ability to tackle challenges in a logical way
What we Offer
As well as a competitive salary and consideration for a yearly discretionary bonus Citi offer;
23 days paid annual leave
Award winning pension scheme,
Life assurance and
Private medical insurance with Bupa healthcare.
In addition, we offer a competitive maternity, paternity and adoption leave scheme and employees also have the option (provided they have a student loan from the Student Loan Company) to divert saver and company match contributions to their student loan. We pride ourselves on our ability to offer employees a number of lifestyle benefits including; on site restaurant and coffee shops, online shopping and concierge service and subsidised clubs and societies.
Our select benefit package offers you the opportunity to customise your benefits according to your own lifestyle preferences and includes corporate discounts, memberships and a range of additional extras.
Our vast range of diversity networks and on site multi faith room demonstrates Citi’s commitment to growing a diverse workforce.
Grade :All Job Level - All Job FunctionsAll Job Level - All Job Functions - GB
Time Type :Full time
Citi is an equal opportunity and affirmative action employer.
Minority/Female/Veteran/Individuals with Disabilities/Sexual Orientation/Gender Identity.
Citigroup Inc. and its subsidiaries ("Citi”) invite all qualified interested applicants to apply for career opportunities. 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 .
To view the "EEO is the Law" poster . To view the EEO is the Law Supplement .
To view the EEO Policy Statement .
To view the Pay Transparency Posting .