📍 Job Overview

• Job Title: AVP - Database Engineer
• Company: Citi
• Location: Mumbai, India
• Job Type: On-site
• Category: Database Administration
• Date Posted: June 13, 2025
• Experience Level: 7-9 years
• Remote Status: On-site

🚀 Role Summary

• Key Responsibilities: Design, develop, and optimize Oracle database solutions using SQL and PL/SQL. Implement and manage applications on Oracle Cloud Infrastructure (OCI). Write Python scripts for data automation, transformation, and validation. Apply Big Data principles to support large-scale data processing needs. Design and maintain robust ETL workflows and data pipelines. Build and support Data Warehouse solutions ensuring performance and reliability. Collaborate with technical and business teams, especially data stakeholders, to understand and fulfill data requirements. Leverage SAS knowledge (if applicable) to support data analysis and reporting initiatives.

💻 Primary Responsibilities

• Database Design & Optimization: Design, develop, and optimize Oracle database solutions using SQL and PL/SQL. Ensure optimal performance and reliability.
• Cloud Infrastructure Management: Implement and manage applications on Oracle Cloud Infrastructure (OCI). Leverage cloud services to enhance data processing and storage capabilities.
• Data Automation & Transformation: Write Python scripts for data automation, transformation, and validation. Streamline data processing workflows and improve efficiency.
• Big Data Processing: Apply Big Data principles to support large-scale data processing needs. Leverage Hadoop, Spark, or other relevant technologies to process and analyze big data.
• ETL Workflows & Data Pipelines: Design and maintain robust ETL workflows and data pipelines. Ensure data integrity, accuracy, and timely delivery.
• Data Warehouse Solutions: Build and support Data Warehouse solutions. Ensure performance, reliability, and scalability to meet business intelligence and analytics needs.
• Stakeholder Collaboration: Collaborate with technical and business teams, especially data stakeholders, to understand and fulfill data requirements. Translate business needs into effective technical solutions.
• SAS Integration (if applicable): Leverage SAS knowledge to support data analysis and reporting initiatives. Integrate SAS with other data processing and analysis tools to enhance overall data capabilities.

🎓 Skills & Qualifications

Education: Bachelor’s degree in Computer Science, Information Technology, or a related field.

Experience: 7-9 years of experience in database engineering, with a strong focus on Oracle SQL and PL/SQL.

Required Skills:

• Strong proficiency in Oracle SQL and PL/SQL
• Experience with Oracle Cloud services
• Solid knowledge of Python programming
• Understanding of Big Data technologies (e.g., Hadoop, Spark)
• Experience with ETL tools and processes
• Familiarity with Data Warehouse design and optimization
• Excellent communication and interpersonal skills to collaborate across teams

Preferred Skills:

• Experience with SAS for data analysis, reporting, or integration
• Background in data analytics, data modeling, or performance tuning
• Prior work experience as a business consultant, interacting with multiple stakeholders
• Familiarity with additional programming/scripting languages

📊 Web Portfolio & Project Requirements

Portfolio Essentials:

• Demonstrate strong proficiency in Oracle SQL and PL/SQL with relevant projects and case studies
• Showcase experience with Oracle Cloud services and data automation using Python
• Highlight ETL workflows and data pipelines designed and maintained for large-scale data processing
• Present Data Warehouse solutions built and supported, emphasizing performance, reliability, and scalability
• Include examples of collaboration with stakeholders and successful data analysis or reporting initiatives using SAS (if applicable)

Technical Documentation:

• Document code quality, commenting, and documentation standards for SQL and PL/SQL scripts
• Explain version control, deployment processes, and server configuration for Oracle Cloud Infrastructure (OCI)
• Describe testing methodologies, performance metrics, and optimization techniques for data processing workflows and data pipelines
• Detail system architecture, data flow, and integration points for Data Warehouse solutions
• Include user documentation, data dictionaries, and other relevant technical artifacts

💵 Compensation & Benefits

Salary Range: INR 25-35 lakhs per annum (based on experience and market standards for senior database engineers in Mumbai)

Benefits:

• Competitive health, dental, and vision insurance plans
• Retirement savings plans with company match
• Generous time-off policies, including vacation, sick leave, and holidays
• Employee stock purchase plan
• Tuition assistance and professional development opportunities
• Employee discounts on various products and services
• Wellness programs and resources to support physical and mental health

Working Hours: Full-time (40 hours/week), with flexibility for project deadlines and maintenance windows

🎯 Team & Company Context

🏢 Company Culture

Industry: Financial Services

Company Size: Large (over 200,000 employees)

Founded: 1812

Team Structure:

