At a Glance
- Tasks: Manage and optimise databases using PostgreSQL, Snowflake, and Greenplum technologies.
- Company: Join a forward-thinking tech company in Glasgow with a focus on innovation.
- Benefits: Competitive daily rate, flexible work schedule, and opportunities for professional growth.
- Other info: Inclusive workplace that values diversity and supports all applicants.
- Why this job: Be at the forefront of data technology and make a significant impact in database management.
- Qualifications: Experience with PostgreSQL, Snowflake, and data ingestion tools is essential.
The predicted salary is between 40000 - 45000 £ per year.
12 Month contract initially + Extensions. Based: Glasgow, 3 days per week onsite. Rate: £400-£450 per day (via Umbrella).
Key Responsibilities
- Database Administration of Greenplum/Postgres/Snowflake.
- Snowflake DBA activities.
- Extensive working knowledge of 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 building data ingestion pipelines with tools such as Informatica, Talend, etc.
- Effective management of data from various sources such as JSON, XML, CSV.
- 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/Greenplum.
- Develop and maintain backup strategies to ensure data integrity and availability.
- Manage day‑to‑day activities such as database provisioning, maintenance and upgrades in Postgres.
- Perform data migrations using gpcopy and other tools, minimizing downtime and data loss.
- Manage database bloat and leverage statistics for performance optimization.
- Understand and utilise GPTEXT for troubleshooting complex issues.
- Leverage Greenplum utilities like gpload, pxf and GPspark for efficient data loading and integration.
- Ensure database security, compliance and adherence to best practices.
- Knowledge of ETL processes and implementation.
- Knowledge of SQL and complex query writing.
- Implement monitoring solutions to proactively identify and resolve issues.
- Develop scripts in shell/Python/Ansible to automate routine database tasks and improve operational efficiency.
- Cloud computing experience with AWS, Microsoft Azure, Google Cloud.
Key Skills and Experience
- Extensive working knowledge of PostgreSQL, Snowflake and Greenplum databases.
- For PostgreSQL: database provisioning, maintenance and upgrades.
- For Greenplum: data migrations using gpcopy, performance optimisation leveraging statistics, management of DB bloat, use of GPTEXT, tools such as gpload, pxf and GPspark.
- For Snowflake: data lakes, data structures and models suitable for the architecture, modelling of roles, schemas and databases.
- SQL and complex query writing.
- Expertise in Shell/Python/Ansible scripting.
- Expertise in Patroni for HADR and streaming replication.
Desirable Skills/Knowledge/Experience
- ETL processes and implementation.
- Building data ingestion pipelines with Informatica, Talend, etc.
- Cloud computing experience with AWS, Microsoft Azure, Google Cloud.
Equal Opportunity Statement
We are committed to fostering an inclusive, equitable and accessible workplace where everyone feels valued and supported. We welcome applications from all individuals, regardless of background or identity, and encourage candidates who may not meet every listed requirement to still apply. If you require any adjustments or support during the recruitment process, please let us know and we will work with you to ensure a fair and accessible experience.
L3 Database Administration in Glasgow employer: LA International
Join a forward-thinking company in Glasgow that values innovation and collaboration, offering a dynamic work culture where your expertise in database administration will be recognised and rewarded. With a commitment to employee growth, you will have access to ongoing training and development opportunities, ensuring you stay at the forefront of technology while enjoying a competitive rate and flexible working arrangements. Embrace the chance to contribute to impactful projects in a supportive environment that prioritises inclusivity and diversity.
StudySmarter Expert Advice🤫
We think this is how you could land L3 Database Administration in Glasgow
✨Network Like a Pro
Get out there and connect with folks in the industry! Attend meetups, webinars, or even just grab a coffee with someone who’s already in the database game. 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
When you get the chance to chat with potential employers, don’t hold back! Share your experiences with PostgreSQL, Snowflake, and Greenplum. Talk about those data ingestion pipelines you’ve built and how you’ve optimised performance. Let them see your passion and expertise!
✨Ace the Interview
Prepare for those interviews by brushing up on common questions related to database administration. Think about scenarios where you’ve tackled challenges like database bloat or implemented backup strategies. Practice makes perfect, so run through mock interviews with friends or colleagues.
✨Apply Through Our Website
Don’t forget to check out our website for the latest job openings! Applying directly through us not only shows your interest but also gives you a better chance of being noticed. Plus, we’re all about making the application process as smooth as possible for you.
We think you need these skills to ace L3 Database Administration in Glasgow
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 relevant projects or achievements!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you’re passionate about database administration and how your expertise aligns with our needs. Keep it concise but impactful – we love a good story!
Show Off Your Technical Skills:Don’t forget to mention your experience with data ingestion pipelines and scripting in Shell/Python/Ansible. We’re looking for someone who can hit the ground running, so highlight any relevant tools and technologies you’ve worked with.
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 – just a few clicks and you’re done!
How to prepare for a job interview at LA International
✨Know Your Databases Inside Out
Make sure you brush up on your PostgreSQL, Snowflake, and Greenplum knowledge. Be ready to discuss specific features, performance tuning techniques, and any recent projects you've worked on that involved these databases. The more confident you are in your expertise, the better you'll impress the interviewers.
✨Showcase Your Scripting Skills
Since scripting in Shell, Python, or Ansible is crucial for this role, prepare to talk about scripts you've developed. Bring examples of how you've automated database tasks or improved operational efficiency. If possible, be ready to demonstrate your thought process behind these scripts.
✨Understand Data Ingestion Pipelines
Familiarise yourself with tools like Informatica and Talend, as well as the data ingestion processes you've implemented. Be prepared to discuss how you've managed data from various sources and any challenges you've faced. This will show your practical experience and problem-solving skills.
✨Prepare for Scenario-Based Questions
Expect questions that put you in real-world scenarios, such as troubleshooting complex issues or managing database bloat. Think through your past experiences and how you handled similar situations. This will help you demonstrate your critical thinking and technical skills effectively.
