Engineering Lead Analyst, Citi

Citi

Location:
India, Pune

Category:
IT - Software Development

Contract Type:
Not provided

Salary:

Not provided

Save Job

Apply Position

Job Description:

Mid-Senior Database Engineer role focusing on database design, architecture, and management with expertise in Microsoft SQL Server, Redis, caching technologies, cloud platforms, and API management. The position requires substantial experience with both on-premises MSSQL engineering and strong automation skills.

Job Responsibility:

Design and optimize database architectures for high availability, scalability, and reliability using MSSQL and Redis
Develop and implement data models that support business requirements
Install, configure, and manage on-premises MSSQL instances and clusters
Perform regular maintenance tasks including backups, restores, and upgrades
Monitor database performance and troubleshoot issues
Design and implement caching strategies to enhance application performance
Implement and manage persistent storage solutions
Deploy and manage MSSQL and Redis instances on public cloud platforms (AWS, Azure)
Design, implement, and manage APIs for database and caching services
Develop automation scripts and tools for database, API, and system management
Analyze and optimize query performance, database indexes, and storage strategies
Ensure database and storage security and compliance
Work closely with developers, system administrators, and DevOps teams
Create and maintain comprehensive documentation

Requirements:

Bachelor's degree in Computer Science, Information Technology, or related field
10 years of experience in database administration and management
Minimum 5 years of experience with caching technologies and cloud platforms
Proven experience with Microsoft SQL Server (MSSQL) and Redis in production environments
Experience with persistent storage solutions and technologies
Experience with on-premises MSSQL engineering and administration
Experience with PostgreSQL and vector databases
Experience with API management and integration
Experience with Terraform for infrastructure automation
Experience with public cloud platforms (AWS, Azure)
In-depth knowledge of MSSQL architecture, configuration, and performance tuning
Proficient in caching mechanisms and strategies with Redis
Experience with persistent storage technologies and data durability strategies
Proficient in database query languages (T-SQL) and data modeling techniques
Experience with scripting and automation tools (PowerShell, Python, Ansible, Terraform)
Familiarity with DevOps practices, CI/CD pipelines, and containerization (Docker, Kubernetes)

Nice to have:

Experience with PostgreSQL and vector databases is a significant advantage
Familiarity with DevOps practices, CI/CD pipelines, and containerization (Docker, Kubernetes) is a plus

Additional Information:

Job Posted:
September 12, 2025

Employment Type:

Fulltime

Work Type:

On-site work

View All Jobs In This Company

Job Link Share:

Engineering Lead Analyst