Find your next tech and IT Job or contract Database

Database Engineer Responsible for the development and delivery of new systems to automate and streamline processes required by different departments. To support the internal IT department with changes and upgrades to software platforms. To be primary contact for all technical questions relating to in-house bespoke systems and interfacing. Database Support Supporting budgeting and financial planning processes for Finance department, including loading and refreshing of data based on requirements. Understand and conduct the front-end functionality to amend and change hierarchical structures within the environment. Debug and analyse errors and anomalies within Hyperion system as raised by Finance and to pinpoint areas of failure and correct any issues. Liaise with Finance on a daily basis to ensure smooth running of the Hyperion environment. Build data flows within the SQL environment in SSIS packages. Introduce new field and data types for new information to be collated in the CORE environment. Integrate with all the Bank’s sub-systems using data abstraction and connectivity layers, i.e. ODBC, ADO.net. Build reports based on business requirements using Hyperion Interactive Reports. Ensure that the environment is running optimally and to utilise house-keeping procedures. Sharepoint Integration: Integrate the SharePoint environment and Forms with Equation system to introduce automation of processes thereby eliminating the need for duplicate entry. Utilise web services to integrate from cutting edge technology into legacy systems such as Equation. End of Day Cycle: Provide second and third level support for in-house programmes during the end of day cycle. Analyse and rectify any problems raised in an independent and team scenario. Ownership of a problem and deliver a solution in a timely manner. Provide out of office hours support. Risk & Regulatory Duties Maintain knowledge of all applicable regulatory requirements including the Bank’s Risk and Compliance policies and procedures and adhere to these to avoid exposing the Bank to undue risk. Report policy/procedure breaches and areas of potential non-compliance and suspicions promptly upon identification in accordance with the Bank's Risk and Compliance policies. Accurately execute all controls within own area to minimise risk of policy, procedure, and/or regulatory breaches. Identify new risks/control gaps within own area and escalate accordingly to your Line Manager and/or Head of Department. Training & Competence Complete all annual mandatory regulatory refresher training as per the Bank's training plans and deadlines. Proactively seek to complete recommended technical and behavioural competencies training required for your role. Conduct Act in accordance with the FCA/PRA Code of Conduct. Business Continuity Fulfil all prescribed business continuity requirements as set out in the organisational or departmental specific plans or as instructed by the Line Manager/Head of Department. Qualifications/Experience Degree level qualified or equivalent. SQL Programming. C# Software development. Knowledge and Skills C# Programming to high level of proficiency. Software analysis and design. SQL query language. Dimensional modelling Data warehouse design concepts, (Inmon or Kimball) The Client is a Bank based in the City of London. This is a 2 year FTC position with a salary of circa £65K - £70K. Do send your CV to us in Word format along with your salary and availability.

Description du profil : Dans un contexte de transformation du SI décisionnel, l’équipe porte actuellement des enjeux forts de modernisation des traitements Big Data, avec une migration en cours vers Spark ainsi qu’un projet de refonte complète dans le cloud basé sur Databricks à moyen terme. Dans ce contexte, nous recherchons un Data Engineer pour l'un de nous clients à Lyon ayant une forte appétence pour : • La compréhension des enjeux métier liés à la donnée • Les environnements Big Data en transformation • Le travail sur des systèmes existants et l’amélioration continue Le profil attendu combine compétences techniques solides et posture d’ingénieur impliqué dans le fonctionnement global du SI (BUILD & RUN). Une expérience minimale de 3 ans est requise.

