Database Administrator

Database Administrator Remote

Shawbrook Bank
Full Time Remote 10.56 - 12.04 GBP Today
Job description

Data Platform

London, England, GB / Homebased

Posted on August 17, 2023


The Opportunity

Shawbrook is a new type of specialist financial services company, combining the relentless focus on customer service and innovation you would expect from a fintech with the expertise and certainty of a bank. Shawbrook is driven by a purpose to solve complex problems that unlock opportunity for its rapidly growing customer base of over 300,000 UK consumers and businesses.

Our success would not have been possible without our Team. Our people differentiate us from the competition through their deep sector knowledge, they are the life force of our business.

Join Shawbrook because you:

  • Want to help us deepen our industry sector knowledge, combining technology alongside the best banking brains.
  • Want to build a bank for the future and be part of our digital transformation journey that will enable customers & businesses to thrive
  • Want to continue to grow professionally. We encourage you to grow and be the best version of yourself.
  • Care about sustainability? We want to be better for our people, environment and society.
  • Bring passion and enjoyment to your work. You’ll work hard but you’ll have fun too.

The Role & Responsibilities

In this role, you will collaborate with a Senior DBA and a team to design, develop, and document solutions for both on-premise OLAP systems using SQL Server and cloud-native data stores in Azure, such as Data Lake Gen 2, Azure SQL Clusters, and Azure Synapse SQL pools.

Your responsibilities will involve:

  • Designing and implementing Azure OLAP solutions, which include creating data models, cubes, dimensions, measures, and calculations.
  • Working closely with Data Engineering and SQLDEV teams to ensure smooth integration of data from Azure Data Lakes into databases on Azure.
  • Monitoring and optimizing the performance of environments, both on-premises and in Azure, by identifying and addressing performance bottlenecks.

Additionally, you'll contribute to enhancing data pipeline architecture and performance, auditing and improving the performance of databases and data lakes, and advancing tools, automation, and monitoring capabilities.

You will also stay informed about emerging trends in database technologies, analyzing both SMP and MPP databases, various Data Lake table formats, and Data Lake-based analytics to identify opportunities for the organization.

Your role will involve advocating for Infrastructure as Code practices through standardized deployments, scaling, and teardowns using technologies like ARM templates and PowerShell modules. Event-driven monitoring and alerts will be part of your responsibilities as well.

You will play a crucial role in establishing the organization's Data Catalog, which will extract information from the Data Lake and other downstream systems to provide data lineage, metadata, and master data insights across the entire bank.

Additionally, you'll maintain lower environment (test, dev) data in synchronization with production environments while ensuring that personally identifiable information (PII) is masked. Your role will also involve automating data deletion and anonymization tasks to align with GDPR regulations.

The Person

SQL Server: In order to provide valuable, business lead insights, you’ll be using SQL to build databases whilst you query, manage and manipulate vast amounts of data.

Python: Your role will involve close collaboration with the Data Engineering team during the integration of pipelines, which are predominantly written in Python a basic level of understanding would be required.

Azure Cloud: Given the significant migration activities underway within Azure, it's crucial to have a strong command of the environment, particularly concerning monitoring and optimizing performance.

Best Practices: We want this individual to drive and implement the Azure best practices across the team. This includes being an SME and documenting the implementation changes.

PowerShell: Proficiency in PowerShell is essential for the role, as it serves as a key tool for driving automation within the database team.

Reward

Your Wellbeing - We take your health and well-being very seriously by providing a range of benefits to give you and your family peace of mind. These include:

  • Market leading family friendly policies such as access to our Maternity, Adoption and Paternity policies from Day 1 of your employment
  • Free access to Headspace, a mindfulness & meditation digital health app
  • Free access to Peppy digital health app that offers personalised support through fertility treatment becoming a parent or menopause
  • EAP (Employee Assistance Programme) - Offering you support on a wide range of subjects including financial concerns, mental wellbeing and more general queries around family, work, housing, and health
  • Cycle-to-work scheme
  • Discounts on gym membership
  • Contributory pension scheme & death in service

Your Lifestyle - It’s important you strike the right balance between your work and personal life. We provide benefits to support you when at work and when you’re enjoying your leisure time.

  • Minimum of 25 days holiday per year
  • Option to buy or sell holiday days through our flexi-holiday scheme
  • Discounts on gym membership nationwide
  • Access to discounts on a range of high street and online brands
  • Community support and charitable giving

Your Contribution - We’re focused on rewarding those that go the extra mile in helping us achieve our goals.

  • Participation in our annual discretionary bonus scheme designed to reward your contribution to our success
  • Proudly Shawbrook recognition scheme focused on recognising our role models and thanking our colleagues for a job well done

Database Administrator
Shawbrook Bank

www.shawbrook.co.uk
Brentwood, United Kingdom
Marcelino Castrillo
$500 million to $1 billion (USD)
1001 to 5000 Employees
Company - Private
Banking & Lending
Finance
2011
Related Jobs

All Related Listed jobs

Manchester - Stocktaker Driver
RGIS Salford, North West England, England 10.7 GBP HOURLY Today

Mileage compensation payments when using own vehicle. O Up to 1.50 per hour additional performance based bonus. Up to 28 days paid holiday per year.

No7 Advisor
No.7 Boots London, England 10.39 - 11.7 GBP HOURLY Today

Getting behind our fantastic in store promotions and No7 offers to grow our sales, driving sales and maximising target opportunities.

Career Launch Work Experience, Manchester, 2023
PwC Manchester, England Today

You'll need to be on course for a 96 UCAS tariff from across your top 3 A-Levels in any subjects or equivalent qualification (excluding General Studies and the

Graduate Highways Engineer x 3
Knowsley Council Huyton, England 27852 - 29439 GBP ANNUAL Today

The ideal candidate will will have a degree in civil engineering or a similar subject. This job advert may close early if enough applications have been

Flexible Promo Work in Birmingham: Brand Communicator
RPM Ltd Birmingham, England 7.8 GBP HOURLY Today

Were an independent creative agency with a strong belief in purposeful brand experiences that change consumer and shopper behaviour.