Back to search
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:
- 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
