$$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Expert
{{ $t($store.state.user.experience_search_name) }}
0
jobs
database administrator/developer
Ken Watkinson
,
Ash Vale, United Kingdom
Experience
Other titles
Skills
I'm offering
A professional database administrator/developer with 20 years’ experience managing enterprise level solutions. Extensive experience supporting production environments and development teams. Installed and supported highly availably installations for large and complex solutions. Performance tuning of indexes, stored procedures and execution plans. Thorough understanding of all aspects of internal SQL Server Processing. Exposure and experience of migrating legacy version of SQL. Working under the ITIL framework throughout entire professional career.
Markets
United Kingdom
Links for more
Once you have created a company account and a job, you can access the profiles links.
Language
English
Fluently
Ready for
Larger project
Ongoing relation / part-time
Full time contractor
Available
My experience
2020 - 2020
freelance
SQL Consultant
Sitoc.
To design and build a high availability cluster (SQL 2016 AlwaysOn) and also assist with the migrate the existing databases across to the new platform.
Design, Sql
2019 - 2020
freelance
MSSQL Database Consultant
Eurolink.
Database Design, Build and tuning
Optimization of current platform
Cross platform migration to MYSQL from MSSQL 2008
Implement Best practices for the developers
MSSQL Training course for the developers
Evaluate new function in SQL
Optimization of current code
Performance benchmarking of code changes
Optimization of current platform
Cross platform migration to MYSQL from MSSQL 2008
Implement Best practices for the developers
MSSQL Training course for the developers
Evaluate new function in SQL
Optimization of current code
Performance benchmarking of code changes
Design, Mysql, Sql, Training, MSSQL, Database, Database design, Tuning
2019 - 2019
job
SQL Database Administrator
Esteem.
Esteem are a Managed service provider, my role with in the organization was to support the end client and give consultancy services.
Main activities and responsibilities:
• Build new MSSQL 2017 Basic AlwaysOn multi Instance Solution
• Migration of their 118 Database from 2000 to 2012 onto 2017
• Document and agree migration approach with the client
• Day to day support of their current environment
Main activities and responsibilities:
• Build new MSSQL 2017 Basic AlwaysOn multi Instance Solution
• Migration of their 118 Database from 2000 to 2012 onto 2017
• Document and agree migration approach with the client
• Day to day support of their current environment
Sql, MSSQL, Database, Service, Support, Administrator, Basic
2013 - 2018
job
SQL Database administrator
Kier Group PLC.
Kier Group plc is a leading construction, services and property group specializing in building and civil engineering, support services, residential and commercial property development and infrastructure project investment.
Held role within the Database administration team, responsible for the day to day running (BAU) as well as active participation in project delivery.
This included design, installation and delivery of new installations and solutions.
Role included designing new BI reports utilizing SSRS and SSIS for data collection and analysis.
Currently working in a demanding production support environment and managing large volume of business-critical data.
Estate compromises 500+ SQL installations, which is a mixture of SQL 2000 to 2016 standard and enterprise.
Main activities and responsibilities:
• implementing best practices solutions and documentation for the team
• capacity management of instances - proactive and reactive
• supported 500+ SQL instance.
• supported/installed 3 SQL geo-clusters
• Designed and implemented several SSRS reports for the SQL team and the client base.
• SQL Performance tuning and optimization
• resolving platform architecture compatibility issues
• patching procedures, backups and restores, disaster recovery planning
• production experience with T-SQL, SSIS, DTS and SSRS
Held role within the Database administration team, responsible for the day to day running (BAU) as well as active participation in project delivery.
This included design, installation and delivery of new installations and solutions.
Role included designing new BI reports utilizing SSRS and SSIS for data collection and analysis.
Currently working in a demanding production support environment and managing large volume of business-critical data.
Estate compromises 500+ SQL installations, which is a mixture of SQL 2000 to 2016 standard and enterprise.
Main activities and responsibilities:
• implementing best practices solutions and documentation for the team
• capacity management of instances - proactive and reactive
• supported 500+ SQL instance.
• supported/installed 3 SQL geo-clusters
• Designed and implemented several SSRS reports for the SQL team and the client base.
• SQL Performance tuning and optimization
• resolving platform architecture compatibility issues
• patching procedures, backups and restores, disaster recovery planning
• production experience with T-SQL, SSIS, DTS and SSRS
Ssis, Tuning, Enterprise, Production, Administrator, BEE, Development, Data collection, Infrastructure, Support, SSRS, Design, PLC, Engineering, Architecture, T-SQL, Management, Database administration, Database, Administration, Sql
2011 - 2013
job
SQL Database Administrator
British Gas \ Centrica Energy.
Centrica is a top 30 FTSE100 company. And is leading integrated energy company in the UK and North America. There is a mixture of oracle and SQL DBA's managing a large number of server my team consisted of fourteen MSSQL DBA's, which was split into two teams BAU and Projects, myself in BAU team which was to keep the day to day running of all are SQL server running and optimized, as well as making sure all backups were operating as normal.
Main activities and responsibilities:
• creating best practices documentation for the business
• Capacity Management of instances
• Supporting around 800 SQL instance.
• supporting around 30 SQL geo-clusters
• Creating SSRS reports for the SQL team and for the business.
• SQL Performance tuning and optimization
• Resolving platform architecture compatibility issues
• Patching procedures, backups and restores, disaster recovery planning
• Production experience with T-SQL, SSIS, DTS and SSRS
Main activities and responsibilities:
• creating best practices documentation for the business
• Capacity Management of instances
• Supporting around 800 SQL instance.
• supporting around 30 SQL geo-clusters
• Creating SSRS reports for the SQL team and for the business.
• SQL Performance tuning and optimization
• Resolving platform architecture compatibility issues
• Patching procedures, backups and restores, disaster recovery planning
• Production experience with T-SQL, SSIS, DTS and SSRS
Sql, SQL Server, Oracle, MSSQL, Database, Management, T-SQL, Architecture, Ssis, SSRS, Server, Administrator, Production, Energy, Tuning, Energy
2007 - 2011
job
Production Databases Administrator
(BCA) British Car Auctions.
I started with BCA (British Car Auctions) for a six week contract to help implement a new SQL disaster recovery solution and also to work beside the permanent DBA's with the day to day tasks, BCA has a large number of SQL server around 130 mixer of production and development environments as well as four clusters with around 18 instances, my contract was then extended and I was then there for a further eighteen months until they recognized the need to employ a fifth full time DBA this has been a very interesting and very demanding role.
Duties
• Support the production environments and development teams.
• Migration from are SQL 2000 to SQL 2005 clusters
• Installation of MSSQL 2000 and 2005 in to 2003 clusters
• Creating reports in SSRS for internal systems monitoring.
• Setting mirroring between are production and DR sites
• Setting up replication feeds using my own custom stored procedures.
• Setting up log shipping between production and DR servers
• Health check's and monitoring via SQL tools and TSQL
• Installation of 2000,2005 and 2008 enterprise editions
• Building ETL DTS and SSIS packages for the business
• Checking TSQL developer's code before running the code into production.
• Following strict change control processes for any changes made to the production SQL instances via a change approval board.
Duties
• Support the production environments and development teams.
• Migration from are SQL 2000 to SQL 2005 clusters
• Installation of MSSQL 2000 and 2005 in to 2003 clusters
• Creating reports in SSRS for internal systems monitoring.
• Setting mirroring between are production and DR sites
• Setting up replication feeds using my own custom stored procedures.
• Setting up log shipping between production and DR servers
• Health check's and monitoring via SQL tools and TSQL
• Installation of 2000,2005 and 2008 enterprise editions
• Building ETL DTS and SSIS packages for the business
• Checking TSQL developer's code before running the code into production.
• Following strict change control processes for any changes made to the production SQL instances via a change approval board.
Support, UP, Processes, Enterprise, Production, Administrator, Server, Health, Development, Monitoring, Sql, Developer, SSRS, Shipping, Ssis, Stored procedures, MSSQL, ETL, SQL Server
2005 - 2007
job
Lead SQL Databases Administrator
Sophos.
Sophos is the world leader in integrated threat management solutions purpose-built for business, education, government and service providers. Protect over 35 million users in more than 150 countries from viruses and spam. My Job was to support their 40+ MSSQL 7, 2000 and MSSQL 2005 server and their MS SQL Cluster, my day to day jobs involved maintenance, performance tuning, SQL scripting, VB Scripting, SQL Job Scheduler, DTS, Backups, Restores query tuning and dead lock resolution.
Duties
• Mentoring a Junior DBA.
• Writing TSQL queries for internal Reporting for sales and Marketing
• Implement Best Practices for all 40+ SQL servers
• Implementation and Management of the Windows 2003 Cluster
• Implement MSSQL 2005 Server in are Vancouver office for BI Reporting
• Day to day management or are 40+ MSSQL 2000 Server
• Working with Business Intelligent for reporting purposes
• Securing all SQL server and security auditing
• Help Implementation of eGain Technical Support System globally
• Documentation for MS SQL Sever Builds
• Documentation of all existing MS SQL Server Builds
• Optimization of SQL Servers and Databases
• Service Packing of are SQL servers
• Disaster Recover planning
• Daily MSSQL Backup reporting via a Central Reporting Server
Duties
• Mentoring a Junior DBA.
• Writing TSQL queries for internal Reporting for sales and Marketing
• Implement Best Practices for all 40+ SQL servers
• Implementation and Management of the Windows 2003 Cluster
• Implement MSSQL 2005 Server in are Vancouver office for BI Reporting
• Day to day management or are 40+ MSSQL 2000 Server
• Working with Business Intelligent for reporting purposes
• Securing all SQL server and security auditing
• Help Implementation of eGain Technical Support System globally
• Documentation for MS SQL Sever Builds
• Documentation of all existing MS SQL Server Builds
• Optimization of SQL Servers and Databases
• Service Packing of are SQL servers
• Disaster Recover planning
• Daily MSSQL Backup reporting via a Central Reporting Server
Windows, Vb, Tuning, Administrator, Server, BEE, Office, Backup, Support, Implementation, Security, Marketing, Service, Sales, Management, MSSQL, Mentoring, Scripting, SQL Server, Writing, Sql
2000 - 2005
job
Senior System Support Analyst
Computer 2000.
Computer 2000 is the UK subsidiary of the TechData group; it employs around 500 staff in the UK with revenues of about £800 million. My role within the organization was to support our 160+ servers across five sites as well as the network and communications; we were also required to manage a number of ongoing projects. In our team of five we all had our own specialized areas, my area was support of our e-commerce team this involved knowledge of Windows NT 4.0 to Windows 2003, Microsoft SQL 2000, IIS 5.
Duties
• Server builds (Hardware, Operating System and applications)
• Consolidation of Server Farm.
• Security updates and patching of 160 Servers plus.
• In charge of logon scripts for all European sites written in "kixstart and vbscript".
• Managing the day to day backups of all five sites.
• Writing scripts to be deployed via MS SMS 2.0 for desktop and application changes.
• DTS Packages for are Business intelligent and Security Reporting
• Troubleshooting of MSSQL servers issues
• Security of are MSSQL server via Baseline Security Analyzer and other tools.
• Building and configuration of the MS SQL 2000 servers
• Writing Data transformation services (DTS) for departmental reporting.
• MSSQL 2000 Performance tuning and optimization (via profiler and Analyzer).
• SQL Server disaster recovery planning
• Migrating of existing databases from version 7 to 2000
• Microsoft Security updates and patching of all our MSSQL 2000 servers
Duties
• Server builds (Hardware, Operating System and applications)
• Consolidation of Server Farm.
• Security updates and patching of 160 Servers plus.
• In charge of logon scripts for all European sites written in "kixstart and vbscript".
• Managing the day to day backups of all five sites.
• Writing scripts to be deployed via MS SMS 2.0 for desktop and application changes.
• DTS Packages for are Business intelligent and Security Reporting
• Troubleshooting of MSSQL servers issues
• Security of are MSSQL server via Baseline Security Analyzer and other tools.
• Building and configuration of the MS SQL 2000 servers
• Writing Data transformation services (DTS) for departmental reporting.
• MSSQL 2000 Performance tuning and optimization (via profiler and Analyzer).
• SQL Server disaster recovery planning
• Migrating of existing databases from version 7 to 2000
• Microsoft Security updates and patching of all our MSSQL 2000 servers
IIS, Tuning, Server, Hardware, Analyst, Vbscript, Support, Transformation, Mssql server, It, Sql, Network, Security, Windows, MSSQL, Microsoft SQL, E-commerce, SQL Server, Writing
My education
1986
-
1987
Guildford County College of Technology
N/a, N/a
N/a, N/a
1982
-
1986
St Peters Roman Catholic Comprehensive School
HighSchoolOrEquivalent, N/a
HighSchoolOrEquivalent, N/a
Ken's reviews
Ken has not received any reviews on Worksome.
Contact Ken Watkinson
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Ken directly in Worksome.
38000+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark