Writing complex SQL queries and scripts. Developing and maintaining database views. Creating and optimising stored procedures. Developing database triggers. Performing query analysis and optimisation.