Engineering Lead Analyst

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.
  • 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.
  • Strong 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.

---