$$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Expert
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Senior SQL Consultant
Habib Khan
,
Rochdale, United Kingdom
Experience
Other titles
Skills
I'm offering
I am a self-motivated, industrious and passionate SQL Server Specialist I possess outstanding skills and abilities, with experience working in retail, finance and telecommunications sectors. I am a results-driven individual and have demonstrated first class analytical and problem-solving skills, with organisational acumen and the ability to work well under pressure. I have a proven ability in delivering projects to agreed timescales and am an expert in mastering new skills in a short timeframe. I have strong communication skills and can present technical and non-technical information to all staff levels, customers and board members. I am an adaptable person, offering excellent client-facing skills and an in-depth understanding of technical and non-technical issues and requirements. My core skillset is built around Microsoft SQL database platforms having worked with SQL Server technologies for around 15 years working in lots of different business sectors covering all aspects of DBA/Development and BI roles CAREER HIGHLIGHTS • Architected/Upgraded MS SQL Instances from various versions and implemented HADR/DR and replication/Snapshots • Full Stack DBA and Managed and lead Database Teams as a Senior DBA and worked as a sole DBA also doing various roles which have included SQL Development and BI work • Worked for various large blue-chip orgs and also smaller orgs in various sectors • Designed and developed MSSQL Databases, Tables, Procs, Triggers, Views, Functions, Cursors, CTEs to an advanced level • Designed and Developed Business Critical and complicated ETL solutions for various businesses which are still being used long after leaving • Performance Tuned and monitored DB instances/Queries using Execution plans etc • Setup databases in the cloud and setup new managed databases instances RDS/Azure • Researched and developed new technologies in various roles throughout my career offering consultancy and implementation of such technologies e.g. New SQL versions/Features/Tools etc • Come from a technical background and have worked as a systems administrator and know my way around domains and can easily cross train and move back into this area • Microsoft Certifications
Markets
United Kingdom
Language
English
Fluently
Ready for
Larger project
Ongoing relation / part-time
Full time contractor
Available
My experience
2019 - 2020
freelance
Contract SQL DBA Consultant
Lloyds Bank.
Hired as a SQL Server Specialist to sit within the projects team to help them identify and remediate outstanding legacy Databases still requiring to be decommissioned. Wrote powershell scripts to speed up the remediation process as a lot of the checks previously were manual.
Key Tasks:
• DBA: Project to decommission 1000s of legacy databases/instances
• Consultancy: Liaise with project office in order to identify SQL databases/instances that are yet to be decommissioned
• DEV: Create Powershell scripts to carry out server analysis and auto generate SQL Decom scripts
• Support: Decommission Servers and update worksheets
• Support: Report back to project office progress
Key Tasks:
• DBA: Project to decommission 1000s of legacy databases/instances
• Consultancy: Liaise with project office in order to identify SQL databases/instances that are yet to be decommissioned
• DEV: Create Powershell scripts to carry out server analysis and auto generate SQL Decom scripts
• Support: Decommission Servers and update worksheets
• Support: Report back to project office progress
Sql, SQL Server, PowerShell, Support, Office, Server, UP
2018 - 2019
temp
Contract SQL DBA/BI Developer
Autocab.
Hired to work as a sole DBA with contact with all areas of the business and senior management and directors in order to firstly implement a GDPR policy and secondly provide support and administration of their large database estate.
Key Tasks:
• Consultancy: Implemented GDPR data strategy
• DBA: Performance tuned Azure SQL databases/Azure DW - monitoring and applying indexes to ensure stats are correct
• DBA: Archive/delete data from large tables where data has been pushed to DW, reduced database size from 500gb+ to 200gb in order to reduce storage cost and increase performance of the main app Database system
• DBA: Performance tuned Azure DW - by ensuring the table distributions types are correct and indexes are of the correct type e.g. hash/round robin distributions and column store indexes
• BI: Created Tableau dashboards and visualisations
• DEV: development processes are followed correctly such as source control(bitbucket)
• DBA: Implemented monitoring of DBs via intelligent insights/data studio
• DEV: Develop ETL/ET tasks for BI needs to retrieve data from ghost/phantom telephone and mobile app data
• DEV: Use PowerShell to archive/delete terabytes of data using powershell
• DEV: Created process/code to anonymise data for right to be forgotten requests
Key Tasks:
• Consultancy: Implemented GDPR data strategy
• DBA: Performance tuned Azure SQL databases/Azure DW - monitoring and applying indexes to ensure stats are correct
• DBA: Archive/delete data from large tables where data has been pushed to DW, reduced database size from 500gb+ to 200gb in order to reduce storage cost and increase performance of the main app Database system
• DBA: Performance tuned Azure DW - by ensuring the table distributions types are correct and indexes are of the correct type e.g. hash/round robin distributions and column store indexes
• BI: Created Tableau dashboards and visualisations
• DEV: development processes are followed correctly such as source control(bitbucket)
• DBA: Implemented monitoring of DBs via intelligent insights/data studio
• DEV: Develop ETL/ET tasks for BI needs to retrieve data from ghost/phantom telephone and mobile app data
• DEV: Use PowerShell to archive/delete terabytes of data using powershell
• DEV: Created process/code to anonymise data for right to be forgotten requests
Developer, Processes, App, Storage, BEE, Development, Monitoring, Azure SQL, Support, Sql, PowerShell, Management, Tableau, GDpr, ETL, Database, Azure, Administration
2016 - 2018
job
Senior SQL DBA/Developer
JDSports.
Initially I was the sole DBA at JD Sports and later hired and grew my team into a larger team consisting of DBA in India and the UK. I delivered lots of key milestones and achievements during this time as the business continued to outperform and innovate. The data was massively critical and support for multichannel department.
Key Tasks:
• Management: Managed the Data Team and MSSQL databases (team of 3 and most senior), in charge of training/hiring and leading database changes.
• DBA: Cloud Migration - Move databases from on premise to cloud SQL Server instances
• DBA: Database Migration - database migration to Azure
• ETL: Sales Force - use Talend to move data from oracle/salesforce to MSSQL and write SQL
• DBA: Database Configuration - Reviewed database settings to ensure all settings are optimal for SQL instances on cloud e.g. memory usage/MAXDOP settings/Adhoc queries.
• Support: Storage - Checked storage requirements and costs for cloud
• DBA: Indexing Stats - Reviewed stats updates and amended them as well as Reindexing/backup policies
• Auditing - SQL server auditing on key tables
• DBA: Performance Tune- optimising querys and ensuring indexes are correct
• DEV: Refactor code - Rewrote stored procedures/views/functions to speed them up
• Database Design - Liaised with Developers to create new databases for ERP data integrations and designed them to ensure best policies are met, with the right indexes and created using normalisation and FK constraints
• Consultancy: Consulted with external contractors to bring inhouse Talend/MCRM jobs that are importing data from external sources to Oracle
Consulted with IIB/oms/fluent/Anatwine to support drop shipping of products and integrate external ERP warehouse data such as dolphin, xentrprise
• Support: Provide support for fredhopper external feeds and other feeds such as mesh to ensure they are running correctly
• Reporting - Provided many different reports to business stakeholders which have been setup using many different ways such as SQL Agent/ FTP using SSIS etc
• Training - Knowledge transfer, training for peers
Key Tasks:
• Management: Managed the Data Team and MSSQL databases (team of 3 and most senior), in charge of training/hiring and leading database changes.
• DBA: Cloud Migration - Move databases from on premise to cloud SQL Server instances
• DBA: Database Migration - database migration to Azure
• ETL: Sales Force - use Talend to move data from oracle/salesforce to MSSQL and write SQL
• DBA: Database Configuration - Reviewed database settings to ensure all settings are optimal for SQL instances on cloud e.g. memory usage/MAXDOP settings/Adhoc queries.
• Support: Storage - Checked storage requirements and costs for cloud
• DBA: Indexing Stats - Reviewed stats updates and amended them as well as Reindexing/backup policies
• Auditing - SQL server auditing on key tables
• DBA: Performance Tune- optimising querys and ensuring indexes are correct
• DEV: Refactor code - Rewrote stored procedures/views/functions to speed them up
• Database Design - Liaised with Developers to create new databases for ERP data integrations and designed them to ensure best policies are met, with the right indexes and created using normalisation and FK constraints
• Consultancy: Consulted with external contractors to bring inhouse Talend/MCRM jobs that are importing data from external sources to Oracle
Consulted with IIB/oms/fluent/Anatwine to support drop shipping of products and integrate external ERP warehouse data such as dolphin, xentrprise
• Support: Provide support for fredhopper external feeds and other feeds such as mesh to ensure they are running correctly
• Reporting - Provided many different reports to business stakeholders which have been setup using many different ways such as SQL Agent/ FTP using SSIS etc
• Training - Knowledge transfer, training for peers
Database design, Agent, UP, Server, Storage, Backup, Support, Shipping, Developer, Ssis, Stored procedures, Sales, Management, Design, Salesforce, ETL, Cloud, Database, MSSQL, ERP, Training, Azure, Oracle, SQL Server, Sql
2014 - 2016
job
Senior SQL Server DBA
Fanatics International.
As a DBA within a fairly technical department and team of 5, I was trusted to deliver key projects and milestones for business-critical systems. I was involved in the end to end life cycle during these projects which involvement from all interfaces of the business and senior management.
Key Tasks:
• Dev: Resigned and developed a new ETL task to replace fredhopper data feeds this was a 6 weeks project that took extensive work to integrate and replace the old system. making it faster/more configurable/easy to deploy. It was previously taking hour's to setup the feed for each site and used to take an hour to send data for each site to fredhopper, once rewritten the packages were taking less than 20 mins for the daily and less than 5 mins for the incremental and could be configured within minutes.
• Dev: Redesigned and developed a new ETL task to replace biztalk which was being used to process critical purchasing and stock inventories. The new system was much faster instead of recursively through biztalk, this project lasted around 6 months and required extensive testing due to how business critical it was.
• Consultancy - Help developers write SQL, source control SQL, and release the code
• BI: work on ETL/ELT process to move data to staging and DW and make changes to the facts dimensions for new reports from the DW
• DBA: Upgraded the DB estate to From SQL 2005 to SQL 2014 with HADR always on and readable replica
• DBA: Optimise Slow performing Queries/Sprocs by adding indexes using Query Execution Plans and SQL Sentry Monitoring
Key Tasks:
• Dev: Resigned and developed a new ETL task to replace fredhopper data feeds this was a 6 weeks project that took extensive work to integrate and replace the old system. making it faster/more configurable/easy to deploy. It was previously taking hour's to setup the feed for each site and used to take an hour to send data for each site to fredhopper, once rewritten the packages were taking less than 20 mins for the daily and less than 5 mins for the incremental and could be configured within minutes.
• Dev: Redesigned and developed a new ETL task to replace biztalk which was being used to process critical purchasing and stock inventories. The new system was much faster instead of recursively through biztalk, this project lasted around 6 months and required extensive testing due to how business critical it was.
• Consultancy - Help developers write SQL, source control SQL, and release the code
• BI: work on ETL/ELT process to move data to staging and DW and make changes to the facts dimensions for new reports from the DW
• DBA: Upgraded the DB estate to From SQL 2005 to SQL 2014 with HADR always on and readable replica
• DBA: Optimise Slow performing Queries/Sprocs by adding indexes using Query Execution Plans and SQL Sentry Monitoring
Sql, SQL Server, ETL, Management, Less, It, Testing, Monitoring, BizTalk, BEE, Server, Performing
2013 - 2014
job
SQL DBA
Carcraft.
I was hired initially to upgrade the database estate from SQL 2000 and later continued to provide database support and development which involved director level involvement with senior management.
• DBA: Upgraded DB estate from SQL Enterprise 2000 to SQL 2018 r2
• DBA: Supported the DB estate - manage backups, schedule and manage releases etc
• DBA: Performance tune - re-index databases and ensure indexes are optimum, rewrite code to optimize where necessary
• DBA: Resolve blocking/deadlocking issues related to poor code
• DEV: Developed lots of ETL packages (SSIS) and update others where necessary e.g. CAP data downloads, RAC uploads etc
• DBA: Upgraded DB estate from SQL Enterprise 2000 to SQL 2018 r2
• DBA: Supported the DB estate - manage backups, schedule and manage releases etc
• DBA: Performance tune - re-index databases and ensure indexes are optimum, rewrite code to optimize where necessary
• DBA: Resolve blocking/deadlocking issues related to poor code
• DEV: Developed lots of ETL packages (SSIS) and update others where necessary e.g. CAP data downloads, RAC uploads etc
Sql, Database, ETL, Management, Ssis, Support, Development, Enterprise
2012 - 2013
job
SQL Production DBA
RAF Benevolent Fund.
Worked as DBA supporting Calyx Managed Instances for Large Clients Such as IPSA/RAF Benevolent Fund/Jaguar etc, in total I was managing up to 80 Database Servers.
Key Tasks
• Support - Dealing with Support calls relating to Service requests/problems/incidents/changes internally and externally
• DBA - databases instances for applications such as MSCRM/SHAREPOINT/SCOM/NIMBUS/BACKUP EXEC/Blackberry/SCRIBE and many more with terabytes of information on some database warehouses.
• DBA - Carrying out routine checks and advisories regarding backup and recovery policies, Best Practices
• Consultancy/Pre-Sales - Liaising with Pre sales and consultants to advise regarding SQL Server service requests such as implementation of new instances/upgrades/adding new tools etc. Work with external clients to fulfil managed services requests such as DB upgrades.
Key Tasks
• Support - Dealing with Support calls relating to Service requests/problems/incidents/changes internally and externally
• DBA - databases instances for applications such as MSCRM/SHAREPOINT/SCOM/NIMBUS/BACKUP EXEC/Blackberry/SCRIBE and many more with terabytes of information on some database warehouses.
• DBA - Carrying out routine checks and advisories regarding backup and recovery policies, Best Practices
• Consultancy/Pre-Sales - Liaising with Pre sales and consultants to advise regarding SQL Server service requests such as implementation of new instances/upgrades/adding new tools etc. Work with external clients to fulfil managed services requests such as DB upgrades.
Sql, SQL Server, SharePoint, Database, SoMe, Sales, Service, Implementation, Support, Backup, Server, Production, UP, Many more
2010 - 2012
job
SQL DBA
Conferma.
I started as a Junior DBA for a start-up company in Manchester for whom I was the first to setup SSRS and lots of critical business repot as well as many Key ETL tasks to process their virtual card client information which was sent out and received by some of their large banking and business partners such as Barclays, AMEX, CO-OP etc. The were lots of achievements in this role and there are systems still being used by Conferma.
Key Tasks:
• DBA - SQL Server 2005/2008 R2 Enterprise Edition, Manage backups, failover in clustered environments, user credentials and general performance related enquiries.
• Security - PCI Compliance
• Development - Worked on projects to develop BI reports and ETL SSIS, stored procedures/triggers/views/functions for business requirements etc
• BI - setup and maintained maintenance of business reports, SSRS
• ETL - automate ETL processes, run reports from table config, pgp encryption etc
• ETL - Create new Processes to handle key financial processes
• Release Management - rollout/assess SQL changes and access business impact
• Support tasks - support the SQL Server environment/performance/patching and day to day related administration
• Other - technical support for the network servers/active directory and desktops
Key Tasks:
• DBA - SQL Server 2005/2008 R2 Enterprise Edition, Manage backups, failover in clustered environments, user credentials and general performance related enquiries.
• Security - PCI Compliance
• Development - Worked on projects to develop BI reports and ETL SSIS, stored procedures/triggers/views/functions for business requirements etc
• BI - setup and maintained maintenance of business reports, SSRS
• ETL - automate ETL processes, run reports from table config, pgp encryption etc
• ETL - Create new Processes to handle key financial processes
• Release Management - rollout/assess SQL changes and access business impact
• Support tasks - support the SQL Server environment/performance/patching and day to day related administration
• Other - technical support for the network servers/active directory and desktops
Compliance, SQL Server 2005, UP, Processes, Enterprise, Server, BEE, Development, Support, SSRS, Security, Sql, Banking, Ssis, Network, Stored procedures, Management, SoMe, ETL, Active Directory, SQL Server, Administration
2006 - 2010
job
3rd Line Operations Support Engineer
TalkTalk.
I was at Talktalk from when they were still a fairly new organisation and achieved a great deal whilst I was there, but the key milestone project that I worked on was to deliver Wholesale calls which saved them 9 Million annually. I liaised with senior management and key business stakeholders to deliver this project.
Key Tasks:
• Support - providing support various teams within the organisation to ensure that problems are resolved in a timely manner according to agreed SLAs
• Team Lead - Manage the EDB/DQ Product and Junior Colleagues
• Project Lead - Wholesale Calls Customer Migration (Saving 9 million per annum)
• Business Analysis - understanding various business processes in order to provide technical support when problems occur and looking to automate common tasks where possible
• Monitoring performance and integrity of supported applications - e.g. Databases, Web servers, bespoke applications, reporting jobs, gateways, etc.
• Providing On call Support - evenings and weekends as part of a team rota
• Providing Training - For new team members, junior engineers.
• Creating Technical Documents - In order to train team members and share knowledge of key systems/projects.
Key Tasks:
• Support - providing support various teams within the organisation to ensure that problems are resolved in a timely manner according to agreed SLAs
• Team Lead - Manage the EDB/DQ Product and Junior Colleagues
• Project Lead - Wholesale Calls Customer Migration (Saving 9 million per annum)
• Business Analysis - understanding various business processes in order to provide technical support when problems occur and looking to automate common tasks where possible
• Monitoring performance and integrity of supported applications - e.g. Databases, Web servers, bespoke applications, reporting jobs, gateways, etc.
• Providing On call Support - evenings and weekends as part of a team rota
• Providing Training - For new team members, junior engineers.
• Creating Technical Documents - In order to train team members and share knowledge of key systems/projects.
Business Analysis, Operations, Training, Management, Support, Monitoring, Web, Organization, Wholesale, Processes
2006 - 2006
job
IT Technician/DBA
Quay Connect.
It
2005 - 2006
temp
Contract Decommissioning Engineer
Siemens.
Habib's reviews
Habib has not received any reviews on Worksome.
Contact Habib Khan
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Habib directly in Worksome.
38100+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark