Job

Job

SQL Software Engineer - SC Cleared

Job type:Contract
Town/City:London
County:Remote
Salary/Rate:£600 - £675 per day
Business Sector:ICT
Job ref:BBBH152100
Post Date:November 14, 2024

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