Jobs
>
Bristol

    Lead SQL Developer - Bristol, United Kingdom - Leonardo

    Default job background
    Full time
    Description

    Job Description:

    We are looking to recruit a Principal SQL Developer to work on the support of a truly unique capability, NAS. NAS is understood to be the largest number plate recognition database in the world supporting UK Policing and Law Enforcement in the detection and prevention of serious crime. The system processes over 50 million vehicle movements per day and holds a dataset of up to 60 billion records in what has been described to us as the largest Microsoft SQL Server instance in the UK.

    We are looking for a forward thinking individual with strong SQL capabilities. In return, we offer our , having wonthe Best Flexible Working Policy Award, Best Flexible Benefits Strategy and Best Flexible Benefits Plan in 2023.

  • Performance Tuning : Analyse and optimise SQL Server Databases for performance efficiency. This includes tuning complex queries, indexes, and server configurations.
  • Troubleshooting : Identify and resolve database performance issues. Provide solutions for query optimisation and server tuning.
  • Best Practice Implementation : Develop and implement best practices for database design, tuning, and maintenance.
  • Collaboration : Work closes with customer and development teams to optimise SQL queries and database schemas based on application requirements.
  • Monitoring : Support in implementing database monitoring tool to pre-emptively identify potential issues.
  • Capacity Planning : Assist in capacity planning and resource optimisation for SQL Server environments
  • Documentation : Create and maintain comprehensive documentation regarding database configuration, optimisations and best practices.
  • Bachelor's degree in Computer Science, Information Technology or a related field.
  • Strong proficiency with SQL and its variation among popular databases
  • In-depth knowledge of SQL Server performance tuning techniques
  • Proficiency in T-SQL, including writing and optimising queries, Index Management
  • Ability to plan resource requirements from high level specifications
  • Understanding of Database Engine Internals, i.e. Understanding of SQL Servers internal architecture, including how queries are processed, how data is stored and how indexes are utilised
  • Familiar with clustered SQL setups and architectures for replicating data
  • Knowledge of Locking, Concurrency Partitioning
  • Experience in configuring SQL Server Resource Governor
  • Experience in using SQL Server Profiler and Extended Events
  • Understanding of Database Sharding
  • Understanding of high availability and disaster recover
  • Proficient understanding of database structures, theories and best practices.
  • Certifications in SQL Server or related fields
  • Experience with cloud-base database solutions
  • Familiarity with other database technologies
  • Security Clearance

    :

    Life at Leonardo

    With a company funded benefits package, a commitment to learning and development, and a flexible approach to working hours focused on the needs of both our employees and customers, a career with Leonardo has never offered as many opportunities or been more accessible to as many people.

  • Pension: Award winning pension scheme (up to 10% employer contribution)
  • Holidays: 25 days plus bank holidays, option to buy/sell leave and to accrue up to 12 additional flexi leave days per year
  • Flexible Working: Flexible hours with hybrid working options. For part time opportunities, please talk to us
  • Wellbeing: Employee Assistance Programme, access to Mental Health support, Financial wellbeing support, network groups (Enable, Pride, Equalise, Reservists, Carers)
  • Lifestyle: Discounted Gym membership, Cycle to work scheme
  • Company funded flexible benefits: Access to private healthcare, dental schemes, Workplace ISA, Go Green Car Scheme, technology and lifestyle options (£500 annual allowance)
  • Training: Free access to more than 4000 online courses via Coursera
  • Referral Incentive: You can earn a reward for successfully referring a friend or family member
  • Bonus: Scheme in place for all employees at management level and below


  • Consortia Bristol, United Kingdom £50,000

    NET Developer | Hybrid in Bristol | Up to £50,000 · NET Developer. · NET Developer, you will be at the forefront of driving technical solutions and implementation across our entire product range. You will work closely with their dynamic team, supporting Technical Consultants in ...


  • Trust In SODA Bristol, United Kingdom £44,000

    I've partnered up with a leading Insurance company looking to hire .NET Developer so join the Engineering Dream team :) · You will be working on a variety of projects, testing and enhancing your problem-solving abilities and creativity - they currently have quite a few brand new ...

  • ARC - Accelerate Recruitment

    BI Developer SQL,ssis

    4 weeks ago


    ARC - Accelerate Recruitment Cardiff, United Kingdom

    Reporting to the Business Information Manager we are looking to appoint a full time Business Information Developer. In order to demonstrate your suitability for this role you must have proven experience within a BI developer role, the ability to liaise withbusiness stakeholders a ...


  • St. James's Place Cardiff, United Kingdom

    Migration of code from Microsoft SQL Server to Snowflake, including adopting a new data structure. · Produce high quality documentation and test evidence to support change management governance requirements. · Assist with the investigation of unexpected financial results through ...

  • IntaPeople

    Lead PL/SQL Developer

    3 weeks ago


    IntaPeople Wales, United Kingdom

    Looking for a Lead PL/SQL Developer role where you will have ongoing L&D opportunities as well as a structured roadmap in terms of progression? IntaPeople are delighted to be partnered with a fintech to scale up the professional services team as they set to revolutionise the lend ...


  • CIMPA Bristol, United Kingdom Full time

    Are you looking to build and develop a career within the aviation consulting environment? If so, we currently have an outstanding opportunity for a PLM (Product Lifecycle Management) Solution Architect to join our dynamic team. · We are looking for an experienced PLM (Product Lif ...

  • IntaPeople Limited

    Lead PL/SQL Developer

    3 weeks ago


    IntaPeople Limited Cardiff, United Kingdom

    Looking for a Lead PL/SQL Developer role where you will have ongoing L&D opportunities as well as a structured roadmap in terms of progression? IntaPeople are delighted to be partnered with a fintech to scale up the professional services team as they set to revolutionise the lend ...


  • Babcock International Bristol, United Kingdom

    **Principal Microsoft SQL Database Administrator**: · - Location: Bristol, GB, BS31 2YH- Onsite or Hybrid: OnSite**Principal Microsoft SQL Database Administrator** · **SF 51804** · **Location: Keynsham UK** · **Business Unit: Corporate Services** · *** · **Purpose of role** · **K ...

  • Opus Recruitment Solutions

    Tech Lead

    4 weeks ago


    Opus Recruitment Solutions Bristol, United Kingdom

    **Tech Lead | Tech4Good | Node, Typescript, React, SQL, AWS, Linux** · **Bristol | Hybrid** · **£70,000 - £80,000** · A market-leading business specialising in the innovative IoT industry, is looking for a Tech Lead to join the business, due to huge growth plans · The business is ...

  • EA Change

    Banner Developer

    3 weeks ago


    EA Change Bristol, United Kingdom

    Role: Banner Developer · Rate: £600/day outside IR35 · Duration: 6 months · Location: Remote · An exciting opportunity for an experienced Banner Developer to join a higher education client on a large-scale IT transformation project. · Role/Requirements: · - Experience and working ...

  • Swiss Design Limited

    Web Designer

    3 weeks ago


    Swiss Design Limited Bristol, United Kingdom

    Job Overview: · **Duties**: · - Design engaging website layouts and graphics using Adobe After Effects, Adobe Flash, and Adobe Creative Suite · - Collaborate with the development team to implement design concepts effectively · - Utilise VHDL, Less, and Balsamiq for prototyping an ...


  • DAC Beachcroft Bristol, United Kingdom

    Job Introduction · DAC Beachcroft is looking to appoint a Senior Database Administrator to join our busy IT Systems team in Bristol. With a significant investment in people, technology and training, our IT environment is fast paced, busy and rapidly growing. We are looking for en ...


  • Opus Recruitment Solutions Ltd Bristol, United Kingdom

    **Lead Data Engineer | Bristol/Hybrid/Remote | Up to £90,000 DOE** · **AWS | DynamoDB | Redshift | SQL | Python | Kafka | Snowflake** · Are you wanting to take the next step in your career and develop into a Lead Data Engineer, developing the Data team due to a new approach to th ...

  • QUINTON DAVIES LIMITED

    Data Engineer

    3 weeks ago


    QUINTON DAVIES LIMITED Bristol, United Kingdom

    **Data Engineer** · **Hybrid/Bristol** · **Salary - £44,000 - £48,000, plus some fantastic benefits** · Quinton Davies are working with an award-winning, innovative, market leading company to secure a **Data Engineer** based in Bristol. · This is an exciting opportunity to work w ...


  • QUINTON DAVIES LIMITED Bristol, United Kingdom

    **Data Engineer Consultant** · **Bristol - Hybrid** · **Salary circa £35,000 - £60,000** · Quinton Davies are working with an innovative and rapidly expanding consultancy to secure a **Data Engineer Consultant** to join their Bristol office. · Working within a highly experienced ...

  • Opus Recruitment Solutions Ltd

    Software Developer

    2 weeks ago


    Opus Recruitment Solutions Ltd Bristol, United Kingdom

    **Software Developer | £40,000 - £50,000 | Fully Remote** · **PHP | Laravel | JavaScript | HTML | SQL | MySQL | PostgreSQL | jQuery | AJAX | LAMP | Linux | Apache | MySQL | MariaDB** · Don't feel valued in your current role? Maybe you're not enjoying the current working environme ...


  • Artis Recruitment Bristol, United Kingdom

    Oracle Fusion Middleware Consultant required by our global, market leading, award winning, professional services organisation. This is a full remote role. The Oracle Fusion Middleware Consultant will join our clients Middleware team and will be responsiblefor developing, building ...

  • Opus Recruitment Solutions Ltd

    Data Systems Engineer

    2 weeks ago


    Opus Recruitment Solutions Ltd Bristol, United Kingdom

    **Data Systems Engineer | Bristol/Hybrid/Remote | Up to £70,000** · **SQL | ETL | Query's | Azure | Python | Testing Data | Aerospace | Bristol |** · My Bristol based client are futuristic innovators and a fast paced organisation who bring together the best of the best across aer ...

  • Jefferson Frank

    Lead Java Developer

    3 weeks ago


    Jefferson Frank Bristol, United Kingdom

    Join this Team of Tech Innovators · Are you ready to take your programming career to the next level? · Look no further We're seeking an exceptional **Lead Java Developer** to contribute to cutting-edge projects that make a real impact. Our doors are open to all applicants, regard ...


  • Fusion People Ltd Bristol, United Kingdom

    Job Title: Application Support Analyst · Location: Bristol, UK - Onsite · Compensation: £30,000 - £ 35,000 + benefits · Role Type: Full time / Permanent · The role · The difference our new 2nd Line Helpdesk will make · As a 2nd Line Helpdesk, you'll have a role that's out of the ...