Database Engineer with SQL Server and SSIS Our Client is a bank based in Central London who are looking to recruit a Database Engineer with the ability to work with SSIS. Responsible for the development and delivery of new systems to automate and streamline processes required by different departments. To support the internal IT department with changes and upgrades to software platforms. To be primary contact for all technical questions relating to in-house bespoke systems and interfacing. Database Support Supporting budgeting and financial planning processes for Finance department, including loading and refreshing of data based on requirements. Understand and conduct the front-end functionality to amend and change hierarchical structures within the environment. Debug and analyse errors and anomalies within Hyperion system as raised by Finance and to pinpoint areas of failure and correct any issues. Liaise with Finance on a daily basis to ensure smooth running of the Hyperion environment. Build data flows within the SQL environment in SSIS packages. Risk & Regulatory Duties Maintain knowledge of all applicable regulatory requirements including the Bank’s Risk and Compliance policies and procedures and adhere to these to avoid exposing the Bank to undue risk. Report policy/procedure breaches and areas of potential non-compliance and suspicions promptly upon identification in accordance with the Bank's Risk and Compliance policies. Accurately execute all controls within own area to minimise risk of policy, procedure, and/or regulatory breaches. Identify new risks/control gaps within own area and escalate accordingly to your Line Manager and/or Head of Department. Qualifications/Experience Degree level qualified or equivalent. SQL Programming. Knowledge and Skills Software analysis and design. SQL query language. Data warehouse design concepts, (Inmon or Kimball) Must have solid experience of working with SSIS and building data warehouses and some knowledge of reporting using SSRS. The Client is a Bank based in the Central London. This is a 12 month FTC position with a salary of circa £55K - £70K. You will be required to be in the office at least 3 days week. Do send your CV to us in Word format along with your salary and availability.

Database Developer with TeraData - Coventry Our Client is looking to recruit a Tera Data Developer with at least 5 years hands-on experience in data analysis, data modeling & SQL writing in Teradata Environment. Must have strong knowledge in Teradata Architecture. (Must have knowledge on Journal, RAID, CLIQUE,FALLBACK mechanism) Good understanding and working knowledge of ALL SQL functions, Join strategies (HASH, MARGE etc.) Understanding and working knowledge of all System tables such as DBQL, PDCRINFO etc Hands on knowledge on Teradata PL/SQL, Store Procedure, Ref Cursor etc With very good hands on knowledge on Teradata SQL, BTEQ, Fastload, Multiload, TPUMP, TPT skill Complete understanding of Performance Tuning technique, working with SKEWNESS, SPACE MANAGING, LOCKING Understanding of Software Development Life Cycle (SDLC) & Data Warehousing Concepts Should have knowledge on Data Profiling activities Should have knowledge on Teradata Viewpoint portlets, alert mechanism etc With excellent analytical and problem-solving abilities, with quick adaptation to new technologies, methodologies, and system Good individual contributor as well as a team player with ability to build strong partner confidence Excellent communication skills and judgment, ability to manage multiple tasks, and work towards a deadline in a fast paced, aggressive development schedule Ability to work in any Shift (24x7) Tera Data, DWBi Concepts, Data Modeling, Development, SQL & analytics. Salary for this role is negotiable but will be in the range £45K to £60K. Please send your CV to us in Word format.

