PostgreSQL Software Engineer
This job does not exist anymore.
Try running a new search or browse our vacancies.
Or fill in the form below to receive job alerts.
Job Type | PermContract |
Area | City of London, England |
Sector | Consultancy / IT |
Salary | GBP 600 - 750 Day Rate |
Advertiser | Leanne Hilliard |
Job Ref | 25175 |
Job Views | 96 |
- Description
- 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 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
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
Contribute to requirements (functional and non-functional)
Contribute to the development of coding- and security standards and processes
Support the team in troubleshooting technical issues
Key Competencies
• 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"
Required competency
PostgreSQL PL/pgSQL
Oracle PL/SQL
Code conversion of PL/SQL to PL/pgSQL
Data Migration from Oracle to PostgreSQL
PostgreSQL Performance Tuning
Desired competency
AWS Cloud Services
Code Migration Tools
Data Migration Tools
Git
Your future duties and responsibilities
Required qualifications to be successful in this role