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 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:
o Competence in and understanding of coding best practices, clean code, code review and similar
o Design, build and assure quality of applications
* Software Design:
o 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:
o 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
#J-18808-Ljbffr