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