Post Project
  • Search
    • Buyers can
    • Search offers to buy now
    • Search freelancers to request a proposal
    • Freelancers can
    • Search projects to quote on
  • How it works
  • Log in
  • Sign up
  • Freelancer?
Categories
    Technology & ProgrammingWriting & TranslationDesignDigital MarketingVideo, Photo & ImageBusinessMusic & AudioMarketing, Branding & SalesSocial Media
Technology & ProgrammingWriting & TranslationDesignDigital MarketingVideo, Photo & ImageBusinessMusic & AudioMarketing, Branding & SalesSocial Media
Ian Harries

Ian Harries

Senior DBA - Microsoft SQL Server

Gravesend, United Kingdom

English speaking

I'm a Senior SQL Server DBA with over 12 years of experience managing and improving SQL Server and associated technologies. My particular specialities include performance...Read moreI'm a Senior SQL Server DBA with over 12 years of experience managing and improving SQL Server and associated technologies.

My particular specialities include performance tuning and overall SQL Server estate improvement - I can help make your SQL Server databases faster, more secure and more efficient.

Contact me:
If you’re having difficulties with your SQL Server environment, or if you are looking to improve your use of SQL Server in order to:
● Future-proof your business
● Make your data more secure and comply with GDPR
● Make more efficient and cost effective use of the platform
● Find new ways to leverage the technology to add value to your business.

I’m UK trained, UK based and positioned to provide services globally. I have experience working in the Finance, Education and Healthcare sectors. I’m a Microsoft Certified Professional and Professional Member of the BCS. I’m familiar with GDPR and various governance standards, and can provide technical advice to help you protect your data and ensure compliance with legislation.

I can offer:
● Quick, short term troubleshooting and problem identification
● Consultancy and advice
● Ongoing maintenance and support (including out of hours)
● Extended improvement and development
● End-to-end project management using Agile or PRINCE2 methodologies

Examples of services I can provide:

SQL Server performance review
● Analyse your server and provide a report on how to improve performance

SQL Server security review
● Analyse your server and provide a report on how security can be improved

SQL Server configuration and maintenance review
● Analyse the configuration and deployment of your database servers and advise on how these can be improved to make them more robust. I’ll produce a drive architecture guideline to show efficient ways to deploy and configure SQL server, and provide advice on how to configure effective automated maintenance tasks of SQL Server

Upgrading SQL Server
● I’ll advise, plan and conduct a full upgrade of your SQL Server instance. I can advise on in-place or migration based upgrades, and provide solutions for zero or minimal downtime upgrades

Monitoring and Maintenance of SQL Server
● I’ll develop and document a strategy for effective maintenance and monitoring of SQL Server. I can provide solutions for any budget, leveraging in-built SQL Server features, bespoke packages, or advise on the use of various third-party options.

T-SQL Query Tuning and Performance Analysis
● Code reviews and tuning as well as active monitoring advising on configuration improvements

Report Writing
● Write custom T-SQL reports, and/or installation and configuration

Data Integration
● Provide solutions to moving your data around and any form of ETL functions required using SQL Server Integration Services. I can also advise you on how to upgrade legacy solutions such as BCP

Business Intelligence and Data Warehousing
● Provide advice on how to leverage the Microsoft BI stack and design and maintenance Data Warehouse solutions

Database Cloud Solutions
● Management of SQL Server databases in the cloud, including Manage Instances in Azure. Provide advice on how to migrate to or leverage cloud services

Training and Advice
● Provide training to your Database, Report Writing, Business Support, or Helpdesk teams in the use of SQL Server or T-SQL. Including how to effectively maintain or upgrade SQL Server, or multi-level troubleshooting methods for each support line. This can be with the use of in-built SQL Server tools, open source scripts or third-party tools

I can provide in-depth reports for any of these tasks for your DBA team to work with, or work with you to deliver changes as hands-on as you require. All work can be conducted remotely and on-site visits are feasible as well.

These are just examples of the types of SQL Server consultancy services I can offer, even if you’re not sure where in your database estate your problems are, I can provide initial reviews to help you know how to proceed.


Selected Skills:
● Microsoft SQL Server 2008-19, including installation and upgrades
● Ensuring SQL Server database integrity, security, high availability and performance
● Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS)
● Advanced T-SQL, PowerShell, .Net Framework, C#, IIS
● AlwaysOn (Availability Groups, Cluster Instances)
● VMware on premise and Microsoft Azure cloud
● Ola Hallengren’s database maintenance scripts
● Google Apps and Google Apps Scripts (GAS)
● Various project management methodologies
● Microsoft SharePoint (2010 and 2013)
● Visual Basic for Applications (VBA)
● JavaScript, inc. JQuery and Json
● Veeam backup & Redgate tools
● sp_blitz family, sp_WhoIsActive

  • £65
    /hr
Contact

Skills

database administrationstructured query language (sql)Microsoft SQLServerdatabase developmentmicrosoft sql azurePowerShell programming languageT-SQL programming language
Industry expertise: Construction, Education, Financial Services, Healthcare and IT

Insights

Freelancer Buyer
Projects listed
0
Freelancers worked with
0
Last active
Dec 09 2020
Response time
instantly

Insights

Freelancer Buyer
Projects worked on
0
Buyers worked with
0
Last active
Dec 09 2020
Response time
instantly

Skills

database administrationstructured query language (sql)Microsoft SQLServerdatabase developmentmicrosoft sql azurePowerShell programming languageT-SQL programming language
Industry expertise: Construction, Education, Financial Services, Healthcare and IT

Insights

Freelancer Buyer
Projects listed
0
Freelancers worked with
0
Last active
Dec 09 2020
Response time
instantly

Insights

Freelancer Buyer
Projects worked on
0
Buyers worked with
0
Last active
Dec 09 2020
Response time
instantly
Skills Insights

Insights

Freelancer Buyer
Projects listed
0
Freelancers worked with
0
Last active
Dec 09 2020
Response time
instantly

Insights

Freelancer Buyer
Projects worked on
0
Buyers worked with
0
Last active
Dec 09 2020
Response time
instantly
Skills Insights
database administrationstructured query language (sql)Microsoft SQLServerdatabase developmentmicrosoft sql azurePowerShell programming languageT-SQL programming language
Industry expertise: Construction, Education, Financial Services, Healthcare and IT
  • Reviews
  • Purchases
  • Endorsements
Hide feedback
The user has no activity as a Freelancer

Product

  • About
  • Team
  • Careers
  • Blog

Support

  • How it works
  • Trust & Safety
  • Help Centre

Discover

  • PeoplePerHour Plus
  • Academy

Resources

  • Customer Stories
  • Business Cost Calculator
  • Startup Cities

Browse

  • Freelance Services
  • Freelance Services By Country
  • Freelance Skills
  • Terms
  • Privacy
  • © 2021 People Per Hour Ltd
We use cookies to improve your experience and our services. By using PeoplePerHour, you agree to ourCookie Policy