• This job is no longer available.
    You can view related vacancies or set-up an email alert notification when similar jobs are added to the website below.

    SQL Server Database Administrator

    £75000 - £80000 per annum
     

    Job Description

    SQL Server Database Administrator

    A global investment bank is currently seeking a SQL Server DBA to join the Database team to work across aspects of Projects, Operations, and Engineering. Projects include end-of-life software for SQL databases as the databases are upgraded to newer versions, so an opportunity to work in a major project across the company.

    In the engineering function the newer SQL Servers will include certification process, installation, testing, and batch processes, where this person will help this process across the bank. This role will sit at the Project support/Operations level 3, so will help with any escalations, and so may require rare on-call work.

    This person must have strong experience in SQL Server along with either PowerShell or Python skills. but will also have exposure to other technologies such as Oracle, Sybase, Mongo, Snowflake, and will get an opportunity to cross train, most likely across Oracle. The Databases are both hosted on cloud and on-premise, so lots exposure to cloud technologies too.

    You will:

    • Implement tools and processes for efficient and effective operational management of the environment
    • Define and implement service catalogue whilst ensuring workload is kept within defined parameters
    • Produce clear supporting documentation to enable off-shore to provide first and second-line of support
    • Provide deep technical assessments of ticket queues to identify and address issues in a holistic manner
    • Perform root cause analysis to resolve any technical issues that off-shore escalate
    • Strive to permanently eliminate issues through automation opportunities and sustainable long-term fixes
    • Partner with SRE team to identify areas for continuous improvement, automation and self-service

    Your experience:

    • Current and previous versions of Microsoft SQL Server experience.
    • Scripting and programming languages such as PowerShell or Python
    • Experienced in Database Installation / De-installation, Configuration, Tuning, Migrations and Upgrades
    • Advanced knowledge of Clustering, High-Availability, Replication and Disaster Recovery techniques
    • Fluent in Backup and Recovery processes and procedures
    • Competent with Logical and Physical database design
    • Ability to interpret and implement CIS security hardening recommendations in a controlled manner
    • Awareness of security and auditing requirements in a regulated environment

    This is a permanent position based in London, operating on a hybrid work setup.

    SIMILAR JOBS
    • Linux Administrator (Contract) - Investment Bank
      Competitive day rate

      A Bank in the City of London is currently seeking a Linux Administrator to join their EMEA Technology team.

      The Linux team is responsible for managing, maintaining, enhancing their linux related technologies across the estate, as well as supporting the drive towards automation by implementation solutions within a project environment.

      From a BAU perspective the team take part in daily health and compliance checks for all Production systems as well as ensuring all Linux/Unix systems are backed up. Other duties include validating monitoring alerts, ensuring sufficient capacity is available to accommodate projected BAU & project growth, as well as maintaining Linux platforms in a highly available, reliable, secure and performant manner.

      From a project perspective the Linux Administrator will help identify savings across project & BAU activities to be implemented through automation involving a detailed process flow, and ensure that all project/investment related workloads are delivered according to plans and defined budgets

      Required skills:

      • Red Hat and Solaris, including system internals and kernel tuning.
      • Red Hat Satellite
      • Ansible
      • AWX
      • REST API integration
      • Scripting
      • CI/CD pipelines and other automation concepts
      • Dev/Ops mentality
      • Git or other source code control software
      • Excellent knowledge of networking, storage, database and virtualization layers.
      • Good working knowledge of Python, Perl and Bash scripting.
      • Clustering and high-availability technologies
    • Digital Solutions Architect - Financial Services
      £80000 - £90000 per annum bonus and benefits

      A Financial Services Company in Southampton is currently seeking a Solutions Architect to join their Technology team.

      The company are currently going through a lot of positive change and digital transformation across various user platforms, with improvements across the digitalization of key applications. The company are well into their cloud journey, partnering with Azure, as well as using other state-of-the art tools to successfully make these changes.

      This person will help create IT design solutions for business units and functions, building technology domain requirements aligned to the Enterprise Architecture framework, as well as key Strategy and long term roadmaps. This team are responsible for the digital design and build out of capabilities for key applications, and driving downstream development of these key changes.

      The team also helps support the development, maintenance, communication and implementation of the solution designs, as well as conducting in-depth technical reviews, and bringing together key expertise to ensure designs are fit for purpose.

      Key Requirements;

      • Proven track record working in Technology Solution Design, from an applications perspective.
      • Experience within a wide variety of IT functions, including system analysis, development and project management.
      • Understanding of industry best practice and trends together with their application within a business context.
      • Knowledge of a wide variety of technologies including several of the disciplines in strategic IT architecture covering either application, infrastructure, data or security architecture with evidenced practice of at least two domains.
      • Any experience of working across Financial Service is beneficial, but not essential
    • Application Support Lead (Fixed Income) - Financial Services
      £115000 - £125000 per annum bonus and benefits

      Sterlings are currently partnered with an Investment Bank who are looking to hire a Senior Application Support Analyst Lead, to join their Front Office Technology Team.

      This person will lead the support team who provide support and maintenance across various desks and multiple asset classes including credit and interest rate derivatives, credit default swaps, currency swaps and interest rate swaps and well as cash equities.

      The team are also responsible for helping improve processes, fixes and enhancements, and Co-ordinate software releases in UAT and Production environments.

      Other duties include updating support documentation and owning the development once released.

      This person will operate as a Player/Coach, bringing to the table a mix of hands-on technical and business knowledge, people leadership, project and communication skills, developing deep knowledge of applications, architecture, up and downstream flows, as well as being a critical esculation point.

      Experience required;

      • Strong Application Support experience within a Financial Trading environment.
      • Solid Supervisory / Management / team leadership experience in technology support of Capital Markets trading and related functions.
      • Solid business knowledge of derivative products (interest rate swaps, credit default swaps, exchange traded futures and options, convertible bonds).
      • Proven technical analysis and investigatory skills with ability to work within a high-pressured environment. Stack includes Ulinx/Linux and SQL Server