Find your next tech and IT Job or contract Transact-SQL

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.

Vos missions ? En tant que consultant support applicatif vous serez en charge des missions suivantes: - Diagnostiquer et résoudre les incidents applicatifs escaladés par le support N1. - Analyser les causes récurrentes et proposer des solutions correctives ou préventives. - Suivre et documenter les tickets dans l'outil ITSM (Jira, ServiceNow, GLPI…). - Réaliser les opérations de maintenance applicative et les mises en production mineures. - Escalader les incidents complexes au support N3 ou aux équipes de développement. - Rédiger et mettre à jour la documentation technique et les procédures de résolution. - Accompagner les utilisateurs et assurer une communication claire lors des incidents. - Participer aux tests fonctionnels après correctifs ou évolutions. La stack Technique : SQL

Développeur Python / PL/SQL & IAContexte Au sein d'une équipe applicative Data, nous recherchons un développeur disposant d'un solide socle Python et PL/SQL, avec une compétence/appétence forte pour l'IA. L'objectif est de contribuer au développement et à la maintenance des applications existantes, tout en intégrant progressivement des cas d'usage IA avec les outils disponibles dans l'entreprise. Missions Développement et maintenance de services en Python et PL/SQL. Développement et automatisation avec Robot Framework. Traitement de tickets et problématiques métier à l'aide des services existants. Participation à la mise en œuvre de solutions et cas d'usage IA. Identification des sujets sur lesquels l'IA peut apporter de la valeur. Échanges avec les métiers et compréhension de leurs problématiques. Accompagnement et montée en compétences de l'équipe sur l'IA. Compétences indispensables : Python, PL/SQL, SQL, développement de services/applications, bonnes capacités d'analyse et compréhension des problématiques métier. Compétences complémentaires : IA / GenAI, Robot Framework, API/services, environnement Data. Qualités recherchées : autonomie, curiosité, capacité d'analyse, pragmatisme, bon relationnel et surtout capacité à transmettre ses connaissances à l'équipe.

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.

Dans le cadre d'un projet Data, nous recherchons un Data Analyst confirmé pour intervenir sur des problématiques d'analyse et de valorisation de données dans un environnement technique exigeant. Vos missionsAnalyser et exploiter des données issues de différentes sources. Concevoir et faire évoluer des traitements et workflows sur Dataiku. Réaliser des requêtes et analyses complexes en SQL. Manipuler et exploiter des données sur Teradata. Contrôler la qualité, la cohérence et la fiabilité des données. Produire des analyses et indicateurs permettant d'accompagner les besoins métier. Participer à la documentation et à l'amélioration des processus Data. Profil recherché4 ans d'expérience minimum en tant que Data Analyst. Maîtrise de Dataiku DSS. Très bonne maîtrise de SQL. Expérience significative sur Teradata. Bonne compréhension des problématiques de qualité et d'exploitation des données. Capacité à analyser des données complexes et à travailler avec différents interlocuteurs. Environnement technique : Dataiku, SQL, Teradata, Data Analysis.

Data Engineer (Python / SQL) Oxford - site based £Competitive Junior to Mid Level Data Engineer Salary + Great Benefits Package Excellent opportunity for a Data Engineer looking to join a highly successful, global organisation where you will play a key role in developing the data infrastructure and systems used to drive business improvement and operational performance. This company is a world-renowned organisation operating at the forefront of advanced engineering and technology. They offer an excellent working environment, exposure to complex technical projects and the opportunity to develop your career within a large, highly respected business. In this varied role, you will design, build and maintain data solutions that create a reliable Single Source of Truth across the business. You will work with Python, SQL and modern data architecture principles to integrate multiple data sources, improve data quality and ensure information is readily available for analytics and reporting. Alongside the core data engineering work, you will develop automated workflows, applications and dashboards, working closely with analysts and wider business teams to translate operational requirements into effective technical solutions. You will also help establish and maintain data architecture standards across the organisation. The ideal candidate will have experience in Data Engineering or a similar position, with strong Python and SQL skills and experience building and maintaining databases and data pipelines. Any experience with SQLAlchemy, data modelling, workflow automation, dashboards or platforms such as Skywise would be advantageous. This is a fantastic opportunity for a Data Engineer to join a prestigious global organisation in a technically varied position where you can have a genuine impact on how data is structured, automated and used across the business. The Role: Build and maintain a robust Single Source of Truth across multiple business applications Develop and optimise data pipelines, workflows and integrations Use Python, SQL and SQLAlchemy for data processing, modelling and database interaction Develop automated workflows, applications and dashboards Ensure data quality, integrity and availability for analytics and reporting Work with analysts and wider business teams to translate requirements into technical solutions The Person: Data Engineer or similar data-focused background Strong Python and SQL skills Experience with databases, data modelling and data pipelines Understanding of modern data architecture principles Experience with automation, workflows or dashboard development beneficial Skywise or Google AppSheet experience advantageous Rise Technical Recruitment Ltd acts an employment agency for permanent roles and an employment business for temporary roles. The salary advertised is the bracket available for this position. The actual salary paid will be dependent on your level of experience, qualifications and skill set and will be decided by our client, the employer. Rise are not responsible or liable for any hiring decisions made by the end client. We are an equal opportunities company and welcome applications from all suitable candidates.

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)

Je suis à la recherche pour un de nos clients d'un Développeur PHP MS SQL. Contexte technique : · Framework PHP MVC propriétaire · Base de données MariaDB · HTML 5, javascript · GIT · JIRA Approche méthodologie Agile. Développement, tests unitaires et tests d'intégration. Maintenance évolutive et corrective · Framework PHP 8 MVC propriétaire · Base de données MariaDB · HTML 5, javascript · GIT · JIRA · Framework PHP 8 MVC propriétaire · Base de données MariaDB · HTML 5, javascript · GIT · JIRA

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.

Pour l'un de nos clients nous recherchons actuellement plusieurs DBA SQL SERVER TRANSVERSES ETUDE ET PRODUCTION Missions proposée : - Intégration dans une équipe Franco-Vietnamienne transverse de DBA et développeurs SQL - Accompagnement et échanges permanent avec une équipe de DBA N3 - Travail en autonomie en mode projet (optimisation, développement de fonctionnalités et mise en place de reporting) - Travail en équipe afin d'échanger sur différentes problématiques - Analyse en live ou post mortem d'incident, préconisations préventives et correctives pour le futur - Audit de bases de données et rédaction de rapport d'audit - Accompagnement et coopération avec différentes équipes : Développement .Net, EDI, SAN, réseaux, système,… - Veille technologique

About the Job C# Dot Net - .net Developer – Brighton Our Client is looking to recruit a Junior C# .net Software Developer with SQL skills. The Client develops software for the banking and life and pensions industry. You will be involved in helping their clients and team visualise and interact with the company's It team and the banking systems software. This is a full time position where our Client is seeking someone with at least 3 to 5 years' experience with C# Dot Net with MS SQL Server software development. You will be involved in developing a reporting tool for clients to be able to login to and turn a query into a visual and interactive representation of the results. The role will include: C# Dot Net development. Support and developing banking software in C# .net with MS SQL or PL SQL. Processes work with the consulting and management teams to understand what they want to achieve and advise them regarding a stepped approach to achieving this goal. Support the development of new products to improve internal efficiency and to better service client needs Introduce and implement new IT software and architecture. Key skills required: · C# Dot Net with SQL · R (Preference) The role will be based in Brighton. This is a 6 month contract. Please send your CV to -hidden email- in MS Word format, along with your salary expectations.

MicroStrategy Developer with SQL Server – Victoria London We require an experienced Micro strategy Developer with Microsoft SQL Server BI with SSIS and if possible with experience of Tableau. The following is a list of skills that we require: Micro Strategy v10.4 Architect Web Visual Insight Report Services Distribution Services Mobile (inc. setup) Previous experience in software upgrades SQL Server Very strong T-SQL DB versions 2005 – 2014 Experience with query performance enhancements (e.g. indexing) Stored Procedures Very strong SSIS experience Nice to have SSAS and MDX experience Tableau The Client would ideally like to see recent development experience of developing with Tableau. The Client is based in Victoria London. Please send your CV to us in Word format along with daily rate and availability.

About the Job C# Dot Net Developer with Classic ASP – Waterloo London We are looking to recruit a C# Dot Net Developer for a Client based at Waterloo London. You must have at least 1 to 3 years experience of software development with the following: Classic-ASP T-SQL jQuery HTML & CSS You will have .NET or MVC experience almost certainly could work in classic-ASP. In addition you must have experience of MS SQL Server. The Client produces surveys which are all managed in-house using their own survey programming framework written in classic-ASP. The framework enables the team to create a new survey very quickly and efficiently, with a high degree of customisation and advanced features, (including in other languages) and publish real-time results via an online reporting platform. Salary will depend on level of experience - £25-£30K for a junior developer and up to £40K with at least 5 years experience. Please send your CV to -hidden email- in Word format, along with your salary expectations and availability.

Software Engineer with C# and MS SQL Server Our Client is a global company based out of Trumbull CT USA. They are looking to recruit a Senior C# Developer with MS SQL Server with at least 5 to 10 years solid expertise. Must have a bachelor's degree in computer science, software engineering, or a related field. A minimum of four (4) years of progressively complex experience in a directly related area, during which both professional and technical capabilities have been clearly demonstrated. A minimum of four (4) years of design and development experience with various relevant Microsoft platforms, tools, technologies, patterns, and techniques related to Azure tools, integration, and data is required. Experience with industry/domains like pharmaceutical, finance, HR, sales, marketing, and manufacturing is highly preferred. Experience with healthcare industry regulations, data security and compliance standards (e.g. GDPR), and EDI standards (e.g. FHIR, HL7), etc. is very valuable. Developer certifications of Azure and/or Microsoft suite technologies is a big plus. Program, configure, and production support functionalities like APIs, Systems & Data integrations, MSFT suite integration, Device integration programming, ETL processes, deployment scripts, etc. Diagnose and resolve reported defects/incidents in applications. Understand and translate business requirements to technical specifications, and able to reverse engineer the code into logical documentation/specifications. Identify bottlenecks, problems, and improvement opportunities and focus on process and performance improvements. Understand, create, and maintain documents, templates, data mapping, transformation requirements, test plans, and other technical documentation. Conduct or coordinate testing to ensure that developed components are consistent with defined functional and technical needs. Execute required steps of the project life cycle, change management, and reporting processes. Collaborate and communicate with business application teams, business champions, and system analysts, Infra/Sec/Ops teams, project managers, or others to responsibly complete the projects and support tasks end-to-end. Stay abreast of technology and industry trends by the means of constant learning. Other relevant tasks as assigned by the manager. Technical skills: In-depth knowledge and thorough experience in programming, configuring, and/or integrating using/with Azure integration tools like Data factory, LogicApps, Functions, API Management, Data catalog, WebApps, Integration service environment, configuring monitoring & diagnostics, etc., and connectivity & security configurations (certificates, encryptions, etc.). In-depth knowledge and experience with Azure data storage (SQL Server, Data lake, Synapse, etc.) & access tools, APIs, cloud connectivity, and ETL processes. Knowledge and some experience of MS Office/MS Office 365 suite, SharePoint Online, Power Apps, GitHub, MS Teams, etc. In-depth knowledge & experience using Visual Studio, with one of the programming languages: C#/Java/JavaScript/Python, and PowerShell. In-depth knowledge and thorough experience of using Serverless, SOAP, XML, REST, JSON, EDI, XSLT, Async/Sync, Request/Response, Service Bus, Publish/Subscribe, Batch/Real-time, Scheduling, Event triggers, etc. In-depth knowledge and development experience using MS SQL Server (SSIS, T-SQL, Stored procedures, Functions, Views, Queries, Datatype conversions, etc.). Thorough understanding of the fundamental architecture of the cloud and on-prem MSFT Suite (e.g. Share point) and Integration platforms architecture (e.g. BizTalk, MuleSoft, or similar), etc., and version control methods. Solid fundamentals and thorough understanding of exception handling principles and production/operational support solutions (alerts, dashboards, runbooks, etc.) Experience working with Azure DevOps and CI/CD pipeline. Experience working with APIs, Postman/SOAPUI tools, MS D365, ServiceNow, Azure Analytics tools, Azure Data lake, Azure Synapse, Azure BYOD & Data verse, Informatica, BI tools, etc. is a big plus. General business skills: Clear communication to translate and explain business requirements to technology & vice-versa. Analytical & methodical mindset with a problem-solving attitude is extremely important for the success of this role. Concise written, verbal, and presentation skills. Must be a team player who can earn a team's respect quickly. Ability to take initiative and be innovative. Ability to complete projects and achieve results in an ambiguous work environment. The Software Engineer will be part of an Integration team that is accountable for technical deliveries of integration projects and system enhancements, and production support services. The candidate is expected to work closely with applications, analytics, infrastructure, security, and compliance, PMO, QA, and system analysis teams. The candidate must be a strong analytical problem solver and creative thinker with the ability to ask the right questions and develop a point of view that will influence technical decisions. The successful candidate will be a disciplined self-starter and will deliver quality solutions to our global business. Team-play and visibility through routine and precise reporting and following of methods and processes is a major aspect of the work and can be a major success factor. The role will be based in Trumbull, Connecticut USA. The salary for this role will be in the range $80K - $120K. Please do send your CV to us in Word format along with salary and availability.

Dans le cadre de la modernisation d'applications critiques dédiées à la gestion et à l'optimisation d'un portefeuille énergétique européen, nous recherchons un Développeur .NET / SQL / Azure confirmé H.F pour rejoindre une équipe en charge d'applications stratégiques à forts enjeux opérationnels et financiers. Vous interviendrez notamment sur la transformation et la migration d'une plateforme historique vers Azure, tout en participant aux évolutions fonctionnelles, à la maintenance et à l'amélioration continue des systèmes existants. Vos missions : Analyser les besoins métiers et participer à la définition des solutions techniques Concevoir et développer les évolutions des applications Participer à la modernisation des composants existants et à la migration vers Azure Développer et maintenir des services WCF, API Web et applications .NET Optimiser les performances applicatives et les traitements SQL Server Rédiger les spécifications techniques et la documentation associée Participer aux phases de tests, recette et mise en production Assurer la maintenance corrective et évolutive des applications Travailler en collaboration avec les équipes fonctionnelles et techniques dans un environnement Agile