Rattaché à l'équipe administrateur de bases de données au sein de la DSI, vous intégrez une équipe de 15 DBAs dédiée à la mise en œuvre de projets de grande envergure. Au sein de l’équipe DBA de la DSI, vous participez à la conception, au développement et à l’exploitation d’une offre de services DBaaS sur Cloud Privé. Vous accompagnez l’industrialisation des moteurs de bases de données au travers de technologies cloud natives, notamment Kubernetes et ses opérateurs de données (CNPG, ECK, etc.), afin de fournir des plateformes de données automatisées, résilientes, sécurisées et exploitables à grande échelle. Vous intervenez sur l’ensemble du cycle de vie des services de données : déploiement, automatisation, supervision, sauvegarde, montée de version, gestion de la haute disponibilité et amélioration continue des plateformes. Couverture de l’équipe DBA : SGBD-R : PostgreSQL, MySQL, MariaDB, Oracle, MS Sql Server, SGBD-NoSQL : Elasticsearch, Opensearch, Cassandra, MongoDB, Redis Vous assurez aussi un rôle de conseil auprès des services ingénieries pour modéliser des projets et apportez de l'aide à la conception. Vos principales fonctions seront les suivantes : Définition, développement, administration et exploitation : - Opérateurs de bases de données Kubernetes - Service DBaaS (managé, infogéré) - Automatisation et industrialization - Supervision et observabilité - MCO – Activités récurrentes Plus en détails : - Définir les modèles de services, templates et catalogues DBaaS. - Suivre les évolutions des plateformes Kubernetes hébergeant les services de données. - Automatiser les opérations de provisionnement, sauvegarde, restauration, patching & Upgrade. - Contribuer à l'intégration des services de données dans l'écosystème Cloud Privé (CMP, API, GitOps, ArgoCD, Helm, Terraform). - Administrer les moteurs de bases de données dans des environnements Cloud Privé et Kubernetes. - Déployer, configurer, maintenir les opérateurs de bases de données. (CNPG …) - Concevoir et faire évoluer l'offre DBaaS en garantissant standardisation, automatisation et industrialisation des services. - Assurer le support de niveau 3 et l'expertise technique auprès des équipes DSI/BUs. - Définir, mettre en œuvre et maintenir les procédures d'exploitation et les standards d'administration des plateformes de données. (Procédures MCO + Prometheus / Grafana) - Garantir la disponibilité, la performance, la sécurité et la résilience des services de données. - Mettre en œuvre une architecture de haute disponibilité, de réplication et de reprise d'activité (PRA/PCA). - Définir et maintenir les stratégies de sauvegarde, de restauration et de point de restoration. - Valider et réaliser les opérations de patching, de montée de version et de migration des plateformes de données. - Participer à l'automatisation des déploiements et des opérations d'administration au travers d'Ansible, Git, CI/CD et des outils d'Infrastructure as Code. - Contribuer à la mise en œuvre des solutions d'observabilité, de supervision et d'alerting des services de données. - Participer aux projets de sécurité, d'audit, de gestion des accès et de conformité réglementaire. - Assurer une veille technologique continue sur les technologies Cloud Native, Kubernetes et les moteurs de bases de données. - Étudier, qualifier et homologuer les nouvelles versions, fonctionnalités et solutions techniques. Les livrables : Déploiement des moteurs de bases de données sur une infrastructure de type Cloud/DBaaS Fiches de service DBaaS, engagement. Standards d’architecture et de déploiement. Runbooks d’exploitation et d’incident. Procédures de sauvegarde et restauration. Tableaux de bord de supervision. Documents de sécurité et procédures d’habilitation. Rapports de performance et de capacité. Environnement technique: · BDD : ~4 000 serveurs physiques et virtuels · OS : Rhel, Ubuntu, Oracle Linux. · Gestion de configuration : git, ansible, terraform · Stockage : S3, Longhorn · Virtualisation : vmware, openstack · IaaS : openstack, outscale, ovh · Sauvegardes : S3/ Commvault, · Middleware : Morpheus, Kubernetes, podman

