Ryan Gadsdon Email & Phone Number

Southampton, Gb

Southampton, England, United Kingdom

- SQL tuning and database design projects- Developed and improved dashboards in Power BI- Consulting database design and indexing in SQL Server- Worked on projects using Google Analytics, BigQuery and Looker Studio reports to create a social media growth strategy around SEO performance with keywords, tags, titles and descriptions.

- SQL, C#, Javascript, HTML & CSS- Automate database processes with our own internal client tool- Software: Grafana, Kibana, Red Gate, SSMS, Visual Studio, AWS, Bitbucket, S3, Jenkins, Jira.- Review existing and new code produced by developers.- Working with product teams to resolve existing bugs and develop new features.- Mass schema and code deployments.- Agile methodology- CI/CD

Chichester

I work as a DBA in SQL server. I built and maintained databases for 4000+ customers across 30 servers. As part of the database team we use agile scrum to manage and complete work efficiently along with Jira to plan tasks and allocate across the team.I am involved in many different areas including schema design, SQL performance, AWS, code review, maintenance routines, C#, server performance, disaster recovery, maintain database repository, SQL & C# code deployments and providing database assistance to 100+ employees. - T-SQL, NoSQL, PostgreSQL - Daily database tasks (Backups, drive Space, Maintenance errors, Timeouts, DB integrity, database moves, database deletes, database restores) - Monitor overall Server Performance (AWS & Redgate for 30+ servers). - Review existing and new code produced by developers. - Debug, maintain, improve & optimise performance for over 4,000 customers. - Maintain repository with bitbucket & GIT source control - Mass schema and code deployments. - 24/7 Disaster recovery for servers. - Software: Grafana, Kibana, Red Gate, SSMS, Visual Studio, AWS, Bitbucket, S3, Jenkins. - AWS Ec2 instances, volumes & S3 buckets (Full permissions) - Providing database assistance for 100+ other employees - Following development workflow with Jira - Reporting to higher up staff on performance of overall system. - Agile methodology - CI/CD

Southampton, United Kingdom

My main responsibilities were to maintain and improve all reports and reporting systems ranging from Oracle, SSRS, Power BI and Excel. I used T-SQL in SQL Server 2016/2017 to develop scripts that were presented through these reporting tools. The development of scripts sometimes involved large queries or altering/creating views, stored procedures, triggers and functions.My role also covered setting up data gateways, weekly forecast reporting, financial accounts/commissions and development of new projects.I learnt a lot about SQL Server and started to venture into database infrastructure, database user access, privileges, query optimisation, data mining and data flow. At this time i was looking to further my career in a more database development/DBA type role.Main Skills and Responsibilities:- SQL Server, Power BI, SSRS & Oracle- Transact-SQL (T-SQL), DAX- Microsoft Excel for data analysis and reporting including power pivot- Database maintenance - Advanced queries and database concepts- High-level database privileges/full database access- Prepare and attend report meetings- Database performance tuning & query optimization- T-SQL Functions, views and stored procedures- Data transfer for reporting from Oracle system to SSRS- Financial Spreadsheets/Reporting- UI/UX design

I worked part time as a web developer in a team of five during the 2nd year of my foundation degree. I developed HTML & CSS pages as well as educational material for their learning portal that provided extra learning resources for students to access outside of classes.

Bsc (Hons), Computing, 2:1

Fields of study: - Advanced database concepts - Data warehousing and mining - Advanced networking - UI/UX design - Business information.

Fdsc, Software Development, 2:1

Fields of study: - Database/SQL - Software engineering - Hardware - Networking principles - Software development cycles