Technology Engineer - SQLServer and VectorDB (Redis)

GSSTech Group
Full-time
On-site

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.

Requirements

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.