Job Description

Job Title: Sr. System Administrator I \xe2\x80\x93 Snowflake / MS Azure (Pune Office)
Area: Platform Operations
Reports to: Platform Operations Manager

Rotary international Overview
Rotary unites people from all continents and cultures who take action to deliver real, long-term solutions to pressing issues facing our communities. Each year, Rotary members invest more than $200 million and 16 million volunteer hours to improve lives and create positive change in the world. In exchange for hard work and dedication in support of Rotary\xe2\x80\x99s clubs and humanitarian initiatives, our employees receive competitive salaries, flexible schedules, comprehensive benefits, and job enrichment. To learn more, visit http://www.rotary.org.

Rotary International Infotech Pvt. Ltd. Overview
Rotary International Infotech Pvt. Ltd, Pune (RI Infotech) is the offshore technology development center (ODC) of Rotary International and is responsible for supporting the IT & ITES needs of Rotary International headquarters, located in Chicago, IL, USA. We use trending technologies which include Oracle, SQL Server, MS .Net, ReactJS, Redux, JavaScript, GraphQL, NodeJS, SharePoint, PeopleSoft, Business Objects and Drupal. We follow Agile methodology for developing solutions and invest time in automation. We are dedicated to innovation and quality in providing cost effective solutions to our customer in these service areas. RI Infotech embodies the beliefs, thoughts, and practices of Rotary International. Our core values of trust, empowerment and teamwork reflect the same. At RI Infotech, we believe in

• Challenging ourselves to take initiative and be a part of the solution.

• Encouraging our employees to demonstrate accountability and a proactive attitude.

• Being professional in our interaction with customers.

• Respecting, recognizing, and appreciating individual performance while working in a team.

Rotary\xe2\x80\x99s Commitment to Diversity
As a global network that strives to build a world where people unite and take action to create lasting change, Rotary values diversity and celebrates the contributions of people of all backgrounds, regardless of their age, ethnicity, race, color, abilities, religion, socioeconomic status, culture, sex, sexual orientation, and gender identity.
General Overview
The Systems Administrator will be responsible for performing the daily duties of Snowflake administration including but not limited to Database administration, database migration, Production deployments ETL translations using FiveTran, Azure DataFactory, reporting and familiarity Data quality solutions. Additionally, the Systems Administrator will have varying degrees of responsibility for work processes, optimization methods and risk management for large and complex projects within Rotary International. The Systems Administrator will work with other IT staff, assorted project delivery staff and the teams in our India and US offices.
You Will Have

• Bachelor\'s degree or equivalent work experience.

• 5+ Years Migration of data (ETL) from SQL Server to Snowflake.

• 2+ Years Working experience with Fivetran.

• 3+ Years Azure storage, Azure SQL, Azure Datawarehouse.

• 3+ Years of Snowflake schema, Data modelling and Elements. You Are Good At

• Oral and written communication with the ability to present ideas in user friendly language.

• Working well under pressure.

• Strong problem-solving skills.

• Excellent prioritization, time management and organizational skills.

• Ability to work independently and perform multiple concurrent and diversified tasks effectively.

• Being a strong team player, self-motivated and detail oriented.

• Ability to collaborate with other teams.

• Showing attention to detail.

• Giving and receiving constructive feedback.

You Are Open To

• Travel.

• Flexible hours.

• 24 x 5 shift coverage.

• Adapt to shifting priorities.

• New processes and tools.

• Ongoing learning and training.

• Managing off-hours issues.

You Will Be Responsible For
Operations

• Ensure the quality and consistency of operating systems by following a defined set of procedures (change control, security procedures and protocols for user password management, backups and hardware configurations).

• Pro-actively identify operating system issues through online monitoring tools, alerting and ticketing systems and coordinate resolution of the identified issues.

• Assume ownership of infrastructure related problems; pursue problem resolution and root cause analysis.

Maintenance

• Perform regular hardware and software maintenance. Assess solutions. Install, configure, and maintain server storage products. Troubleshoot Infrastructure related problems. Monitor for system uptime, using tools that detect anomalous system behavior.

• Establish, implement and maintain server storage, Azure and OCI policies and procedures. Lead incident response and conduct root cause analysis.

Training and Orientation

• You will be responsible for helping to train and mentor staff on the Platform Operations team \xe2\x80\x93 developing and revising procedures and job aids for the department while also evaluating and recommending changes to increase efficiency and seeking continuous improvements.

Leadership Attributes

• Collaboration: Team up with others to meet business goals.

• Communication: Actively listen and check for understanding.

• Innovation: Think creatively and propose new ways to complete tasks.

• Productivity: Achieve results that move Rotary towards its goals.

• Strategy: Understand how your role aligns with Rotary\xe2\x80\x99s goals.

Why work for Rotary?

• Competitive Compensation Package

• Professional Development Opportunities

• Work life balance

• Rewards & Recognition

• Above market and generous paid time off

• Provident Fund & Gratuity

• Employee centric policies: Insurance, Employee Referral, Relocation Policy, Internal Job Application etc.

• International Employee Assistance Program