Waterlooville, England, United Kingdom
Business Intelligence and SQL Developer for MS SQL Server based systems. Administrative experience acting as a MSSQL DBA and Tableau Server Administrator. SQL Development experience predominantly to support ETL processes. Experienced in creating ETL packages using SQL SSIS and TSQL. Experienced creating Reporting solutions with SSRS, Crystal Reports, and Tableau Desktop/Server. Specialties: MS SQL Server Tableau Server Tableau Desktop SSIS SSRS TSQL Logi Analytics Windows Server Crystal Reports VB C# Powershell Python HTML CSS XML
Using SSIS to create, maintain, and support a complex ETL solution to load travel insurance policy data into the company's claims system in a variety of formats from insurers and insurance partners to ensure claims can be verified against the latest accurate customer policy data. Using Redgate SQL Monitor to monitor the SQL Server estate. Identify performance issues at the host, instance, database, and query level and work with the infrastructure and development teams to identify performance issues, optimise performance, remove technical debt, and ensure best technical practice is followed. Responsible for refreshing lower level development environments (Test, UAT, Training) Performing regular and periodic system upgrades to the company's "Nordic" insurance claims system that is in use 24/7/365. Performing updates to the database, fat client, web client, and multiple supporting web services, and ancillary systems. Identifying slow running database processes and queries and optimising them through either re-writing or index management. Using VS2022 and .Net MVC to create and maintain Web Service/API integrations between Charles Taylor and their customers.
Responsible for development and maintenance of Crystal Reports report suit for company’s “Compliance” traffic management software application, including general enhancement of standard reports, or development of paid for bespoke reports. Database Administrator (DBA) for customer hosted SaaS SQL Servers managing backups, disaster recovery, replication, warehousing, security, and performance tuning for 10 server hosts running approx. 60 SQL Instances. On Premises Tableau Server Administrator for Tableau Server hosting 10 customer sites, 100 Users, handling automated deployments, report/dashboard creation, and maintaining self-service data sources. Undertaking large scale database migrations for onboarding new customers by performing analysis and migration of data from competitor’s systems into Conduent’s Compliance system Working with the Support and Deployment teams to write tools, scripts, and processes to simplify, automate, or speed up manual tasks Work with Infrastructure Team to identify and resolve SQL based performance issues at host, instance, database, and stored procedure / query level.
DBA and systems administrator for development servers on a virtual Hyper-V environment. SQL Developer developing automation solutions for manual business processes for both internal projects and clients by leveraging knowledge of SQL Server, SSIS, and SSRS in conjunction with .Net developers; Responsible for undertaking weekly and monthly data refreshes using SSIS to update business intelligence tools; Working with Business Analysts to design business requirement documents for new projects;
Backup and restorations of database Capacity Planning for database storage on the SAN Designing and implementing Extract, Transform, and Load (ETL) packages using SSIS Administering legacy DTS packages that migrate data from AS/400 to SQL Server Managing deployment of development database code through development, staging, pilot, and live environments. Evaluating and testing new SQL technologies to see if their implementation offers benefits to developers or customers. Performance tuning using Profiler, Execution Plans, then manual SP rewrites and/or index and schema changes Responding to any 2nd/3rd line database problems assigned to me in Team Foundation Server Producing Adhoc MIS reports for clients with specific criteria. Documentation of procedures used by the Database team using MS Sharepoint. Installation and configuration or virtual test SQL Servers using MS Hyper-V