At a Glance
- Tasks: Administer and optimise PostgreSQL, Greenplum, and Snowflake databases in a dynamic financial services environment.
- Company: Join a leading financial services firm with a focus on data innovation.
- Benefits: Competitive daily rate, hybrid work model, and opportunities for skill enhancement.
- Other info: Collaborative team culture with a focus on cloud-based solutions.
- Why this job: Make an impact in a complex data environment while advancing your database expertise.
- Qualifications: Strong DBA experience with PostgreSQL, Snowflake, and Greenplum required.
The predicted salary is between 85000 - 100000 £ per year.
We are seeking an experienced L3 Database Administrator to join a large-scale enterprise data environment within the financial services sector. The role focuses on administration, optimisation, and support of PostgreSQL, Greenplum, and Snowflake platforms in a complex, data-intensive environment. This is a hands-on technical role requiring deep expertise across database administration, performance tuning, data engineering support, and cloud-based data platforms.
Key Responsibilities
- Administer, maintain, and support PostgreSQL, Greenplum, and Snowflake database environments
- Manage database provisioning, upgrades, patching, and lifecycle activities
- Design and support scalable data models and architectures within Snowflake
- Work with data ingestion pipelines using tools such as Informatica or Talend
- Manage data migration activities using tools such as gpcopy with minimal downtime
- Perform performance tuning, query optimisation, and database health checks
- Handle database backup, recovery, and high availability strategies (including Patroni-based setups)
- Monitor and manage database bloat, statistics, and system performance
- Support troubleshooting using Greenplum utilities such as gpload, PXF, and GP-related tooling
- Automate database operations using Shell scripting, Python, or Ansible
- Work with structured and semi-structured data formats (JSON, XML, CSV)
- Ensure security, compliance, and operational best practices across environments
- Collaborate with engineering teams on ETL processes and data workflows
- Support cloud-based deployments across AWS, Azure, or GCP environments
Essential Skills
- Strong DBA experience across PostgreSQL, Snowflake, and Greenplum
- Advanced SQL and complex query writing
- Experience with PostgreSQL administration (provisioning, upgrades, maintenance)
- Greenplum expertise including performance tuning, gpcopy, and system optimisation
- Snowflake experience including roles, schemas, data modelling, and architecture
- Strong scripting skills in Shell, Python, or Ansible
- Experience with Patroni and streaming replication for high availability
- Strong understanding of data pipelines and ETL concepts
Desirable Skills
- Experience with ETL tools such as Informatica or Talend
- Cloud platform experience (AWS / Azure / GCP)
- Exposure to large-scale enterprise data environments
L3 Database Administrator employer: Queen Square Recruitment
Join a leading financial services firm in Glasgow as an L3 Database Administrator, where you will thrive in a dynamic hybrid work environment that fosters collaboration and innovation. With a strong emphasis on employee growth, the company offers extensive training opportunities and a supportive culture that values your expertise in database management. Enjoy competitive rates and the chance to work with cutting-edge technologies in a complex data landscape, making this an ideal place for professionals seeking meaningful and rewarding careers.
StudySmarter Expert Advice🤫
We think this is how you could land L3 Database Administrator
✨Network Like a Pro
Get out there and connect with people in the industry! Attend meetups, webinars, or even just grab a coffee with someone who works in database administration. You never know who might have a lead on your dream job!
✨Show Off Your Skills
When you get the chance to chat with potential employers, make sure to highlight your hands-on experience with PostgreSQL, Snowflake, and Greenplum. Share specific examples of how you've optimised databases or tackled complex issues – it’ll make you stand out!
✨Tailor Your Approach
Before any interview, do your homework on the company and the role. Understand their tech stack and be ready to discuss how your skills can help them manage their data environments better. This shows you're genuinely interested and prepared!
✨Apply Through Our Website
Don’t forget to check out our website for the latest job openings! Applying directly through us not only gives you access to exclusive roles but also helps us keep track of your application. Let’s land that L3 Database Administrator role together!
We think you need these skills to ace L3 Database Administrator
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your experience with PostgreSQL, Snowflake, and Greenplum. We want to see how your skills match the role, so don’t be shy about showcasing your DBA expertise!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you’re the perfect fit for this L3 Database Administrator role. Share specific examples of your past work that relate to the responsibilities listed in the job description.
Show Off Your Technical Skills:Don’t forget to mention your scripting skills in Shell, Python, or Ansible. We love seeing candidates who can automate database operations, so make sure to include any relevant projects or experiences!
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for this exciting opportunity in our hybrid working environment!
How to prepare for a job interview at Queen Square Recruitment
✨Know Your Databases Inside Out
Make sure you brush up on your PostgreSQL, Greenplum, and Snowflake knowledge. Be ready to discuss your hands-on experience with these platforms, including any specific challenges you've faced and how you overcame them.
✨Show Off Your Scripting Skills
Since scripting is a big part of the role, be prepared to talk about your experience with Shell, Python, or Ansible. Maybe even bring along a small script you've written to demonstrate your skills and thought process.
✨Understand the Financial Services Context
Familiarise yourself with the financial services sector and how database management plays a role in it. Being able to relate your technical skills to industry-specific scenarios will show that you understand the bigger picture.
✨Prepare for Scenario-Based Questions
Expect questions that ask you to solve real-world problems, like optimising a slow query or managing database bloat. Think through some scenarios beforehand so you can articulate your thought process clearly during the interview.
