Download PDF

Summary


Looking for a role requiring analytical challenges. Remote, South/East Wales, Borders, South West.
Availability: 1 month.

SQL Server skill summary

SQL Server Administration

Maintenance, data security, backup planning, disk infrastructure, GDPR. 10 years +

SQL Server Design/Development

Formal training. Vast experience. 2 * MCP exams. Provide StackOverflow assistance. 10 years +. 

SQL Server Optimisation

3+ years dedicated in very large, highly complex systems. Identifying bottlenecks, applying creative solutions/emergency workarounds.

AWS DBs RDS SQL Server WE 2017/DynamoDB

Migration, development, monitoring, assessing tiers/platforms for requirement. 1.5 years +

Database Theory

Formally trained in Relational and Object-Oriented DB theory. Have provided solutions implementing NoSQL within relational structures and with on-premise OO servers.

Warehousing Solutions

Provided warehousing solutions for early SQL Server releases, administered and authored dimensions in SSAS and migrated existing warehousing to Amazon Redshift. 2 years +

Work experience

DBA

  • Data governance.
  • Maintaining quality and responsiveness of applications
  • Influencing design and overall architecture of web applications.

SQL Server 2012 - 2017, AWS, RDS, Access, Visual Studio, C#, GitHub, LINQ, third party tools

Eurostop Ltd

2016-042019-06

Senior Support Analyst

  • Providing critical third-tier SQL Server support and optimisation to retail clients with VLDBs and demanding applications.
  • Advising and providing solutions from infrastructure to user interface.
  • Force behind moving to a NOSQL solution within relational db and removing business logic from applications.
  • Administered warehousing solutions in SSAS and migrating to Redshift

SQL Server 2000 - 2017, Visual Studio, C#, TFS,  SSAS, Redshift, numerous third party tools.

Cloudsafe Solutions

2015-052016-05

Business Owner

  • Provided full life-cycle, managed solutions, maintenance, documentation and support on a variety of development platforms.
  • Reinvented business to provide bolt-together cloud services instead of bespoke application development.
  • Sub-contracted through Comcraft Ltd. to provide QR Code integration and CM solutions.

Microsoft Project, SQL Server 2014, Access, VB6, Xero, Insightly, Workforce, various cloud services.

Self-employed

2013-122015-04

English Language Teacher, Tokyo

Obtained TEFL certification and offered English language assistance and proofreading at a local school and privately for adult learners.

Moko-shop, Redhill, Surrey

2004-022013-10

Business Creator and Software Developer

Oversaw family internet retail business, specialising in first edition books. Market research, developing stock control procedures, software, arbitrage tool creation, bar- code reader integration, shop-front web-site creation.

Shopify, SQL Server 2000 - 2012, Access, Excel, VBA, HTML.

Britannic Retirement Solutions, Redhill, Surrey

2000-062004-01

DBA/Senior Full-Stack Developer

  • Employed as a VB/SQL Server full-stack developer.
  • Within 2 months applied and won position of company DBA.
  • Provided design standards, maintenance routines, optimisation, data migration, documentation and quality control.
  • Authored search engines and ActiveX tools to automate version control.
  • Designed and implemented security model.
  • Force behind conversion to DCOM architecture.

SQL Server 2000, Visual Basic 6, Crystal Reports, SourceSafe, Access, Excel, VBA.

Diageo, Central London

2000-042000-06

CONTRACTED Software Developer(through Volt Europe)

  • Developed and managed full-life cycle of 'Project Refresh' facilities and software licence tracking application, suite of reporting tools, custom data replication manager. 

Microsoft Project, SQL Server 2000, Access, VB 6

Volt Europe, Redhill, Surrey

1999-042000-06

Analyst Programmer

  • Full-stack VB COM/N- tier and SQL Server repository model NOSQL development.
  • Authored  version control environment for build deployment in SourceSafe/VBA 
  • Developed smaller MSOffice CM and tracking applications for Volt clients.

VB, SQL Server 7.0, SourceSafe, Access, Excel

Deutsche Bank, City of London (through MMT Computing Ltd.)

1998-021999-04

CONTRACTED Y2K Programmer

  • Developed suite of tools for use by Y2K testers to analyse code within existing Access, VB, GW Basic, Excel, Clipper and Foxpro applications and report on Y2K errors encountered
  • Developed and maintained general financial and derivatives applications using RAD analysis/development techniques.
  • Converted financial applications to accept EMU.

SQL Server 7.0, Access, VB, Excel, Clipper, DBASEIII

West Wales Training and Enterprise, Swansea

1996-051997-12

CONTRACTED Full-Stack Developer

  • Sole developer on project re-designing/building MIS for the West Wales Training and Enterprise Initiative.
  • Design and development of a completely configurable report generator.

Access, VB, Informix, SQL Server.

Perfect Books, Bridgend, S.Wales

1996-011996-04

Application Developer

  • Converting an existing GWBasic solicitors' double-entry bookkeeping application to Microsoft Access 2.0.

GW Basic, Access 2.0

Education

University of Wales, Cardiff

19911995

Computing/Education Jnt. Hons.

Microsoft qualifications

  • 70-461: Querying Microsoft SQL Server 2012/2014
  • 70-761: Querying Data with Transact-SQL
    Verification: https://www.youracclaim.com/users/philip-thomas.40f48ce3
  • 70-051: Microsoft Access Application Development

Professional membership

References

Graham Field - Manager at Volt (Europe), owner Field Consultancy Ltd., 49 Wray Park Rd, Reigate RH20EQ 01737 221069, gaf@fieldconsultancy.co.uk

Deborah Loh - Marketing Manager at Eurostop Ltd., West Africa House, Ashbourne Rd, Hanger Hill, London W5 3QP 020 8991 2700, deborahl@eurostop.com

It is appreciated if my current employer is not contacted for a reference until an offer is accepted.