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
