L3 Database Administration in Glasgow, City of Glasgow

Posted by DCV Technologies

Our leading multinational investment bank and financial services client is currebtly looking for x2 L3 DBA's for the Database Administration of Greenplum/ Postgres/ Snowflake. The successful candidates will have extensive working knowledge on PostgreSQL, Snowflake and Greenplum databases.

Role 1 : Snowflake DBA

Role 2 : GP/PSG DBA (good to know Snowflake)

Your Profile

Essential skills/knowledge/experience:

  • 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

Your responsibilities:

  • 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.
  • Proven experience in performance tuning and optimization for Postgres/Snowflake and Greenplum.
  • Develop and maintain backup strategies to ensure data integrity and availability.
  • 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.
  • Ensure database security, compliance, and adherence to best practices.
  • 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
Apply Now →

Application opens at the source listing. Free for jobseekers.

Related Jobs