Connecting to LinkedIn...

SQL Database Administrator

Job Title: SQL Database Administrator
Contract Type: Permanent
Location: West London, London
Industry:
Salary: Negotiable
Start Date: ASAP
Duration: PERM
REF: pp/ck/dataeng_1606136036
Contact Name: Caroline Kennedy
Contact Email: caroline.kennedy@projectpeople.com
Job Published: over 3 years ago

Job Description

This is an exciting opportunity to work for a company who are currently undergoing a major business transformation, underpinned by significant investment in their technology.

As an accomplished SQL Database Administrator, you will be responsible for creating and maintaining all data feeds that the Data Platform requires and that data sets are optimised, structured, partitioned, indexed and performant. This role will also have a high degree of ad hoc data requests to be filled for the business and troubleshooting of data issues.

This role will be based in the UK but have interactions with business users in the US.

Responsibilities of the SQL Database Administrator include:

  • Creating and maintaining data feeds in and out of the Data Platform
  • Responsible for indexing, partitioning, scheduling loads and optimising all databases that are part of Data Platform as a key priority
  • Performing ad hoc data requests for the business where quick turnaround time is required for insight and critical decision making. This could be using a variety of technologies and working across Azure, Salesforce and Google platforms
  • Working with the BI Developer to ensure that all data feeds are optimised and available at the required times. This can include Change Capture, Change Data Control and other "delta loading" approaches
  • Documenting all interface specifications for data feeds coming in and out of the Data Platform
  • Ensuring that data encryption, obfuscation and access management of the data layer are in place and maintained
  • Assisting the wider team with data optimisation, indexing and partitioning tasks. This resource would also review other developer's SQL queries and interfaces to highlight performance issues and adherence to industry best practice
  • Working with the Service Management team to resolve any production issues that require specialist support during normal business hours
  • Maintain and extend ETL process monitoring, outputs and alerts
  • Actively working with users to understand data issues, tracing back data lineage and helping the business put appropriate data cleansing and quality processes in place
  • Managing secure access to data sets for the business
  • Optimising and reviewing all ETL and database processes to ensure that the platform is running efficiently and cost effectively

The successful SQL Database Administrator will have:

  • Strong DBA and SQL coding experience
  • Extensive experience developing using T-SQL, relational databases, SSIS, KingswaySoft and other ETL technologies
  • Knowledge of SSRS, SSAS, Power BI, Power Query and DAX
  • Working knowledge of REST APIs
  • Desirable to have working knowledge of SalesForce data structures
  • Experience using Cloud technologies and tooling for Azure and Google (GCP is less of a focus but the candidate will need to be confident to participate in data migration and connectivity to this platform)
  • Strong coding skills and ability to write and de-bug ad hoc queries using various tools. Python and understanding of Machine Learning is also a nice to have but an opportunity for future development

To apply for the SQL Database Administrator please send your CV to caroline.kennedy@projectpeople.com

Project People is acting as an Employment Agency in relation to this vacancy.