Technology Engineer - SQL Server and VectorDB (Redis)
We are seeking an experienced Database Engineer with expertise in SQL Server and VectorDB to manage high-performance, secure, and highly available database environments. The role involves designing and administering HA/DR solutions, performing migrations, optimizing performance, and managing Redis Enterprise deployments. You will also automate repetitive tasks using Ansible, Jenkins, Terraform, and Groovy while working on multiple challenging, business‑critical banking projects under tight deadlines, including occasional out‑of‑hours and weekend work. Collaboration with cross‑functional teams is essential to deliver robust, scalable database solutions.
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.
Seniority Level: Mid‑Senior level
Employment Type: Full‑time
Job Function: Other
Industries: IT Services and IT Consulting