Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Manage and optimise PostgreSQL, Greenplum, and Snowflake databases while ensuring data security.
- Company: Join a forward-thinking tech company in Glasgow with a hybrid work model.
- Benefits: Competitive day rate, flexible working, and opportunities for skill development.
- Why this job: Be at the forefront of database technology and make a significant impact on data management.
- Qualifications: Extensive experience with PostgreSQL, Greenplum, and Snowflake administration required.
- Other info: Dynamic role with on-call responsibilities and excellent career advancement potential.
The predicted salary is between 43200 - 72000 £ per year.
Location: Glasgow - Hybrid (3 days in office)
Day Rate: £510 (Inside IR35)
Contract Duration: 6 Months
Additional Conditions: On-call over weekends
Role Overview
We are seeking an experienced Database Administrator to manage PostgreSQL, Greenplum or Snowflake databases. The role includes administration, performance tuning, backup and recovery, automation, and supporting data ingestion and integration pipelines.
Focus areas:
- Snowflake DBA – data lakes, architecture, roles, schemas, and databases.
- Greenplum/Postgres DBA – database maintenance, migrations, and performance optimisation.
Responsibilities
- Administer and maintain PostgreSQL, Greenplum, and Snowflake databases
- Design and manage Snowflake data structures, roles, schemas, and databases
- Build and manage data ingestion pipelines (Informatica, Talend)
- Manage data from multiple sources (JSON, XML, CSV)
- Implement Patroni for HADR and streaming replication
- Perform database provisioning, maintenance, upgrades, and migrations (gpcopy)
- Optimise performance using statistics and Greenplum utilities (gpload, PXF, GP spark)
- Manage database bloat and troubleshoot issues using GPTEXT
- Develop scripts in Shell, Python, or Ansible to automate routine tasks
- Ensure database security, compliance, and best practices
- Implement monitoring solutions to proactively detect and resolve issues
- Support cloud deployments (AWS, Azure, GCP)
Essential Skills
- Extensive experience with PostgreSQL, Greenplum, and Snowflake administration
- Postgres: provisioning, maintenance, upgrades, and migrations
- Greenplum: migrations, performance tuning, bloat management, GPTEXT, utilities (gpload, PXF, GP spark)
- Snowflake: architecture, data lakes, roles, schemas, SQL, complex queries
- Expertise in Patroni for HADR and streaming replication
- Scripting skills in Shell, Python, or Ansible
- Experience with backup, recovery, and database security
Desirable Skills
- ETL processes and implementation
- Data ingestion pipelines (Informatica, Talend)
- Cloud experience with AWS, Azure, or GCP
Locations
Database Administrator in Glasgow, Scotland employer: Stott and May
Contact Detail:
Stott and May Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Database Administrator in Glasgow, Scotland
✨Network Like a Pro
Get out there and connect with folks in the industry! Attend meetups, webinars, or even local tech events. You never know who might have the inside scoop on job openings or can put in a good word for you.
✨Show Off Your Skills
Create a portfolio or GitHub repository showcasing your database projects. Whether it's performance tuning or automation scripts, having tangible examples of your work can really impress potential employers.
✨Ace the Interview
Prepare for common DBA interview questions and be ready to discuss your experience with PostgreSQL, Greenplum, and Snowflake. Practice explaining complex concepts in simple terms – it shows you really know your stuff!
✨Apply Through Us!
Don’t forget to check out our website for the latest job openings. Applying directly through us not only gives you a better chance but also keeps you in the loop about new opportunities tailored to your skills.
We think you need these skills to ace Database Administrator in Glasgow, Scotland
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with PostgreSQL, Greenplum, and Snowflake. We want to see how your skills match the role, so don’t be shy about showcasing your database administration 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 Database Administrator role. Share specific examples of your past work with data ingestion pipelines or performance tuning to grab our attention.
Show Off Your Scripting Skills: Since scripting in Shell, Python, or Ansible is essential, make sure to mention any relevant projects or tasks where you’ve used these skills. We love seeing how you automate routine tasks to improve efficiency!
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 the role. Plus, it’s super easy!
How to prepare for a job interview at Stott and May
✨Know Your Databases Inside Out
Make sure you brush up on your PostgreSQL, Greenplum, and Snowflake knowledge. Be ready to discuss your experience with database administration, performance tuning, and migrations. Prepare specific examples of how you've tackled challenges in these areas.
✨Show Off Your Scripting Skills
Since scripting in Shell, Python, or Ansible is essential, be prepared to talk about scripts you've developed. Maybe even bring a sample script to demonstrate your automation skills. This will show that you can handle routine tasks efficiently.
✨Understand the Role of Data Ingestion Pipelines
Familiarise yourself with data ingestion tools like Informatica and Talend. Be ready to explain how you've managed data from various sources and how you’ve built or optimised ingestion pipelines in past roles.
✨Prepare for Scenario-Based Questions
Expect questions that put you in real-world scenarios, such as troubleshooting database bloat or implementing monitoring solutions. Think through your past experiences and how you would approach these situations to demonstrate your problem-solving skills.