L3 Database Administration

Database Administration of Greenplum/ Postgres/ Snowflake

Your responsibilities: Candidate will have extensive working knowledge on PostgreSQL, Snowflake and Greenplum databases.

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.
• Strong knowledge of Postgres/Greenplum database backup and recovery strategies.
• Proven experience in performance tuning and optimization for Postgres/Snowflake and Greenplum.
• Develop and maintain backup strategies to ensure data integrity and availability.
• Manage day-to-day activities such as database provisioning, maintenance, and upgrades in Postgres.
• 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.
• Leverage Greenplum utilities like gpload, pxf, and GP spark for efficient data loading and integration.
• Ensure database security, compliance, and adherence to best practices.
• Knowledge about ETL processes and its implementation.
• 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.

Qualifications

Essential skills/knowledge/experience: Extensive working knowledge (DB Administration) on PostgreSQL, Snowflake and Greenplum databases.

Required Skills

• 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 scripting knowledge.
• Expertise in Patroni for HADR and streaming replication.

Preferred Skills

• ETL processes and its implementation.
• Building data ingestion pipelines with tools like Informatica, Talend etc.
• Cloud computing experience with AWS, Microsoft Azure, Google Cloud.