Templates
Skill

Working With Databases

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

Working With Databases

Level 1

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

  • Performance: You are able to write SQL queries.

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

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

Level 2

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

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

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

  • 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.

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.

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

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

  • 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.

Level 4

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

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

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

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

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.

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

  • 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.

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