Engineering Lead Analyst-Couchbase, Redis, OCI, Ansible, Teraform

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 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 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 cloud-based solutions adhere to best practices for security, cost management, and performance.
• API Management : Design, implement, and manage APIs for database and caching 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 :

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.