PostgreSQL Software Engineer - SC Cleared - Hybrid - £600 - £675 a day 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 approachModel the solutions approach and toolingSupport the software's development and testingResponsibilities: 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 practicesFor 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 appropriateTechnical environment: PostgreSQL PL/pgSQLOracle PL/SQLCode conversion of PL/SQL to PL/pgSQLData Migration from Oracle to PostgreSQLPostgreSQL Performance TuningPerformance TuningGITYour skills and experience: Development:Competence in and understanding of coding best practices, clean code, code review and similarDesign, build and assure quality of applicationsSoftware 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
#J-18808-Ljbffr