Matillion & Snowflake Administrator

Job Role : Matillion & Snowflake AdministratorClient Location : Hyderabad/Bengaluru/ChennaiJoining : Earlier the bestEmployment : Full-timeWe are looking for an experienced Matillion and Snowflake Administrator with strong hands-on expertise in administering, monitoring, securing, optimizing, and supporting enterprise data platforms.The ideal candidate will be responsible for the day-to-day administration of Matillion and Snowflake environments, including user and access management, platform monitoring, security, performance optimization, cost management, environment management, upgrades, production support, and troubleshooting.The role requires close collaboration with Data Engineering, Cloud Infrastructure, Security, DevOps, BI, and Application teams to ensure high availability, reliability, scalability, and security of the data platform.Key Responsibilities :Matillion Administration :- Administer and support Matillion environments across Development, QA, UAT, and Production.- Manage Matillion users, roles, permissions, access controls, and environment configurations.- Monitor Matillion platform health, job execution, resource utilization, and operational performance.- Configure and maintain Matillion agents, environments, credentials, connections, and integrations.- Manage platform configurations, upgrades, patches, and version changes.- Monitor scheduled jobs and troubleshoot failed or long-running jobs in coordination with development teams.- Support connectivity between Matillion and data sources, cloud storage platforms, Snowflake, APIs, and other enterprise systems.- Manage credentials, secrets, authentication mechanisms, and secure connectivity.- Perform environment health checks and proactively identify performance or capacity issues.- Support backup, recovery, high availability, and disaster recovery procedures.- Assist with migration and promotion of configurations across environments.- Maintain platform standards, operational procedures, monitoring dashboards, and support runbooks.- Work with Matillion support for product-related issues and incident resolution.Snowflake Administration :- Administer and support Snowflake accounts and environments across Development, QA, UAT, and Production.- Manage users, roles, privileges, warehouses, databases, schemas, and access controls.- Design, implement, and maintain Role-Based Access Control frameworks.- Manage authentication and security configurations, including SSO, MFA, OAuth, key-pair authentication, and network policies.- Configure and maintain storage integrations, security integrations, external stages, and API integrations.- Monitor Snowflake account usage, query performance, storage utilization, and credit consumption.- Manage virtual warehouses, auto-suspend, auto-resume, scaling policies, and resource monitors.- Perform workload monitoring and support query and warehouse performance optimization.- Implement and monitor Snowflake cost-control and optimization measures.- Support Snowflake replication, failover, disaster recovery, and business continuity processes.- Manage data retention, Time Travel, cloning, and data-sharing configurations.- Support Snowpipe, Streams, Tasks, Dynamic Tables, and other platform-level services from an administration perspective.- Monitor failed queries, access issues, blocked workloads, and platform incidents.- Support auditing, compliance, governance, masking policies, row access policies, and tagging requirements.- Coordinate with Snowflake support for platform-related issues and service incidents.Production Support & Operations :- Provide administration and operational support for Matillion and Snowflake production environments.- Monitor platform availability, scheduled workloads, alerts, and critical incidents.- Troubleshoot access, connectivity, authentication, configuration, and performance issues.- Participate in incident management, problem management, and root-cause analysis.- Maintain operational documentation, SOPs, support runbooks, and knowledge-base articles.- Support change management, release management, and platform maintenance activities.- Automate repetitive administrative and monitoring activities where applicable.- Collaborate with Security, Infrastructure, DevOps, and Data Engineering teams on platform improvements. (ref:hirist.tech)