At a Glance
- Tasks: Manage and optimise databases using PostgreSQL, Snowflake, and Greenplum.
- Company: Join a world-leading organisation committed to innovation and support.
- Benefits: Competitive daily rate, flexible work environment, and career development opportunities.
- Other info: Inclusive workplace welcoming diverse applicants; excellent growth potential.
- Why this job: Make a real impact on exciting projects in a dynamic tech landscape.
- Qualifications: Experience with database administration and strong SQL skills required.
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
- 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
- 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 utilize GPTEXT for troubleshooting complex issues
- Leverage Greenplum utilities like gpload, pxf, and GP Spark for efficient data loading and integration
- Ensure database security, compliance, and adherence to best practices
- Knowledge about ETL processes and its 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 (DB Administration) on PostgreSQL, Snowflake and Greenplum databases
- For Postgres - Database provisioning, maintenance, and upgrades
- For Greenplum - Data Migrations using gpcopy, performance optimization leveraging Statistics, Manage Db bloat, Understand and utilize GPTEXT for troubleshooting complex issues, experience in Greenplum utilities like gpload, pxf, and GP Spark for efficient data loading and integration
- For Snowflake - Data lakes, data structures and data models suited to Snowflake architecture, Snowflake modelling - roles, schemas and databases
- SQL and complex query writing
- Expertise in Shell/Python/Ansible scripting knowledge
- Expertise in Patroni for HADR and streaming replication
Desirable skills/knowledge/experience:
- ETL processes and its implementation
- Building data ingestion pipelines with tools like Informatica, Talend etc.
- Cloud computing experience with AWS, Microsoft Azure, Google Cloud
This is an excellent opportunity on a great project of work. If you are looking for your next exciting opportunity, apply now for your CV to reach me directly, we will respond as soon as possible.
LA International is an award-winning partner of choice for many of the world's most influential companies and government organisations. Holding Enhanced Government Security Accreditation, we are recognised as the European market leader in the delivery of Security Cleared talent to organisations that demand the very highest levels of security, compliance and assurance.
A multiple award-winning organisation, having secured the prestigious Queens Award for Enterprise: International Trade over consecutive years. 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 we 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.
Please Note: If a high volume of applications is received, only candidates shortlisted will be contacted.
L3 Database Administration in Glasgow employer: LA International Computer Consultants Ltd
Join a world-leading organisation in Glasgow as an L3 Database Administrator, where you will benefit from a supportive work culture that prioritises employee development and inclusivity. With a commitment to innovation and excellence, this progressive company offers exciting opportunities for growth and the chance to make a meaningful impact on long-term projects, all while enjoying competitive rates and a collaborative environment.
Contact Details:
LA International Computer Consultants Ltd Recruitment Team
StudySmarter Expert Advice🤫
We think this is how you could land L3 Database Administration in Glasgow
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, attend meetups, and engage on platforms like LinkedIn. You never know who might have the inside scoop on job openings or can put in a good word for you.
✨Tip Number 2
Prepare for interviews by practising common questions and scenarios related to database administration. We recommend doing mock interviews with friends or using online resources to boost your confidence and refine your answers.
✨Tip Number 3
Showcase your skills through personal projects or contributions to open-source. This not only demonstrates your expertise in PostgreSQL, Snowflake, and Greenplum but also gives you something tangible to discuss during interviews.
✨Tip Number 4
Apply directly through our website! It’s the best way to ensure your application gets seen. Plus, we love seeing candidates who take the initiative to connect with us directly.
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 key responsibilities listed in the job description, so don’t hold back on showcasing your relevant projects!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you’re excited about this opportunity and how your background makes you a perfect fit. We love seeing genuine enthusiasm for the role and our company.
Showcase Your Technical Skills:Be specific about your technical expertise, especially in areas like data ingestion pipelines and database optimisation. We’re looking for candidates who can demonstrate their knowledge of tools like Informatica and Talend, so make sure to include those details!
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 to do!
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 PostgreSQL, Snowflake, and Greenplum knowledge. Be ready to discuss specific features, performance tuning, and backup strategies. The more you can demonstrate your expertise, the better!
✨Showcase Your Problem-Solving Skills
Prepare to talk about past experiences where you've tackled complex database issues. Use examples that highlight your troubleshooting skills, especially with tools like GPTEXT and Patroni for HADR. This will show them you're not just knowledgeable but also practical.
✨Familiarise Yourself with Data Ingestion Tools
Since experience with tools like Informatica and Talend is key, make sure you can discuss how you've used these in previous roles. If you have any projects or successes to share, bring those up to illustrate your hands-on experience.
✨Demonstrate Your Cloud Knowledge
With cloud computing being a big part of this role, be prepared to discuss your experience with AWS, Azure, or Google Cloud. Highlight any relevant projects or certifications that showcase your ability to work in cloud environments.
