At a Glance
- Tasks: Manage and optimise databases like PostgreSQL, Snowflake, and Greenplum.
- Company: Join a world-leading organisation with a focus on innovation.
- Benefits: Competitive daily rate, flexible work schedule, and opportunities for professional growth.
- Other info: Long-term contract with potential extensions and a supportive team.
- Why this job: Make a real impact in a progressive environment while developing your skills.
- Qualifications: Extensive knowledge of database management and data processing technologies.
The predicted salary is between 40000 - 45000 £ per year.
12 Month contract initially + Extensions
Based: 3 days p/w onsite in Glasgow
Rate - £400 - £450 p/d (via Umbrella)
We have a great opportunity with a world leading organisation where you will be provided with all of the support and development to succeed. A progressive organisation where you can really make a difference. We have a great opportunity for a Database Administrator on a long term program of work.
Key Responsibilities:- Database Administration of Greenplum/Postgres/Snowflake
- Candidate will have extensive working knowledge on PostgreSQL, Snowflake and Greenplum databases.
- Snowflake internals and integration with other data processing technologies.
- Data lakes, data structures and data models suited to Snowflake architecture.
- Snowflake modelling - roles, schemas and databases.
- Experience of building data ingestion pipelines with tools like Informatica, Talend etc.
- Effective management of data from various sources like JSON, XML, CSV etc.
- Expertise in Patroni for HADR and streaming replication.
- Strong knowledge of Postgres/Greenplum database backup and recovery strategies.
- Proven experience in performance tuning and optimization for Postgres/Snowflake and Greenplum.
- Develop and maintain backup strategies to ensure data integrity and availability.
L3 Database Administration employer: LA International Computer Consultants Ltd
Join a world-leading organisation in Glasgow that prioritises employee development and support, offering a collaborative work culture where your contributions truly matter. With a focus on innovation and growth, this role as a Database Administrator provides you with the opportunity to enhance your skills while working on cutting-edge technologies in a dynamic environment. Enjoy the benefits of a long-term contract with competitive rates and the chance to make a significant impact within a progressive team.
Contact Details:
LA International Computer Consultants Ltd Recruitment Team
StudySmarter Expert Advice🤫
We think this is how you could land L3 Database Administration
✨Tip Number 1
Network like a pro! Reach out to your connections in the database administration field, especially those who work with PostgreSQL, Snowflake, or Greenplum. 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 experience with data ingestion pipelines and performance tuning. This will give potential employers a clear picture of what you can bring to the table.
✨Tip Number 3
Prepare for interviews by brushing up on common DBA scenarios. Be ready to discuss your experience with backup strategies and data management. Practising answers to technical questions can really boost your confidence!
✨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.
We think you need these skills to ace L3 Database Administration
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 key responsibilities listed in the job description, so don’t hold back!
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. Share specific examples of your past work with data ingestion pipelines or performance tuning that relate to the job.
Showcase Your Technical Skills:When filling out your application, be sure to mention any tools you've used like Informatica or Talend. We love seeing candidates who can effectively manage data from various sources, so highlight those 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 don’t miss out on any important updates about the process!
How to prepare for a job interview at LA International Computer Consultants Ltd
✨Know Your Databases Inside Out
Make sure you brush up on your knowledge of PostgreSQL, Snowflake, and Greenplum. Be ready to discuss their internals, integration with other technologies, and how you've used them in past projects. This will show that you're not just familiar with the tools but can also leverage them effectively.
✨Showcase Your Data Pipeline Skills
Prepare to talk about your experience building data ingestion pipelines using tools like Informatica or Talend. Have specific examples ready that highlight your problem-solving skills and how you managed data from various sources like JSON, XML, and CSV. This will demonstrate your hands-on experience and technical prowess.
✨Discuss Backup and Recovery Strategies
Be ready to explain your approach to backup and recovery strategies for Postgres and Greenplum databases. Share any challenges you've faced and how you overcame them. This shows that you understand the importance of data integrity and availability, which is crucial for this role.
✨Prepare for Performance Tuning Questions
Expect questions around performance tuning and optimisation for the databases mentioned. Think of specific instances where you improved performance and be prepared to discuss the methods you used. This will highlight your analytical skills and ability to enhance database efficiency.
