Working With Databases

By Progression

The ability to create and update databases, store and retrieve data and maintain the integrity of the data.

Level 1

Is able to use the database to store and retrieve data in a usable way.

  • Infrastructure: You understand the basics of the database management system, such as how to add tables, views and indexes.

  • Security: You understand the basics of database management system security.

  • Performance: You are able to write SQL queries.

Level 2

Has a good understanding of the different types of databases and can assess which would be most appropriate for a specific situation.

  • Infrastructure: You have a good understanding of the database and can identify usage trends and performance bottlenecks. You can optimise a system for specific requirements.

  • Security: You ensure that the database is secure, and can work with a team to manage the security of the system.

  • Performance: You write SQL queries as per requirements. You have basic knowledge of database design.

Level 3

Is able to manage complex queries, work with data scientists and help in the design of new databases. Works with other members of the engineering team to maintain appropriate levels of redundancy and security.

  • Infrastructure: You have detailed knowledge of the many types of databases, their strengths and weaknesses. You are able to install a database, configure it for optimal performance and provide basic maintenance.

  • Security: You have expert knowledge of database security, and are able to work as a team lead on projects related to securing databases.

  • Performance: You can design and implement complex SQL queries to optimise performance.You understand database design principles.

Level 4

Manages large and complex databases. Can automate processes to improve performance. Can write efficient, optimised SQL queries and code.

  • Infrastructure: You lead on designing and building customised databases for various projects and users.

  • Security: You lead the team on projects related to securing databases, ensuring that all staff are aware of their role in maintaining data integrity.

  • Performance: You are able to design advanced SQL queries to filter data, and optimise performance.

Level 5

Manages databases for the entire organisation. Has in-depth understanding of database design, development and troubleshooting, as well as automated processes that can be applied to dramatically improve performance over time.

  • Infrastructure: You are an organisational leader on database infrastructure, overseeing all aspects of projects related to database management systems.

  • Security: You oversee all work related to securing databases. You set direction for the organisation's database policies. You are an expert on data integrity.

  • Performance: You lead the organisation in designing and implementing complex SQL solutions to solve challenging performance problems.

Build your first team in minutes

Get access to our library of templates and skills and invite your team, for free