Database Administration

Database Administrator (Level 3)6 Month contract initiallyBased: Max 3 days Onsite in GlasgowRate: £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. Database Administration of Greenplum/ Postgres/ Snowflake Role 1 : Snowflake DBA Role 2 : GP/PSG DBA (good to know Snowflake) 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. LA International is a HMG approved ICT Recruitment and Project Solutions Consultancy, operating globally from the largest single site in the UK as an IT Consultancy or as an Employment Business & Agency depending upon the precise nature of the work, for security cleared jobs or non-clearance vacancies, LA International welcome applications from all sections of the community and from people with diverse experience and backgrounds. Award Winning LA International, winner of the Recruiter Awards for Excellence, Best IT Recruitment Company, Best Public Sector Recruitment Company and overall Gold Award winner, has now secured the most prestigious business award that any business can receive, The Queens Award for Enterprise: International Trade, for the second consecutive period. #J-18808-Ljbffr