SQL DBA

Recruiter
Metapak
Location
Covent Garden
Posted
13 Nov 2017
Closes
16 Nov 2017
Contract Type
Permanent
Hours
Full Time
MetaPack is currently at the heart of the eCommerce revolution and our delivery management software (SaaS) enables some of the world's most well-known retail brands and eCommerce companies such as Marks & Spencer, John Lewis, House of Fraser, ASOS and Ralph Lauren to provide better, faster, cheaper and more convenient options for delivery with the ability to trace and track your packages, regardless of how complicated it is to get it there.

We are a dynamic, fast-growth B2B SaaS technology organisation that has been growing at 40% year on year for the last 5 years, we are headquartered in Central London with offices across the world. Our software processes 500 - 5000 orders per minute and last year enabled over 450 million parcels to be delivered to over 200 countries.

We are currently recruiting another SQL DBA for the business, the overriding purpose of the position is to ensure that data used and required by the business is accurate and deliverable in a clear and timely manner.

As an integral member of the development team, you will be responsible for designing and/or approving implementation of any interaction between functional components of the application architecture and its SQL databases.

The role has a crucial impact on monitoring performance and managing parameters to provide fast responses to users.

Key Responsibilities
  • Analysis of the delivered requirements and documentation of functional changes in MetaPack products
  • Active acquisition of specialized knowledge ("business domain") related to logistic carrier modules and processes carried out by carriers
  • Acquire product knowledge for the solutions developed by MetaPack as well as further transfer of product knowledge in the Software Development team
  • Developing skills related to relational databases (min. SQL Server) - database management, structure design, monitoring, query optimization
  • Developing skills related to non-relational databases
  • Designing and modifying the database structure in MetaPack products
  • Monitoring and retrieving analytical data from production and test database servers
  • Optimizing structure and queries based on collected data
  • Check scripts and database queries written by other developers and provide code quality tips
  • Take additional initiatives to improve the quality and / or delivering process of software, to share knowledge through the MetaPack Academy (workshops, presentations, etc.)
  • Consulting customer support activities
  • Collaboration with Scrum Teams in accordance with the adopted process:
  • Participation in meetings (sprint planning, daily meeting, sprint review, sprint retrospection, other required by the process)
  • Estimation and execution of database related tasks resulting from analysis of notified requirements or finished design documents
  • Verification of the quality of database developer tasks
  • Assesses database performance by developing a protocol for measurement of results and identification of problem areas
  • Supports database performance by monitoring database performance; evaluating and resolving processing and programming problems; designing database management tools; answering user questions
  • Secures database by preparing access and control policies and procedures
  • Other tasks assigned by line manager


Key Skills
  • Professional experience as a database programmer or database administrator
  • Knowledge/experience of Microsoft's SQL 2008, 2012, 2014 & 2016
  • Knowledge about Microsoft and VMware technologies
  • Knowledge of Always On
  • Knowledge of Microsoft Clustering
  • Knowledge about DDL, DML, DQL, DCL
  • Good knowledge of version control mechanisms
  • Good knowledge about query optimization
  • Fully understand the principles of agile team software development
  • Ability to design and implement changes in relational database structure
  • Good trouble shooting skills, analytical and service-minded attitude


So why work at MetaPack, with year-on-year growth of 40% over the last 5 years, and with further growth planned, there has never been a better time to join us on our journey as we further cement our place as the number one global player in the industry!
This job was originally posted as www.cwjobs.co.uk/job/77240244