SQL Server Database Engineer with SSIS Our Client is bank based in Central London – who are looking to recruit Database Engineer with at least 5 to 7 years sold expertise of working SQL Server SSIS and SSRS. Responsible for the development and delivery of pipelines (collect, validate and prepare high quality data) to automate and streamline processes required by different departments. Support existing SSIS ETLs (overnight and intraday), proactively fine-tune and enhance existing codes to increase robustness and error monitoring. Support the internal IT department with changes and upgrades to software platforms. Convert legacy Hyperion reports to SSRS. Software Development: Analysis of issues pertaining to problems or errors raised by in-house systems, i.e. CORE, SharePoint interface, Equation end of day cycle. Understanding business requirements in order to develop and deliver appropriate solutions based on system definition documents. Proficiency in advanced 4GL programming languages and able to apply to the fully development life-cycle. Database Support To build data pipelines within the SQL environment in SSIS packages, where required, introduce new field and data types for new information to be collated in the CORE environment. To build tabular models (SSAS) for different business units. To build reports based on business requirements using SQL SSRS. To integrate with all the Bank’s sub-systems using data abstraction and connectivity layers, i.e. ODBC, ADO.net. Ensure that the environment is running optimally and with high standard house-keeping procedures. Sharepoint Integration: To integrate the SharePoint environment and Forms with Equation system to introduce automation of processes thereby eliminating the need for duplicate entry. To utilise web services to integrate from cutting edge technology into legacy systems such as Equation. End of Day Cycle: To provide second and third level support for in-house programmes during the end of day cycle. To be able to analyse and rectify any problems raised in an independent and team scenario. To take ownership of a problem and deliver a solution in a timely manner. Provide out of office hours support. Risk & Regulatory Duties Maintain knowledge of all applicable regulatory requirements including the Bank’s Risk and Compliance policies and procedures and adhere to these to avoid exposing the Bank to undue risk. Report policy/procedure breaches and areas of potential non-compliance and suspicions promptly upon identification in accordance with the Bank's Risk and Compliance policies. Accurately execute all controls within own area to minimise risk of policy, procedure, and/or regulatory breaches. Identify new risks/control gaps within own area and escalate accordingly to your Line Manager and/or Head of Department. Training & Competence Complete all annual mandatory regulatory refresher training as per the Bank's training plans and deadlines. Proactively seek to complete recommended technical and behavioural competencies training required for your role. Act in accordance with the FCA/PRA Code of Conduct. Fulfil all prescribed business continuity requirements as set out in the organisational or departmental specific plans or as instructed by the Line Manager/Head of Department. Qualifications/Experience Degree level qualified or equivalent. MS SQL stack (SSIS, SSAS, SSRS) to high level of proficiency - Essential C# Programming / JavaScript programming - Desirable Knowledge and Skills Software analysis and design good practice Dimensional modelling, Entity Relationship modelling, Normalised modelling. Data warehouse design concepts, (Inmon, Kimball) The position is based in Central and you will be required to be in the office for 3 days a week. Please note the Client does NOT provide sponsorship. The salary for this position is in the range £65K – £75K. Please do send your CV to us in Word format along with your salary and availability.

Database Engineer with SQL Server SSIS, SSRS and SSAS Our Client is a bank based in Central London who are looking to recruit a Database Engineer with the ability to work with SSIS. You must have solid expertise of at least 5 years experience of working with MS SQL Server and SSIS – SSIS is very important for this position. Responsible for the development and delivery of new systems to automate and streamline processes required by different departments. To support the internal IT department with changes and upgrades to software platforms. To be primary contact for all technical questions relating to in-house bespoke systems and interfacing. Database Support Supporting budgeting and financial planning processes for Finance department, including loading and refreshing of data based on requirements. Understand and conduct the front-end functionality to amend and change hierarchical structures within the environment. Debug and analyse errors and anomalies within Hyperion system as raised by Finance and to pinpoint areas of failure and correct any issues. Liaise with Finance on a daily basis to ensure smooth running of the Hyperion environment. Build data flows within the SQL environment in SSIS packages. Risk & Regulatory Duties Maintain knowledge of all applicable regulatory requirements including the Bank’s Risk and Compliance policies and procedures and adhere to these to avoid exposing the Bank to undue risk. Report policy/procedure breaches and areas of potential non-compliance and suspicions promptly upon identification in accordance with the Bank's Risk and Compliance policies. Accurately execute all controls within own area to minimise risk of policy, procedure, and/or regulatory breaches. Identify new risks/control gaps within own area and escalate accordingly to your Line Manager and/or Head of Department. Qualifications/Experience Degree level qualified or equivalent. SQL Programming. Knowledge and Skills Software analysis and design. SQL query language with SSIS SSRS and SSAS Data warehouse design concepts, (Inmon or Kimball) Must have solid experience of working with SSIS and building data warehouses and some knowledge of reporting using SSRS. The Client is a Bank based in the Central London. This is a 12 month FTC position with a salary of circa £55K - £70K. You will be required to be in the office at least 3 days week. Do send your CV to us in Word format along with your salary and availability.

