Database Developer

Citi; Gurugram District; On-site; INR 1,800,000 - 3,200,000; Full time

Job summary

Citi in India seeks a senior database developer to design, develop and maintain robust SQL Server databases for risk and marketing domains. You will optimize stored procedures, ensure data integrity and security, and collaborate with developers and analysts to meet business requirements.

The role emphasizes performance tuning, data modeling, ETL processes (SSIS) and independent ownership of projects in a banking environment. Master’s degree is preferred.

Qualifications

• 8+ years of experience as a database developer with a focus on SQL Server in a major bank (Risk or Marketing)
• Strong SQL Server expertise: T-SQL, stored procedures, triggers, performance tuning
• Solid data modeling concepts and experience with data modeling tools
• Experience with ETL tools and processes (e.g., SSIS) a plus
• Programming experience in PowerShell; PySpark is a plus
• Excellent analytical, problem-solving, and independent-work skills

Responsibilities

• Database Development: Design, develop, and maintain high-performance SQL Server solutions
• Stored Procedures: Write, optimize, and maintain complex stored procedures, triggers, and user-defined functions
• Performance Tuning: Monitor and optimize database performance
• Data Modeling: Design logical and physical data models
• Data Integrity: Enforce data quality with constraints and validation rules
• ETL Processes: Develop and maintain ETL to load/transform data from multiple sources
• Collaboration: Work with developers, analysts, and stakeholders to meet requirements

Skills

Analytical Thinking

Constructive Debate

Escalation Management

Industry Knowledge

Policy and Procedure

Policy and Regulation

Process Execution

Product Knowledge

Risk Controls and Monitors

Risk Identification and Assessment

Education

Master's degree in Computer Science or Statistics

Tools

SSIS

PowerShell

PySpark

Job description

Overall Objective:

This is a senior-level individual contributor role responsible for the design, development, and maintenance of our database systems. The primary objective is to ensure the performance, integrity, and security of our data by developing robust and efficient database solutions. This individual will act as a subject matter expert on SQL Server and will be responsible for creating and optimizing complex stored procedures and database queries.

Key Responsibilities:

• Database Development: Design, develop, and maintain high-performance, scalable database solutions using SQL Server.


• Stored Procedures: Write, optimize, and maintain complex stored procedures, triggers, and user-defined functions to support business applications.


• Performance Tuning: Monitor and optimize database performance, identifying and resolving bottlenecks and performance issues.


• Data Modeling: Design and implement logical and physical data models to meet business requirements.


• Data Integrity: Ensure data integrity and consistency through the implementation of constraints, data validation rules, and other best practices.


• ETL Processes: Develop and maintain ETL processes to load and transform data from various sources into the database.


• Collaboration: Work closely with application developers, business analysts, and other stakeholders to understand requirements and provide database solutions.

Qualifications:

• Experience: 8+ years of experience as a database developer, with a strong focus on SQL Server as an individual contributor in a major bank, working within Risk or Marketing teams with a focus on the mortgage and/or retail/commercial banking industry.


• Technical Skills:
  
  
  
  • Database: Expertise in SQL Server, including T-SQL, stored procedures, triggers, and performance tuning.
  
  
  • Data Modeling: Strong understanding of data modeling concepts and experience with data modeling tools.
  
  
  • ETL: Experience with ETL tools and processes (e.g., SSIS) is a plus.
  
  
  • Programming: Experience with PowerShell, Pyspark is a plus.
  
  
  
  


• Soft Skills:
  
  
  
  • Analytical Thinking: Strong analytical and problem-solving skills, with the ability to analyze complex data and business requirements.
  
  
  • Attention to Detail: Meticulous attention to detail and a commitment to data quality and accuracy.
  
  
  • Independence: Ability to work independently with limited supervision and take ownership of projects.
  
  
  
  

Education:

• Master's degree in Computer Science or Statistics is required.

Job Family Group:

Risk Management

Job Family:

Portfolio Credit Risk Management

Time Type: Full time

Most Relevant Skills

• Analytical Thinking


• Constructive Debate


• Escalation Management


• Industry Knowledge


• Policy and Procedure


• Policy and Regulation


• Process Execution


• Product Knowledge


• Risk Controls and Monitors


• Risk Identification and Assessment.

Other Relevant Skills: For complementary skills, please see above and/or contact the recruiter.

Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law.

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 Citi's EEO Policy Statement and the Know Your Rights poster.\"