At a Glance
- Tasks: Lead PostgreSQL database discovery and design migration strategies for optimal performance.
- Company: Join a forward-thinking team focused on data engineering excellence.
- Benefits: Competitive rate, remote work flexibility, and a chance to enhance your skills.
- Other info: Collaborative environment with opportunities for professional growth.
- Why this job: Make a real impact by optimising databases and improving data governance.
- Qualifications: Strong PostgreSQL expertise and experience with large datasets required.
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.
Postgres DBA/Data Engineer - Active SC employer: Stealth iT Consulting
As a Postgres DBA/Data Engineer with us, you'll thrive in a supportive remote work environment that values collaboration and innovation. We offer competitive rates, opportunities for professional growth, and a culture that encourages knowledge sharing and technical discovery, making it an ideal place for those looking to make a meaningful impact in data engineering.
StudySmarter Expert Advice🤫
We think this is how you could land Postgres DBA/Data Engineer - Active SC
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, especially those who work with PostgreSQL or data engineering. A friendly chat can lead to insider info about job openings that aren't even advertised yet.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your PostgreSQL projects, including any performance tuning or complex SQL queries you've tackled. This will give potential employers a taste of what you can bring to the table.
✨Tip Number 3
Prepare for interviews by brushing up on common PostgreSQL scenarios and challenges. Be ready to discuss your experience with partitioning strategies and query optimisation, as these are hot topics for this role.
✨Tip Number 4
Don't forget to apply through our website! We make it easy for you to submit your application directly, and it shows you're serious about joining our team. Plus, we love seeing candidates who take that extra step!
We think you need these skills to ace Postgres DBA/Data Engineer - Active SC
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your PostgreSQL expertise and experience with large datasets. We want to see how your skills match the job description, so don’t be shy about showcasing your relevant projects!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you’re the perfect fit for the Postgres DBA/Data Engineer role. We love seeing your personality come through, so keep it engaging and relevant.
Showcase Your Problem-Solving Skills:In your application, mention specific examples where you've tackled performance bottlenecks or worked in legacy environments. We’re looking for candidates who can think critically and adapt to challenges!
Apply Through Our Website:Don’t forget to submit your application through our website! It’s the easiest way for us to keep track of your application and ensure it gets the attention it deserves.
How to prepare for a job interview at Stealth iT Consulting
✨Know Your PostgreSQL Inside Out
Make sure you brush up on your PostgreSQL skills, especially around declarative partitioning and indexing strategies. Be ready to discuss your experience with performance tuning and how you've tackled complex SQL queries in the past.
✨Prepare for Technical Discovery Questions
Expect questions about your approach to analysing existing databases and identifying performance bottlenecks. Think of specific examples where you've successfully led technical discovery and how you validated telemetry designs.
✨Showcase Your Data Engineering Knowledge
Be prepared to talk about data ingestion patterns and lifecycle management. Highlight any experience you have with large time-series datasets and how you've managed them in legacy environments.
✨Communicate Clearly and Effectively
Strong communication skills are key! Practice explaining your technical findings in a way that non-technical stakeholders can understand. This will show that you can bridge the gap between technical and non-technical teams.
