Senior Database Engineer (SQL Server/Azure)

Gent, Belgium

Striving for excellence is in our DNA. Since 1993, we have been helping the world’s leading companies imagine, design, engineer, and deliver software and digital experiences that change the world. We are more than just specialists, we are experts.

DESCRIPTION


Currently we are looking for a Senior Database Engineer (SQL Server/Azure) for our Gent office to make the team even stronger.


We are looking for a Senior Database Engineer who will work as a part of a dynamic, global team in a rapidly growing company. While the role is truly one of an individual contributor, a high degree of interaction and teamwork are required to be effective in the role. The qualified candidate will possess excellent technical and organizational skills. An individual must possess good teamwork, leadership and communication skills.

You will be the link between several product development teams, who develop our SaaS products, and operations, who maintain our SaaS products in the Azure Cloud for multiple global customers (Global brands).

Responsibilities

  • Maintain and improve the time-to-market of new software releases on Azure Cloud;
  • Assist product development and operations in deploying new software releases and bring new customers to SaaS;
  • Maintain and monitor all databases across the enterprise to ensure issues are taken care of before they pose a problem. This includes monitoring several dozen physical servers across multiple geographic locations, containing over 100 databases, several thousand tables, spanning billions of records;
  • Use a variety of tools for monitoring (such as scripts, email alerts, dashboards and user inquiries describing end user symptoms that need to be corrected);
  • Create, implement, test and manage automated database backups for the entire SQL server farm across all geographical locations using industry standard software and best practices;
  • Create and maintain all server documentation on the local Wiki regarding security policies, replication polices, server architecture and backup policies. Included in this documentation would be a change log to track changes made by any individual to any live production database at any time;
  • Create, manage and troubleshoot server replication policies all geographical nodes. Troubleshooting will include research and analysis of slow moving replications, missing records and other anomalies that can occur during replication;
  • Participate in design of new databases and servers, working with stakeholders and acting as a subject matter expert to determine proper industry best practices;
  • Assist Database Developers to retrieve data whenever needed, using SQL scripts and procedures;
  • Tune queries as needed for optimal response time using various methods such as script optimization, file grouping, index creation and optimization as well as location and geographic optimization;
  • Review and publish changes to the production environment and all changes created by the development team using provided scripts and packages on a scheduled basis;
  • Participate in an on-call rotation for after-hours production support.

Requirements

  • Bachelor’s or Master’s degree in computer science (10 years of IT experience);
  • Experience in setting up the DevOps pipeline (3 years of experience);
  • Solid understanding of how to configure, deploy, manage and maintain large cloud hosted systems (preferably on Azure); including auto-scaling, monitoring, performance tuning, troubleshooting and disaster recovery;
  • Proficiency in source control, continuous integration, and testing pipelines;
  • Experience in log management and log aggregation;
  • Fluency in one or more scripting languages such as PowerShell;
  • Affinity with C#.NET is nice to have;
  • Database experience (SQL Server, SQL Azure, NoSQL, etc.);
  • Solid understanding of SQL, SQL Performance Monitor, SQL Profiler and SQL Compare;
  • Experience in interpreting 'Estimated Execution Plans' to identify and/or resolve performance issues;
  • Experience in applying timely and scheduled database application patches related to both t the product and security. The application of patches and service packs include testing them in a test environment before promoting them to production;
  • The ability to troubleshoot database server related CPU, memory, I/O, disk space and other resource contention issues using Database Performance Analyzer SQL Diagnostic Manager, native SQL tools;
  • Setting up, maintaining and monitoring database server security via a combination of Active Directory and sever level permission settings;
  • Experience working in a process-oriented environment with formal Request, Change, and Problem Management processes;
  • Fluent in English.

We offer

  • Competitive compensation depending on experience and skills;
  • Regular assessments and salary reviews;
  • Opportunities for self-realization;
  • Friendly team and enjoyable working environment;
  • Flexible working schedule;
  • Corporate and social events.