At a Glance
- Tasks: Administer and optimise databases in a hybrid role with a leading financial institution.
- Company: Join a global financial services leader with a focus on innovation.
- Benefits: Competitive daily rate, hybrid work model, and valuable industry experience.
- Other info: 12-month contract with opportunities for professional growth.
- Why this job: Enhance your database skills while making an impact in the financial sector.
- Qualifications: Extensive DBA experience with PostgreSQL, Snowflake, and Greenplum required.
The predicted salary is between 96000 - 96000 £ per year.
Contracting role based in Glasgow (Hybrid, 3 days in office) for a 12-month engagement within the financial services sector. You will provide expert-level database administration across Snowflake, Greenplum, and PostgreSQL environments, covering performance tuning, data migrations, backup and recovery, security, and automation - supporting a leading global financial institution.
Key Responsibilities:
- Administer and maintain PostgreSQL, Snowflake, and Greenplum databases across provisioning, upgrades, and day-to-day operations.
- Manage Greenplum data migrations using gpcopy, minimising downtime and data loss, and leverage gpload, pxf, and GP Spark for efficient data loading and integration.
- Manage database bloat and utilise GPTEXT for troubleshooting complex Greenplum issues, leveraging statistics for performance optimisation.
- Design and manage Snowflake architecture including data lakes, data structures, roles, schemas, and databases.
What You Will Ideally Bring:
- Extensive hands-on DBA experience across PostgreSQL, Snowflake, and Greenplum - essential.
- Strong SQL skills including complex query writing and performance tuning across Snowflake and PostgreSQL.
- Proven expertise in Patroni for HADR and streaming replication.
- Solid Scripting ability in Shell, Python, and/or Ansible for database automation.
- Experience with Greenplum utilities - gpload, pxf, GP Spark, gpcopy, and GPTEXT.
- Knowledge of ETL processes and data ingestion pipeline tools such as Informatica or Talend - preferred.
- Experience handling structured and unstructured data formats - JSON, XML, CSV.
- Cloud computing experience across AWS, Microsoft Azure, or Google Cloud - advantageous.
Contract Details:
- Duration: 12 months
- Rate: £400 per day
- Location: Glasgow (Hybrid - 3 days on-site)
- Start Date: ASAP
L3 Database Administration - 12 months - Glasgow (Hybrid) employer: Hamilton Barnes
Join a leading global financial institution in Glasgow, where you will thrive in a dynamic hybrid work environment that fosters collaboration and innovation. With a strong emphasis on employee growth, you will have access to ongoing training and development opportunities, ensuring your skills remain at the forefront of the industry. Enjoy a supportive work culture that values diversity and encourages meaningful contributions, making this an excellent place for professionals seeking rewarding careers in database administration.
StudySmarter Expert Advice🤫
We think this is how you could land L3 Database Administration - 12 months - Glasgow (Hybrid)
✨Tip Number 1
Network like a pro! Reach out to your connections in the financial services sector and let them know you're on the hunt for a DBA role. You never know who might have the inside scoop on openings or can put in a good word for you.
✨Tip Number 2
Get your online presence sorted! Make sure your LinkedIn profile is up-to-date and showcases your skills in PostgreSQL, Snowflake, and Greenplum. Recruiters often search for candidates online, so let’s make sure they find you!
✨Tip Number 3
Prepare for those interviews! Brush up on your SQL skills and be ready to discuss your experience with database administration. Practise common interview questions and scenarios related to performance tuning and data migrations.
✨Tip Number 4
Don’t forget to apply through our website! We’ve got loads of opportunities that match your skills. Plus, applying directly can sometimes give you an edge over other candidates. Let’s get you that DBA role!
We think you need these skills to ace L3 Database Administration - 12 months - Glasgow (Hybrid)
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 job description, 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 role. We love seeing enthusiasm for the financial services sector and how your past experiences can contribute to our team.
Show Off Your Technical Skills:Don’t forget to mention your SQL prowess and any scripting abilities you have in Shell, Python, or Ansible. We’re looking for someone who can hit the ground running, so let us know how you’ve used these skills in previous roles!
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. Plus, it’s super easy!
How to prepare for a job interview at Hamilton Barnes
✨Know Your Databases Inside Out
Make sure you brush up on your PostgreSQL, Snowflake, and Greenplum knowledge. Be ready to discuss your hands-on experience with these databases, especially around performance tuning and data migrations. Prepare specific examples of challenges you've faced and how you overcame them.
✨Show Off Your SQL Skills
Since strong SQL skills are essential for this role, practice writing complex queries before the interview. Be prepared to explain your thought process when optimising queries and how you approach performance tuning. This will demonstrate your expertise and problem-solving abilities.
✨Get Familiar with Automation Tools
If you have experience with Shell, Python, or Ansible for database automation, make sure to highlight it. Think of scenarios where you've used these tools to streamline processes or improve efficiency. This will show that you're not just a DBA but also someone who embraces automation.
✨Understand the Financial Services Context
Since this role is within the financial services sector, it’s beneficial to understand the unique challenges and regulations in this field. Research common database issues faced by financial institutions and be ready to discuss how your skills can help address these challenges.
