Trouvez votre prochaine offre d’emploi ou de mission freelance SQL

Nous recherchons un DBA SQL Server pour rejoindre une entreprise spécialisée dans les solutions de confiance numérique et de gestion documentaire. Dans un contexte de forte croissance, vous interviendrez sur une plateforme stratégique qui devra absorber une montée en charge importante liée à la réforme de la facturation électronique. Vos missions : Au sein de l'équipe technique, vous serez en charge de : Optimiser les performances des bases de données SQL Server. Assurer la disponibilité, la supervision et le bon fonctionnement des environnements de production. Renforcer la sécurité des bases de données. Identifier et résoudre les problématiques de performance. Mettre en place les bonnes pratiques d'administration et de maintenance. Accompagner les équipes dans les évolutions de l'infrastructure de données. Participer, à terme, aux réflexions autour d'une migration de SQL Server vers PostgreSQL. Vous travaillerez en étroite collaboration avec une équipe SysOps composée de trois personnes ainsi qu'avec un DBA PostgreSQL, qui pourront vous accompagner sur les sujets d'infrastructure et d'évolution de la plateforme. Pourquoi rejoindre cette mission ? Participation à un projet stratégique lié à la réforme de la facturation électronique. Plateforme amenée à accueillir plus de 100 000 clients. Environnement technique moderne avec des projets d'évolution (Kubernetes, PostgreSQL). Une équipe technique expérimentée composée notamment de 3 SysOps et d'un DBA PostgreSQL. Des sujets à forts enjeux de performance, de disponibilité et d'évolutivité. Informations complémentaires Localisation : Paris Télétravail : 2 jours par semaine, avec 3 jours de présence sur site Type de mission : Freelance Durée : 3 mois minimum Démarrage : ASAP

Role Title: SQL - Oracle Database Administrator Location: Manchester / Barrow - 3 days onsite/week Duration: 6 initial months contract Rate INSIDE IR35 MARKET RATE SC Cleared Role Description: * Focusing on scalability, integrity, performance, availability, security, monitoring and troubleshooting of core DB clusters * Owning core database clusters in Production as well as on a wide range of technologies * Reporting into the Operations Manager and working alongside the Senior DBA * Oracle schema object sizing. * Monitor data block organisation. * Monitor physical storage and contention. * Monitor tablespace utilization * Memory usage. * Physical I/O tuning. * Lock monitoring. * Database resource utilization. * Alert log, Backup status * Database free space. * Performance tuning ratios * Check Invalid objects * Monitor build-up of trace files. * Monitor growth of alert logs. * Purge log and trace files, which are no longer required. * Database Monitoring * Cache (Buffer Cache, Library Cache, Dictionary Cache) hit/miss ratios * Point in time database recovery, using on-line redo logs. * Provide advice during database restoration following a crash or media failure. * Monitor Archive log retention period for database recoverability and highlight issues / limitations. * Ensure database changes are reflected into the backup strategy. Your skills and experience: * Shared pool usage * Customized DBMS_JOBS running * Logical I/O on the database * SAR on the database server * Locks on the database * Sessions and session queries * Monitor database availability issues * Monitor on-line and archived log file usage * Monitor roll-back segment usage * EARS call handling for Oracle DBA team * Change handling for Oracle DBA team * Participate in implementation planning * Export & Import data between production and test instances as required Please share your latest CV LA International is an award-winning partner of choice for many of the world's most influential companies and government organisations. Holding Enhanced Government Security Accreditation, we are recognised as the European market leader in the delivery of Security Cleared talent to organisations that demand the very highest levels of security, compliance and assurance. A multiple award-winning organisation, having secured the prestigious Queens Award for Enterprise: International Trade over consecutive years. We are committed to fostering an inclusive, equitable and accessible workplace where everyone feels valued and supported. We welcome applications from all individuals, regardless of background or identity, and we encourage candidates who may not meet every listed requirement to still apply. If you require any adjustments or support during the recruitment process, please let us know and we will work with you to ensure a fair and accessible experience. Please Note: If a high volume of applications is received, only candidates shortlisted will be contacted.

