Job Title:
Senior Oracle Database Developer
Function: Compliance Technology
Reporting to: Markets Trade Surveillance UX manager
Location: Belfast
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.
Team/Function Overview
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.
Key Responsibilities:
- Write enterprise-class reusable and efficient Oracle SQL queries, stored procedures and triggers
- Investigate existing PL/SQL and Database structures, to improve query response times and ability to handle very large data volumes
- 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
- 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
Knowledge/Experience:
- Professional working experience in Information Technology
- Comfortable working with large data volumes and 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 PLSQL 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
- 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
Technical Skills:
- Expert level Oracle SQL*Plus, PL/SQL, Stored procedures and triggers
- SQL
- Linux
- Working knowledge of data serialization formats (JSON / XML)
- Continuous Integration
- (Desirable) Hadoop
- (Desirable) Java and Java Web Technologies
- Knowledge of working in Cloud technologies
Qualifications:
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.
Competencies
- 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.
-------------------------------------------------
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 CLICK HERE.
To view the "EEO is the Law" poster CLICK HERE. To view the EEO is the Law Supplement CLICK HERE.
To view the EEO Policy Statement CLICK HERE.
To view the Pay Transparency Posting CLICK HERE.