Sr Database Architect

Job Description

IntroductionCitis Institutional Clients Group (ICG) is comprised of diverse, talented professionals located in more than 100 countries, jurisdictions and territories globally. Citis Banking, Capital Markets and Advisory (BCMA) is one of four divisions within ICG andprovides 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 Citis global client basethrough 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 bankers 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 understandingthe 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 associatedinfrastructure/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 Citis 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:

• Bachelors 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 opportunityreview 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