It looks like you are in United States. Would you like to go to https://onsiter.com/us/ instead?
Might be available
(Updated 2023-09-22)DBA/BI Developer
England, United Kingdom
Fluent English
- managing, upgrading, migrating, monitoring, and troubleshooting SQL Server
- IT Professional (MCITP) Database Administrator
- Microsoft Certified Technology Specialist (MCTS)
Skills (48)
DATA RETREIVAL
DATA TRANSFORMATION
DATA RETRIEVAL
STORED PROCEDURES
Business Intelligence
DOCUMENTATION
OLTP
DATA INTEGRITY
PIPELINE
SQL SERVER 2008
REPLICATION
SQL SERVER 2005
STORED PROCEDURE
CAPACITY PLANNING
DATA MAPPING
MAPPING
RECONCILIATIONS
DOCUMENTING
IMPORT/EXPORT
SQL
POLICY MANAGEMENT
SQL QUERIES
MS SQL SERVER 2008
DATABASE ENGINE
MS SQL Server
DATABASE ADMINISTRATOR
SHIPPING
RELATIONAL DATABASE
Microsoft SQL Server
MAINTENANCE
BI
Maintain Data
SQL Server
DECOMMISSION
SQL SERVER 2012
OLE DB
DATABASE
PERFORMANCE ANALYSIS
DATABASE SYSTEMS
REQUIREMENTS GATHERING
Database Design
DATABASE MODELING
DATA MODELS
BUSINESS REQUIREMENTS
Access Database
Access Databases
Microsoft Access
VISIO
Professional Experience
Oracle DATA WAREHOUSE CONSULTANT/ DBA / BI DEVELOPER EDUCATION BARNET
ENFIELD AND HARINGEY MENTAL HEALTH NHS TRUST
2023-09 - 2023-09
AUG 25, 2022 - JULY 31 2023 Sc (Hons): Information Technology, Project Management Microsoft Certified Technology Specialist (MCTS) SQL Server 2008, Implementation and Maintenance Candidate Profile 2008 Prince II Certification Microsoft Certified IT Professional (MCITP) Database Administrator * Migration of SQL Server 2008R2 and 2012 to SQL Server 2016 * Migration of SQL Server Reporting Services 2012 to SQL Server Reporting Services 2016 * Performing Assessments and documenting migration errors and deprecated objects with SQL server migration assistant * Migration of on Prem SQL Server 2016 to Azure managed instance with SQL server migration assistant * Migration of Access databases to SQL Server 2016 with SQL server migration assistant * Using SQL Server Profiler to capture deprecated objects and compatibility issues.
* Implementing maintenance plans to ensure the health, security, availability, performance, and manageability of the SQL Server environment.
* Implementing the declarative management framework (policy management and enforcement DMF) * Establishing and monitoring backup schedules * Tuning database configuration for optimum performance * Diagnosing and resolving problems relating to database service availability * Monitoring and maintaining quality assurance by checking the consistency, continuity, and coherence of supported services * Created an incremental loading solution of DB2/ Oracle tables and CSV files into SQL Server Database using SSIS * Used Sub queries, joins, CTE, and Analytical functions for data retrieval * Designed and developed efficient SSIS packages for processing fact and dimension tables using transformations like Fuzzy lookup, lookup, merge, merge join, script component * Created systems for capturing error data in flat files using flat file destination, sending the error data in flat files attached to the corresponding mail ids using Sent Mail Task, and correcting error data * Providing extensive Training of the team DBA team on the ground to take on support and maintenance of replication, log shipping maintenance, and backup jobs * SSRS ROLE * Designing and creating Report templates, bar graphs, and pie charts * Writing queries to generate reports for analysis of data using table control, * Writing matrix control to create crosstab reports handling sub-reports and defining queries for generating drill-down reports in SSRS * Creating multiple parameterized stored procedures which were used by the reports to get the data.
* Working on formatting SSRS reports using the Global variables and expressions * Creating parameterized reports, Drill down and Drill through reports using SSRS to create error failure reports
* Implementing maintenance plans to ensure the health, security, availability, performance, and manageability of the SQL Server environment.
* Implementing the declarative management framework (policy management and enforcement DMF) * Establishing and monitoring backup schedules * Tuning database configuration for optimum performance * Diagnosing and resolving problems relating to database service availability * Monitoring and maintaining quality assurance by checking the consistency, continuity, and coherence of supported services * Created an incremental loading solution of DB2/ Oracle tables and CSV files into SQL Server Database using SSIS * Used Sub queries, joins, CTE, and Analytical functions for data retrieval * Designed and developed efficient SSIS packages for processing fact and dimension tables using transformations like Fuzzy lookup, lookup, merge, merge join, script component * Created systems for capturing error data in flat files using flat file destination, sending the error data in flat files attached to the corresponding mail ids using Sent Mail Task, and correcting error data * Providing extensive Training of the team DBA team on the ground to take on support and maintenance of replication, log shipping maintenance, and backup jobs * SSRS ROLE * Designing and creating Report templates, bar graphs, and pie charts * Writing queries to generate reports for analysis of data using table control, * Writing matrix control to create crosstab reports handling sub-reports and defining queries for generating drill-down reports in SSRS * Creating multiple parameterized stored procedures which were used by the reports to get the data.
* Working on formatting SSRS reports using the Global variables and expressions * Creating parameterized reports, Drill down and Drill through reports using SSRS to create error failure reports
LEAD DBA/ DATA WAREHOUSE DEVELOPER
EAST LONDON NHS FOUNDATION TRUST
2023-09 - 2023-09
(DBA/SSIS/SSRS) * DBA ROLE * Installing and configuring SQL Server 2014 and 2016 as the Production, Test and Development server * Implementation of MS SQL Server 2008/2005 Management studio to create Complex Stored Procedures, User Defined Functions (UDFs) Views using T-SQL to evaluate result for the reports * Installation and Configuration of SQL Server 2014 and 2016 databases * Installation and Configuration of SQL Server Report Server and configuration of Report manager * Responsible for performing T-SQL tuning, multi-tasking and optimizing queries for reports which take longer time in execution with SQL Server 2012/2014/2016.
* Identifying data needs of customers and exceeding their expectations.
* Handling database performance tuning and query optimization * Detecting and fixing SLQ server issues and other resource contention * Performing backups, recovery models, and database shrink operations.
* Creating and supporting stored procedures, tables, functions, and views * Supporting database system for changes, implementation, and upgrades * Creating SQL Server Profiler traces using with Database Tuning Advisor DTA for optimum performance of queries * Developing scripts for database monitoring and maintenance * Using System tables, System Stored Procedure, DBCC commands for Database maintenance * Creating jobs, alerts to run SSAS, SSRS packages periodically * Creating the automating processes for the activities such as database backup processes and * SSAS, SSRS Packages run sequentially using SQL Server Agent job..
* Analyzing, consolidating and tuning databases and servers for optimal efficiency * Monitoring systems and platforms for availability * Restoring and recovering corrupted databases * Installing and testing upgrades and patches * SSIS ROLE * Creating Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
* Creating SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems * Developing, deploying, and monitoring SSIS Packages * Deploying packages on different servers and configuring it * Creating SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005/2008 * Performing operations like Data reconciliation, validation and error handling after Extracting data into SQL Server * Working on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server * Creating SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts * Generating and formatting Reports using Global Variables, Expressions and Functions for the reports * Developing data links and data loading scripts, including data transformations, reconciliations and accuracies * Migration of all Server objects to a new Server * Migration of data from Legacy systems * Creating SSIS Packages using SSIS Designer for exporting and importing heterogeneous data from Multiple Sources, e.g.: Oracle, Excel Spreadsheet, csv, NetSuite etc.
* To SQL Server 2005/2008/2012/2014/2016 * Developing complex T-SQL queries and designing Incremental SSIS packages to load the data into warehouse.
* Designing SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation.
* Developing DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server 2014/2016 Integration Services SSIS * Documentation of packages and applying Naming Standards * SSRS ROLE * Designing and creating Report templates, bar graphs and pie charts * Writing queries to generate reports for analysis of data using table control, * Writing matrix control to create cross tab reports handling sub reports and defining query for generating drill down reports in SSRS.
* Creating multiple parameterized stored procedures which were used by the reports to get the data.
* Working on formatting SSRS reports using the Global variables and expressions * Creating parameterized reports, Drill down and Drill through reports using SSRS to create error failure reports.
* Azure Data Factory * Implementing ETL and data movement solutions using Azure Data Factory, SSIS create and run SSIS Package ADF V2 Azure-SSIS IR * Designing and implementing database solutions in Azure SQL Data Warehouse, Azure SQL * Recreating existing application logic and functionality in the Azure Data Lake, Data Factory, SQL Database and SQL data warehouse environment, experience in DWH/BI project implementation using Azure Data Factory * Migrate data from traditional database systems to Azure databases * Implementing Copy activity, Custom Azure Data Factory Pipeline Activities for On-cloud ETL processing * Lifting and Shifting with Azure SQL Database + SSIS in Azure Data Factory
* Identifying data needs of customers and exceeding their expectations.
* Handling database performance tuning and query optimization * Detecting and fixing SLQ server issues and other resource contention * Performing backups, recovery models, and database shrink operations.
* Creating and supporting stored procedures, tables, functions, and views * Supporting database system for changes, implementation, and upgrades * Creating SQL Server Profiler traces using with Database Tuning Advisor DTA for optimum performance of queries * Developing scripts for database monitoring and maintenance * Using System tables, System Stored Procedure, DBCC commands for Database maintenance * Creating jobs, alerts to run SSAS, SSRS packages periodically * Creating the automating processes for the activities such as database backup processes and * SSAS, SSRS Packages run sequentially using SQL Server Agent job..
* Analyzing, consolidating and tuning databases and servers for optimal efficiency * Monitoring systems and platforms for availability * Restoring and recovering corrupted databases * Installing and testing upgrades and patches * SSIS ROLE * Creating Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
* Creating SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems * Developing, deploying, and monitoring SSIS Packages * Deploying packages on different servers and configuring it * Creating SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005/2008 * Performing operations like Data reconciliation, validation and error handling after Extracting data into SQL Server * Working on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server * Creating SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts * Generating and formatting Reports using Global Variables, Expressions and Functions for the reports * Developing data links and data loading scripts, including data transformations, reconciliations and accuracies * Migration of all Server objects to a new Server * Migration of data from Legacy systems * Creating SSIS Packages using SSIS Designer for exporting and importing heterogeneous data from Multiple Sources, e.g.: Oracle, Excel Spreadsheet, csv, NetSuite etc.
* To SQL Server 2005/2008/2012/2014/2016 * Developing complex T-SQL queries and designing Incremental SSIS packages to load the data into warehouse.
* Designing SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation.
* Developing DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server 2014/2016 Integration Services SSIS * Documentation of packages and applying Naming Standards * SSRS ROLE * Designing and creating Report templates, bar graphs and pie charts * Writing queries to generate reports for analysis of data using table control, * Writing matrix control to create cross tab reports handling sub reports and defining query for generating drill down reports in SSRS.
* Creating multiple parameterized stored procedures which were used by the reports to get the data.
* Working on formatting SSRS reports using the Global variables and expressions * Creating parameterized reports, Drill down and Drill through reports using SSRS to create error failure reports.
* Azure Data Factory * Implementing ETL and data movement solutions using Azure Data Factory, SSIS create and run SSIS Package ADF V2 Azure-SSIS IR * Designing and implementing database solutions in Azure SQL Data Warehouse, Azure SQL * Recreating existing application logic and functionality in the Azure Data Lake, Data Factory, SQL Database and SQL data warehouse environment, experience in DWH/BI project implementation using Azure Data Factory * Migrate data from traditional database systems to Azure databases * Implementing Copy activity, Custom Azure Data Factory Pipeline Activities for On-cloud ETL processing * Lifting and Shifting with Azure SQL Database + SSIS in Azure Data Factory
SENIOR DATABASE ADMINISTRATOR
MENCAP CHARITY
2023-09 - 2023-09
* Migration of 100 Access databases to Microsoft SQL Server * Split Access database into Front End and Back End and then linking the front end to the back end before migration to SQL server.
* Resolve issues arising from incompatible queries, datatypes, and Visual Basic Applications (VBA) functions, if any after migration * Optimize the performance of the back-end SQL Server by putting logic on the server, avoiding heterogeneous queries, using views in forms and reports in Access, and minimizing loading data in them * Configuring Query Store in SQL Server to capture and fix slow running queries Business as Usual * Maintained SQL Server Database; ensured accuracy of information and automated numerous functions.
* Fine tuning of database objects and server to ensure efficient data retrieval.
* Monitor and optimize system performance using SQL Profiler and Database Engine Tuning Advisor * Designed and implemented incremental and full back up policies and procedures.
* Created and implemented database design solutions in collaboration with programming team.
* Developed user defined functions and triggers to implement the requirements of the business.
* Performed database logical and physical design, maintenance, tuning, archiving, backups, replication, recovery, software upgrades, capacity planning and optimization for SQL Server database.
* Migration of all Server objects to a new Server * Analyzing, consolidating and tuning databases and servers for optimal efficiency * Used database consistency checks using DBCC utilities.
* Experience in creating database Objects like Tables, Stored Procedures, Views, Triggers, user defined data types and functions.
* Responsible for day to day tasks like re-indexing, checking integrity, backup and recovery 2) Extensive use of SSIS and SSRS * Consolidating and optimizing available data warehouse infrastructure * Planning, Co-coordinating analysis, design and extraction of encounter data from multiple source systems into the data warehouse relational database while ensuring data integrity * Developing, documenting and validating complex business rules vital for data transformation * Carrying out monitoring, tuning, and database performance analysis
* Resolve issues arising from incompatible queries, datatypes, and Visual Basic Applications (VBA) functions, if any after migration * Optimize the performance of the back-end SQL Server by putting logic on the server, avoiding heterogeneous queries, using views in forms and reports in Access, and minimizing loading data in them * Configuring Query Store in SQL Server to capture and fix slow running queries Business as Usual * Maintained SQL Server Database; ensured accuracy of information and automated numerous functions.
* Fine tuning of database objects and server to ensure efficient data retrieval.
* Monitor and optimize system performance using SQL Profiler and Database Engine Tuning Advisor * Designed and implemented incremental and full back up policies and procedures.
* Created and implemented database design solutions in collaboration with programming team.
* Developed user defined functions and triggers to implement the requirements of the business.
* Performed database logical and physical design, maintenance, tuning, archiving, backups, replication, recovery, software upgrades, capacity planning and optimization for SQL Server database.
* Migration of all Server objects to a new Server * Analyzing, consolidating and tuning databases and servers for optimal efficiency * Used database consistency checks using DBCC utilities.
* Experience in creating database Objects like Tables, Stored Procedures, Views, Triggers, user defined data types and functions.
* Responsible for day to day tasks like re-indexing, checking integrity, backup and recovery 2) Extensive use of SSIS and SSRS * Consolidating and optimizing available data warehouse infrastructure * Planning, Co-coordinating analysis, design and extraction of encounter data from multiple source systems into the data warehouse relational database while ensuring data integrity * Developing, documenting and validating complex business rules vital for data transformation * Carrying out monitoring, tuning, and database performance analysis
LEAD DATA WAREHOUSE DEVELOPER
BRIGHTON & SUSSEX UNIVERSITY HOSPITALS NHS TRUST
2023-09 - 2023-09
(DBA/SSIS/SSRS) DATA WAREHOUSE PROJECT
ALAMAC LTD
2023-09 - 2023-09
BIRMINGHAM APR 10, 2018 - AUG 15 2019 * Azure Data Factory * Implementing ETL and data movement solutions using Azure Data Factory, SSIS create and run SSIS Package ADF V2 Azure-SSIS IR * Designing and implement database solutions in Azure SQL Data Warehouse, Azure SQL * Recreating existing application logic and functionality in the Azure Data Lake, Data Factory, SQL Database and SQL data warehouse environment, experience in DWH/BI project implementation using Azure Data Factory
DBA/ DATABASE ANALYST / DATA WAREHOUSE DEVELOPER
TALK TALK TELECOMMUNICATION
2023-09 - 2023-09
* Project Objective * Migration of over two thousand databases which are SQL Server 2000 to 2012 versions to SQL Server 2016 strategic platform.
* Each database will be thoroughly analyzed and recommended for either migration, upgrading, merging or decommission.
* Each database will be thoroughly analyzed and recommended for either migration, upgrading, merging or decommission.
DATA WAREHOUSE DEVELOPER, SSIS/DBA
TELETRAC NAVMAN
2023-09 - 2023-09
DATA WAREHOUSE DEVELOPER
THE DENTAL DIRECTORY
2023-09 - 2023-09
SQL ANALYST AND SSRS REPORT DEVELOPER
EAST & NORTH HERTFORDSHIRE NHS TRUST
2023-09 - 2023-09
SQL ANALYST AND SSRS/ SSIS DEVELOPER
SURREY AND BORDERS PARTNERSHIP NHS FOUNDATION
2023-09 - 2023-09
LEAD DATABASE ADMINISTRATOR / SSRS DEVELOPER
CHARLES RUSSELL SPEECHLYS LAW FIRM
2023-09 - 2023-09
Role SSRS DEVELOPER, SQL ANALYST AND SSRS/ SSIS DEVELOPER, SQL ANALYST AND LEAD SSRS/ SSIS DEVELOPER
SSRS DEVELOPER
NORTHWEST LONDON NHS FOUNDATION TRUST
2023-09 - 2023-09
DATABASE ADMINISTRATOR / SSIS DEVELOPER / SSRS DEVELOPER
2023-09 - 2023-09
CENTRAL AND NORTHWEST LONDON NHS FOUNDATION TRUST
2023-09 - 2023-09
Business Intelligence Developer / DBA
Geodis Logistic Europe
2022-04 - 2022-08
Developed or modifies procedures to solve complex problems.
Designed and codes screen layouts, printed outputs and interfaces with other systems.
Converted designs and specifications into computer code.
Created test scenarios and runs tests to find errors and confirm programs meet specifications.
Analyse code to find causes of errors and revises programs.
Involved Requirements Gathering from the Business Users, Design and Develop workflows.
Involved database design process data modelling process for application using MS-Visio and SQL database diagrams Involved Data mapping, Column mapping maintain data dictionaries Data models Involved creating, maintaining different SQL Server Objects such Tables, Procedures, Functions, Views, CTE's, Triggers etc.
Involved in writing complex SQL Scripts using dynamic sql for loading data into maintenance tables.
Extensively used SSIS Data Profiler Task to profile target source systems (tables & views) prior to building ETL solutions, which was instrumental in cleaning data for data consistency and designing table structures.
Built various SSIS packages having different tasks and transformations for various clients and Scheduled SSIS packages.
Loaded of tables from DB2/ Oracle tables and CSV files to SQL Server performed every night across multiple systems.
Used Sub queries, joins, CTE's and Analytical functions for data retrieval.
Designed and codes screen layouts, printed outputs and interfaces with other systems.
Converted designs and specifications into computer code.
Created test scenarios and runs tests to find errors and confirm programs meet specifications.
Analyse code to find causes of errors and revises programs.
Involved Requirements Gathering from the Business Users, Design and Develop workflows.
Involved database design process data modelling process for application using MS-Visio and SQL database diagrams Involved Data mapping, Column mapping maintain data dictionaries Data models Involved creating, maintaining different SQL Server Objects such Tables, Procedures, Functions, Views, CTE's, Triggers etc.
Involved in writing complex SQL Scripts using dynamic sql for loading data into maintenance tables.
Extensively used SSIS Data Profiler Task to profile target source systems (tables & views) prior to building ETL solutions, which was instrumental in cleaning data for data consistency and designing table structures.
Built various SSIS packages having different tasks and transformations for various clients and Scheduled SSIS packages.
Loaded of tables from DB2/ Oracle tables and CSV files to SQL Server performed every night across multiple systems.
Used Sub queries, joins, CTE's and Analytical functions for data retrieval.
Certifications
Information Technology, Project Management Microsoft Certified Technology Specialist (MCTS) SQL Server 2008, Implementation and Maintenance Candidate Profile 2008 Prince II Certification Microsoft Certified IT Professional (MCITP) Database Administrator
Microsoft Certified Technology Specialist
Microsoft Certified IT Professional
Certified Technology Specialist
Certified IT Professional
Certified Technology
Microsoft Certified
MCITP
MCTS