• Database Administration Team: Responsible for database design, development, optimization, and management
• Cloud Infrastructure Team: Manages Oracle Cloud Infrastructure (OCI) and other cloud services
• Data Analytics Team: Performs data analysis, modeling, and reporting using tools like SAS
• Business Teams: Includes various lines of business, such as Retail Banking, Corporate Banking, and Investment Banking

Development Methodology:

• Agile/Scrum methodologies for software development and data processing workflows
• Code reviews, testing, and quality assurance practices for SQL and PL/SQL scripts
• Deployment strategies, CI/CD pipelines, and server management for Oracle Cloud Infrastructure (OCI)

Company Website: www.citigroup.com

📈 Career & Growth Analysis

Database Administration Career Level: Senior Database Engineer, responsible for designing, developing, and optimizing Oracle database solutions. Manages applications on Oracle Cloud Infrastructure (OCI) and collaborates with stakeholders to fulfill data requirements.

Reporting Structure: Reports to the Database Administration Manager or similar role within the organization. Collaborates with various teams, including Cloud Infrastructure, Data Analytics, and Business Teams.

Technical Impact: Influences data processing, storage, and analysis capabilities. Ensures optimal performance, reliability, and scalability of database solutions and data pipelines.

Growth Opportunities:

• Technical Growth: Expand expertise in Oracle Cloud services, Big Data technologies, and data analytics tools like SAS
• Leadership Potential: Develop team management and architecture decision-making skills through mentoring, training, and project leadership opportunities
• Career Progression: Transition into roles such as Database Architect, Data Engineering Manager, or similar leadership positions within the organization

🌐 Work Environment

Office Type: Modern, collaborative workspace with multiple monitors, testing devices, and development tools available

Office Location(s): Mumbai, India

Workspace Context:

• Collaborative workspace with open floor plans and dedicated team spaces
• Access to multiple monitors, testing devices, and development tools for efficient work
• Cross-functional collaboration with designers, marketers, and other business teams

Work Schedule: Full-time (40 hours/week), with flexibility for deployment windows, maintenance, and project deadlines

📄 Application & Technical Interview Process

Interview Process:

1. Technical Assessment (60-90 minutes): Evaluate SQL and PL/SQL proficiency, data automation using Python, and understanding of ETL processes and Data Warehouse design. Assess problem-solving skills and ability to optimize database performance.
2. System Design & Architecture Discussion (60-90 minutes): Discuss data modeling, data flow, and integration points for a given scenario. Evaluate understanding of cloud infrastructure, big data processing, and data pipeline design.
3. Behavioral & Cultural Fit Assessment (30-45 minutes): Assess communication skills, teamwork, and cultural fit within the organization. Discuss experiences working with stakeholders and managing data projects.
4. Final Evaluation & Next Steps (15-30 minutes): Review technical and behavioral assessment results. Discuss career growth opportunities and next steps in the interview process.

Portfolio Review Tips:

• Highlight relevant projects demonstrating strong proficiency in Oracle SQL and PL/SQL
• Showcase experience with Oracle Cloud services and data automation using Python
• Present ETL workflows and data pipelines designed and maintained for large-scale data processing
• Include examples of collaboration with stakeholders and successful data analysis or reporting initiatives using SAS (if applicable)
• Include technical documentation, user documentation, and other relevant artifacts

Technical Challenge Preparation:

• Brush up on SQL and PL/SQL skills, focusing on optimization, performance, and reliability
• Review Python scripting for data automation, transformation, and validation
• Familiarize yourself with Oracle Cloud Infrastructure (OCI) and relevant cloud services
• Study ETL processes, data pipeline design, and Data Warehouse solutions
• Prepare for system design and architecture discussions, focusing on data modeling, data flow, and integration points

ATS Keywords: Oracle SQL, PL/SQL, Oracle Cloud, Python, ETL, Big Data, Data Warehouse, SAS, Data Analysis, Data Modeling, Performance Tuning, Stakeholder Interaction, Data Automation, Data Transformation, Data Validation

📌 Application Steps

To apply for this Senior Database Engineer position:

1. Submit your application through the application link provided
2. Customize your resume and portfolio to highlight relevant database engineering skills and projects
3. Prepare for the technical assessment by reviewing SQL and PL/SQL concepts, Python scripting, and Oracle Cloud services
4. Research Citi's data processing and analytics initiatives to demonstrate your understanding of the organization's data needs and goals
5. Prepare for the system design and architecture discussion by studying data modeling, data flow, and integration points for relevant scenarios
6. Practice your problem-solving skills and brush up on your communication skills for the behavioral and cultural fit assessment
7. Review the company's benefits and compensation packages to ensure they meet your expectations and career goals