Database Administrator

Role/Job title L3 Database Administration Work Location Glasgow Role type Contract InsideIR35 Mode of working Hybrid 3 days/week Duration of assignment 12 months The Role Database Administration of Greenplum/ Postgres/ Snowflake

• Role 1 : Snowflake DBA
• Role 2 : GP/PSG DBA (good to know Snowflake) Your 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 Your Profile Essential skills/knowledge/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 scription 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