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 and below skill sets wherever applicable Key Responsibilities Database Design and Architecture 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 where applicable On-Premises MSSQL Engineering and Administration Install configure and manage on-premises MSSQL instances and clusters ensuring optimal performance and reliability Perform regular maintenance tasks including backups restores and upgrades Monitor on-premises MSSQL environments implement improvements and troubleshoot issues Database Management and Maintenance Manage MSSQL instances and Redis clusters both on-premises and in the cloud Perform regular maintenance tasks including backups restores and upgrades Monitor database performance implement improvements and troubleshoot issues as they arise Caching Solutions Design and implement caching strategies to enhance application performance and reduce database load Utilize caching mechanisms in Redis and integrate with other caching solutions as needed Analyze and optimize cache performance eviction policies and cache coherency Persistent Storage Solutions Implement and manage persistent storage solutions to ensure data durability and reliability Work with various storage technologies and strategies to support data integrity and high performance Monitor storage performance and make adjustments to improve efficiency and scalability Public Cloud Integration Deploy and manage MSSQL and Redis instances on public cloud platforms such as AWS and Azure Leverage cloud-native tools and services for database caching and storage management including auto-scaling and monitoring Ensure cloud-based solutions adhere to best practices for security cost management and performance API Management Design implement and manage APIs for database and caching services Ensure API security performance and scalability Monitor and optimize API usage and performance integrating with existing systems as needed Automation Develop and implement automation scripts and tools for database API and system management including deployment scaling and monitoring Utilize tools like Terraform for infrastructure automation and orchestration Streamline and automate routine tasks to enhance operational efficiency Performance Tuning and Optimization Analyze and optimize query performance database indexes and storage strategies for MSSQL Implement caching strategies and manage data replication between MSSQL and Redis Optimize PostgreSQL and vector databases for performance and efficiency Data Security and Compliance Ensure database and storage security and compliance with organizational policies and industry standards Implement data encryption access controls and regular audits Collaboration and Support Work closely with developers system administrators and DevOps teams to ensure seamless integration of database caching API and storage solutions Provide technical support and guidance on database caching API and storage-related issues to other team members Documentation and Best Practices Create and maintain comprehensive documentation for database API and system configurations procedures and policies Establish and promote best practices for database API development deployment and monitoring Qualifications Education Bachelor s degree in Computer Science Information Technology or a related field Experience 10 years of experience in database administration and management Required for couchbase Redis Database and oracle cloud infrastructure OCI expert automation Ansible Teraform 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 Technical Skills 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 Robust experience with on-premises MSSQL environments Experience with PostgreSQL and vector databases including performance tuning and optimization Experience with API management including design implementation and monitoring Experience with cloud platforms AWS Azure and cloud-native tools for database caching and storage management Proficient 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 Soft Skills Strong problem-solving skills and attention to detail Excellent communication and collaboration abilities Ability to work independently and as part of a team in a fast-paced environment - Job Family Group Technology - Job Family Systems Engineering - Time Type Full time - Most Relevant Skills Please see the requirements listed above - 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

📌 Engineering Lead Analyst-couchbase, Redis, Oci, Ansible, Teraform (Maharashtra)
🏢 Citi
📍 Maharashtra