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
