Sql Database

Key Skills:

Strong Postgres/PostgreSQL database experience
Open source tools for unit testing e.g. dbunit
Advanced SQL development skills, including writing complex SQL queries/procedures
Write procedures for backup, archiving and disaster recovery
Ensure that the databases achieve maximum performance and availability
Design indexing strategies
Analyse existing SQL queries for performance improvements. Construct and optimise SQL queries using explain analyse and slow query logging
Data transfer mechanisms
Defining the test data requirements
Define database schema and develop best practice approaches
Adherence to industry best practices , standards and adoption of Open Source technologies
Good communication skills
Agile development environments: Scrum, TDD, BDD, Kanban
Well versed with agile ceremonies (stand-up, sprint planning, sprint review, sprint retrospective etc.)
Experience of working on large programmes having number of cross-functional teams
Additional skillset:

Python,
AWS,
NoSQL database
Java, Microservices
Experience in large scale integration projects involving messaging, web-services and distributed systems.
Awareness of Docker based release management process
Public Sector domain experience preferred