Snowflake Admin + Application Support – 6 years – Pune Full Time NEW

Job Description

Who are we

An agile and next-generation digital accelerating company providing digital transformation and technology services right from ideation to implementation. These services have applicability across a variety of industries, including banking & financial services, insurance, retail, higher education, food, healthcare, and manufacturing.

The Role

• Collaborate with cross-functional teams, including customers, project management, software engineering, and network operations, to gather database requirements, improve existing systems, and develop new systems.
• Install and upgrade database systems, ensuring smooth and efficient processes.
• Implement and maintain robust database security measures, adhering to industry standards and guidelines.
• Design and support 24×7 high-availability solutions for seamless database operations.
• Optimize database and server performance by analyzing and configuring physical server hardware, operating systems, and database software settings. Provide recommendations for upgrades and new systems.
• Develop and optimize database components, including queries, stored procedures, ETL processes, and conduct code reviews and optimizations to enhance performance.
• Execute database schema and code changes, perform bottleneck analysis, and ensure efficient server/database performance, including recovery and restores when needed.
• Plan for system growth and scalability to accommodate future requirements.
• Ensure compliance with vendor license agreements to maintain legal and operational integrity.
• Handle various reporting and data export/import tasks, working with different formats like CSV, XML, and unstructured data.
• Document the database environment, processes, and best practices to maintain a comprehensive knowledge base.
• Provide technical support and prompt problem resolution to address any database-related issues.
• Be available for production/on-call support to maintain continuous system availability and address emergencies effectively.
• Be willing to learn new technologies and assist with architecture and design.
• Work efficiently within a high security environment.
• Communicate clearly and effectively to all levels of the organization.

Requirements

• DB2 – Basic knowledge
• Snowflake – Mandatory
• Linux – Mandatory
• GitHub
• Azure – Must have knowledge on cloud
• ProgreSQL – will have knowledge if person has worked on Azure DB
• Cosmos DB – will have knowledge if person has worked on Azure DB