Technology Engineer - SQLServer and VectorDB (Redis)

About the Role

We are seeking an experienced Database Engineer with expertise in SQL Server and VectorDB to manage high-performance, secure, and highly available database environments. You will design and administer HA/DR solutions, perform migrations, optimize performance, and manage Redis Enterprise deployments. The role involves automating repetitive tasks using Ansible, Jenkins, Terraform, and Groovy. You will work on multiple challenging, business-critical banking projects under tight deadlines, with occasional out-of-hours and weekend work. Collaboration with cross-functional teams is essential to deliver robust, scalable database solutions. This position demands precision, problem-solving skills, and the ability to thrive under pressure.

Key Responsibilities:

• Administer, configure, and maintain SQL Server databases in large enterprise environments.
• Design, implement, and manage High Availability (HA) and Disaster Recovery (DR) solutions, including Always-on AGs, Distributed AGs, replication, and mirroring.
• Manage SQL Always Cluster administration and oversee database upgrades (in-place with AG, DAG & Windows failover cluster).
• Optimize database performance and troubleshoot performance issues.
• Manage backups, restores, recovery models, and database migrations.
• Implement security features such as auditing and TLS encryption.
• Deploy and manage Redis Enterprise on OpenShift, including Active-Active Database configurations, auto-tiering/FlexDB, and Redis modules (Redis Search and Vector Index management).
• Collaborate with cross-functional teams, applying Agile practices and automation tools.

Qualifications & Experience:

Essential:

• Bachelor’s degree or higher in Computer Science.
• 6+ years’ experience in large organizations.
• Excellent knowledge of SQL Server administration, HA/DR options, performance tuning, and optimization.
• Strong experience with SQL Server 2016 and higher versions.
• Proficiency in Always-on AGs, Distributed AGs, replication, and mirroring.
• Experience with Redis Enterprise deployment and features.
• Strong understanding of security features, backups, and database migration.
• Knowledge of SQL and/or PL/SQL, PowerShell, and Unix/Linux/Windows operating systems.
• Familiarity with Agile methodologies.

Desirable:

• Relevant industry certifications.
• Banking domain experience.
• Technical knowledge of OS and virtualization (Windows, VMWare, Hyper-V).
• Experience with automation tools such as Ansible, Jenkins, Terraform, and ArgoCD.
• Scripting knowledge (Bash, Python).
• Exposure to other databases.

Behavioral Competencies:

• Ability to work under pressure and manage multiple projects simultaneously.
• Professional communication and interpersonal skills.
• Strong self-management and organizational skills.