Senior Database Architect: SQL Server, Oracle, Azure, Database, Insurance We are supporting a Global Insurer's initiative to build out their Database function with a dedicated team of Database experts. As part of this expansion, a Senior Database Architect is required to define & design Database architecture solutions for the database landscape. In a multi-platform environment, you will lead the design & development of scalable database architecture solutions. You will join a brand-new team, working alongside other architects, DBAs and application developers. You will be well versed in designing SQL & Oracle database solutions and delivering migration projects to Azure. As part of this data-driven business, you will play a key role in increasing database capabilities & innovating automation processes. Responsibilities: Responsible for the end-to-end design & implementation of Database infrastructure solutions Identifying gaps & opportunities in Database landscape Build relationships across the Business' Data & Applications services Play a key role in evaluating architecture & recommending new software & toolings Work alongside Database Engineers & Application support teams through to implementation Requirements: Experience designing architecture solutions for SQL Server and Oracle Knowledge of Azure environments and delivering migration projects An understanding of Microsoft technologies is required. Oracle knowledge is also desirable Knowledge of backup and restore processes is needed An understanding Relational Database Management System architecture and how it relates to the application landscape Senior Database Architect: SQL Server, Oracle, Azure, Database, Insurance
03/05/2024
Full time
Senior Database Architect: SQL Server, Oracle, Azure, Database, Insurance We are supporting a Global Insurer's initiative to build out their Database function with a dedicated team of Database experts. As part of this expansion, a Senior Database Architect is required to define & design Database architecture solutions for the database landscape. In a multi-platform environment, you will lead the design & development of scalable database architecture solutions. You will join a brand-new team, working alongside other architects, DBAs and application developers. You will be well versed in designing SQL & Oracle database solutions and delivering migration projects to Azure. As part of this data-driven business, you will play a key role in increasing database capabilities & innovating automation processes. Responsibilities: Responsible for the end-to-end design & implementation of Database infrastructure solutions Identifying gaps & opportunities in Database landscape Build relationships across the Business' Data & Applications services Play a key role in evaluating architecture & recommending new software & toolings Work alongside Database Engineers & Application support teams through to implementation Requirements: Experience designing architecture solutions for SQL Server and Oracle Knowledge of Azure environments and delivering migration projects An understanding of Microsoft technologies is required. Oracle knowledge is also desirable Knowledge of backup and restore processes is needed An understanding Relational Database Management System architecture and how it relates to the application landscape Senior Database Architect: SQL Server, Oracle, Azure, Database, Insurance
Senior Database Engineer: SQL Server, Azure, Database, T-SQL, PowerShell We are supporting a Global Specialty Insurer's initiative to build out their Database function with a dedicated team of Database experts. As part of this expansion, a Senior Database Engineer is required to develop automated solutions in support of a multi-platform environment. In an ever-evolving business, you will have the opportunity to shape the database system & infrastructure, allowing the business to capitalize on streamlined & automated processes. Working alongside a brand-new team of DBAs and Database Architects, you will be a key player in the development & support of SQL, Oracle and Azure databases. You will have excellent T-SQL & PowerShell programming, deep Microsoft Suite knowledge and supporting Database systems & migrations. This is an excellent opportunity to join a brand-new team and design & maintain scalable and robust databases for a truly Global business Responsibilities: Design, implement & support Database infrastructure & administration solutions Collaborate with DBA and application teams to ensure database performance, reliability and scalability Support code repository for the DBA team - ensuring code is up-to-date and functional Set standards and policies for best database practice & identify opportunities for improvement Participate in the evaluation of toolings, utitiles and applications to assist DBAs Requirements: Experience providing database development & support for SQL Server and Oracle Proven experience supporting the migration of database systems to Azure Deep understanding of Microsoft SQL, SSRS, SSIS and SSAS. Knowledge of Oracle is also desirable Strong programming knowledge including T-SQL and PowerShell Proven background in supporting relationship Database Management System architecture Senior Database Engineer: SQL Server, Azure, Database, T-SQL, PowerShell
03/05/2024
Full time
Senior Database Engineer: SQL Server, Azure, Database, T-SQL, PowerShell We are supporting a Global Specialty Insurer's initiative to build out their Database function with a dedicated team of Database experts. As part of this expansion, a Senior Database Engineer is required to develop automated solutions in support of a multi-platform environment. In an ever-evolving business, you will have the opportunity to shape the database system & infrastructure, allowing the business to capitalize on streamlined & automated processes. Working alongside a brand-new team of DBAs and Database Architects, you will be a key player in the development & support of SQL, Oracle and Azure databases. You will have excellent T-SQL & PowerShell programming, deep Microsoft Suite knowledge and supporting Database systems & migrations. This is an excellent opportunity to join a brand-new team and design & maintain scalable and robust databases for a truly Global business Responsibilities: Design, implement & support Database infrastructure & administration solutions Collaborate with DBA and application teams to ensure database performance, reliability and scalability Support code repository for the DBA team - ensuring code is up-to-date and functional Set standards and policies for best database practice & identify opportunities for improvement Participate in the evaluation of toolings, utitiles and applications to assist DBAs Requirements: Experience providing database development & support for SQL Server and Oracle Proven experience supporting the migration of database systems to Azure Deep understanding of Microsoft SQL, SSRS, SSIS and SSAS. Knowledge of Oracle is also desirable Strong programming knowledge including T-SQL and PowerShell Proven background in supporting relationship Database Management System architecture Senior Database Engineer: SQL Server, Azure, Database, T-SQL, PowerShell
Concept IT is thrilled to be supporting an established global company that has been at the forefront of revolutionising the mobility industry, pushing boundaries, and driving innovation. You will be working for a company that is recognised as a global leader in designing, manufacturing, and distributing mobility solutions. Data Warehouse Manager - Building a Modern Warehouse Location: West Midlands Start Date: ASAP Salary: Up to £83,000 Hybrid: 2 days on site ideal We are seeking a skilled Data Warehouse Manager to lead the design, development, and delivery of a new data hub, while also managing the existing Legacy data warehouse. This role is crucial for ensuring that the data infrastructure meets the highest standards and supports the business needs effectively. The successful candidate will oversee a talented team and work within our client's IT function. Principal Job Duties & Responsibilities: Design, build, and test corporate data warehouse. Develop, test, and document ETL and ELT solutions. Ensure accurate documentation, including lineage, for all solutions. Monitor and assess solution performance and suitability. Maintain data models, schemas, and metadata repositories. Address operational data warehouse issues promptly. Ensure compliance with standards and controls. Enhance user functionality and productivity with new solutions. Improve processes to standardise their data warehouse environment. Required Skills, Knowledge, and Experience: Extensive experience with SQL, preferably with Microsoft SQL Server and Oracle. Expertise in data warehousing, data modelling, data science, and cloud solutions. Experience with ETL development using Azure Data Factory and Informatica. Previous management experience in data warehousing or data engineering. Familiarity with both Cloud (Azure) and On-prem data platforms. Proficiency in the end-to-end BI life cycle and complex environments. Experience with Azure DevOps and CI/CD pipelines. Competencies: Strong knowledge of data warehouse management best practices. Proficiency in solution design, build, and testing. Skilled in ETL design and dimensional, OLAP, and relational-based solutions. Experience with Kimball and Inmon architectures. Ability to design data quality and master data management processes. Forward Thinking Results Orientation Business Acumen Building Collaborative Relationships Personal Credibility Requirements: This role requires various cognitive abilities and effective communication skills, both verbal and written. Additionally, the ability to focus on tasks and problem-solving skills are essential. Reasonable accommodations can be provided for individuals with disabilities. If you possess the required skills and experience and are interested in joining our team, please apply now by clicking APPLY.
03/05/2024
Full time
Concept IT is thrilled to be supporting an established global company that has been at the forefront of revolutionising the mobility industry, pushing boundaries, and driving innovation. You will be working for a company that is recognised as a global leader in designing, manufacturing, and distributing mobility solutions. Data Warehouse Manager - Building a Modern Warehouse Location: West Midlands Start Date: ASAP Salary: Up to £83,000 Hybrid: 2 days on site ideal We are seeking a skilled Data Warehouse Manager to lead the design, development, and delivery of a new data hub, while also managing the existing Legacy data warehouse. This role is crucial for ensuring that the data infrastructure meets the highest standards and supports the business needs effectively. The successful candidate will oversee a talented team and work within our client's IT function. Principal Job Duties & Responsibilities: Design, build, and test corporate data warehouse. Develop, test, and document ETL and ELT solutions. Ensure accurate documentation, including lineage, for all solutions. Monitor and assess solution performance and suitability. Maintain data models, schemas, and metadata repositories. Address operational data warehouse issues promptly. Ensure compliance with standards and controls. Enhance user functionality and productivity with new solutions. Improve processes to standardise their data warehouse environment. Required Skills, Knowledge, and Experience: Extensive experience with SQL, preferably with Microsoft SQL Server and Oracle. Expertise in data warehousing, data modelling, data science, and cloud solutions. Experience with ETL development using Azure Data Factory and Informatica. Previous management experience in data warehousing or data engineering. Familiarity with both Cloud (Azure) and On-prem data platforms. Proficiency in the end-to-end BI life cycle and complex environments. Experience with Azure DevOps and CI/CD pipelines. Competencies: Strong knowledge of data warehouse management best practices. Proficiency in solution design, build, and testing. Skilled in ETL design and dimensional, OLAP, and relational-based solutions. Experience with Kimball and Inmon architectures. Ability to design data quality and master data management processes. Forward Thinking Results Orientation Business Acumen Building Collaborative Relationships Personal Credibility Requirements: This role requires various cognitive abilities and effective communication skills, both verbal and written. Additionally, the ability to focus on tasks and problem-solving skills are essential. Reasonable accommodations can be provided for individuals with disabilities. If you possess the required skills and experience and are interested in joining our team, please apply now by clicking APPLY.
Concept IT is thrilled to be supporting an established global company that has been at the forefront of revolutionising the mobility industry, pushing boundaries, and driving innovation. You will be working for a company that is recognised as a global leader in designing, manufacturing, and distributing mobility solutions. Data Warehouse Engineer - Design, Developing and Testing Location: West Midlands - Hybrid 2 days on site a week Start Date: ASAP Salary: Up to £70,000 Our client is seeking a Data Engineer to play a pivotal role in designing, building, testing, and deploying Data Warehouse environment and solutions. This role encompasses the entire life cycle, from planning to data consolidation and aggregation. The Data Engineer will ensure all data products and solutions within the business insights ecosystem meet high standards of resilience, robustness, and reliability, while maintaining thorough documentation. Principal Job Duties & Responsibilities: Design, build, test, and document ETL and ELT solutions. Maintain accurate documentation, including lineage, for all productionised solutions. Monitor and evaluate solution performance and suitability. Ensure the planned architecture of the Data Warehouse environment is delivered. Maintain data models, schemas, and metadata repositories. Monitor and maintain operational data warehouse builds, resolving issues promptly. Identify and escalate potential quality issues or performance risks during monitoring. Assure that developed solutions adhere to agreed standards and controls. Guarantee the release and promotion of newly developed solutions to enhance user functionality and productivity. Provide and improve templates, forms, and processes to standardise the Data Warehouse environment and solutions. Required Skills, Knowledge, and Experience: Experience designing, developing, and testing Azure Data Factory/Fabric pipelines, including PySpark Notebooks and Dataflow Gen2 workflows. Previous experience with Informatica Power Centre is desired. Significant experience in designing, writing, editing, debugging, and testing SQL code, stored procedures, and database schemas, preferably for Microsoft SQL Server and Oracle. Working as part of a data warehouse or data engineering team. Experience with both Cloud (Azure) and On-premise configurations. Proficiency in using Azure DevOps and CI/CD pipelines for automated deployments. Good understanding of Datamodelling concepts and working within an end-to-end BI life cycle. Experience working within challenging and complex environments. Competencies: Proficiency in data warehouse management best practices, controls, and standards. Ability to design and code ETL solutions for dimensional, OLAP, and relational-based systems. Experience with Kimball and Inmon architectures for solution design. Knowledge of designing data quality and master data management processes. Forward Thinking Results Orientation Business Acumen Building Collaborative Relationships Personal Credibility Requirements: The role requires various cognitive abilities and effective communication skills, both verbal and written. Additionally, problem-solving skills and the ability to focus on tasks are essential. Reasonable accommodations can be provided for individuals with disabilities. If you possess the required skills and experience and are interested in joining our team, please apply now by clicking APPLY.
03/05/2024
Full time
Concept IT is thrilled to be supporting an established global company that has been at the forefront of revolutionising the mobility industry, pushing boundaries, and driving innovation. You will be working for a company that is recognised as a global leader in designing, manufacturing, and distributing mobility solutions. Data Warehouse Engineer - Design, Developing and Testing Location: West Midlands - Hybrid 2 days on site a week Start Date: ASAP Salary: Up to £70,000 Our client is seeking a Data Engineer to play a pivotal role in designing, building, testing, and deploying Data Warehouse environment and solutions. This role encompasses the entire life cycle, from planning to data consolidation and aggregation. The Data Engineer will ensure all data products and solutions within the business insights ecosystem meet high standards of resilience, robustness, and reliability, while maintaining thorough documentation. Principal Job Duties & Responsibilities: Design, build, test, and document ETL and ELT solutions. Maintain accurate documentation, including lineage, for all productionised solutions. Monitor and evaluate solution performance and suitability. Ensure the planned architecture of the Data Warehouse environment is delivered. Maintain data models, schemas, and metadata repositories. Monitor and maintain operational data warehouse builds, resolving issues promptly. Identify and escalate potential quality issues or performance risks during monitoring. Assure that developed solutions adhere to agreed standards and controls. Guarantee the release and promotion of newly developed solutions to enhance user functionality and productivity. Provide and improve templates, forms, and processes to standardise the Data Warehouse environment and solutions. Required Skills, Knowledge, and Experience: Experience designing, developing, and testing Azure Data Factory/Fabric pipelines, including PySpark Notebooks and Dataflow Gen2 workflows. Previous experience with Informatica Power Centre is desired. Significant experience in designing, writing, editing, debugging, and testing SQL code, stored procedures, and database schemas, preferably for Microsoft SQL Server and Oracle. Working as part of a data warehouse or data engineering team. Experience with both Cloud (Azure) and On-premise configurations. Proficiency in using Azure DevOps and CI/CD pipelines for automated deployments. Good understanding of Datamodelling concepts and working within an end-to-end BI life cycle. Experience working within challenging and complex environments. Competencies: Proficiency in data warehouse management best practices, controls, and standards. Ability to design and code ETL solutions for dimensional, OLAP, and relational-based systems. Experience with Kimball and Inmon architectures for solution design. Knowledge of designing data quality and master data management processes. Forward Thinking Results Orientation Business Acumen Building Collaborative Relationships Personal Credibility Requirements: The role requires various cognitive abilities and effective communication skills, both verbal and written. Additionally, problem-solving skills and the ability to focus on tasks are essential. Reasonable accommodations can be provided for individuals with disabilities. If you possess the required skills and experience and are interested in joining our team, please apply now by clicking APPLY.
Concept IT is thrilled to be supporting an established global company that has been at the forefront of revolutionising the mobility industry, pushing boundaries, and driving innovation. You will be working for a company that is recognised as a global leader in designing, manufacturing, and distributing mobility solutions. Senior Data Warehouse Engineer - Design, Developing and Testing Location: West Midlands - Hybrid 2 days on site a week Start Date: ASAP Salary: Up to £70,000 Our client is seeking a Data Engineer to play a pivotal role in designing, building, testing, and deploying Data Warehouse environment and solutions. This role encompasses the entire life cycle, from planning to data consolidation and aggregation. The Data Engineer will ensure all data products and solutions within the business insights ecosystem meet high standards of resilience, robustness, and reliability, while maintaining thorough documentation. Principal Job Duties & Responsibilities: Design, build, test, and document ETL and ELT solutions. Maintain accurate documentation, including lineage, for all productionised solutions. Monitor and evaluate solution performance and suitability. Ensure the planned architecture of the Data Warehouse environment is delivered. Maintain data models, schemas, and metadata repositories. Monitor and maintain operational data warehouse builds, resolving issues promptly. Identify and escalate potential quality issues or performance risks during monitoring. Assure that developed solutions adhere to agreed standards and controls. Guarantee the release and promotion of newly developed solutions to enhance user functionality and productivity. Provide and improve templates, forms, and processes to standardise the Data Warehouse environment and solutions. Required Skills, Knowledge, and Experience: Experience designing, developing, and testing Azure Data Factory/Fabric pipelines, including PySpark Notebooks and Dataflow Gen2 workflows. Previous experience with Informatica Power Centre is desired. Significant experience in designing, writing, editing, debugging, and testing SQL code, stored procedures, and database schemas, preferably for Microsoft SQL Server and Oracle. Working as part of a data warehouse or data engineering team. Experience with both Cloud (Azure) and On-premise configurations. Proficiency in using Azure DevOps and CI/CD pipelines for automated deployments. Good understanding of Datamodelling concepts and working within an end-to-end BI life cycle. Experience working within challenging and complex environments. Competencies: Proficiency in data warehouse management best practices, controls, and standards. Ability to design and code ETL solutions for dimensional, OLAP, and relational-based systems. Experience with Kimball and Inmon architectures for solution design. Knowledge of designing data quality and master data management processes. Forward Thinking Results Orientation Business Acumen Building Collaborative Relationships Personal Credibility Requirements: The role requires various cognitive abilities and effective communication skills, both verbal and written. Additionally, problem-solving skills and the ability to focus on tasks are essential. Reasonable accommodations can be provided for individuals with disabilities. If you possess the required skills and experience and are interested in joining our team, please apply now by clicking APPLY.
03/05/2024
Full time
Concept IT is thrilled to be supporting an established global company that has been at the forefront of revolutionising the mobility industry, pushing boundaries, and driving innovation. You will be working for a company that is recognised as a global leader in designing, manufacturing, and distributing mobility solutions. Senior Data Warehouse Engineer - Design, Developing and Testing Location: West Midlands - Hybrid 2 days on site a week Start Date: ASAP Salary: Up to £70,000 Our client is seeking a Data Engineer to play a pivotal role in designing, building, testing, and deploying Data Warehouse environment and solutions. This role encompasses the entire life cycle, from planning to data consolidation and aggregation. The Data Engineer will ensure all data products and solutions within the business insights ecosystem meet high standards of resilience, robustness, and reliability, while maintaining thorough documentation. Principal Job Duties & Responsibilities: Design, build, test, and document ETL and ELT solutions. Maintain accurate documentation, including lineage, for all productionised solutions. Monitor and evaluate solution performance and suitability. Ensure the planned architecture of the Data Warehouse environment is delivered. Maintain data models, schemas, and metadata repositories. Monitor and maintain operational data warehouse builds, resolving issues promptly. Identify and escalate potential quality issues or performance risks during monitoring. Assure that developed solutions adhere to agreed standards and controls. Guarantee the release and promotion of newly developed solutions to enhance user functionality and productivity. Provide and improve templates, forms, and processes to standardise the Data Warehouse environment and solutions. Required Skills, Knowledge, and Experience: Experience designing, developing, and testing Azure Data Factory/Fabric pipelines, including PySpark Notebooks and Dataflow Gen2 workflows. Previous experience with Informatica Power Centre is desired. Significant experience in designing, writing, editing, debugging, and testing SQL code, stored procedures, and database schemas, preferably for Microsoft SQL Server and Oracle. Working as part of a data warehouse or data engineering team. Experience with both Cloud (Azure) and On-premise configurations. Proficiency in using Azure DevOps and CI/CD pipelines for automated deployments. Good understanding of Datamodelling concepts and working within an end-to-end BI life cycle. Experience working within challenging and complex environments. Competencies: Proficiency in data warehouse management best practices, controls, and standards. Ability to design and code ETL solutions for dimensional, OLAP, and relational-based systems. Experience with Kimball and Inmon architectures for solution design. Knowledge of designing data quality and master data management processes. Forward Thinking Results Orientation Business Acumen Building Collaborative Relationships Personal Credibility Requirements: The role requires various cognitive abilities and effective communication skills, both verbal and written. Additionally, problem-solving skills and the ability to focus on tasks are essential. Reasonable accommodations can be provided for individuals with disabilities. If you possess the required skills and experience and are interested in joining our team, please apply now by clicking APPLY.
NO SPONSORSHIP Company is located in Chicago - Can be hybrid or remote if needed Contract to Hire role Data Quality Test Engineer This can be a straight contract role or a contract to hire role. The Test Engineer will be responsible for ensuring the successful implementation of new features as well as improvement of existing functionality for data architecture projects. This includes Integration testing, Customer Data Quality testing, Data verification testing, Regression testing etc. This is a hands-on testing position which requires deep knowledge and understanding of all aspects of developing and executing Back End testing. The Test Engineer must be an advocate for all things Testing and Quality Assurance while driving and implementing best practices. The ideal candidate must possess strong analytical and critical thinking abilities. Data testing skills are required. Position Requirements Bachelor's degree At least 3-5 years of testing experience in data Strong experience with writing queries in relational databases like Oracle and SQL server. Familiar with SQL server queries including calling stored procedures by passing parameters, functions, views, and indexes to be used during ETL process. Possess extensive and in-depth knowledge of developing SQL scripts using SQL functions, grouping operations, sub queries, analytical function and joins to test ETL projects. ETL testing using SQL server Integration Services (SSIS) and SSRS. Experience in testing database applications to validate source to destination data movement and transformation. Knowledge of automated data testing is preferred. Hands-on experience in Planning and Manual test execution. Experience in Regression Test Strategies, Regression suite maintenance and execution. Hands-on experience with Jira, ALM, TFS/ADO or similar systems of record. Understanding of Development and Test cycles, including respective best practices. Hands-on experience in Agile and Waterfall methodologies. Ability to troubleshoot issues, identifying root causes and support development team in development of resolutions. Strong communication and Client/Business interfacing and interpersonal skills are a must.
02/05/2024
NO SPONSORSHIP Company is located in Chicago - Can be hybrid or remote if needed Contract to Hire role Data Quality Test Engineer This can be a straight contract role or a contract to hire role. The Test Engineer will be responsible for ensuring the successful implementation of new features as well as improvement of existing functionality for data architecture projects. This includes Integration testing, Customer Data Quality testing, Data verification testing, Regression testing etc. This is a hands-on testing position which requires deep knowledge and understanding of all aspects of developing and executing Back End testing. The Test Engineer must be an advocate for all things Testing and Quality Assurance while driving and implementing best practices. The ideal candidate must possess strong analytical and critical thinking abilities. Data testing skills are required. Position Requirements Bachelor's degree At least 3-5 years of testing experience in data Strong experience with writing queries in relational databases like Oracle and SQL server. Familiar with SQL server queries including calling stored procedures by passing parameters, functions, views, and indexes to be used during ETL process. Possess extensive and in-depth knowledge of developing SQL scripts using SQL functions, grouping operations, sub queries, analytical function and joins to test ETL projects. ETL testing using SQL server Integration Services (SSIS) and SSRS. Experience in testing database applications to validate source to destination data movement and transformation. Knowledge of automated data testing is preferred. Hands-on experience in Planning and Manual test execution. Experience in Regression Test Strategies, Regression suite maintenance and execution. Hands-on experience with Jira, ALM, TFS/ADO or similar systems of record. Understanding of Development and Test cycles, including respective best practices. Hands-on experience in Agile and Waterfall methodologies. Ability to troubleshoot issues, identifying root causes and support development team in development of resolutions. Strong communication and Client/Business interfacing and interpersonal skills are a must.
*We are unable to sponsor for this role* *At the minimum year-long contract* A prestigious company is on the search for a Data Quality Test Engineer. The Test Engineer will be responsible for ensuring the successful implementation of new features as well as improvement of existing functionality for data architecture projects. This includes Integration testing, Customer Data Quality testing, Data verification testing, Regression testing etc. Responsibilities Review business requirements, functional specifications, use cases, design, and architecture documents to create effective, value-add test plans. Identify and close gaps, by assisting in QA discovery or analysis of a built or process, in order to facilitate requirements refinements. Identify issues in data, application configurations and screen designs, report and oversee issue resolution. Plan and execute Manual, Functional, and Regression test suite. Independently develop, modify, and execute test plans based on requirements and design documents. Identify, report and track defects and User Experience issues through a system of record. Collaborate with external teams on root cause analysis. Ensuring proper traceability from requirements to test artifacts. Actively participate in requirements and code reviews. Actively participate and drive improvements in Agile Scrum delivery. Be a thought leader in the test design and execution arena (manual and automated). Creation and input of test data, either manually or by using tools, programs, or masked production data to execute test cases. Qualifications: Bachelor's degree in Computer Science or related area. At least 3-5 years of testing experience in data or ETL projects. Strong experience with writing queries in relational databases like Oracle and SQL server. Familiar with SQL server queries including calling stored procedures by passing parameters, functions, views, and indexes to be used during ETL process. Possess extensive and in-depth knowledge of developing SQL scripts using SQL functions, grouping operations, sub queries, analytical function and joins to test ETL projects. ETL testing using SQL server Integration Services (SSIS) and SSRS. Experience in testing database applications to validate source to destination data movement and transformation. Knowledge of automated data testing is preferred. Hands-on experience in Planning and Manual test execution. Experience in Regression Test Strategies, Regression suite maintenance and execution. Hands-on experience with Jira, ALM, TFS/ADO or similar systems of record. Hands-on experience in Agile and Waterfall methodologies.
02/05/2024
Project-based
*We are unable to sponsor for this role* *At the minimum year-long contract* A prestigious company is on the search for a Data Quality Test Engineer. The Test Engineer will be responsible for ensuring the successful implementation of new features as well as improvement of existing functionality for data architecture projects. This includes Integration testing, Customer Data Quality testing, Data verification testing, Regression testing etc. Responsibilities Review business requirements, functional specifications, use cases, design, and architecture documents to create effective, value-add test plans. Identify and close gaps, by assisting in QA discovery or analysis of a built or process, in order to facilitate requirements refinements. Identify issues in data, application configurations and screen designs, report and oversee issue resolution. Plan and execute Manual, Functional, and Regression test suite. Independently develop, modify, and execute test plans based on requirements and design documents. Identify, report and track defects and User Experience issues through a system of record. Collaborate with external teams on root cause analysis. Ensuring proper traceability from requirements to test artifacts. Actively participate in requirements and code reviews. Actively participate and drive improvements in Agile Scrum delivery. Be a thought leader in the test design and execution arena (manual and automated). Creation and input of test data, either manually or by using tools, programs, or masked production data to execute test cases. Qualifications: Bachelor's degree in Computer Science or related area. At least 3-5 years of testing experience in data or ETL projects. Strong experience with writing queries in relational databases like Oracle and SQL server. Familiar with SQL server queries including calling stored procedures by passing parameters, functions, views, and indexes to be used during ETL process. Possess extensive and in-depth knowledge of developing SQL scripts using SQL functions, grouping operations, sub queries, analytical function and joins to test ETL projects. ETL testing using SQL server Integration Services (SSIS) and SSRS. Experience in testing database applications to validate source to destination data movement and transformation. Knowledge of automated data testing is preferred. Hands-on experience in Planning and Manual test execution. Experience in Regression Test Strategies, Regression suite maintenance and execution. Hands-on experience with Jira, ALM, TFS/ADO or similar systems of record. Hands-on experience in Agile and Waterfall methodologies.
*We are unable to sponsor as this is a permanent Full time role* A prestigious company is looking for a Oracle Applications DBA Tech Lead/Manager. This is a hands-on tech lead/manager. They will focus on all Oracle ERP applications and will focus heavily on Oracle EBS (11i/R12). This company is looking for someone with heavy Oracle Fusion Cloud experience. Responsibilities: You will support the following levels: Physical - you will be responsible for the physical and technical oriented aspects eg, storage, security, networking and more; Application - you will handle all application-related issues (eg, queries, users, Embedded SQL's etc.) You will ensure database resources are sized properly and a design strategy is developed to make sure that the database is maintained at a healthy size. You will ensure availability and performance of multi database and application environments with very large volumes and sizes. Responsible to manage Oracle Cloud OCI platform and maintain the ongoing integrations and configurations to keep the Cloud platform in a healthy condition. You will manage or perform routine DBA tasks like database maintenance, backups, recovery, table space management, upgrades, etc. You will execute periodic health checks for databases and recommend changes that should be executed in the production environment to ensure optimal performance. You will interact and work with multiple infrastructure, Security and IT teams as part of environment setup, maintenance and support. This is an important function of this role. Plans and responds to service outages including backup and restore. Monitors system performance diagnosing software and hardware failures to resolution Provides patch management and distribution capabilities to prevent new threats with minimized physical infrastructure impacts. Creates and tests data backups. Provides data cleansing services, verifies data integrity, and implements access controls. Performs database configuration, monitoring, and tuning. Routine maintenance including problem defect analysis and resolution, space, storage, object management, physical database layout, rollback segment management, and temporary space management. Supports logs and alerts, access rights and roles, database instance version control. New IDs, roles, authorizations, audits, locked/unlocked status, revocation. Performs memory usage monitoring, database parameter configuration, database resources, I/O distribution. Ensures system health, maintenance, technical security, recovery, and basic application technical tuning. Maintains Oracle Quarterly Releases and patch management schedules. Supports Systems Development, Migration, and Integration efforts as needed. Significant contributor to work plans for security analysis and recommendations Qualifications: Bachelor's Degree Computer Science or similar required 10+ years Oracle EBS (11i/R12) Minimum five (5) years in ERP Cloud platform 20+ years of experience as Oracle ERP APPS DBA Must have executed a minimum of two Upgrade cycles in the past. Will be responsible for Cutover Downtime reduction thru process improvements in each Upgrade iteration, Must have experience in EBS Application architecture, Concurrent managers, Workflow, layout of application on infrastructure, etc. Must have excellent knowledge in cloning, patching, backup recovery of ERP application including knowledge of ODI, FAW/ADW, Performance tuning, SQL profiling Must have hands on experience of RMAN, Backup Management and different Recovery techniques. Design and Implement disaster recovery plans. Support Oracle Cloud and EBS developers for custom coding, code migration, workflow and concurrent requests Knowledge of system administration functionality within Oracle Cloud ERP, Unix Shell Scripting skills on Oracle ODA's and OVM's Ability to manage and supervise DBA staff in the team. Responsible for providing day-to-day status and maintenance for Oracle EBS and ERP Cloud. Work with multiple application teams and developers.
02/05/2024
Full time
*We are unable to sponsor as this is a permanent Full time role* A prestigious company is looking for a Oracle Applications DBA Tech Lead/Manager. This is a hands-on tech lead/manager. They will focus on all Oracle ERP applications and will focus heavily on Oracle EBS (11i/R12). This company is looking for someone with heavy Oracle Fusion Cloud experience. Responsibilities: You will support the following levels: Physical - you will be responsible for the physical and technical oriented aspects eg, storage, security, networking and more; Application - you will handle all application-related issues (eg, queries, users, Embedded SQL's etc.) You will ensure database resources are sized properly and a design strategy is developed to make sure that the database is maintained at a healthy size. You will ensure availability and performance of multi database and application environments with very large volumes and sizes. Responsible to manage Oracle Cloud OCI platform and maintain the ongoing integrations and configurations to keep the Cloud platform in a healthy condition. You will manage or perform routine DBA tasks like database maintenance, backups, recovery, table space management, upgrades, etc. You will execute periodic health checks for databases and recommend changes that should be executed in the production environment to ensure optimal performance. You will interact and work with multiple infrastructure, Security and IT teams as part of environment setup, maintenance and support. This is an important function of this role. Plans and responds to service outages including backup and restore. Monitors system performance diagnosing software and hardware failures to resolution Provides patch management and distribution capabilities to prevent new threats with minimized physical infrastructure impacts. Creates and tests data backups. Provides data cleansing services, verifies data integrity, and implements access controls. Performs database configuration, monitoring, and tuning. Routine maintenance including problem defect analysis and resolution, space, storage, object management, physical database layout, rollback segment management, and temporary space management. Supports logs and alerts, access rights and roles, database instance version control. New IDs, roles, authorizations, audits, locked/unlocked status, revocation. Performs memory usage monitoring, database parameter configuration, database resources, I/O distribution. Ensures system health, maintenance, technical security, recovery, and basic application technical tuning. Maintains Oracle Quarterly Releases and patch management schedules. Supports Systems Development, Migration, and Integration efforts as needed. Significant contributor to work plans for security analysis and recommendations Qualifications: Bachelor's Degree Computer Science or similar required 10+ years Oracle EBS (11i/R12) Minimum five (5) years in ERP Cloud platform 20+ years of experience as Oracle ERP APPS DBA Must have executed a minimum of two Upgrade cycles in the past. Will be responsible for Cutover Downtime reduction thru process improvements in each Upgrade iteration, Must have experience in EBS Application architecture, Concurrent managers, Workflow, layout of application on infrastructure, etc. Must have excellent knowledge in cloning, patching, backup recovery of ERP application including knowledge of ODI, FAW/ADW, Performance tuning, SQL profiling Must have hands on experience of RMAN, Backup Management and different Recovery techniques. Design and Implement disaster recovery plans. Support Oracle Cloud and EBS developers for custom coding, code migration, workflow and concurrent requests Knowledge of system administration functionality within Oracle Cloud ERP, Unix Shell Scripting skills on Oracle ODA's and OVM's Ability to manage and supervise DBA staff in the team. Responsible for providing day-to-day status and maintenance for Oracle EBS and ERP Cloud. Work with multiple application teams and developers.
CyberArk Privileged Access Management Engineer - vacancy for a globally operating Basel based company in the pharmaceutical sector . Your tasks: Leading the transition from Legacy privilege access solutions to strategic CyberArk products Collaborating with system architects to understand target architecture and high-level requirements Designing and implementing solutions for managing privileged entitlements and authentication Providing third-level support for owned services and extending support of CyberArk solution Facilitating the decommissioning of Legacy privilege access management solutions Driving custom enhancements to augment CyberArk functionality and meet evolving needs Your experience/knowledge: 5+ years of experience in programming/Scripting languages such as Perl, JAVA, Python, etc. 5+ years of expertise engineering solutions with Oracle PL/SQL, Microsoft MSQL, and Sybase Back End Familiarity with CyberArk privileged session management product and/or Avecto Privilege Guard products Strong technical IT background and understanding of IT security principles Extensive experience in a large multinational corporation, preferably in financial services Bachelor's degree in a relevant field or equivalent experience Your soft skills: Excellent communication skills and ability to articulate complex solutions Proactive, motivated, and solution-oriented team player Location: Basel, Switzerland Sector: Pharmaceutical Start: 06/2024 Duration: 07MM+ Ref .Nr.: BH 21617 Take the next step and send us your resume along with a daytime phone number where we can reach you. Due to Swiss work permit restrictions, we can only consider applications from Swiss nationals, EU citizens as well as current work-permit holders for Switzerland. Ukrainian refugees are warmly welcomed, we will support you all the way. We welcome applications from individuals of all genders, age groups, sexual orientations, personal expressions, ethnic backgrounds, and religious beliefs. Therefore, there is no requirement to provide gender information or a photo in your application. As per client requirements, we need information about your marital status, nationality, date of birth, and a valid Swiss work permit. For applicants with disabilities, we are happy to explore potential solutions with our end client.
02/05/2024
Project-based
CyberArk Privileged Access Management Engineer - vacancy for a globally operating Basel based company in the pharmaceutical sector . Your tasks: Leading the transition from Legacy privilege access solutions to strategic CyberArk products Collaborating with system architects to understand target architecture and high-level requirements Designing and implementing solutions for managing privileged entitlements and authentication Providing third-level support for owned services and extending support of CyberArk solution Facilitating the decommissioning of Legacy privilege access management solutions Driving custom enhancements to augment CyberArk functionality and meet evolving needs Your experience/knowledge: 5+ years of experience in programming/Scripting languages such as Perl, JAVA, Python, etc. 5+ years of expertise engineering solutions with Oracle PL/SQL, Microsoft MSQL, and Sybase Back End Familiarity with CyberArk privileged session management product and/or Avecto Privilege Guard products Strong technical IT background and understanding of IT security principles Extensive experience in a large multinational corporation, preferably in financial services Bachelor's degree in a relevant field or equivalent experience Your soft skills: Excellent communication skills and ability to articulate complex solutions Proactive, motivated, and solution-oriented team player Location: Basel, Switzerland Sector: Pharmaceutical Start: 06/2024 Duration: 07MM+ Ref .Nr.: BH 21617 Take the next step and send us your resume along with a daytime phone number where we can reach you. Due to Swiss work permit restrictions, we can only consider applications from Swiss nationals, EU citizens as well as current work-permit holders for Switzerland. Ukrainian refugees are warmly welcomed, we will support you all the way. We welcome applications from individuals of all genders, age groups, sexual orientations, personal expressions, ethnic backgrounds, and religious beliefs. Therefore, there is no requirement to provide gender information or a photo in your application. As per client requirements, we need information about your marital status, nationality, date of birth, and a valid Swiss work permit. For applicants with disabilities, we are happy to explore potential solutions with our end client.
Oracle DBA Tech Team Lead/Manager Salary: Open + Bonus Location: Chelmsford, MA On-site: 5 days/week *We are unable to provide sponsorship for this role* Qualifications Bachelor's degree 10+ years Oracle EBS (11i/R12) 5+ years in ERP Cloud platform 20+ years of experience as Oracle ERP APPS DBA Managerial/supervisory experience Minimum execution of two Upgrade cycles in the past. Will be responsible for Cutover Downtime reduction through process improvements in each Upgrade iteration, must have experience in EBS Application architecture, Concurrent managers, Workflow, layout of application on infrastructure, etc. Excellent knowledge in cloning, patching, backup recovery of ERP application including knowledge of ODI, FAW/ADW, Performance tuning, SQL profiling. Hands on experience of RMAN, Backup Management and different Recovery techniques. Design and Implement disaster recovery plans. Responsibilities You will support the following levels: Physical - you will be responsible for the physical and technical oriented aspects eg, storage, security, networking and more; Application - you will handle all application-related issues (eg, queries, users, Embedded SQL's etc.) You will ensure database resources are sized properly and a design strategy is developed to make sure that the database is maintained at a healthy size. You will ensure availability and performance of multi database and application environments with very large volumes and sizes. Responsible to manage Oracle Cloud OCI platform and maintain the ongoing integrations and configurations to keep the Cloud platform in a healthy condition. You will manage or perform routine DBA tasks like database maintenance, backups, recovery, table space management, upgrades, etc. You will execute periodic health checks for databases and recommend changes that should be executed in the production environment to ensure optimal performance. You will interact and work with multiple infrastructure, Security, and IT teams as part of environment setup, maintenance, and support. This is an important function of this role. Plans and responds to service outages including backup and restore. Monitors system performance diagnosing software and hardware failures to resolution.
01/05/2024
Full time
Oracle DBA Tech Team Lead/Manager Salary: Open + Bonus Location: Chelmsford, MA On-site: 5 days/week *We are unable to provide sponsorship for this role* Qualifications Bachelor's degree 10+ years Oracle EBS (11i/R12) 5+ years in ERP Cloud platform 20+ years of experience as Oracle ERP APPS DBA Managerial/supervisory experience Minimum execution of two Upgrade cycles in the past. Will be responsible for Cutover Downtime reduction through process improvements in each Upgrade iteration, must have experience in EBS Application architecture, Concurrent managers, Workflow, layout of application on infrastructure, etc. Excellent knowledge in cloning, patching, backup recovery of ERP application including knowledge of ODI, FAW/ADW, Performance tuning, SQL profiling. Hands on experience of RMAN, Backup Management and different Recovery techniques. Design and Implement disaster recovery plans. Responsibilities You will support the following levels: Physical - you will be responsible for the physical and technical oriented aspects eg, storage, security, networking and more; Application - you will handle all application-related issues (eg, queries, users, Embedded SQL's etc.) You will ensure database resources are sized properly and a design strategy is developed to make sure that the database is maintained at a healthy size. You will ensure availability and performance of multi database and application environments with very large volumes and sizes. Responsible to manage Oracle Cloud OCI platform and maintain the ongoing integrations and configurations to keep the Cloud platform in a healthy condition. You will manage or perform routine DBA tasks like database maintenance, backups, recovery, table space management, upgrades, etc. You will execute periodic health checks for databases and recommend changes that should be executed in the production environment to ensure optimal performance. You will interact and work with multiple infrastructure, Security, and IT teams as part of environment setup, maintenance, and support. This is an important function of this role. Plans and responds to service outages including backup and restore. Monitors system performance diagnosing software and hardware failures to resolution.
Robert Walters is working in partnership with a UK leading utility infrastructure services provider. A multibillion turnover over business, specialising in providing services across water, energy, transport, and telecoms. Due to continued growth, they are keen to expand their finance systems support business. As such, they are keen to appoint an Oracle Financial Consolidation and Close Cloud Service (FCCS) Administrator. You will provide leadership in ensuring finance systems support business challenges and enhancements to underlying business processes. The permanent opportunity for an Oracle Financial Consolidation and Close Cloud Service (FCCS), will pay a salary range of £75,000 to £90,000 plus car cash allowance and bonus with a hybrid working model. Oracle Financial Consolidation and Close Cloud Service (FCCS): Duties Responsible for the Financial Consolidation & Close Cloud Services (FCCS) applications Lead Oracle Enterprise Performance Management (EPM) environment Identify improvement opportunities and work with multiple business units Configure/Set Up/Support of Oracle FCCS applications Manage user access, role and security privileges within FCCS apps Sys Admin for production system and integration with external systems Monitor system performance, troubleshooting issues - patches and updates Provide technical support to end-users Ensure change management approval processes are followed Manage incidents and service requests - inception to completion Act as point of contact for business and third parties for issue resolution and problem management Maintain documentation related to system config, process and procedures Oracle Financial Consolidation and Close Cloud Service (FCCS): Experience Strong financial accounting experience administration experience with Oracle FCCS solutions experience in supporting and implementing FCCS Proficiency in EPM Automate Experience in Oracle PBCS, ARCS and Reporting (OTBI, SQL) desirable System integration experience desirable Business Intelligence software experience desirable Information security. Knowledge of enterprise architecture The permanent opportunity for an Oracle Financial Consolidation and Close Cloud Service (FCCS) will pay a salary range of £75,000 to £90,000 plus car cash allowance and bonus with a hybrid working model. This is an opportunity to join a UK market leader, that has grown year on year. For further information, please apply with an updated CV and contact Ajay Hayre on (see below). Robert Walters Operations Limited is an employment business and employment agency and welcomes applications from all candidates
01/05/2024
Full time
Robert Walters is working in partnership with a UK leading utility infrastructure services provider. A multibillion turnover over business, specialising in providing services across water, energy, transport, and telecoms. Due to continued growth, they are keen to expand their finance systems support business. As such, they are keen to appoint an Oracle Financial Consolidation and Close Cloud Service (FCCS) Administrator. You will provide leadership in ensuring finance systems support business challenges and enhancements to underlying business processes. The permanent opportunity for an Oracle Financial Consolidation and Close Cloud Service (FCCS), will pay a salary range of £75,000 to £90,000 plus car cash allowance and bonus with a hybrid working model. Oracle Financial Consolidation and Close Cloud Service (FCCS): Duties Responsible for the Financial Consolidation & Close Cloud Services (FCCS) applications Lead Oracle Enterprise Performance Management (EPM) environment Identify improvement opportunities and work with multiple business units Configure/Set Up/Support of Oracle FCCS applications Manage user access, role and security privileges within FCCS apps Sys Admin for production system and integration with external systems Monitor system performance, troubleshooting issues - patches and updates Provide technical support to end-users Ensure change management approval processes are followed Manage incidents and service requests - inception to completion Act as point of contact for business and third parties for issue resolution and problem management Maintain documentation related to system config, process and procedures Oracle Financial Consolidation and Close Cloud Service (FCCS): Experience Strong financial accounting experience administration experience with Oracle FCCS solutions experience in supporting and implementing FCCS Proficiency in EPM Automate Experience in Oracle PBCS, ARCS and Reporting (OTBI, SQL) desirable System integration experience desirable Business Intelligence software experience desirable Information security. Knowledge of enterprise architecture The permanent opportunity for an Oracle Financial Consolidation and Close Cloud Service (FCCS) will pay a salary range of £75,000 to £90,000 plus car cash allowance and bonus with a hybrid working model. This is an opportunity to join a UK market leader, that has grown year on year. For further information, please apply with an updated CV and contact Ajay Hayre on (see below). Robert Walters Operations Limited is an employment business and employment agency and welcomes applications from all candidates
Oracle Lead Solutions Designer FP&A - Hybrid - 3 days per week onsite in London, 2 days remote - £90,000 We are currently seeking to recruit an Oracle Lead Solution Designer (Finance Planning & Analysis) to join our Technology team in London (with remote working too). The Technology team operates on a global basis and we are looking for a team player to assist in improving and extracting maximum value from our Oracle landscape. This is a great opportunity for an Oracle Lead Solution Designer to play an integral role responsible for defining the overall architecture and design of IT solutions supporting Finance Planning and Analysis business requirements. The successful Oracle Solution Designer will be key in driving the technical direction and strategy for the organisation. The successful candidate will bring external experience and expertise of creating sustainable Oracle solutions, improving service standards, sharing best practice, and engaging with key stakeholders (internal and external) to provide excellent service. A key member of the Back Office transformation team, the Oracle Lead Solution Designer will have the opportunity to work in a global solution delivery environment alongside key technology partners in delivering best of breed solutions to meet US centric and local accounting and financial reporting requirements. Roles and Responsibilities Accountable for the delivery of the chosen Oracle solution(s) through the whole delivery life cycle, working with various IT teams and vendors to manage ideas, through to design, through to delivery and operation of Oracle Solution. Provide solution & design knowledge to advise project teams, business stakeholders and third-party vendors on Oracle options Ensure that all solutions in place are technically sound and optimized for best performance on the Oracle Cloud eco-system Ensure seamless integration and enablement of business self-service on reporting and analytics solutions from financial planning data and information Ensure that all solutions in place adhere to appropriate governance with supporting documentation Work with the wider team to refine the Oracle design roadmap within the Framework defined by Architecture. This will include inputting into cloud adoption and its implementation. Extensive experience of assessing and implementing internal and vendor solutions Mitigate risk and have awareness of emerging threats to security as well as compliance Assurance on integration design patterns and solutions are optimal and service based, leading to re-use and supportability in a BAU environment Ensure that solutions are an appropriate balance between short-term delivery needs and medium/long term strategic aspirations. Assist in the creation and maintenance of Oracle technical roadmaps working with Architects to ensure aligned. Propose the Oracle system improvement ideas for better customer experience Present Oracle solution design to the stakeholders and feedback the comments Involved in all the phases of the solution delivery to guide the teams Conducting regular evaluations of the system architecture and collaborating with the teams to improve the designs Performing continuous research on emerging technologies to stay updated with the best alternatives and to improve the existing architecture Reviewing vendor designs, ensuring alignment to business requirements and supportable without creating unnecessary technical debt Skills/Experience Essential Proven experience in Oracle solution design, roadmaps and delivery Hand on in Oracle Cloud solutions including but not limited to: Accounting Foundation, Accounting Hub, Fusion ERP, EPM (EPBCS, EPCM), Oracle Integration Cloud, Enterprise Data Management Cloud Solutions Strong working knowledge in Oracle Cloud Products including AFCS, AHCS, EPM modules, EDMCS and OIC Previous hands-on experience and end-to-end implementations with Oracle Finance, Reinsurance or Cloud solutions Strong knowledge on analytics solutions that integrate into EPM delivering seamless self-serve capability for business users Understanding key finance planning and forecast data requirements, including processing of allocations and drivers Deep technical knowledge of Oracle Cloud products Should excel in Oracle finance planning and analysis processes Expertise in Oracle upgrades and patching Experience in Oracle migration and transformation Expertise in Sub-ledger to General Ledger actual vs plan integration and analysis Well versed with Oracle Integration to process significant data volumes, and manage hierarchy changes in EDMCS, supporting performance management Good knowledge in System performance improvements Strong knowledge in end to end to end design and integration systems Experience in Non-Oracle product integrations with Oracle Strong communication and presenting skills Experience proposing and implementing technically complex projects Excellent understanding of the project delivery life cycle Experience and knowledge of multiple Oracle products and services in general and how they work together Ability to rapidly pick-up new technologies, propositions and business challenges and translate them into Oracle Solutions and offerings Oracle Certification or relevant certification related to design or delivery Experience using Fusion Analytics and Oracle Analytics Cloud Desirable Accounting qualifications, and/or significant experience in delivering US GAAP and IFRS reporting standards Insurance and/or finance services accounting standards and how they convert to system needs Awareness of the leading industry trends, industry standards and follow regulatory changes Experience using Fusion Analytics and Oracle Analytics Cloud Experience in non-Oracle analytical tools that connect to the Oracle Eco-System Oracle brownfield migration and/or greenfield experience Financial or Reinsurance experience or knowledge Configuration design experience for Oracle systems that are in the cloud Experience working with one of more of the following: SAP BW, SAP S/4, PeopleSoft Good knowledge in Oracle coding language and enhancements Previous experience in cloud products like AWS, Azure Personal Characteristics Collaborates well with all levels within the organization Good Communicator - succinctly communicates vision to all stakeholders in a compelling and effective way Data Driven - values evidence, research and customer feedback Decisive - makes effective customer centric decisions Flexible - adapts and thrives under change and ambiguity in an independent and flat structure Excellent internal customer service and communication skills. Ability to understand and communicate technical language to non-technical audiences Ability to work in a fast-paced environment with multiple priorities Ability to produce accurate work under pressure with frequent deadlines Demonstrate critical thinking and analytical skills with attention to detail Excellent problem-solving skills, with the ability to work independently and collaborating with others Ability to exercise confidentiality and professionalism in the performance of duties Self sufficient with the ability to maintain progress on tasks and projects
27/04/2024
Full time
Oracle Lead Solutions Designer FP&A - Hybrid - 3 days per week onsite in London, 2 days remote - £90,000 We are currently seeking to recruit an Oracle Lead Solution Designer (Finance Planning & Analysis) to join our Technology team in London (with remote working too). The Technology team operates on a global basis and we are looking for a team player to assist in improving and extracting maximum value from our Oracle landscape. This is a great opportunity for an Oracle Lead Solution Designer to play an integral role responsible for defining the overall architecture and design of IT solutions supporting Finance Planning and Analysis business requirements. The successful Oracle Solution Designer will be key in driving the technical direction and strategy for the organisation. The successful candidate will bring external experience and expertise of creating sustainable Oracle solutions, improving service standards, sharing best practice, and engaging with key stakeholders (internal and external) to provide excellent service. A key member of the Back Office transformation team, the Oracle Lead Solution Designer will have the opportunity to work in a global solution delivery environment alongside key technology partners in delivering best of breed solutions to meet US centric and local accounting and financial reporting requirements. Roles and Responsibilities Accountable for the delivery of the chosen Oracle solution(s) through the whole delivery life cycle, working with various IT teams and vendors to manage ideas, through to design, through to delivery and operation of Oracle Solution. Provide solution & design knowledge to advise project teams, business stakeholders and third-party vendors on Oracle options Ensure that all solutions in place are technically sound and optimized for best performance on the Oracle Cloud eco-system Ensure seamless integration and enablement of business self-service on reporting and analytics solutions from financial planning data and information Ensure that all solutions in place adhere to appropriate governance with supporting documentation Work with the wider team to refine the Oracle design roadmap within the Framework defined by Architecture. This will include inputting into cloud adoption and its implementation. Extensive experience of assessing and implementing internal and vendor solutions Mitigate risk and have awareness of emerging threats to security as well as compliance Assurance on integration design patterns and solutions are optimal and service based, leading to re-use and supportability in a BAU environment Ensure that solutions are an appropriate balance between short-term delivery needs and medium/long term strategic aspirations. Assist in the creation and maintenance of Oracle technical roadmaps working with Architects to ensure aligned. Propose the Oracle system improvement ideas for better customer experience Present Oracle solution design to the stakeholders and feedback the comments Involved in all the phases of the solution delivery to guide the teams Conducting regular evaluations of the system architecture and collaborating with the teams to improve the designs Performing continuous research on emerging technologies to stay updated with the best alternatives and to improve the existing architecture Reviewing vendor designs, ensuring alignment to business requirements and supportable without creating unnecessary technical debt Skills/Experience Essential Proven experience in Oracle solution design, roadmaps and delivery Hand on in Oracle Cloud solutions including but not limited to: Accounting Foundation, Accounting Hub, Fusion ERP, EPM (EPBCS, EPCM), Oracle Integration Cloud, Enterprise Data Management Cloud Solutions Strong working knowledge in Oracle Cloud Products including AFCS, AHCS, EPM modules, EDMCS and OIC Previous hands-on experience and end-to-end implementations with Oracle Finance, Reinsurance or Cloud solutions Strong knowledge on analytics solutions that integrate into EPM delivering seamless self-serve capability for business users Understanding key finance planning and forecast data requirements, including processing of allocations and drivers Deep technical knowledge of Oracle Cloud products Should excel in Oracle finance planning and analysis processes Expertise in Oracle upgrades and patching Experience in Oracle migration and transformation Expertise in Sub-ledger to General Ledger actual vs plan integration and analysis Well versed with Oracle Integration to process significant data volumes, and manage hierarchy changes in EDMCS, supporting performance management Good knowledge in System performance improvements Strong knowledge in end to end to end design and integration systems Experience in Non-Oracle product integrations with Oracle Strong communication and presenting skills Experience proposing and implementing technically complex projects Excellent understanding of the project delivery life cycle Experience and knowledge of multiple Oracle products and services in general and how they work together Ability to rapidly pick-up new technologies, propositions and business challenges and translate them into Oracle Solutions and offerings Oracle Certification or relevant certification related to design or delivery Experience using Fusion Analytics and Oracle Analytics Cloud Desirable Accounting qualifications, and/or significant experience in delivering US GAAP and IFRS reporting standards Insurance and/or finance services accounting standards and how they convert to system needs Awareness of the leading industry trends, industry standards and follow regulatory changes Experience using Fusion Analytics and Oracle Analytics Cloud Experience in non-Oracle analytical tools that connect to the Oracle Eco-System Oracle brownfield migration and/or greenfield experience Financial or Reinsurance experience or knowledge Configuration design experience for Oracle systems that are in the cloud Experience working with one of more of the following: SAP BW, SAP S/4, PeopleSoft Good knowledge in Oracle coding language and enhancements Previous experience in cloud products like AWS, Azure Personal Characteristics Collaborates well with all levels within the organization Good Communicator - succinctly communicates vision to all stakeholders in a compelling and effective way Data Driven - values evidence, research and customer feedback Decisive - makes effective customer centric decisions Flexible - adapts and thrives under change and ambiguity in an independent and flat structure Excellent internal customer service and communication skills. Ability to understand and communicate technical language to non-technical audiences Ability to work in a fast-paced environment with multiple priorities Ability to produce accurate work under pressure with frequent deadlines Demonstrate critical thinking and analytical skills with attention to detail Excellent problem-solving skills, with the ability to work independently and collaborating with others Ability to exercise confidentiality and professionalism in the performance of duties Self sufficient with the ability to maintain progress on tasks and projects
Request Technology - Craig Johnson
Chelmsford, Massachusetts
*We are unable to sponsor for this permanent Full time onsite role* *Position is bonus eligible* Prestigious Enterprise Company is currently seeking an Senior Manager Oracle Applications DBA. Candidate will be very hands-on, and will be ensuring production up-time service levels are maintained and made available per requirements that include backup, recovery, refresh, performance tuning, and security (physical and data). Responsibilities: You will support the following levels: Physical - you will be responsible for the physical and technical oriented aspects eg, storage, security, networking and more; Application - you will handle all application-related issues (eg, queries, users, Embedded SQL's etc.) You will ensure database resources are sized properly and a design strategy is developed to make sure that the database is maintained at a healthy size. You will ensure availability and performance of multi database and application environments with very large volumes and sizes. Responsible to manage Oracle Cloud OCI platform and maintain the ongoing integrations and configurations to keep the Cloud platform in a healthy condition. You will manage or perform routine DBA tasks like database maintenance, backups, recovery, table space management, upgrades, etc. You will execute periodic health checks for databases and recommend changes that should be executed in the production environment to ensure optimal performance. You will interact and work with multiple infrastructure, Security and IT teams as part of environment setup, maintenance and support. This is an important function of this role. Plans and responds to service outages including backup and restore. Monitors system performance diagnosing software and hardware failures to resolution Provides patch management and distribution capabilities to prevent new threats with minimized physical infrastructure impacts. Creates and tests data backups. Provides data cleansing services, verifies data integrity, and implements access controls. Performs database configuration, monitoring, and tuning. Routine maintenance including problem defect analysis and resolution, space, storage, object management, physical database layout, rollback segment management, and temporary space management. Supports logs and alerts, access rights and roles, database instance version control. New IDs, roles, authorizations, audits, locked/unlocked status, revocation. Performs memory usage monitoring, database parameter configuration, database resources, I/O distribution. Ensures system health, maintenance, technical security, recovery, and basic application technical tuning. Maintains Oracle Quarterly Releases and patch management schedules. Supports Systems Development, Migration, and Integration efforts as needed. Significant contributor to work plans for security analysis and recommendations Qualifications: Bachelor's Degree Computer Science or similar required 10+ years Oracle EBS (11i/R12) Minimum five (5) years in ERP Cloud platform 20+ years of experience as Oracle ERP APPS DBA Must have executed a minimum of two Upgrade cycles in the past. Will be responsible for Cutover Downtime reduction thru process improvements in each Upgrade iteration, Must have experience in EBS Application architecture, Concurrent managers, Workflow, layout of application on infrastructure, etc. Must have excellent knowledge in cloning, patching, backup recovery of ERP application including knowledge of ODI, FAW/ADW, Performance tuning, SQL profiling Must have hands on experience of RMAN, Backup Management and different Recovery techniques. Design and Implement disaster recovery plans. Support Oracle Cloud and EBS developers for custom coding, code migration, workflow and concurrent requests Knowledge of system administration functionality within Oracle Cloud ERP, Unix Shell Scripting skills on Oracle ODA's and OVM's Excellent interpersonal communication skills Ability to work with team members located in multiple geographies and time zones. Ability to manage and supervise DBA staff in the team. Responsible for providing day-to-day status and maintenance for Oracle EBS and ERP Cloud.
23/04/2024
Full time
*We are unable to sponsor for this permanent Full time onsite role* *Position is bonus eligible* Prestigious Enterprise Company is currently seeking an Senior Manager Oracle Applications DBA. Candidate will be very hands-on, and will be ensuring production up-time service levels are maintained and made available per requirements that include backup, recovery, refresh, performance tuning, and security (physical and data). Responsibilities: You will support the following levels: Physical - you will be responsible for the physical and technical oriented aspects eg, storage, security, networking and more; Application - you will handle all application-related issues (eg, queries, users, Embedded SQL's etc.) You will ensure database resources are sized properly and a design strategy is developed to make sure that the database is maintained at a healthy size. You will ensure availability and performance of multi database and application environments with very large volumes and sizes. Responsible to manage Oracle Cloud OCI platform and maintain the ongoing integrations and configurations to keep the Cloud platform in a healthy condition. You will manage or perform routine DBA tasks like database maintenance, backups, recovery, table space management, upgrades, etc. You will execute periodic health checks for databases and recommend changes that should be executed in the production environment to ensure optimal performance. You will interact and work with multiple infrastructure, Security and IT teams as part of environment setup, maintenance and support. This is an important function of this role. Plans and responds to service outages including backup and restore. Monitors system performance diagnosing software and hardware failures to resolution Provides patch management and distribution capabilities to prevent new threats with minimized physical infrastructure impacts. Creates and tests data backups. Provides data cleansing services, verifies data integrity, and implements access controls. Performs database configuration, monitoring, and tuning. Routine maintenance including problem defect analysis and resolution, space, storage, object management, physical database layout, rollback segment management, and temporary space management. Supports logs and alerts, access rights and roles, database instance version control. New IDs, roles, authorizations, audits, locked/unlocked status, revocation. Performs memory usage monitoring, database parameter configuration, database resources, I/O distribution. Ensures system health, maintenance, technical security, recovery, and basic application technical tuning. Maintains Oracle Quarterly Releases and patch management schedules. Supports Systems Development, Migration, and Integration efforts as needed. Significant contributor to work plans for security analysis and recommendations Qualifications: Bachelor's Degree Computer Science or similar required 10+ years Oracle EBS (11i/R12) Minimum five (5) years in ERP Cloud platform 20+ years of experience as Oracle ERP APPS DBA Must have executed a minimum of two Upgrade cycles in the past. Will be responsible for Cutover Downtime reduction thru process improvements in each Upgrade iteration, Must have experience in EBS Application architecture, Concurrent managers, Workflow, layout of application on infrastructure, etc. Must have excellent knowledge in cloning, patching, backup recovery of ERP application including knowledge of ODI, FAW/ADW, Performance tuning, SQL profiling Must have hands on experience of RMAN, Backup Management and different Recovery techniques. Design and Implement disaster recovery plans. Support Oracle Cloud and EBS developers for custom coding, code migration, workflow and concurrent requests Knowledge of system administration functionality within Oracle Cloud ERP, Unix Shell Scripting skills on Oracle ODA's and OVM's Excellent interpersonal communication skills Ability to work with team members located in multiple geographies and time zones. Ability to manage and supervise DBA staff in the team. Responsible for providing day-to-day status and maintenance for Oracle EBS and ERP Cloud.
Power Apps Developer Based 2 days month on site in Permanent Opportunity The ideal candidate will need to hold an active NPPV3 We are seeking a talented Power Apps Developer to join our team. In this role, you will be responsible for developing, testing, documenting, and supporting a variety of new and enhanced software solutions and services. Your work will align with enterprise and system architectures and standards to meet defined business needs. Additionally, you will contribute to the continuous improvement of our existing infrastructure. Requirements: - Degree-level education - Proficiency in Power Apps development, including Power Apps Portals, Model-Driven/Canvas Applications, and Microsoft Dataverse - Experience with Microsoft Power Platform, including Power Automate and/or Power BI - Familiarity with Azure DevOps for agile solution delivery - Preferred experience in DotNet development (eg, C#, .Net, Entity Framework, SQL Server) - Experience with Intelligent Automation toolsets such as Power Automate - Knowledge of developing and deploying with providers like Azure & AWS Experience: - Proficiency in relevant programming languages such as Microsoft .Net, ASP, C#, and others like VB, C++ - Good practical knowledge and skills in software development methodologies such as Lean, Agile, and Objectory/UML - Proficiency in application development software tools and languages such as DevOps, XML, XSLT, Business Objects, and Microsoft Visual Studio - Proficiency in database software such as SQL Server, Oracle, MySQL - Strong problem-solving skills - Broad and deep knowledge and experience of diverse products and business requirements - Experience in developing solutions in a large complex organization - Ability to translate user requirements into ICT service designs - Experience in analysing systems, processes, and operational procedures for continual improvement - Ability to lead technical meetings and drive discussions - Familiarity with business analysis techniques Responsibilities: 1. Develop, test, and document new and amended software solutions according to high-level solution designs and agreed standards. 2. Create/review designs, evaluate potential solutions, and undertake detailed data flows/analysis and mappings. 3. Establish and execute plans for unit and system testing, adhering to formal change control processes. 4. Implement products into live operation, adhering to formal change control processes. 5. Deliver effective support and maintenance services for locally developed software systems/solutions. 6. Act as a consulting developer, understanding strategic business requirements and recommending options. 7. Drive continuous improvement and innovation, evaluating emerging technology and new initiatives. 8. Represent and promote the reputation and values of the organization at various meetings and groups. 9. Ensure a balance between service and cost in design decisions. 10. Build and maintain relationships with Managed Service Providers and other suppliers. 11. Undertake other duties as required. Join us in creating impactful solutions and driving innovation in our organization. Apply now!
23/04/2024
Full time
Power Apps Developer Based 2 days month on site in Permanent Opportunity The ideal candidate will need to hold an active NPPV3 We are seeking a talented Power Apps Developer to join our team. In this role, you will be responsible for developing, testing, documenting, and supporting a variety of new and enhanced software solutions and services. Your work will align with enterprise and system architectures and standards to meet defined business needs. Additionally, you will contribute to the continuous improvement of our existing infrastructure. Requirements: - Degree-level education - Proficiency in Power Apps development, including Power Apps Portals, Model-Driven/Canvas Applications, and Microsoft Dataverse - Experience with Microsoft Power Platform, including Power Automate and/or Power BI - Familiarity with Azure DevOps for agile solution delivery - Preferred experience in DotNet development (eg, C#, .Net, Entity Framework, SQL Server) - Experience with Intelligent Automation toolsets such as Power Automate - Knowledge of developing and deploying with providers like Azure & AWS Experience: - Proficiency in relevant programming languages such as Microsoft .Net, ASP, C#, and others like VB, C++ - Good practical knowledge and skills in software development methodologies such as Lean, Agile, and Objectory/UML - Proficiency in application development software tools and languages such as DevOps, XML, XSLT, Business Objects, and Microsoft Visual Studio - Proficiency in database software such as SQL Server, Oracle, MySQL - Strong problem-solving skills - Broad and deep knowledge and experience of diverse products and business requirements - Experience in developing solutions in a large complex organization - Ability to translate user requirements into ICT service designs - Experience in analysing systems, processes, and operational procedures for continual improvement - Ability to lead technical meetings and drive discussions - Familiarity with business analysis techniques Responsibilities: 1. Develop, test, and document new and amended software solutions according to high-level solution designs and agreed standards. 2. Create/review designs, evaluate potential solutions, and undertake detailed data flows/analysis and mappings. 3. Establish and execute plans for unit and system testing, adhering to formal change control processes. 4. Implement products into live operation, adhering to formal change control processes. 5. Deliver effective support and maintenance services for locally developed software systems/solutions. 6. Act as a consulting developer, understanding strategic business requirements and recommending options. 7. Drive continuous improvement and innovation, evaluating emerging technology and new initiatives. 8. Represent and promote the reputation and values of the organization at various meetings and groups. 9. Ensure a balance between service and cost in design decisions. 10. Build and maintain relationships with Managed Service Providers and other suppliers. 11. Undertake other duties as required. Join us in creating impactful solutions and driving innovation in our organization. Apply now!