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
L3 Database Administration in Glasgow employer: Dcv Technologies
Join a forward-thinking company that values innovation and collaboration, where as a Senior Software Engineer, you will be at the forefront of developing cutting-edge maritime navigation and radar systems. Our supportive work culture fosters continuous learning and professional growth, offering you the chance to mentor junior engineers while working on impactful projects in a dynamic environment. Located in a vibrant area, we provide competitive benefits and a commitment to work-life balance, making us an excellent employer for those seeking meaningful and rewarding careers.
