At a Glance
- Tasks: Manage and optimise databases using PostgreSQL, Snowflake, and Greenplum technologies.
- Company: Join a world-leading organisation with a progressive culture and supportive environment.
- Benefits: Competitive daily rate, flexible work arrangements, and opportunities for professional growth.
- Other info: Dynamic freelance role with potential for career advancement in a globally recognised company.
- Why this job: Make a real impact on exciting projects while developing your skills in cutting-edge database technologies.
- Qualifications: Extensive experience in database administration and knowledge of SQL and ETL processes.
6 Month contract initially
Based: Max 3 days Onsite in Glasgow
Rate: £450 - £550 p/d - (via Umbrella company)
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 number of Database Administrators (Level 3) to join the team.
Key Responsibilities:
- 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 modeling - 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 & 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 modeling - 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.
Database Administration (Level 3) (IT) / Freelance employer: LA International Computer Consultants Ltd
Join a world-leading organisation in Glasgow as a Database Administrator (Level 3) and enjoy a supportive work culture that prioritises your professional development. With a focus on innovation and collaboration, you'll have the opportunity to make a significant impact while working on exciting projects. Benefit from competitive rates, flexible onsite requirements, and the chance to be part of an award-winning team recognised for excellence in IT recruitment.
Contact Details:
LA International Computer Consultants Ltd Recruitment Team
StudySmarter Expert Advice🤫
We think this is how you could land Database Administration (Level 3) (IT) / Freelance
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, attend meetups, and engage in online forums. You never know who might have the inside scoop on job openings or can refer you directly.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your database projects, especially those involving PostgreSQL, Snowflake, and Greenplum. This will give potential employers a taste of what you can do beyond just your CV.
✨Tip Number 3
Prepare for interviews by brushing up on common DBA scenarios and challenges. Be ready to discuss your experience with data ingestion pipelines and performance tuning, as these are hot topics in the field right now.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we’re always looking for talented individuals like you to join our team!
We think you need these skills to ace Database Administration (Level 3) (IT) / Freelance
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your extensive 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!
Showcase Your Projects:If you've worked on any relevant projects, especially involving data ingestion pipelines or database performance tuning, be sure to include them. We love seeing real-world applications of your skills!
Keep It Clear and Concise:While we appreciate detail, make sure your application is easy to read. Use bullet points for your skills and experiences, and keep your language straightforward. We want to get to know you quickly!
Apply Through Our Website:For the best chance of success, apply directly through our website. This way, your application goes straight to us, and we can review it promptly. We’re excited to hear from you!
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 share examples of how you've tackled complex database issues in the past. Whether it's troubleshooting with GPTEXT or managing database bloat, having real-world scenarios will impress your interviewers.
✨Familiarise Yourself with Data Ingestion Tools
Since experience with tools like Informatica and Talend is key, make sure you can talk about your hands-on experience with these technologies. Highlight any projects where you built data ingestion pipelines to show your practical skills.
✨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. Share specific examples of how you've leveraged cloud services for database management and optimisation.
