주요 콘텐츠로 건너 뛰기

커리어

COVID-19:

우리 동료들과 지원자들의 건강은 우리의 최우선 순위입니다. 따라서 Citi는 COVID-19 상황을 면밀히 모니터링하고 있습니다. 우리는 추후 공지가 있을 때까지, 임시적으로 모든 후보자 인터뷰를 가상으로 실시하는 것을 포함하여 전 세계적으로 회사 전체에 예방 조치를 구현하였습니다.

Sr Database Architect

직무 ID 22511323 기본 근무지 London, United Kingdom; 채용 범주 Technology
바로 지원하기

Introduction

Citi's Institutional Clients Group (ICG) is comprised of diverse, talented professionals located in more than 100 countries, jurisdictions and territories globally. Citi's Banking, Capital Markets and Advisory (BCMA) is one of four divisions within ICG and provides comprehensive relationship coverage along with a full suite of products and services. In an effort to be the best possible financial partner to its institutional clients, the BCMA business strives to meet the demands w of Citi's global client base through debt capital raising, merger and acquisitions, and equity-related strategic financing solutions. 

BCMA technology is focused on building a cross-functional team of talented individuals, creating a unique platform to deliver products that will disrupt the industry through technical innovation and creativity. 

Our mission as a business focused technology organization is to provide best-in-class products and services to our global clients while solving our banker’s biggest pain points.

Why Citi?

  • Over 200 years in business with a great team of creative, visionary and entrepreneurial thinkers.
  • Tremendous opportunities to advance, open to everyone across all levels. Learn and grow simultaneously!
  • We offer a unique journey of personal and professional development, accomplishment and satisfaction.
  • We value intelligence and a global mindset. There is a strong culture of empowerment here – we embrace diversity.
  • We do our best to be flexible and may differ depending on the business or area.
  • Citi India supports would be and returning mothers with various childcare benefits.
  • Citi offers a robust training program. We continually reevaluate our training model to ensure that we are always offering the most relevant and best in class training.
  • At Citi, we value internal mobility. We want you to build a long-term career with us, so you can expect opportunities to move around the organization.

Job Description

The position is within BCMA Technology which is focused on automating and modernizing operations while implementing and leveraging cross product shared services opportunities. The position is for an experienced Database Architect who will spend time understanding the business needs and set up the most appropriate mechanism of storing, organizing, and accessing data needed day to day. You should be passionate about technology and have broad and in-depth understanding of different database technologies, as well associated infrastructure/cloud strategies that would underpin them.


Responsibilities:

  • With business and technical needs/limitations understood, create an architectural Database strategy for BCMA that is carefully aligned to overall Data Strategy for ICG. This should include patterns for the most common data needs and demand.
  • Work with BCMA Data Architects to ensure Database and Data strategies are aligned.
  • Provide subject matter expertise and architectural guidance & direction to application development teams
  • Create a set of processes, principles as well as governance for overseeing database build out within BCMA.
  • Own success – Take ownership of deliverables both individually as well as part of the team.
  • Mentor cross functional team members
  • Explore an understand application team architectures and determine areas of complexity, inefficiency, and potential risks, proposing alternative approaches where appropriate
  • Strictly follow Citi’s engineering standards and ensure these are part of any designs/solutions proposed
  • Operate with a limited supervision
  • Line Management

Key Technology Skills:

  • Expert knowledge and understanding with MS SQL Server/ Oracle with NoSQL being highly desirable.
  • Data Modelling (Conceptual, Logical & Physical)
  • Performance optimizations on SQL Server/ Oracle, SQL tuning and investigation of bottlenecks
  • Advanced knowledge of both SQL Server and Oracle Security models and how to effectively implement them
  • Advanced knowledge of Database Administration tasks and activities
  • Ability to translate architecture and low-level requirements to design and code using SQL
  • Able to design physical data models for insert as well as query performance aligned to business use cases
  • Hands on SQL features – Stored Procedures, Indexes, Partitioning, Bulk loads, DB configuration, Security/Roles, Maintenance, Exception Handling
  • Infrastructure (Physical, VM, Cloud) patterns for hosting Database solutions
  • Exposure to a variety of reporting and query tools. Tableau would be beneficial.

Highly Desirable Technology Skills

  • Hands-on MongoDB experience and how to design the best MongoDB schema for a given application
  • Knowledge on various MongoDB libraries and APIs for different programming languages and platform
  • Demonstrate an understanding of the differences between typical relational and NoSQL database development and access methodologies
  • Experience of Tableau configuration with SQL Server/Oracle.
  • Working with virtualized SQL / Oracle / MongoDB implementations.
  • Working knowledge of Snowflake


Education:

  • Bachelor’s degree/University degree or equivalent experience

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

Job Family Group:

Technology

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

Job Family:

Applications Development

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

Time Type:

Full time

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

Citi is an equal opportunity and affirmative action employer.

Qualified applicants will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

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 review Accessibility at Citi.

View the "EEO is the Law" poster. View the EEO is the Law Supplement.

View the EEO Policy Statement.

View the Pay Transparency Posting

바로 지원하기
  • 22만 명 이상의 유능하고 다양한 직원으로 구성된 Citi 팀에 합류하십시오

  • 90개 국가의 공동체에서 자원봉사를 행하는 사회적 책임감을 가진 직원들

  • 95개 이상의 시장에 실제로 존재하는 의미 있는 채용 기회

우리는 모든 개인을 포용하고 다양한 관점을 장려하여, 귀하가 영향력을 생성하고 경력을 성장시킬 수 있는 문화를 조성합니다. Citi는 높은 수준의 전문성 기준, 굳건한 성실성과 관대함, 지적 호기심 및 엄격함을 보여주는 동료를 소중하게 생각합니다. 우리는 귀하가 씨티에서 경력을 쌓는다는 일이 가진 중요성을 인식하며, 귀하의 헌신에 대하여 우리도 마찬가지로 노력할 것을 약속 드립니다

저장된 채용 공고

열람한 채용 공고가 없습니다.

이전에 본 채용 공고

열람한 채용 공고가 없습니다.