Services

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.
Scroll to Top