Designing database tables and structures. Creating views, functions and stored procedures. Writing optimized SQL queries for integration with other applications. Creating database triggers for use in automation. Maintaining data quality and overseeing database security.