Bonjour, Je suis à la recherche d’un Test Lead à Marseille : Missions principales : • Définir la stratégie de test pour chaque release (périmètre, environnements, planning, risques) • Piloter et coordonner l’ensemble des phases de tests (E2E, UAT, interfaces, data, performance, validation production) • Assurer le suivi quotidien de l’avancement des tests et garantir la couverture des scénarios pricing • Concevoir et revoir les cas de tests à partir des user stories avec une approche basée sur les risques • Garantir la traçabilité entre les exigences, les tests et les anomalies • Gérer le cycle de vie des défauts (qualification, priorisation, suivi, résolution) • Animer les sessions de triage et analyser les causes racines • Assurer la coordination entre les équipes métiers, IT, produit et data • Gérer les environnements de tests et la qualité des données • Produire les reportings (avancement, qualité, risques, KPI) et contribuer aux comités de pilotage • Accompagner le go-live (validation des critères de sortie, recommandations de mise en production) • Assurer le suivi en hypercare post go-live

Database Engineer with SQL Server SSIS, SSRS and C# .net asp.net Our Client is a bank based in Central London who are looking to recruit a Database Engineer with the ability to work with SSIS. You must have solid expertise of at least 5 years experience of working with MS SQL Server and SSIS – SSIS is very important for this position. Responsible for the development and delivery of new systems to automate and streamline processes required by different departments. To support the internal IT department with changes and upgrades to software platforms. To be primary contact for all technical questions relating to in-house bespoke systems and interfacing. Database Support Supporting budgeting and financial planning processes for Finance department, including loading and refreshing of data based on requirements. Understand and conduct the front-end functionality to amend and change hierarchical structures within the environment. Debug and analyse errors and anomalies within Hyperion system as raised by Finance and to pinpoint areas of failure and correct any issues. Liaise with Finance on a daily basis to ensure smooth running of the Hyperion environment. Build data flows within the SQL environment in SSIS packages. Risk & Regulatory Duties Maintain knowledge of all applicable regulatory requirements including the Bank’s Risk and Compliance policies and procedures and adhere to these to avoid exposing the Bank to undue risk. Report policy/procedure breaches and areas of potential non-compliance and suspicions promptly upon identification in accordance with the Bank's Risk and Compliance policies. Accurately execute all controls within own area to minimise risk of policy, procedure, and/or regulatory breaches. Identify new risks/control gaps within own area and escalate accordingly to your Line Manager and/or Head of Department. Qualifications/Experience Degree level qualified or equivalent. SQL Programming. Knowledge and Skills Software analysis and design. SQL query language with SSIS SSRS and SSAS Data warehouse design concepts, (Inmon or Kimball) Any experience of developing with C# .net and asp.net would be very useful Must have solid experience of working with SSIS and building data warehouses and some knowledge of reporting using SSRS. The Client is a Bank based in the Central London. This is a 12 month FTC position with a salary of circa £55K - £70K. You will be required to be in the office at least 3 days week. Do send your CV to us in Word format along with your salary and availability.

Dans le cadre de cette mission de 3 mois minimum, vous rejoignez une équipe passionnée d'une quinzaine de personnes afin de prendre en charge la gestion, l'optimisation et la sécurisation des architectures de données de notre client. En tant qu'expert de votre domaine, votre rôle consistera à garantir la haute disponibilité, l'intégrité et la performance globale des bases de données au quotidien. Vous interviendrez activement sur des phases stratégiques de build et de run, tout en apportant votre support technique aux équipes de développement. Ce poste offre l'opportunité de relever des défis techniques stimulants et de manipuler des technologies de pointe au sein d'infrastructures à forte valeur ajoutée.

