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:

We are seeking a highly skilled and motivated Mid-Senior Database Engineer with 10 years of experience, including a minimum of 5 years with caching technologies and cloud platforms. Expertise in Microsoft SQL Server (MSSQL), Redis, caching strategies, persistent storage solutions, and API management is essential. The ideal candidate will also have experience with PostgreSQL, vector databases, on-premises engineering, and Terraform for infrastructure automation. This role requires substantial experience with both on-premises MSSQL engineering and administration, as well as strong automation skills. Experience with public cloud platforms such as AWS and Azure is also crucial. The candidate should possess a deep understanding of database architecture, data modeling, performance tuning, API management, cloud-based solutions.

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 and performance objectives
design and manage PostgreSQL databases and vector databases
install, configure, and manage on-premises MSSQL instances and clusters
perform regular maintenance tasks, including backups, restores, and upgrades
monitor database performance, implement improvements, and troubleshoot issues
design and implement caching strategies to enhance application performance
implement and manage persistent storage solutions to ensure data durability
deploy and manage MSSQL and Redis instances on public cloud platforms such as AWS and Azure
design, implement, and manage APIs for database and caching services
develop and implement 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 with organizational policies
work closely with developers, system administrators, and DevOps teams
create and maintain comprehensive documentation for database, API, and system configurations, procedures, and policies

Requirements:

10 years of experience in database administration and management
required for Couchbase, Redis (Database) and Oracle Cloud Infrastructure (OCI)
expertise in automation with Ansible and Terraform
minimum of 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 is a significant advantage
experience with API management and integration
experience with Terraform for infrastructure automation
experience with public cloud platforms (AWS, Azure) for deploying and managing database, caching, and storage solutions
in-depth knowledge of MSSQL architecture, configuration, and performance tuning
proficient in caching mechanisms and strategies, including experience with Redis caching
experience with persistent storage technologies and data durability strategies
strong experience with on-premises MSSQL environments
expertise in database query languages (T-SQL) and data modeling techniques
experience with scripting and automation tools (e.g., PowerShell, Python, Ansible, Terraform)
familiarity with DevOps practices, CI/CD pipelines, and containerization (Docker, Kubernetes) is a plus
strong problem-solving skills
excellent communication and collaboration abilities
ability to work in a fast-paced environment

Nice to have:

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

Additional Information:

Job Posted:
September 23, 2025

Employment Type:

Fulltime

Work Type:

On-site work

View All Jobs In This Company

Job Link Share:

Engineering Lead Analyst