Do you have strong Oracle Applications DBA experience and strive for a new and exciting challenge? We are looking for a strong Senior Database Administrator to provide Production and Development Support Services to a major Oracle E-Business Suite. The team comprises of 11 DBA's who are all ensuring that issues and changes resulting from live incidents, maintenance or approved change requests are identified, resolved and tested prior to implementation. The estate primarily comprises the Oracle eBusiness Suite (Payroll, HR, Finance and CRM). A Strategic Management Information (SMI) solution using OBIEE with an Exadata hosted data warehouse. A Hub interface between the main database and satellite systems, some of which are also in-house while others have third party COTS packages as their front end. This is an exciting time for the team, with plans well underway to transform from current systems to the Cloud. This would give you the opportunity to deploy your skills to support the transition and grow with the team. You will also be supported with training on different areas to help you broaden your knowledge. The role is hybrid with 2 days a week in our Gosport Office. What you will be doing: Maintain the Oracle EBusiness system running in a closed secure network. Maintain the Strategic Management Information (SMI) system, running on a mixture of AIX and Linux, and assist in the upgrade to Oracle Analytics Server (OAS 5.9) Maintain and support the SMI Data Warehouse solution hosted on Exadata appliances. Install Oracle software patches to the relevant environments according to the patch's instructions, as advised by the Patching Manager. Supervise and tune the database environment, ensuring system integrity and performance. Respond to and resolve database problems to ensure system availability. Ensure that the operations team are able to make direct contact when on call. Ensure the Disaster Recovery system is always receiving shipped logs, and they are being applied in a timely fashion to meet the SLAs. Action allocated incident investigation and ensure that resolutions and actions are performed in the required timescales as prioritised and agreed by the DBA Team. Be available for scheduled out of hours maintenance tasks and on-call rotas as agreed with the DBA Team Leader. What you'll bring: Oracle E-Business maintenance skills Performance Tune On experience. Oracle technology installs and upgrades to databases and WebLogic on Unix and Windows Multi-node database installations RMAN Backup and Recovery experience Disaster Recovery with Standby and Fail-Over Ability to attend site out-of-hours, and at weekends if required, for on-call response. It would be great if you had: Experience with Oracle Cloud Infrastructure (OCI) Oracle Business Intelligence technical experience Oracle Enterprise Manager experience SQL & PL/SQL coding experience Unix shell scripting If you are interested in this role but not sure if your skills and experience are exactly what we're looking for, please do apply, we'd love to hear from you! Although the role is advertised as full time, we support different ways of working and can offer a range of flexible working arrangements. So, if you're interested and need to work flexibly, we encourage you to apply and talk to us about what might be possible. Employment Type: Full-time, Permanent Location: Gosport Security Clearance Level: DV Internal Recruiter: Theo Salary: £49,781 Benefits: 25 days annual leave with the choice to buy additional days, life assurance, pension, and generous flexible benefits fund Loved reading about this job and want to know more about SSCL? Shared Services Connected Ltd was established as a joint venture between the Cabinet Office and Sopra Steria, in 2013 as part of the Government's Shared Services Strategy for Smarter Government programme and operates from four regional centres of excellence: Blackpool; Newcastle; Newport; and York. We deliver best in class business transformation programmes to across the Public Sector with a target to release one billion pounds of savings to the public. We have established an enviable track record in the design and delivery of large-scale innovative HR, Payroll, IT, and Finance & Accounting solutions to significantly improve efficiencies and enhance service levels across Government and Public Sector. Our clients include several government agencies including the Department for Work and Pensions, Environment Agency Department for Education, Ministry of Justice and Home Office as well as the Metropolitan Police Service and the Construction Industry Training Board. We embrace difference as a source of creativity, innovation and competitive advantage and are striving to become a more diverse organisation. We welcome applications from people with a diverse variety of backgrounds and identities. We are committed to equality of opportunity for all and do not discriminate on the basis of race, religion, colour, gender, age, disability, sexual orientation or marital status. We have partnered with Vercida , the UK's largest diversity and inclusion focused careers site, where all our vacancies are available in an accessible format. If you require any adjustments to the recruitment process, to enable you to perform to the best of your ability, please let us know when completing your application. We participate in the Disability Confident scheme and are committed to offering an interview to any candidate with a disability, who meets the minimum criteria for the role. If you believe this could apply to you, please let us know when completing your application.
24/09/2022
Full time
Do you have strong Oracle Applications DBA experience and strive for a new and exciting challenge? We are looking for a strong Senior Database Administrator to provide Production and Development Support Services to a major Oracle E-Business Suite. The team comprises of 11 DBA's who are all ensuring that issues and changes resulting from live incidents, maintenance or approved change requests are identified, resolved and tested prior to implementation. The estate primarily comprises the Oracle eBusiness Suite (Payroll, HR, Finance and CRM). A Strategic Management Information (SMI) solution using OBIEE with an Exadata hosted data warehouse. A Hub interface between the main database and satellite systems, some of which are also in-house while others have third party COTS packages as their front end. This is an exciting time for the team, with plans well underway to transform from current systems to the Cloud. This would give you the opportunity to deploy your skills to support the transition and grow with the team. You will also be supported with training on different areas to help you broaden your knowledge. The role is hybrid with 2 days a week in our Gosport Office. What you will be doing: Maintain the Oracle EBusiness system running in a closed secure network. Maintain the Strategic Management Information (SMI) system, running on a mixture of AIX and Linux, and assist in the upgrade to Oracle Analytics Server (OAS 5.9) Maintain and support the SMI Data Warehouse solution hosted on Exadata appliances. Install Oracle software patches to the relevant environments according to the patch's instructions, as advised by the Patching Manager. Supervise and tune the database environment, ensuring system integrity and performance. Respond to and resolve database problems to ensure system availability. Ensure that the operations team are able to make direct contact when on call. Ensure the Disaster Recovery system is always receiving shipped logs, and they are being applied in a timely fashion to meet the SLAs. Action allocated incident investigation and ensure that resolutions and actions are performed in the required timescales as prioritised and agreed by the DBA Team. Be available for scheduled out of hours maintenance tasks and on-call rotas as agreed with the DBA Team Leader. What you'll bring: Oracle E-Business maintenance skills Performance Tune On experience. Oracle technology installs and upgrades to databases and WebLogic on Unix and Windows Multi-node database installations RMAN Backup and Recovery experience Disaster Recovery with Standby and Fail-Over Ability to attend site out-of-hours, and at weekends if required, for on-call response. It would be great if you had: Experience with Oracle Cloud Infrastructure (OCI) Oracle Business Intelligence technical experience Oracle Enterprise Manager experience SQL & PL/SQL coding experience Unix shell scripting If you are interested in this role but not sure if your skills and experience are exactly what we're looking for, please do apply, we'd love to hear from you! Although the role is advertised as full time, we support different ways of working and can offer a range of flexible working arrangements. So, if you're interested and need to work flexibly, we encourage you to apply and talk to us about what might be possible. Employment Type: Full-time, Permanent Location: Gosport Security Clearance Level: DV Internal Recruiter: Theo Salary: £49,781 Benefits: 25 days annual leave with the choice to buy additional days, life assurance, pension, and generous flexible benefits fund Loved reading about this job and want to know more about SSCL? Shared Services Connected Ltd was established as a joint venture between the Cabinet Office and Sopra Steria, in 2013 as part of the Government's Shared Services Strategy for Smarter Government programme and operates from four regional centres of excellence: Blackpool; Newcastle; Newport; and York. We deliver best in class business transformation programmes to across the Public Sector with a target to release one billion pounds of savings to the public. We have established an enviable track record in the design and delivery of large-scale innovative HR, Payroll, IT, and Finance & Accounting solutions to significantly improve efficiencies and enhance service levels across Government and Public Sector. Our clients include several government agencies including the Department for Work and Pensions, Environment Agency Department for Education, Ministry of Justice and Home Office as well as the Metropolitan Police Service and the Construction Industry Training Board. We embrace difference as a source of creativity, innovation and competitive advantage and are striving to become a more diverse organisation. We welcome applications from people with a diverse variety of backgrounds and identities. We are committed to equality of opportunity for all and do not discriminate on the basis of race, religion, colour, gender, age, disability, sexual orientation or marital status. We have partnered with Vercida , the UK's largest diversity and inclusion focused careers site, where all our vacancies are available in an accessible format. If you require any adjustments to the recruitment process, to enable you to perform to the best of your ability, please let us know when completing your application. We participate in the Disability Confident scheme and are committed to offering an interview to any candidate with a disability, who meets the minimum criteria for the role. If you believe this could apply to you, please let us know when completing your application.
Are you an expert in SQL scripts for JPA (Joint Personnel Applications) and Oracle!? Are you considering a new and exciting challenge, where you can make the most of your skills? If so this role may be just for you! We are looking for a Senior Software Engineer with an in depth knowledge of SQL to our team of Software Engineers. The team run the technical infrastructure applications that are responsible for coordinating pay for veterans. They complete data fixes on JPA, the support of archived preserved data for Management Information (MI) purposes and the data loading activities associated with refreshing the Virtual Training Environments. The service was formed in 2007 to provide harmonised administration services and accurate processing of pay, allowances, and pensions to the veterans' communities. IT looks to modernise the way the Client carry out pay administration, based on the introduction of policy and regulations supported by new administration processes and Commercial Off The Shelf (COTS) software. The role is Hybrid with two days per week based in our Gosport office and 3 days remote. What you'll be doing: Manage SQL scripts, collaborating closely with ORACLE on the content of scripts and running scripts on JPA. Producing paperwork for RCB, updating dimensions, creating DBA requests, obtaining customer approval for the changes, Liaising with the functional team members during process. Assist with the resolution of queries raised with the Data Team and other teams. Maintain reference data as supplied approved agencies from the Authority, taking them through the Release Control Board (RCB) process. Maintain accurate figures for work carried out against the Measure of Performance identifiers. Correction of bulk corrupt records, including, creating GFF or SQL correction scripts. Maintain Serena Incidents for the team. Create Data Loader scripts. Interrogate the DPR using SQL to formulate responses to customer queries. Advise on matters relating to VTE, DPR and DPRR as required. The team is growing as workload increases and therefore there may be responsibility to deliver training and support to newer members of the team in the future. What you'll Bring: Experience working with Oracle / JPA Knowledge of writing SQL Scripts SQL and PL experience Ability to prioritise and facilitate large workloads. It would be great if you had: Prior experience working with a government client. If you are interested in this role but not sure if your skills and experience are exactly what we're looking for, please do apply, we'd love to hear from you! Although this role is advertised as full-time, we support different ways of working and can offer a range of flexible working arrangements. So, if you're interested and need to work flexibly, we encourage you to apply and talk to us about what might be possible. Employment Type: Full-time Permanent Location: Gosport Security Clearance Level: SC Internal Recruiter: Theo Salary: £46,969 - £56,363 DOE Benefits: 25 days annual leave with the choice to buy additional days, life assurance, pension, and generous flexible benefits fund Loved reading about this job and want to know more about SSCL? Shared Services Connected Ltd was established as a joint venture between the Cabinet Office and Sopra Steria, in 2013 as part of the Government's Shared Services Strategy for Smarter Government programme and operates from four regional centres of excellence: Blackpool; Newcastle; Newport; and York. We deliver best in class business transformation programmes to across the Public Sector with a target to release one billion pounds of savings to the public. We have established an enviable track record in the design and delivery of large-scale innovative HR, Payroll, IT, and Finance & Accounting solutions to significantly improve efficiencies and enhance service levels across Government and Public Sector. Our clients include several government agencies including the Department for Work and Pensions, Environment Agency Department for Education, Ministry of Justice and Home Office as well as the Metropolitan Police Service and the Construction Industry Training Board. We embrace difference as a source of creativity, innovation and competitive advantage and are striving to become a more diverse organisation. We welcome applications from people with a diverse variety of backgrounds and identities. We are committed to equality of opportunity for all and do not discriminate on the basis of race, religion, colour, gender, age, disability, sexual orientation or marital status. We have partnered with Vercida , the UK's largest diversity and inclusion focused careers site, where all our vacancies are available in an accessible format. If you require any adjustments to the recruitment process, to enable you to perform to the best of your ability, please let us know when completing your application. We participate in the Disability Confident scheme and are committed to offering an interview to any candidate with a disability, who meets the minimum criteria for the role. If you believe this could apply to you, please let us know when completing your application.
24/09/2022
Full time
Are you an expert in SQL scripts for JPA (Joint Personnel Applications) and Oracle!? Are you considering a new and exciting challenge, where you can make the most of your skills? If so this role may be just for you! We are looking for a Senior Software Engineer with an in depth knowledge of SQL to our team of Software Engineers. The team run the technical infrastructure applications that are responsible for coordinating pay for veterans. They complete data fixes on JPA, the support of archived preserved data for Management Information (MI) purposes and the data loading activities associated with refreshing the Virtual Training Environments. The service was formed in 2007 to provide harmonised administration services and accurate processing of pay, allowances, and pensions to the veterans' communities. IT looks to modernise the way the Client carry out pay administration, based on the introduction of policy and regulations supported by new administration processes and Commercial Off The Shelf (COTS) software. The role is Hybrid with two days per week based in our Gosport office and 3 days remote. What you'll be doing: Manage SQL scripts, collaborating closely with ORACLE on the content of scripts and running scripts on JPA. Producing paperwork for RCB, updating dimensions, creating DBA requests, obtaining customer approval for the changes, Liaising with the functional team members during process. Assist with the resolution of queries raised with the Data Team and other teams. Maintain reference data as supplied approved agencies from the Authority, taking them through the Release Control Board (RCB) process. Maintain accurate figures for work carried out against the Measure of Performance identifiers. Correction of bulk corrupt records, including, creating GFF or SQL correction scripts. Maintain Serena Incidents for the team. Create Data Loader scripts. Interrogate the DPR using SQL to formulate responses to customer queries. Advise on matters relating to VTE, DPR and DPRR as required. The team is growing as workload increases and therefore there may be responsibility to deliver training and support to newer members of the team in the future. What you'll Bring: Experience working with Oracle / JPA Knowledge of writing SQL Scripts SQL and PL experience Ability to prioritise and facilitate large workloads. It would be great if you had: Prior experience working with a government client. If you are interested in this role but not sure if your skills and experience are exactly what we're looking for, please do apply, we'd love to hear from you! Although this role is advertised as full-time, we support different ways of working and can offer a range of flexible working arrangements. So, if you're interested and need to work flexibly, we encourage you to apply and talk to us about what might be possible. Employment Type: Full-time Permanent Location: Gosport Security Clearance Level: SC Internal Recruiter: Theo Salary: £46,969 - £56,363 DOE Benefits: 25 days annual leave with the choice to buy additional days, life assurance, pension, and generous flexible benefits fund Loved reading about this job and want to know more about SSCL? Shared Services Connected Ltd was established as a joint venture between the Cabinet Office and Sopra Steria, in 2013 as part of the Government's Shared Services Strategy for Smarter Government programme and operates from four regional centres of excellence: Blackpool; Newcastle; Newport; and York. We deliver best in class business transformation programmes to across the Public Sector with a target to release one billion pounds of savings to the public. We have established an enviable track record in the design and delivery of large-scale innovative HR, Payroll, IT, and Finance & Accounting solutions to significantly improve efficiencies and enhance service levels across Government and Public Sector. Our clients include several government agencies including the Department for Work and Pensions, Environment Agency Department for Education, Ministry of Justice and Home Office as well as the Metropolitan Police Service and the Construction Industry Training Board. We embrace difference as a source of creativity, innovation and competitive advantage and are striving to become a more diverse organisation. We welcome applications from people with a diverse variety of backgrounds and identities. We are committed to equality of opportunity for all and do not discriminate on the basis of race, religion, colour, gender, age, disability, sexual orientation or marital status. We have partnered with Vercida , the UK's largest diversity and inclusion focused careers site, where all our vacancies are available in an accessible format. If you require any adjustments to the recruitment process, to enable you to perform to the best of your ability, please let us know when completing your application. We participate in the Disability Confident scheme and are committed to offering an interview to any candidate with a disability, who meets the minimum criteria for the role. If you believe this could apply to you, please let us know when completing your application.
Are you a Database Administrator looking for your next challenge? We have an exciting new opportunity to join our fast-growing organisation who are instrumental in delivery on key projects for some of the largest government clients. Excellent database experience and superb attention to detail are what you need for this role. You will Provide DBA Production and Development Support Services to a major Oracle estate. Ensuring that issues and changes resulting from live incidents, maintenance or approved change requests are identified, resolved and tested prior to authorised implementation. We can offer excellent career progression opportunities and training and development opportunities! This is a Hybrid role based in our Gosport office, 2 days in the office and 3 days working from home. If you have these skills and want professional development... this could be the role for you... What you will be doing: Maintain the Oracle EBusiness 12.2.5 system running with an Oracle 12 with no cloud ability. Maintain the Strategic Management Information (SMI) system - Oracle Business Intelligence Enterprise Edition (OBIEE) Maintain the SMI Oracle 12.1 Data Warehouse system hosted on a 2 node RAC Exadata V6-X2. Install Oracle software patches to the relevant environments according to the patch's instructions, as directed by the Patching Manager. Supervise and tune the database environment, to ensure system integrity and performance. Respond to and resolve database problems to ensure system availability. Response to problems should strive to ensure that service levels are adhered to. Monitor and action tasks in the DBA group email inbox and ensure that resolutions and actions are performed in the required timescales. What you will bring: Oracle E-Business Suite R12.2 HRMS, Payroll, Finance and CRM skills with an Oracle 12.1 Database Oracle technology installs and upgrades experience Multi-node installations with RAC and load balancing Patching and Cloning Oracle Applications ASM and non-ASM environments Oracle Business Intelligence Enterprise Edition technical skills It would be great if you had: Performance Tuning experience Employment Type: Full Time/Permanent Location Gosport (Hybrid) Security Clearance Leve l DV MOD Internal Recruiter Sophie Salary £40,000 Benefits 25 days annual leave with the option to buy additional days, life assurance, pension and generous benefits flexible fund which is 3% of base salary Loved reading about this job and want to know more about us? Shared Services Connected Ltd was established as a joint venture between the Cabinet Office and Sopra Steria, in 2013 as part of the Government's Shared Services Strategy for Smarter Government programme and operates from four regional centres of excellence: Blackpool; Newcastle; Newport; and York. We deliver best in class business transformation programmes to across the Public Sector with a target to release one billion pounds of savings to the public. We have established an enviable track record in the design and delivery of large-scale innovative HR, Payroll, IT, and Finance & Accounting solutions to significantly improve efficiencies and enhance service levels across Government and Public Sector. Our clients include several government agencies including the Department for Work and Pensions, Environment Agency Department for Education, Ministry of Justice and Home Office as well as the Metropolitan Police Service and the Construction Industry Training Board. We embrace difference as a source of creativity, innovation and competitive advantage and are striving to become a more diverse organisation. We welcome applications from people with a diverse variety of backgrounds and identities. We are committed to equality of opportunity for all and do not discriminate on the basis of race, religion, colour, gender, age, disability, sexual orientation or marital status. We have partnered with Vercida , the UK's largest diversity and inclusion focused careers site, where all our vacancies are available in an accessible format. If you require any adjustments to the recruitment process, to enable you to perform to the best of your ability, please let us know when completing your application. We participate in the Disability Confident scheme and are committed to offering an interview to any candidate with a disability, who meets the minimum criteria for the role. If you believe this could apply to you, please let us know when completing your application.
21/09/2022
Full time
Are you a Database Administrator looking for your next challenge? We have an exciting new opportunity to join our fast-growing organisation who are instrumental in delivery on key projects for some of the largest government clients. Excellent database experience and superb attention to detail are what you need for this role. You will Provide DBA Production and Development Support Services to a major Oracle estate. Ensuring that issues and changes resulting from live incidents, maintenance or approved change requests are identified, resolved and tested prior to authorised implementation. We can offer excellent career progression opportunities and training and development opportunities! This is a Hybrid role based in our Gosport office, 2 days in the office and 3 days working from home. If you have these skills and want professional development... this could be the role for you... What you will be doing: Maintain the Oracle EBusiness 12.2.5 system running with an Oracle 12 with no cloud ability. Maintain the Strategic Management Information (SMI) system - Oracle Business Intelligence Enterprise Edition (OBIEE) Maintain the SMI Oracle 12.1 Data Warehouse system hosted on a 2 node RAC Exadata V6-X2. Install Oracle software patches to the relevant environments according to the patch's instructions, as directed by the Patching Manager. Supervise and tune the database environment, to ensure system integrity and performance. Respond to and resolve database problems to ensure system availability. Response to problems should strive to ensure that service levels are adhered to. Monitor and action tasks in the DBA group email inbox and ensure that resolutions and actions are performed in the required timescales. What you will bring: Oracle E-Business Suite R12.2 HRMS, Payroll, Finance and CRM skills with an Oracle 12.1 Database Oracle technology installs and upgrades experience Multi-node installations with RAC and load balancing Patching and Cloning Oracle Applications ASM and non-ASM environments Oracle Business Intelligence Enterprise Edition technical skills It would be great if you had: Performance Tuning experience Employment Type: Full Time/Permanent Location Gosport (Hybrid) Security Clearance Leve l DV MOD Internal Recruiter Sophie Salary £40,000 Benefits 25 days annual leave with the option to buy additional days, life assurance, pension and generous benefits flexible fund which is 3% of base salary Loved reading about this job and want to know more about us? Shared Services Connected Ltd was established as a joint venture between the Cabinet Office and Sopra Steria, in 2013 as part of the Government's Shared Services Strategy for Smarter Government programme and operates from four regional centres of excellence: Blackpool; Newcastle; Newport; and York. We deliver best in class business transformation programmes to across the Public Sector with a target to release one billion pounds of savings to the public. We have established an enviable track record in the design and delivery of large-scale innovative HR, Payroll, IT, and Finance & Accounting solutions to significantly improve efficiencies and enhance service levels across Government and Public Sector. Our clients include several government agencies including the Department for Work and Pensions, Environment Agency Department for Education, Ministry of Justice and Home Office as well as the Metropolitan Police Service and the Construction Industry Training Board. We embrace difference as a source of creativity, innovation and competitive advantage and are striving to become a more diverse organisation. We welcome applications from people with a diverse variety of backgrounds and identities. We are committed to equality of opportunity for all and do not discriminate on the basis of race, religion, colour, gender, age, disability, sexual orientation or marital status. We have partnered with Vercida , the UK's largest diversity and inclusion focused careers site, where all our vacancies are available in an accessible format. If you require any adjustments to the recruitment process, to enable you to perform to the best of your ability, please let us know when completing your application. We participate in the Disability Confident scheme and are committed to offering an interview to any candidate with a disability, who meets the minimum criteria for the role. If you believe this could apply to you, please let us know when completing your application.
Are you looking for an opportunity as a Senior Oracle Developer where you will take responsibility for the completion of allocated work packages within agreed time, quality and cost? What you will be doing: You will maintain the status of development activities pertaining to allocated work package. In addition, you will work closely with the business consultants, developers, designers & business/system leg testers, ensuring timely communication of dependencies, risks & issues relating to allocated work package, dependant work packages and upcoming stages Rapid generation and demonstration of prototypes in consultation with business consultants using Oracle SQL, PL-SQL and Oracle forms/Reports. Design and develop routines using PL/SQL. Develop user interface screens using Oracle 12c Forms and Reports Participate in low level application design workshops and contribute to database design activities; Preparation of design specifications (DS) based on the first draft of the functional specifications (FS); Submit review comments on FS, DS. Construct code based on the Functional and Design Spec; submit feedback on potential scope creep situations. Perform peer group unit test & code reviews. Perform defect analysis and bug fixing duly maintaining defect evolution Identify, document and monitor issues & risks and advise the impact of the same to the Delivery Manager Adhere to quality processes What you'll bring: You will have proven experience with the following skills - SQL, PL/SQL Oracle 12c Forms and Reports Oracle 12c Database Serena Dimensions or any equivalent tool It would be great if you had knowledge of: Oracle APEX Java Oracle Identity and Access Management Employment Type - Full Time, Permanent Location - Hemel Hempstead with hybrid working Security Clearance Level - eligible for SC Internal Recruiter - Lee Brown Salary - up to £55k Benefits - 25 days annual leave with the option to buy additional days, life assurance, pension, and generous benefits fund of up to £1650 per annum (3% of salary) Although this role is advertised as full-time, we believe that flexibility at work can promote work/life balance, increase your motivation, reduce stress and improve performance and productivity. We support different ways of working and can offer a range of flexible working arrangements. So, if you're interested and need to work flexibly, we encourage you to apply and talk to us about what might be possible. Loved reading about this job and want to know more about our company? Sopra Steria's Aerospace, Defence and Security business designs, develops and deploys digital solutions to Central Government clients. The work we do makes a real difference to the client's goal of National Security, and we operate in a unique and privileged environment. We are given time for professional development activities, and we coach and mentor our colleagues, sharing knowledge and learning from each other. We foster a culture in which employees feel valued and supported and have pride in their work for the customer, delivering outstanding rates of customer satisfaction in the UK's most complex safety- and security-critical markets. Our technical specialists deploy systems running many of the major operating systems such as Microsoft Windows, Mac OS, and multiple Linux distros. We also provide Messaging and Collaboration systems and support, Application packaging and deployment, along with supporting Infrastructure and Cloud services and support. Our time can be split between our services and project work, so we have the chance to be multi-disciplined and access to a range of technologies. We embrace difference as a source of creativity, innovation and competitive advantage and are striving to become a more diverse organisation. We welcome applications from people with a diverse variety of backgrounds and identities. We are committed to equality of opportunity for all and do not discriminate on the basis of race, religion, colour, gender, age, disability, sexual orientation or marital status. We have partnered with Vercida , the UK's largest diversity and inclusion focused careers site, where all our vacancies are available in an accessible format. If you require any adjustments to the recruitment process, to enable you to perform to the best of your ability, please let us know when completing your application. We participate in the Disability Confident scheme and are committed to offering an interview to any candidate with a disability, who meets the minimum criteria for the role. If you believe this could apply to you, please let us know when completing your application.
21/09/2022
Full time
Are you looking for an opportunity as a Senior Oracle Developer where you will take responsibility for the completion of allocated work packages within agreed time, quality and cost? What you will be doing: You will maintain the status of development activities pertaining to allocated work package. In addition, you will work closely with the business consultants, developers, designers & business/system leg testers, ensuring timely communication of dependencies, risks & issues relating to allocated work package, dependant work packages and upcoming stages Rapid generation and demonstration of prototypes in consultation with business consultants using Oracle SQL, PL-SQL and Oracle forms/Reports. Design and develop routines using PL/SQL. Develop user interface screens using Oracle 12c Forms and Reports Participate in low level application design workshops and contribute to database design activities; Preparation of design specifications (DS) based on the first draft of the functional specifications (FS); Submit review comments on FS, DS. Construct code based on the Functional and Design Spec; submit feedback on potential scope creep situations. Perform peer group unit test & code reviews. Perform defect analysis and bug fixing duly maintaining defect evolution Identify, document and monitor issues & risks and advise the impact of the same to the Delivery Manager Adhere to quality processes What you'll bring: You will have proven experience with the following skills - SQL, PL/SQL Oracle 12c Forms and Reports Oracle 12c Database Serena Dimensions or any equivalent tool It would be great if you had knowledge of: Oracle APEX Java Oracle Identity and Access Management Employment Type - Full Time, Permanent Location - Hemel Hempstead with hybrid working Security Clearance Level - eligible for SC Internal Recruiter - Lee Brown Salary - up to £55k Benefits - 25 days annual leave with the option to buy additional days, life assurance, pension, and generous benefits fund of up to £1650 per annum (3% of salary) Although this role is advertised as full-time, we believe that flexibility at work can promote work/life balance, increase your motivation, reduce stress and improve performance and productivity. We support different ways of working and can offer a range of flexible working arrangements. So, if you're interested and need to work flexibly, we encourage you to apply and talk to us about what might be possible. Loved reading about this job and want to know more about our company? Sopra Steria's Aerospace, Defence and Security business designs, develops and deploys digital solutions to Central Government clients. The work we do makes a real difference to the client's goal of National Security, and we operate in a unique and privileged environment. We are given time for professional development activities, and we coach and mentor our colleagues, sharing knowledge and learning from each other. We foster a culture in which employees feel valued and supported and have pride in their work for the customer, delivering outstanding rates of customer satisfaction in the UK's most complex safety- and security-critical markets. Our technical specialists deploy systems running many of the major operating systems such as Microsoft Windows, Mac OS, and multiple Linux distros. We also provide Messaging and Collaboration systems and support, Application packaging and deployment, along with supporting Infrastructure and Cloud services and support. Our time can be split between our services and project work, so we have the chance to be multi-disciplined and access to a range of technologies. We embrace difference as a source of creativity, innovation and competitive advantage and are striving to become a more diverse organisation. We welcome applications from people with a diverse variety of backgrounds and identities. We are committed to equality of opportunity for all and do not discriminate on the basis of race, religion, colour, gender, age, disability, sexual orientation or marital status. We have partnered with Vercida , the UK's largest diversity and inclusion focused careers site, where all our vacancies are available in an accessible format. If you require any adjustments to the recruitment process, to enable you to perform to the best of your ability, please let us know when completing your application. We participate in the Disability Confident scheme and are committed to offering an interview to any candidate with a disability, who meets the minimum criteria for the role. If you believe this could apply to you, please let us know when completing your application.
Are you a Senior DBA looking for a new challenge? Reporting to the Technical Operations Lead, the role of the Senior Database Administrator Lead, will be to support delivery of database services within the hosting environment in line with client SLAs. This will involve supporting development and implementation of the database platform ready to be populated by applications from the client and, monitoring, managing and fine-tuning this environment, throughout the whole lifecycle. This is a Database lead role, where you will lead a small team across multiple client sites. You will be responsible for carrying out mentoring, 1-2-1's and workflows of your team. What you will be doing: Implement Database environments in line with client requests Support resolution of issues with Database environment owning trouble tickets to conclusion Maintain records of current database sizes and configurations Maintain database backups for use in the event of system failure Proactively monitor database use and performance Advise on and implements additional database storage and new databases as required Administration of databases Ensure database designs provide for Disaster Recovery Planning Install and configure the database environment and software Manage and execute changes on the database in line with Client requests Attach and detach storage from the database Implement server specific governance including password policy, user access, default settings etc. Conduct all data imports, exports and adjustments to data structure and/or data model in line with client requests Perform regular KPI Reporting Develop databases that support multiple data models and extended capabilities such as spatial and graph, and support data virtualisation, distributed storage, and in memory storage e.g. for the use of high performance satellite image analysis and recognition Provide support for real time processing on transactional data or hybrid transactional analytic database systems You will need: Significant experience in SQL Server Database Administration covering multiple versions of Microsoft SQL Server PostgreSQL/MySQL Oracle Databases Experience working with database performance tuning Ability to anticipate problems and take decisive action Out of Hours Maintain accurate records and documentation Experience applying ITIL methodology It would be great if you had: Experience involving multiple software vendors Knowledge of Storage Technologies Willing to work out of hours and attend remote sites Experience working in virtualised environment If you are interested in this role but not sure if your skills and experience are exactly what we're looking for, please do apply, we'd love to hear from you! Employment Type: Full-time Location: Stevenage OR Portsmouth Security Clearance Level: Must be eligible for SC Internal Recruiter: Josh Huggins-Smith Salary: £55,000 to £65,000 Benefits: 25 days annual leave with the option to buy additional days, life assurance, pension, and generous flexible benefits fund Although this role is advertised as full-time, we believe that flexibility at work can promote work/life balance, increase your motivation, reduce stress and improve performance and productivity. We support different ways of working and can offer a range of flexible working arrangements. So, if you're interested and need to work flexibly, we encourage you to apply and talk to us about what might be possible. Loved reading about this job and want to know more about our company? Sopra Steria's Aerospace, Defence and Security business designs, develops and deploys digital solutions to Central Government clients. The work we do makes a real difference to the client's goal of National Security, and we operate in a unique and privileged environment. We are given time for professional development activities, and we coach and mentor our colleagues, sharing knowledge and learning from each other. We foster a culture in which employees feel valued and supported and have pride in their work for the customer, delivering outstanding rates of customer satisfaction in the UK's most complex safety- and security-critical markets. Our technical specialists deploy systems running many of the major operating systems such as Microsoft Windows, Mac OS, and multiple Linux distros. We also provide Messaging and Collaboration systems and support, Application packaging and deployment, along with supporting Infrastructure and Cloud services and support. Our time can be split between our services and project work, so we have the chance to be multi-disciplined and access to a range of technologies. We embrace difference as a source of creativity, innovation and competitive advantage and are striving to become a more diverse organisation. We welcome applications from people with a diverse variety of backgrounds and identities. We are committed to equality of opportunity for all and do not discriminate on the basis of race, religion, colour, gender, age, disability, sexual orientation or marital status. We have partnered with Vercida , the UK's largest diversity and inclusion focused careers site, where all our vacancies are available in an accessible format. If you require any adjustments to the recruitment process, to enable you to perform to the best of your ability, please let us know when completing your application. We participate in the Disability Confident scheme and are committed to offering an interview to any candidate with a disability, who meets the minimum criteria for the role. If you believe this could apply to you, please let us know when completing your application.
21/09/2022
Full time
Are you a Senior DBA looking for a new challenge? Reporting to the Technical Operations Lead, the role of the Senior Database Administrator Lead, will be to support delivery of database services within the hosting environment in line with client SLAs. This will involve supporting development and implementation of the database platform ready to be populated by applications from the client and, monitoring, managing and fine-tuning this environment, throughout the whole lifecycle. This is a Database lead role, where you will lead a small team across multiple client sites. You will be responsible for carrying out mentoring, 1-2-1's and workflows of your team. What you will be doing: Implement Database environments in line with client requests Support resolution of issues with Database environment owning trouble tickets to conclusion Maintain records of current database sizes and configurations Maintain database backups for use in the event of system failure Proactively monitor database use and performance Advise on and implements additional database storage and new databases as required Administration of databases Ensure database designs provide for Disaster Recovery Planning Install and configure the database environment and software Manage and execute changes on the database in line with Client requests Attach and detach storage from the database Implement server specific governance including password policy, user access, default settings etc. Conduct all data imports, exports and adjustments to data structure and/or data model in line with client requests Perform regular KPI Reporting Develop databases that support multiple data models and extended capabilities such as spatial and graph, and support data virtualisation, distributed storage, and in memory storage e.g. for the use of high performance satellite image analysis and recognition Provide support for real time processing on transactional data or hybrid transactional analytic database systems You will need: Significant experience in SQL Server Database Administration covering multiple versions of Microsoft SQL Server PostgreSQL/MySQL Oracle Databases Experience working with database performance tuning Ability to anticipate problems and take decisive action Out of Hours Maintain accurate records and documentation Experience applying ITIL methodology It would be great if you had: Experience involving multiple software vendors Knowledge of Storage Technologies Willing to work out of hours and attend remote sites Experience working in virtualised environment If you are interested in this role but not sure if your skills and experience are exactly what we're looking for, please do apply, we'd love to hear from you! Employment Type: Full-time Location: Stevenage OR Portsmouth Security Clearance Level: Must be eligible for SC Internal Recruiter: Josh Huggins-Smith Salary: £55,000 to £65,000 Benefits: 25 days annual leave with the option to buy additional days, life assurance, pension, and generous flexible benefits fund Although this role is advertised as full-time, we believe that flexibility at work can promote work/life balance, increase your motivation, reduce stress and improve performance and productivity. We support different ways of working and can offer a range of flexible working arrangements. So, if you're interested and need to work flexibly, we encourage you to apply and talk to us about what might be possible. Loved reading about this job and want to know more about our company? Sopra Steria's Aerospace, Defence and Security business designs, develops and deploys digital solutions to Central Government clients. The work we do makes a real difference to the client's goal of National Security, and we operate in a unique and privileged environment. We are given time for professional development activities, and we coach and mentor our colleagues, sharing knowledge and learning from each other. We foster a culture in which employees feel valued and supported and have pride in their work for the customer, delivering outstanding rates of customer satisfaction in the UK's most complex safety- and security-critical markets. Our technical specialists deploy systems running many of the major operating systems such as Microsoft Windows, Mac OS, and multiple Linux distros. We also provide Messaging and Collaboration systems and support, Application packaging and deployment, along with supporting Infrastructure and Cloud services and support. Our time can be split between our services and project work, so we have the chance to be multi-disciplined and access to a range of technologies. We embrace difference as a source of creativity, innovation and competitive advantage and are striving to become a more diverse organisation. We welcome applications from people with a diverse variety of backgrounds and identities. We are committed to equality of opportunity for all and do not discriminate on the basis of race, religion, colour, gender, age, disability, sexual orientation or marital status. We have partnered with Vercida , the UK's largest diversity and inclusion focused careers site, where all our vacancies are available in an accessible format. If you require any adjustments to the recruitment process, to enable you to perform to the best of your ability, please let us know when completing your application. We participate in the Disability Confident scheme and are committed to offering an interview to any candidate with a disability, who meets the minimum criteria for the role. If you believe this could apply to you, please let us know when completing your application.