Database Engineer with SQL Server Responsible for the development and delivery of new systems to automate and streamline processes required by different departments. To support the internal IT department with changes and upgrades to software platforms. To be primary contact for all technical questions relating to in-house bespoke systems and interfacing. Database Support Supporting budgeting and financial planning processes for Finance department, including loading and refreshing of data based on requirements. Understand and conduct the front-end functionality to amend and change hierarchical structures within the environment. Debug and analyse errors and anomalies within Hyperion system as raised by Finance and to pinpoint areas of failure and correct any issues. Liaise with Finance on a daily basis to ensure smooth running of the Hyperion environment. Build data flows within the SQL environment in SSIS packages. Risk & Regulatory Duties Maintain knowledge of all applicable regulatory requirements including the Bank’s Risk and Compliance policies and procedures and adhere to these to avoid exposing the Bank to undue risk. Report policy/procedure breaches and areas of potential non-compliance and suspicions promptly upon identification in accordance with the Bank's Risk and Compliance policies. Accurately execute all controls within own area to minimise risk of policy, procedure, and/or regulatory breaches. Identify new risks/control gaps within own area and escalate accordingly to your Line Manager and/or Head of Department. Qualifications/Experience Degree level qualified or equivalent. SQL Programming. Knowledge and Skills Software analysis and design. SQL query language. Data warehouse design concepts, (Inmon or Kimball) The Client is a Bank based in the City of London. This is a 2 year FTC position with a salary of circa £65K - £70K. Do send your CV to us in Word format along with your salary and availability.

DBA Oracle - SQL SERVER - Confirmé - Impératif AlloyDb - Junior - Souhaitable Connaissances linguistiques Anglais Professionnel (Impératif) Description détaillée : Administrer les bases de données de production de la plateforme client en lien étroit avec les productions applicatives. Communiquer avec sa hiérarchie pour le suivi des projets. Au quotidien, traiter les demandes de nos clients / gérer les incidents. Suivre le MCO des bases de données. Le poste est à Villeurbanne et comprend des astreintes et interventions en HNO. Le télétravail est possible. Administration Base de Données / Référentiel (DBA) - Régions - N4Définition du profil Gère et administre les infrastructures matérielles et/ou logicielles de l'entreprise, en assure la cohérence, la qualité et la sécurité Participe à la définition et à la mise en oeuvre de ces infrastructures retenues par les projets : Prend en charge le maintien en conditions opérationnelles des infrastructures matérielles et logicielles relatives à son périmètre Traite les incidents et problèmes pouvant survenir sur les plates-formes Fiabilise et optimise le fonctionnement des infrastructures en anticipant les évolutions de capacité et de performance Contribue à la mise en oeuvre des solutions de continuité et participe aux tests de résilience Documente les configurations et rédige les consignes destinées aux supports niveaux 1 et 2 Réalise les déploiements des infrastructures dans le cadre des projets techniques et métier Travaille en relation étroite et permanente avec les équipes Etudes et Infrastructures et Sécurité Contribue aux projets d'évolution des infrastructures sous responsabilité des équipes d'Infrastructures Effectue un support technique pour l'ensemble des infrastructures de son périmètre Crée, à la demande des domaines ou de l'exploitation, les outils spécifiques d'aide à l'exploitation Met en oeuvre les outils de surveillance Effectue un support technique de second niveau pour l'ensemble de son domaine

