L3 Database Administration

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