• Job Reference: PR/020885
  • Date Posted: 28 May 2021
  • Recruiter: E-Resourcing
  • Location: London
  • Salary: £55,000 to £60,000
  • Bonus/Benefits: 10% Bonus
  • Sector: IT (general)
  • Job Type: Permanent
  • Work Hours: Full Time

Job Description

Database Administrator / DBA / Data Warehouse Specialist


£55,000 - £60,000 + 10% Bonus

Our client, a global leader in their field are seeking a DBA / Data warehouse specialist with strong SQL AWS & SSIS experience

This position is to work on application development projects. You will work closely with technical leads and developers to assist in both logical and physical database designs along with database & SQL performance tuning.

What you will be doing:

  • Design database applications, such as interfaces, data transfer mechanisms, global temporary tables, data partitions, and function-based indexes to enable efficient access of the generic database structure
  • Design databases to support business applications, ensuring system scalability, security, performance and reliability
  • Review and or Develop data models for applications, metadata tables, views or related database structures
  • Design and Develop extract load and transform (ETL) and Database design for data warehouse
  • Develop or maintain backup processes, archived procedures, procedural codes, or queries for applications
  • Develop and document database architectures
  • Develop database architectural strategies at the modeling, design and implementation stages to address business or industry requirements
  • Demonstrate database technical functionality, such as performance, security and reliability

Work with your team:

  • Work with solution architects, developers, business analysts, and others to understand business or industry requirements
  • Create and enforce database development standards and ensure cross-team coordination
  • Coach and mentor other developers in our team. Ensure that our ways of working are consistent across the teams
  • Integration with other groups in the company related to hosting, DBA support, Server upgrades and server support
  • Perform work in development environment, test in staging environment and work with other groups to push changes to production
  • Maintain balanced relationships across the business community, technical team, and IT vendors
  • Manage client requests and expectations
  • Proactively and consistently communicate task status
  • Communicate risks, assumptions, issues, and dependencies to appropriate stakeholders and escalate if necessary, to ensure the project's success

What you will need:

  • Ability to communicate with user community, project management, developers, contractors, and all levels of management
  • Exstensive Database Development experience
  • Significant SQL Server experience in a Development environment responsible for design, build and configuration or equivalent
  • Significant experience developing in SQL Server Stored Procedures or equivalent
  • Data warehouse experience using SSIS or equivalent
  • Ability to troubleshoot ETLs developed using SSIS, C#.Net. or equivalent
  • Ability to troubleshoot Database mirroring and SQL Always on or equivalent
  • Jira (or equivalent) experience
  • Worked in Web/Internet, Intranet and/or Extranet development teams or equivalent
  • Knowledge of logical and technical database application design
  • Knowledge of NoSQL and other cloud databases such as Cassandra or AWS RDS AWS Cloud knowledge (S3, ) or equivalent
  • Knowledge of the software development life cycle
  • Database modelling
  • SQL Performance tuning or equivalent

If you are looking to work with a global brand that's at the top of its game then please apply below!