Database Engineer with SQL and C# Our Client is a City based bank – looking to recruit a Database Engineer with at least 3 to 5 years expertise of developing and supporting SQL and C#. Software Development: Analysis of issues pertaining to problems or errors raised by in-house systems, i.e. CORE, SharePoint interface, Equation end of day cycle. Understanding business requirements in order to develop and deliver appropriate solutions based on system definition documents. Proficiency in advanced 4GL programming languages and able to apply to the fully development life-cycle. Database Support Supporting budgeting and financial planning processes for Finance department, including loading and refreshing of data based on requirements. Understand and conduct the front-end functionality to amend and change hierarchical structures within the environment. Debug and analyse errors and anomalies within Hyperion system as raised by Finance and to pinpoint areas of failure and correct any issues. Liaise with Finance on a daily basis to ensure smooth running of the Hyperion environment. Build data flows within the SQL environment in SSIS packages. Introduce new field and data types for new information to be collated in the CORE environment. To integrate with all the Bank’s sub-systems using data abstraction and connectivity layers, i.e. ODBC, ADO.net. Build reports based on business requirements using Hyperion Interactive Reports. Ensure that the environment is running optimally and to utilise house-keeping procedures. Sharepoint Integration: Integrate the SharePoint environment and Forms with Equation system to introduce automation of processes thereby eliminating the need for duplicate entry. Utilise web services to integrate from cutting edge technology into legacy systems such as Equation. End of Day Cycle: Provide second and third level support for in-house programmes during the end of day cycle. Able to analyse and rectify any problems raised in an independent and team scenario. Take ownership of a problem and deliver a solution in a timely manner. Provide out of office hours support. Risk & Regulatory Duties Maintain knowledge of all applicable regulatory requirements including the Bank’s Risk and Compliance policies and procedures and adhere to these to avoid exposing the Bank to undue risk. Report policy/procedure breaches and areas of potential non-compliance and suspicions promptly upon identification in accordance with the Bank's Risk and Compliance policies. Accurately execute all controls within own area to minimise risk of policy, procedure, and/or regulatory breaches. Identify new risks/control gaps within own area and escalate accordingly to your Line Manager and/or Head of Department. Training & Competence Complete all annual mandatory regulatory refresher training as per the Bank's training plans and deadlines. Proactively seek to complete recommended technical and behavioural competencies training required for your role. Conduct Act in accordance with the FCA/PRA Code of Conduct. Business Continuity Fulfil all prescribed business continuity requirements as set out in the organisational or departmental specific plans or as instructed by the Line Manager/Head of Department. Qualifications/Experience Degree level qualified or equivalent. SQL Programming. C# Software development. Knowledge and Skills C# Programming to high level of proficiency. Software analysis and design. SQL query language. Dimensional modelling Data warehouse design concepts, (Inmon or Kimball) This is a Full-Time Contract initially for 6 months – but likely to become permanent. Salary for this position will be £55K - £60K per annum. The Client is based in the City of London. Please do send your CV to us in Word format along with your salary and availability.

MS SQL Server DBA Database Administrator – Investment Bank – Canary Wharf - London Our Client is an International Bank with offices in Canary Wharf London. They are now looking to recruit a Senior MS SQL Server DBA with at least 5 years expertise. Although the role is for a Senior MS SQL Server DBA – the Client would like you to have a background in Data Warehousing. As MS SQL Server DBA with Application Support you will be involved with developing and implementing solutions for the banks financial systems. As an MS SQL Server DBA role will involve the following: Ensure the integrity, security and accuracy of production database environment, ensuring good performance of the dependent applications. Plan and implement operating procedures for backup of database and recovery of database information. Develops database-related application development standards covering database creation, software placement, storage and auditing. Ensures the integrity of the recovery system at all times. Initiates formal testing of the recovery system. Develops database procedures as necessary to enhance the application suite as required. Responds to, resolves and documents support calls for the production and test applications. Maintains to a high standard documentation supporting the build, maintenance and operational procedures of the database environment. Acts as the technical liaison between database operations and vendor support. Performs other related duties as assigned. You must have at least 5 to 7 years solid expertise as a MS SQL Server DBA – Database Administrator. Must have the Microsoft SQL Server Administration (Enterprise Edition) experience. High Level T-SQL programming (SP, Functions, Triggers). Operation, design and implementation experience of Mirroring, Log Shipping and SQL Server Replication. SQL Reporting services and Analysis services maintenance and tuning. Configuration and operation of clustered database Servers using external storage. Scripting stored procedures. Security concepts of database management. Change management concepts and application The role will be to work as a MS SQL DBA with an element of supporting financial applications. Salary for this role is negotiable - but is expected to be in the range £55K - £70K + benefits. Please send your CV’s to us in MS Word format.

