LinkedInBen Ritson
Ben Ritson

Ben Ritson

Database Administrator at Jet2.com

Location
Leeds, United Kingdom
Industry
Law Practice
Previous
  1. Simpson Millar LLP
Education
  1. Woodkirk High Specialist Science School
40connections

Join LinkedIn & access Ben's full profile

Join LinkedIn & access Ben's full profile. It's free!

As a LinkedIn member, you'll join 300 million other professionals who are sharing connections, ideas, and opportunities.

  • See who you know in common
  • Get introduced
  • Contact Ben directly
40connections
Woodkirk High Specialist Science School

Woodkirk High Specialist Science School

View full profile

Background

Summary

Currently working as a Database Administrator for Simpson Millar LLP solicitors in Leeds, I am responsible for the databases of the firm’s ten offices. I have been a loyal employee for five years, progressing from Post Room Assistant up to my current role after showing my enthusiasm and ability for database administration. I have successfully worked in my current role since November 2010.

I am also keen to progress my skills further outside of work and I am currently studying towards earning SQL 2012 certifications. I have recently been to SQL Saturday in Dublin, which is organised by PASS and Intend on going to SQL bits in the near future.

Experience

Database Administrator

Jet2.com
– Present (1 year 11 months)Leeds, United Kingdom

Database Administrator

Simpson Millar LLP
(2 years 4 months)Leeds, United Kingdom

I began working in my current role as Database Administrator in November 2010, when my predecessor moved on to a new company. Although I was working as an IT Technician at the time, I had showed an interest in and a natural understanding of database administration, as well as reliability, and so I was invited to take on the role of sole Database Administrator for the firm.

Effectively ‘thrown in at the deep end’, I had only two month’s full time training from my predecessor before becoming the firm’s sole DBA. I therefore put in a lot of hours in my own time to learn the role and develop my skills. Since taking on this role, despite minimal formal training, I have progressed substantially and I am now a competent DBA. My interest in database administration has also increased throughout my time in this role.

My general day-to-day duties involve:

• Supporting the live platform, the developers, the IT department and the finance team.
• Supporting any service desks tickets that get escalated.
• Checking that backups have run correctly.
• Checking the error logs to make sure everything is running correctly.
• Checking all SQL Server Agent jobs have run correctly.

My main projects in this role have been:

• Redeveloping the backup strategy to place emphasis on mission critical databases and to include backups to DPM and offsite storage.
• Creating a suite of SSRS reports for the Finance Team and Management Team.
• Creating a procedure to pull all the offices call data into one database so I could then create reports on it for the relevant Managers.
• Recreating various accounts procedures to enable the Accounts Team to do bulk batches rather than having to do them one at a time.
• Putting in place auditing on all databases.
• Creating various databases which have been used in various projects around the company.
• Upgrading the case management system to the newest version and troubleshooting any teething issues following on from the upgrade.

IT Technician

Simpson Millar
(1 year 8 months)Leeds, United Kingdom

I was promoted to IT Technician in April 2009 after demonstrating my skills and my enthusiasm for IT, which were consequently recognised by the IT Department. My duties involved:

• Troubleshooting and fixing any issues that were logged through the service help desk or telephone. Generally these included issues with the case management system, Microsoft Office, the telephone system and other third party applications.
• Liaising with external providers to get issues fixed.
• Providing first line support for all systems.
• PC builds and setting up new users, such as creating user profiles.

Post Room Assistant

Simpson Millar
(1 year 10 months)Leeds, United Kingdom

My duties whilst working in the post room included:
• Opening and organising the post, sorting it into relevant departments.
• Scanning / processing the post to the firm’s case management system.
• Creating spreadsheets.
• Other administrative tasks.

Courses

Independent Coursework

  • Designing, Optimizing and Maintaining a Database Administrative Solution for Microsoft SQL Server (50400)
  • Implementing a Microsoft SQL Server 2008 Database (6232)
  • Writing Queries Using Microsoft SQL Server 2008 Transact-SQL (2778)
  • An Introduction to Transact-SQL in Microsoft Server 2008 (4326)
  • Querying and Filtering Data in Microsoft SQL Server 2008 (4327)
  • Grouping and Summarizing Data in Microsoft SQL Server 2008 (4328)

Certifications

MCTS SQL Server 2008 Database Administrator

Microsoft

MCTS SQL Server 2008 Database Developer

Microsoft

Skills

  • Microsoft SQL Server
  • SSRS
  • Log Shipping
  • SQL Clustering
  • Mirroring
  • Replication

Education

Woodkirk High Specialist Science School

View Ben's full profile to...

  • See who you know in common
  • Get introduced
  • Contact Ben directly

Not the Ben Ritson you're looking for? View more

Insights


People Also Viewed

LinkedIn members in United Kingdom:

  1. a
  2. b
  3. c
  4. d
  5. e
  6. f
  7. g
  8. h
  9. i
  10. j
  11. k
  12. l
  13. m
  14. n
  15. o
  16. p
  17. q
  18. r
  19. s
  20. t
  21. u
  22. v
  23. w
  24. x
  25. y
  26. z
  27. more