Clearance: Must have SC (with NPPV3 to be approved once in post)

Location: Hybrid - Home Working & average 1 day per week London or Reading

You will join a global IT consultancy, within a dedicated team tasked with migrating a very large Oracle 11gR1 database and PL/SQL code to PostgreSQL in AWS Cloud. The role will see you

+ Make or guide architectural decisions on the migration approach

+ Model the solutions approach and tooling

+ Support the software's development and testing

Responsibilities:

• Assist as part of a team on the design components of systems
• Code, document changes, follow established processes and conduct unit testing
• Ensure adherence to secure coding standards and best practices
• For more experienced Consultants:
• Produce designs, including for instance program specifications or prototypes/MVPs and backup, recovery and restart procedure, data flows, etc.
• Provide estimates and review the work of developers
• Undertake the complete technical design of smaller applications or components of larger applications using templates and tools
• Specify user/system interfaces and translate designs into technical solutions taking into account of target environment, performance requirements and existing systems
• Produce designs and document all work, using required standards, methods and tools, including prototyping/MVP where appropriate

Technical environment

• PostgreSQL PL/pgSQL
• Oracle PL/SQL
• Code conversion of PL/SQL to PL/pgSQL
• Data Migration from Oracle to PostgreSQL
• PostgreSQL Performance Tuning
• Data Migration
• Performance Tuning
• Postgre SQL
• GIT

Your skills and experience:

• Development:
  • Competence in and understanding of coding best practices, clean code, code review and similar
  • Design, build and assure quality of applications
• Software Design:
  • Specify system behaviour in software components based on requirements
• Demonstrated understanding of current trends in software development and architecture and integration in other systems (eg. Cloud, Automation, APIs, DevOps, Mobile)
• Secure Software Development:
  • Ensure application and data confidentiality, integrity, and availability by developing software having security built in.
• Database Engineering, development of CRUD procedures and functions

PostgreSQL Software Engineer - SC Cleared - Hybrid - 600 - 675 a day