Nous recherchons avant tout Un véritable DBA de Production, capable d'administrer des bases SQL Server critiques constituant le cœur de la plateforme e-commerce, tout en étant un DBA d'Étude capable d'accompagner les équipes de développement en amont des projets. Le candidat devra être en mesure de : - Challenger les choix de modélisation et les développements SQL, - Valider les impacts techniques des évolutions, - Participer aux revues de code (Pull Requests), - Anticiper les problématiques de performance avant la mise en production, - Accompagner la transformation de la plateforme vers PostgreSQL, Couchbase et les services Cloud. Cette double compétence Production + Étude est indispensable pour garantir à la fois la stabilité de la plateforme actuelle et réussir notre modernisation. 1). ETUDE : CONCEPTION Assure un rôle de responsable des choix techniques du modèle et de la conception des objets de la BDD S'assure au sein des projets du respect des normes, méthodes et processus d'industrialisation Contribue aux chiffrages des développements BDD à réaliser Contribue à la conception technique (MCD, MPD*) de la solution à mettre en œuvre dans le respect des choix techniques en lien avec les autres intervenants du projet Peut participer à la réalisation des scripts de création des modèles physiques EXPLOITATION Participe à la définition des process d'exploitation spécifiques aux BDD : méthode de sauvegarde, process de maintenance, etc. en vue de leur spécification dans les dossiers d'exploitation Assure en collaboration avec les équipes projet & développement la définition des paramètres de la BDD pour une utilisation optimale SUPPORT Est référent sur la conception et l'implémentation des BDD, du modèle à la construction et à l'optimisation des requêtes associées en lien avec les Développeurs et Tech Lead Assiste les utilisateurs des équipes projets au travers de formations et de conseil sur l'utilisation des BDD Effectue le support technique des équipes de développement de niveau 2 de l'ensemble des BDD Peut assurer un rôle de correspondant entre les directions sur les aspects BDD ÉTUDES ET CONTRÔLES Assure une veille technologique sur les Systèmes de Gestion de BDD (SGBD) Définit les normes et standards d'utilisation et d'exploitation des SGBD pour les équipes de développement Contrôle l'implémentation des normes pour les applications développées en interne : validation des clés primaires, secondaires et des index Audite les applications développées par des tiers 2). PRODUCTION : ADMINISTRATION Effectue le choix d'implémentation des bases de données (BDD) Crée les bases en liaison avec l'administrateur système et les chefs de projets Met en œuvre les logiciels de gestion de BDD et effectue l'adaptation, l'administration et la maintenance de ces logiciels EXPLOITATION Assure l'intégrité des BDD existantes en garantissant la sécurité physique (procédures de sauvegarde, restauration, journalisation, démarrage après incidents?) et logique (confidentialité, accès) sur les environnements anté-préproduction Met en œuvre les outils de surveillance Règle les paramètres des BDD pour une utilisation optimale Participe aux analyses sur la gestion des espaces de stockage : Capacity planning, Tablespaces et partitionnements SUPPORT Supporte les développeurs et Tech lead sur les problématiques liées aux BDD Assiste les utilisateurs (formation, requêtes techniques?) Effectue le support technique de niveau 2 de l'ensemble des BDD Possède un rôle de correspondant technique entre les chefs de projets et le support technique des éditeurs ÉTUDES ET CONTRÔLES Assure une veille technologique sur les SGBD et les progiciels Suit et contrôle les évolutions de version des bases existantes et progiciels Teste, valide, pour les aspects techniques, tous les logiciels et progiciels Définit les normes et standards d'utilisation et d'exploitation des SGBD* Contrôle l'implémentation des normes pour les applications développées en interne : validation des clés primaires, secondaires et des index Audite les applications développées par des tiers Veille à la sécurité d'accès aux données : définit ou implémente l'accès aux données en autorisant des profils de connexion (gestion des privilèges)