Nous recherchons un DBA SQL Server 2 jours/semaine sur site et 3 jour en télétravail Description: Compétences attendues : - DBA SQL en environnement PLM - Connaissance ITIL - Maîtrise des environnements MS SQL inclus clustering et idéalement Oracle, Postgre SQL, MySQL. - connaissance Système LINUX et WINDOWS - capacité à proposer des solutions Tâches : - traitement des incidents / changes - suivi des incidents et des changes - respect des SLA -participation aux projets sur sollicitation Techno : - MS SQL 2008 to 2022 - Oracle - Postgre SQL - MySQL - DB2 (optionnel) - MS SQL Server,PostgreSQL,

PROPULSE IT recherche un DBA pour une mission chez un de ses clients dans le cadre de la ré-internatlisation de l'exploitation de 500 bases de données SQL Server Sous la responsabilité du responsable de service et le support d'un référent interne expert le candidat aura en charge la gestion des activités suivantes : - Appropriation du contexte technique assuré par l'infogérant (transfert de connaissance), et documentation de ce dernier (dossiers d'exploitation) - Accompagnement à la préparation de la reprise d'exploitation en interne (outillage de monitoring et de supervision (OEM, Centreon), élaboration et documentation des process de gestion des incidents et des changement, d'escalade, d'organisation, du catalogue de service) - Participation aux activité de réversibilité d'exploitation des bases de données avec l'infogérent (phase Shadow et reverse shadow) A l'issue de la réversibilité, il aura en charge la gestion globale d'exploitation du périmètre des bases de données - Gestion des incidents et des changements - Maintien en Condition opérationnelles et de Sécurité (Patching) - Contribution à la mise à jour et au maintien du catalogue des services Base de Données - Reporting et du suivi d'activité global de son périmètre - Respect des normes et exigences de sécurité des systèmes d'informations - Respect des process - Réalisation et mise à jour des documentations d'exploitation En complément, il participera à l'accompagnement technique d'intégration des bases de données pour les projets (BUILD) - Définition d'architecture des bases de données pour les projet applicatifs (accompagnement des architectes sur les spécifications et exigences techniques de dimensionnement, disponibilité, et de performance - Accompagnement à l'intégration des bases de données des solutions applicatives - Elaboration des référentiels techniques de bases de données (Dossier d'architecture technique détaillés, Dossier de mise en exploitation)

Dans le cadre du renforcement d'une équipe en charge des infrastructures de bases de données d'un grand groupe, nous recherchons un DBA SQL Server expérimenté. Vous interviendrez sur des environnements critiques afin d'assurer l'administration, la disponibilité, les performances et la sécurité des bases SQL Server supportant des applications à forts enjeux métier. Vos missions porteront sur l'administration des environnements SQL Server Standalone et Haute Disponibilité, les migrations de bases de données, la qualification des nouvelles versions, le maintien et l'évolution des automatisations Ansible, l'accompagnement des équipes projets et RUN, le traitement des problématiques de sécurité, la participation aux cellules de crise ainsi que la rédaction de la documentation technique. Vous contribuerez également à l'amélioration continue des plateformes et aux échanges avec l'éditeur lorsque cela sera nécessaire. Compétences techniquesBases de donnéesMicrosoft SQL Server SQL Server Standalone SQL Server Haute Disponibilité SystèmeWindows AutomatisationAnsible Red Hat Ansible Automation Platform (AAP) OutilsGitLab Grafana ActivitésAdministration SQL Server Migration de bases de données Optimisation des performances Sécurisation des environnements Documentation technique Support RUN Gestion des incidents Qualification de nouvelles versions LanguesAnglais opérationnel

Nous recherchons un(e) DBA PRODUCTION RUN (80%) BUILD (20%) afin d'administrer les bases de données Postgré et SQL Server En environnement de production 24/7 => astreintes (et HNO si besoin) Les livrables sont des Documents d'exploitation et des comptes rendus d'intervention Français Courant (Impératif) Anglais Professionnel (Secondaire) Description détaillée : Assurer le maintien en conditions opérationnelles des environnements portant les bases de données, avec périodes d'astreintes et interventions en HNO le cas échéant. Exploitation récurrente et proactive. Administration des environnements (Bases, supervision, sauvegardes, évolution). Optimisation et tuning. Traiter (N2 et N3) les incidents de Production. Réaliser les demandes de services et de changements. Réaliser le support aux équipes Projets et Intégration (participation aux transferts en production, mise à disposition des données aux plate-formes Hors Prod). Valider la documentation technique du domaine. Produire des documents techniques et les fiches de consignes nécessaires au pilotage. Etudier, proposer et prendre en charge la mise en œuvre des évolutions des environnements (migration, upgrade, nouveaux environnements). Date de démarrage 01/08/2023 Date de fin 30/06/2024 Paris 14 Nombre de jour souhaitable sur site 3 jours par semaine

MI Analyst with MS SQL Server - City London Our Client is an international bank with offices in the City London. They are looking to recruit an MI Analyst with at least 5 years experience of MS SQL Server, SSIS, SSRS, and Sharepoint. The main elements of the role are follows: - Work within MI team in supporting and delivering all aspects of MI - BAU encompassing data warehouse back end maintenance and Housekeeping - Support annual Disaster Recovery invoking/testing - Contribute to design, build and implementation of new reports and applications/interfaces. - Facilitate internal/external Audits and Penetration Testing. Remediation General Skills -Experience working within mission-critical environments -Experience in operational deployments -Maintains required industry recognised skills through training and self-study methods Technical Skills -In-depth knowledge of MS SQL -In-depth knowledge of SDLC -C# Development (advantageous) Technologies SQL - TSQL, SSIS and SSRS. SQL - DBA. SharePoint & InfoPath. Hyperion (Oracle EPM). C# Any experience of process automation and Equation/iSeries DB knowledge. SWIFT. AIX would be very handy. Good interpersonal skills Thorough and reliable Technically competent Ability to work unsupervised This is 6 month full-time permanent role. The salary will be £45K - £50K pro-rata. It is intended that you will work 2 days from the office and 3 days remotely from home for the foreseeable future. Do send your CV to us in Word format along with your salary and availability.

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.

Expert MS SQL Server afin d'accompagner les équipes sur des problématiques d'architecture, de modernisation et de gouvernance des environnements de données. Vous interviendrez au sein d'un écosystème complexe et aurez un rôle central de conseil et d'expertise sur les technologies Microsoft SQL Server. Vos principales missions seront les suivantes : Apporter une expertise technique sur les environnements SQL Server / MSSQL. Participer aux travaux d'architecture et d'urbanisation des données. Garantir la sécurité des accès et la conformité avec les normes de l'entreprise. Réaliser les analyses d'obsolescence et préparer les stratégies de montée de version. Contribuer aux projets de migration SQL Server. Accompagner les équipes techniques et diffuser les bonnes pratiques. Produire et maintenir la documentation technique associée. Rédiger les normes, dossiers de choix et documents d'architecture. Être force de proposition sur les solutions techniques adaptées aux enjeux de l'environnement. Enrichir la base documentaire et participer à l'amélioration continue des référentiels techniques.

Notre client lance un programme stratégique de modernisation de son application bancaire cœur de métier (Core Banking – LCB), à la suite de plusieurs audits techniques menés en 2025 et 2026. Les principaux enjeux identifiés sont : Performance des bases SQL Server Scalabilité de la plateforme Maintenabilité des développements Gouvernance des données Résilience opérationnelle Pérennité de l'architecture L'objectif est de mener les plans de remédiation tout en accompagnant les équipes de développement vers les bonnes pratiques SQL Server. Missions principales1. Performance et optimisationAnalyse des rapports d'audit et priorisation des actions Optimisation des requêtes T-SQL Analyse des plans d'exécution Refonte de la stratégie d'indexation Diagnostic des problèmes CPU, mémoire et I/O Analyse et résolution des : Locking Blocking Deadlocks Recherche des causes racines des incidents de performance 2. Modernisation SQL ServerParticipation aux montées de version SQL Server Modernisation de l'architecture des bases Amélioration de la haute disponibilité et de la résilience Mise en place de stratégies d'archivage 3. Architecture et gouvernanceRevues d'architecture et de modélisation Optimisation de la consommation des ressources Renforcement de l'observabilité et du monitoring Définition des bonnes pratiques SQL 4. Accompagnement des équipesCoaching des développeurs Diffusion des bonnes pratiques SQL Server Transfert de compétences Coordination avec les équipes de développement et production Définition des priorités techniques

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 £60K – £75K. Please do send your CV to us in Word format along with your salary and availability.

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.