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
We use essential cookies to make this site work. With your permission we would also like to use the optional cookies below. Nothing optional is set until you choose, and you can change your mind at any time from "Cookie settings" at the bottom of every page. Cookie policy.
Essential — keep the site working and secure, and remember the choice you make here. Always on.