Role Title: Data Administrator Duration: 6 months Location: Hybrid - Northampton 2 days a week Rate: £411 per day- Umbrella only Would you like to join a global leader in consulting, technology services and digital transformation? Our client is at the forefront of innovation to address the entire breadth of opportunities in the evolving world of cloud, digital and platforms. Role purpose/summary Microsoft Certified SQL Server DBA Manage SQL Server databases through multiple product life cycle environments, from development to mission-critical production systems. Configure and maintain database Servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security. Apply data modelling techniques to ensure development and implementation support efforts meet integration and performance expectations Independently analyze, solve, and correct issues in Real Time, providing problem resolution end-to-end. Refine and automate regular processes, track issues, and document changes Assist developers with complex query tuning and schema refinement. Provide 24x7 support for critical production systems. Perform scheduled maintenance and support release deployment activities after hours. Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members. Key Skills/requirements 5+ years MS SQL Server Administration experience required Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools Experience with backups, restores and recovery models Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server Experience working with Windows server, including Active Directory Excellent written and verbal communication Flexible, team player, "get-it-done" personality Ability to organize and plan work independently Ability to work in a rapidly changing environment Ability to multi-task and context-switch effectively between different activities and teams MCTS, MCITP, and/or MVP certifications a plus All profiles will be reviewed against the required skills and experience. Due to the high number of applications we will only be able to respond to successful applicants in the first instance. We thank you for your interest and the time taken to apply!
25/04/2024
Project-based
Role Title: Data Administrator Duration: 6 months Location: Hybrid - Northampton 2 days a week Rate: £411 per day- Umbrella only Would you like to join a global leader in consulting, technology services and digital transformation? Our client is at the forefront of innovation to address the entire breadth of opportunities in the evolving world of cloud, digital and platforms. Role purpose/summary Microsoft Certified SQL Server DBA Manage SQL Server databases through multiple product life cycle environments, from development to mission-critical production systems. Configure and maintain database Servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security. Apply data modelling techniques to ensure development and implementation support efforts meet integration and performance expectations Independently analyze, solve, and correct issues in Real Time, providing problem resolution end-to-end. Refine and automate regular processes, track issues, and document changes Assist developers with complex query tuning and schema refinement. Provide 24x7 support for critical production systems. Perform scheduled maintenance and support release deployment activities after hours. Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members. Key Skills/requirements 5+ years MS SQL Server Administration experience required Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools Experience with backups, restores and recovery models Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server Experience working with Windows server, including Active Directory Excellent written and verbal communication Flexible, team player, "get-it-done" personality Ability to organize and plan work independently Ability to work in a rapidly changing environment Ability to multi-task and context-switch effectively between different activities and teams MCTS, MCITP, and/or MVP certifications a plus All profiles will be reviewed against the required skills and experience. Due to the high number of applications we will only be able to respond to successful applicants in the first instance. We thank you for your interest and the time taken to apply!
Database Administrator - York, England/Hybrid I'm working with a York based B2B SaaS provider with an industry-leading product used by clients nationwide. The product is multi-featured and designed to retain sensitive data, automate processes and they're also currently developing a BI feature and a payment feature to become more of an all-rounder product. Who are they looking for? They are looking for a Database Administrator with a knack for optimising performance and ensuring seamless data management. You would be joining their dynamic operations and production team and they are looking for someone who doesn't mind working independently and would like autonomy over their project work. Your main responsibilities will be finding more innovative ways to manage data and leading by best practise, so someone who can work independently would be best suited for this role. What will I be doing? Day to day activity will include database management of their on Prem Legacy databases which are still in the process of being migrated to the cloud. One of your key focuses will be supporting the migration process, working with the Development team to maintain optimal performance. You will need to analyse their existing data storage options and using this knowledge, it will be your job to propose enhancements and then collaborate with other teams to implement them. You will get a lot of autonomy over the future of data storage once this migration project has taken place and there is scope for you to be working with cloud platforms. Who am I? To be considered as an ideal candidate for this role, the main thing they are looking for is experience with SQL, preferably T-SQL. It would be great if you had experience working in an environment with critically sensitive data and could provide examples of this as well, but you won't be ruled out if you don't have this experience. Some other desirable experience but not essential : It would be beneficial if you had experience working with SQL Sentry so you can optimize the database environment. It would also be great if you had experience working with open-source object-relational mapping frameworks. What's in it for you? Salary-wise, we are looking at a maximum of £65,000 plus benefits. At the very top end of this, you would need to have some commercial experience working with T-SQL, MongoDB and Entity framework. You would be expected in the office once a week and for any business-critical circumstances, so ideally you need to be based in a commutable distance to York. There is room to progress here in future as the company looks to continue to grow the team, and it's a great learning environment to be in. They also have truly flexible working hours, and you will get a lot of independence and autonomy over what you are working on. If this sounds like your next role, contact Katie Ferguson at Cathcart Technology
24/04/2024
Full time
Database Administrator - York, England/Hybrid I'm working with a York based B2B SaaS provider with an industry-leading product used by clients nationwide. The product is multi-featured and designed to retain sensitive data, automate processes and they're also currently developing a BI feature and a payment feature to become more of an all-rounder product. Who are they looking for? They are looking for a Database Administrator with a knack for optimising performance and ensuring seamless data management. You would be joining their dynamic operations and production team and they are looking for someone who doesn't mind working independently and would like autonomy over their project work. Your main responsibilities will be finding more innovative ways to manage data and leading by best practise, so someone who can work independently would be best suited for this role. What will I be doing? Day to day activity will include database management of their on Prem Legacy databases which are still in the process of being migrated to the cloud. One of your key focuses will be supporting the migration process, working with the Development team to maintain optimal performance. You will need to analyse their existing data storage options and using this knowledge, it will be your job to propose enhancements and then collaborate with other teams to implement them. You will get a lot of autonomy over the future of data storage once this migration project has taken place and there is scope for you to be working with cloud platforms. Who am I? To be considered as an ideal candidate for this role, the main thing they are looking for is experience with SQL, preferably T-SQL. It would be great if you had experience working in an environment with critically sensitive data and could provide examples of this as well, but you won't be ruled out if you don't have this experience. Some other desirable experience but not essential : It would be beneficial if you had experience working with SQL Sentry so you can optimize the database environment. It would also be great if you had experience working with open-source object-relational mapping frameworks. What's in it for you? Salary-wise, we are looking at a maximum of £65,000 plus benefits. At the very top end of this, you would need to have some commercial experience working with T-SQL, MongoDB and Entity framework. You would be expected in the office once a week and for any business-critical circumstances, so ideally you need to be based in a commutable distance to York. There is room to progress here in future as the company looks to continue to grow the team, and it's a great learning environment to be in. They also have truly flexible working hours, and you will get a lot of independence and autonomy over what you are working on. If this sounds like your next role, contact Katie Ferguson at Cathcart Technology
IBM DataStage Expert - Banking Client - Brussels Duration: 8 months Rate: 500 - 800 per day Hybrid working: Must be able to be in Brussels for team meetings/Workshops The team helps to transform data into insights using techniques such as text mining, machine learning, process mining, network analytics, predictive modelling, and creates reports using Cognos or Power BI. Role . Collect, clean, prepare and load the necessary data into the Data Warehouse, so that they can be used for reporting purposes; creating insights and answering business challenges . Act as a liaison between the team and other stakeholders. . Review the business requirements for the development and design needs . Design dimensional models to meet the business reporting needs . Design the technical ETL solution (define the technical interface, specifications for the source systems, the ETL processes from landing zone till storage) and develop the solution with IBM DataStage . Design the physical relational data model in collaboration with the database administrator . Define the scheduling requirements for ETL processes in the data warehouse . Develop & test (unit test, functional test and data profiling) the ETL processes . Prepare the releases & installation instructions . Provide documentation and support the developers . Create best practices . Handle hotline by solving the problems linked to ETL raised by the end users . Your main responsibilities will be to handle developments. You will act in close collaboration with the other team members and our clients. . You will find the right balance between cost and quality/completeness. Your Profile: . We are looking for a profile with excellent technical skills and a strong interest for the financial business. . You have minimum 5 years' experience in designing data models in a data warehouse context and developing applications in IBM DataStage. . You have an interest in the banking business and are willing to learn more . You have a good working knowledge of the SQL language . You're a good team player . You have strong communication skills and are willing to interact with both business/internal clients and your technical colleagues . You have good analytical skills and you're interested to solve problems in a complex environment . You can work on multiple projects at once . Knowledge of Agile methodology and BI reporting tools (IBM Cognos/Power BI) is clearly an asset Please do send across to me the most up to date CV to (see below)
19/04/2024
Project-based
IBM DataStage Expert - Banking Client - Brussels Duration: 8 months Rate: 500 - 800 per day Hybrid working: Must be able to be in Brussels for team meetings/Workshops The team helps to transform data into insights using techniques such as text mining, machine learning, process mining, network analytics, predictive modelling, and creates reports using Cognos or Power BI. Role . Collect, clean, prepare and load the necessary data into the Data Warehouse, so that they can be used for reporting purposes; creating insights and answering business challenges . Act as a liaison between the team and other stakeholders. . Review the business requirements for the development and design needs . Design dimensional models to meet the business reporting needs . Design the technical ETL solution (define the technical interface, specifications for the source systems, the ETL processes from landing zone till storage) and develop the solution with IBM DataStage . Design the physical relational data model in collaboration with the database administrator . Define the scheduling requirements for ETL processes in the data warehouse . Develop & test (unit test, functional test and data profiling) the ETL processes . Prepare the releases & installation instructions . Provide documentation and support the developers . Create best practices . Handle hotline by solving the problems linked to ETL raised by the end users . Your main responsibilities will be to handle developments. You will act in close collaboration with the other team members and our clients. . You will find the right balance between cost and quality/completeness. Your Profile: . We are looking for a profile with excellent technical skills and a strong interest for the financial business. . You have minimum 5 years' experience in designing data models in a data warehouse context and developing applications in IBM DataStage. . You have an interest in the banking business and are willing to learn more . You have a good working knowledge of the SQL language . You're a good team player . You have strong communication skills and are willing to interact with both business/internal clients and your technical colleagues . You have good analytical skills and you're interested to solve problems in a complex environment . You can work on multiple projects at once . Knowledge of Agile methodology and BI reporting tools (IBM Cognos/Power BI) is clearly an asset Please do send across to me the most up to date CV to (see below)