Cloud
-
- Migration of on-premises infrastructure to Azure cloud.
- Design, build, and management of VMs and networking.
- Design and management of Azure SQL, including performance, best practices, and usage within a data strategy.
- Database estate management (SQL server, Azure SQL) including administration (DBA), backup and restore processes, maintenance plans, performance tuning.
Data
-
- Access database migrations to Azure SQL.
- Setup Azure Data Factory pipelines with data flows from CSV to Azure SQL with automatic ingestion and transformation from source to Azure Blob Storage to destination sink.
- Employ Logic App for trigger, control, and notification mechanisms.
- Design and build Power BI reports and dashboards from multiple flat-file and database sources.
- Document databases, columns, and usage for user consumption and understanding.
Tools Employed
-
- Azure DevOps for work items, sprint planning, version control / Git and ADF Repository
- Lucid Chart for design and architecture, review with client.
- Notion for technical documentation, project management.
- SQL Server Management Studio and Navicat for database management, diagrams, schema creation
- RedGate tools for database dependency tracking, schema compare, documentation.