Postgres DBA/Data Engineer - Active SC

Job Title: Postgres DBA/Data Engineer
Rate: £450 (Inside IR35)
Duration: 6 months
Location: Remote
Clearance: Active SC
Stages: 1 Stage

Key Responsibilities

• Lead technical discovery of existing PostgreSQL databases, including:
  • Current partitioning strategies
  • Indexing and query patterns
  • Data volumes and growth characteristics
• Design migration to native PostgreSQL declarative partitioning, including:
  • Partition strategy (eg monthly)
  • Indexing and automation considerations
  • Migration and sequencing options
• Analyse complex stored procedures and query behaviour to:
  • Identify performance bottlenecks
  • Validate feasibility of proposed telemetry and observability designs
• Support definition of query observability and telemetry, advising on:
  • What metadata is practical to capture
  • How to minimise overhead
• Contribute to data governance activities by:
  • Supporting metadata discovery
  • Validating lineage assumptions
  • Advising on retention and archival feasibility
• Work collaboratively in a non-agile, Legacy environment where discovery and knowledge recovery are required.

Essential Skills and Experience

• Strong PostgreSQL expertise, including:
  • Declarative partitioning
  • Index design and query planning
  • Performance tuning and vacuum/analyse behaviour
• Experience working with large time-series datasets.
• Ability to analyse and reason about complex SQL and stored procedures.
• Practical understanding of data engineering concepts, including:
  • Ingestion patterns
  • Query telemetry and observability
  • Data life cycle management
• Experience operating in Legacy or under-documented environments.
• Strong communication skills to explain technical findings to architects and stakeholders.