Found Description
Key responsibilities:
SQL development and database engineering
Design: ...
SQL development and database engineering
- Write advanced SQL queries, stored procedures, functions, views, and triggers.
- Design, normalise, and implement relational database models and schemas.
- Perform performance tuning and query optimisation, including execution plan analysis and troubleshooting.
- Define and implement indexing strategies, including clustered, non-clustered, and columnstore indexes.
- Develop and maintain ETL pipelines and data integration processes.
- Apply data warehousing concepts and dimensional modelling techniques.
- Manage database security, permissions, and access control.
- Plan and execute backup, recovery, and disaster recovery procedures.
- Handle transaction management and concurrency control in high-volume environments.
- Support data migration initiatives and database deployments.
Design: ...