Snowflake and SQL developer

Job Description :

Snowflake - Support, Maintenance, Remediation and Governance activities.

SQL Servers (ETL, RDM, RDRM, CRM, DPR, Arrear_RM, SSIS) - Support, Maintenance, Remediation and Governance activities.

Key responsibilities:

Good Knowledge on Snowflake, SQL Server.

Support in incident management

Monitor daily operations and data movements (Oracle, SQL Server, Snowflake, Kafka)

Service request handling (user creation, data requests, audit, reporting etc.)

Implement security and user access framework

Support in patching and DR events

Change and problem management

Deployments and RTL Support

Database provisioning, maintenance, and administration

Database and server performance improvement

Data archiving and purging framework

Database monitoring and alerting

Configuration management and documentation

Data protection procedures

Cost monitoring and optimization initiatives

Third-party integrations with multiple tools

Migration of tables from ODS/Oracle to Snowflake (via ODI)

DR and CRM data migration to Snowflake (to avoid legacy reporting)

File loading and file creation frameworks

Storage space and cost optimization

Observability with Datadog dashboards

Minimize Azure SQL DB dependency by moving data to Snoflake.

User access management and auditing

Maintenance and monitoring of database health - daily reports

Table partition implementation

File loading and automation framework

SSIS packages for ETL and parallel file loading jobs

Maintenance and support of legacy jobs

SSIS migration and server decommissioning

ODS to Snowflake migration support

CRM job migration and execution

Storage space optimization and reclamation