Postgres DBA/Data Engineer - Active SC
Stealth It
4 days ago
Role details
Contract type
Temporary contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
JuniorJob location
Remote
Tech stack
Databases
Information Engineering
Data Governance
PostgreSQL
Performance Tuning
SQL Stored Procedures
SQL Databases
Indexer
Job description
- 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.
Requirements
- 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.
