PostgreSQL Engineer - Eurobase People : Job Details

My client is a global IT Consultancy working within the public sector in the UK

This role is looking for a Postgres Developer with experience with converting PL/SQL to PL/pgSQL

The role is based in Reading (2 days per week) and is paying £650-700pd Inside ir35 (Umbrella)

Please do not apply if you do not hold ACTIVE SC clearance

Join a dedicated team tasked with migrating a very large Oracle 11gR1 database and PL/SQL code to PostgreSQL in AWS Cloud. This programme is in its infancy so an excellent opportunity for an engineer with the right knowledge and experience to make a deep impact upon the shape and direction of the programme.Make or guide architectural decisions on the migration approachModel the solutions approach and toolingSupport the software's development and testing

Responsibilities:Assist as part of a team on the design components of systemsCode, document changes, follow established processes and conduct unit testingEnsure 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 developersUndertake the complete technical design of smaller applications or components of larger applications using templates and toolsSpecify user/system interfaces and translate designs into technical solutions taking into account of target environment, performance requirements and existing systemsProduce designs and document all work, using required standards, methods and tools, including prototyping/MVP where appropriateContribute to requirements (functional and non-functional)Contribute to the development of coding- and security standards and processesSupport the team in troubleshooting technical issues

Key CompetenciesDevelopment:- 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 requirementsDemonstrated 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"

Required competency:3: 201470 - PostgreSQL PL/pgSQL2: 201386 - Oracle PL/SQL3: Code conversion of PL/SQL to PL/pgSQL3: 200563 - Data Migration from Oracle to PostgreSQL2: 201450 - PostgreSQL Performance Tuning

Desired competency:200467 - AWS Cloud ServicesCode Migration ToolsData Migration Tools200764 - Git