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
BP 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
GitMax 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.
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.