Job experience
Richard Shuster
  • Day to day support responsibilities of the designated projects.
  • Day to day support of Production and Development database environments via a work queue as project time schedules
  • Delivering on internal development projects (T-SQL)
  • Taking ownership of tasks and project deliverables
  • SQL Database administration and support on multiple mission critical clustered SQL 2000 and 2005 systems operating in an ITIL certified work environment
  • Setting up of replication technologies including mirroring and logshipping and provision of ongoing support
  • Adhering to the Stock Exchange's rigorous Change Management process and supplementing all project work with clear and concise support documentation
  • Various project work: migration of databases to new hardware, clustered SQL 2000 to 2005 upgrades, integration between disparate systems of partner companies
  • Housekeeping tasks including Index defrags, space management, log checking, providing secure backups to 3rd parties, performance tuning and capacity planning.
  • Best practice audits of SQL environments to ensure systems adhere to company policy
  • Review of T-SQL code from 3rd parties and team members
  • Design and implementation of new system requirements using T-SQL
  • Design and implementation of backup strategies, utilizing Native SQL, Litespeed, Netbackup or a combination of technologies
  • Design and implementation of DTS and SSIS packages, including migration of DTS to SSIS packages
  • Design and implementation of SQL Reporting Services reports
  • Generating ADHOC reports for business users
  • Troubleshooting and resolution of live service issues
  • Setting up and maintaining UAT environments
  • `On-call' and `out of hours' support in addition to the core on-site daily cover.
2010.07 - 2014.02
Database Administrator
  • Scoping and architecting new cloud based tendering system for international client based in Australia
  • Working closely with groups of international development teams to deliver solutions within SLA's
  • Creation of operational capability with regards to back office systems, front end systems (including websites, email infrastructure, operational procedures et al)
  • Architecting and implementation of new production SQL 2008 R2 and SQL 2012 infrastructure
  • SQL Server migration from SQL 2005 / 2008 R2 to SQL 2012
  • Scripting and automation of procedures
  • Managing test and pre-production infrastructure
  • Commissioning of new hardware and software
  • Researching and testing of cloud based solutions such as SQL Azure
  • Project management of application development, ETL processes, Automation
  • Performance tuning of SQL databases
  • Managing replication, logshipping and mirroring configs
  • General troubleshooting and maintenance / house-keeping tasks
  • Writing of proposal documents for funding
  • Writing and maintaining of procedure documents
  • Applying ``ITIL-Light'' to a SME environment to streamline operations
  • Managing network security and security patching
  • Training and mentoring of staff on various back and front office systems
  • Training and lab work around new SQL 2012 technologies such as AlwaysOn, Azure integration, partitioning, new SSIS capabilities and so forth.
  • Interfacing with clients and business stakeholders
2014.02 - 2015.05
Brewin Dolphin Securities
Database administrator
Database administrator
2021.01 - current
  • Business as usual tasks, performance monitoring and tuning, troubleshooting and root cause analysis using community and 3rd party tools (SQL Sentry), deployment of production releases, updating test and dev data environments.
  • Maintenance and capacity planning and monitoring using in house tools.
  • T-SQL development of stored procedures, SSIS packages and reports
  • Supporting and troubleshooting overnight batch processing with data sources from AS400 and external SQL systems, maintaining change data capture processes for full and delta data loads
  • Project work included SQL migrations, setting up new SQL clusters and HA environments, storage upgrades from existing SAN to NetApp storage.
  • On-call support.
  • Documentation of environments and processes.
  • Function as part of the service delivery team working in an Agile environment following KANBAN principles to keep track of work streams in progress.
  • BPF is the finance partner for a wide variety of house hold names including Apple, Tesla and many furniture and motor dealerships across the UK.
  • Delivering support services for patient critical 24x7 operations, where the Trust runs 387+ different applications from around 172+ different vendors. Life critical and essential services include drug dispensaries, patient registration and tracking or records, electronic medical charts, systems for A&E, theatre and bed vacancy management, Biztalk (for integration and data sharing of applications) and so forth.
  • Role predominantly BAU based with project work as required. BAU tasks included monitoring SQL estate, morning checks, troubleshooting, resolution and root cause analysis.
  • Project work included SQL migrations and upgrades (from old versions of SQL to 2012/2014), commissioning of new services for application and project teams, proof of concept work. GSST also undergoing a huge shit to two new data centres, building in-house Software as a Service model. The DBA team was involved with overseeing the SQL aspects and advising on best practice for the implementation.
  • Automation of many manual BAU tasks for DBA team using PowerShell (such as automating disk reporting, morning checks, alerts, parsing SQL logs, reporting on HA status and so forth). This significantly cut down man hours required to perform these tasks.
  • Implementing well recognised community scripts as part of the management framework for the SQL farm, including those from Adam Mechanic and Ola Hellengren.
  • 99% of SQL farm in VM environment. Physical servers in cluster configurations. Storage and VM capability outsourced and as such critical to engage and maintain good vendor relations to assure quick turnaround of requests for information or tasks.
  • Improving Trustwide security methodologies, implementation of best practice security models (``no, you can't have Sysadmin...'' discussions and educating app and vendor teams).
  • Adhering to change management processes and documentation standards.
  • On-call support.
2015.06 - 2021.08
Database administrator
12 years
12 years
10 years
7 years
MCPI (2008)
  • Microsoft Certified Professional +Internet

Meet our team