Sr IT Database Administrator - Snowflake

Honeywell • Phoenix, AZ

1d • Hybrid

About The Position

The future is what you make it. When you join Honeywell, you become a member of our global team of thinkers, innovators, dreamers and doers who make the things that make the future. That means changing the way we fly, fueling jets in an eco-friendly way, keeping buildings smart and safe and even making it possible to breathe on Mars. Working at Honeywell isn’t just about developing cool things. That’s why all of our employees enjoy access to dynamic career opportunities across different fields and industries. Are you ready to help us make the future? As Senior Snowflake Platform Admin of Overall Data & Database Management organization at Honeywell, you will have opportunity to work with large footprint of various Data & database technologies and make a difference by establishing a solid foundation for innovation, performance, reliability, and scalability working on on-prem and public cloud solutions leveraging multiple Data & Database Technologies. You will have opportunity to work on Snowflake Platform Administration – including Snowflake development, architecture, and operations that are responsible for setting the Snowflake’s strategy and delivering a scalable and reliable data platform that supports Honeywell’s Digital Platform and Applications. Additionally, you will also participate and provide your guidance for the design and implementation of Snowflake in global high availability and high-performance environments. You will be working with leads to maintain the Snowflake models across all applications, design new solutions at the cutting edge of distributed database technology and will deliver large scale systems that will have an impact on revenue growth. You will report directly to our Sr. Director, IT and you’ll work out of our Phoenix, AZ location on a Hybrid work schedule. Hybrid Work Schedule Note: For the first 90 days, New Hires must be prepared to work 100% onsite M-F

Requirements

• Minimum 6 year’s hands-on experience as DBA with Knowledge of Snowflake Platform Administration
• Minimum 4 years of solid experience of Snowflake Tuning and optimization.
• Minimum 4 years of hands-on experience with Snowflake Platform including Governance Integration, Security and Operations
• Must have hands-on experience and knowledge of database technology in Azure, and AWS.

Nice To Haves

• Bachelor’s in Computer Science or equivalent work experience preferred
• Good scripting Knowledge – DB, Power Shell, Unix/Shell Scripting.
• Design, optimize, document, and implement the operational aspects in supporting the Snowflake cloud platform
• Proficiency with security protocols (SAML, SCIM, OAuth, OpenID, etc.)
• Experience in transforming to and from on premise environment to cloud technology
• Excellent oral, written and collaborative communication skills.
• The ability to partner effectively across IT teams, suppliers and business customers on cross-functional projects and process improvements
• Strong interpersonal skills - effective listening and be a motivated team player.
• Self-motivated, demonstrated bias for action
• Skilled in partnering with internal customers at all levels to define problems, identify solutions, and facilitate change
• Experience with data protection, business continuity and disaster recovery options, configuration, and execution
• The ability to be a change agent and promotes positive change in the organization demonstrating drive for continual improvement and efficiency
• Ability to effectively deal with critical outages and remediation efforts given risk activities
• Experience and Knowledge on Oracle, No SQL databases and Big data is big plus.
• Excellent leadership communication and executive presence
• Strong influencing, program and change management skills
• Strong business acumen and customer focus
• Conveys specific, observable, and/or measurable expectations for each assignment, and verifies understanding and agreement on deliverables and timeframes
• Consistently makes timely decisions even in the face of complexity, balancing systematic analysis with decisiveness
• Analytical experience with spreadsheet analysis, public presentations, and data management the ability to be a change agent and promote positive change in the organization
• The ability to translate business issues / requirements and objectives into technical solutions
• Strong knowledge of IT business processes and practices including ITIL methodology

Responsibilities

• Involve on adoption of strategic use cases for Snowflake.
• Lead all the Intake requests for Snowflake as a platform, assess available solutions and recommend the most suitable solution
• Deep understanding of Snowflake Usage Monitoring, Resource Monitoring, Managing Warehouses, Administrating User Account, Network Policies, Monitor Session Activities.
• Familiarity with other SQL/NoSQL databases such as Oracle, MySQL, MS SQL, PostgreSQL & MongoDB
• Collaborate on Snowflake Automation activities to improve process efficiency and risk compliance
• Implement data sharing / replication - cross cloud / cross region for internal/external clients
• Implement monitoring and alerting, implement backup and recovery processes, provide Platform and SQL performance tuning best practices.
• Drive Stability initiatives by proactively reviewing and addressing Snowflake performance and capacity trends
• Effectively participate and guide - 24x7 operational support shift model
• Fulfill user requests ranging from User Management, Database Refresh, Performance tuning, Migration.
• Mentor and guide Snowflake Platform Teammates blended with young and experienced.
• Ensure regular maintenance and pro-active remediation of Snowflake operational problems.
• Ready to learn other core database technology like Oracle, open source databases.
• Stay focused, aggressive, active, lead by example, coordinate, and guide the leadership team, and provide value as a strong team player.
• Design and Implement Disaster Recovery, Replication and Business Continuity solutions for Snowflake.
• Lead and manage high severity Snowflake issues impacting revenue applications working cross functionally across leads of infrastructure/Cloud, network, and application teams.
• Ensure centralized 24x7 Snowflake Monitoring and Auditing Tools in place and effective in operation.
• Review consistently on the usage of Snowflake inventory on-going basis and work on consolidation, migration and deletion of assets associated and ensure savings to IT spend.
• Effective governance of third-party vendor both onshore and offshore
• Engage completely into full lifecycle of Snowflake environment (Plan, Build, Patch, Run)
• Risk and Control oversight of Snowflake environment ensuring engagement with DB Security and Engineering teams.
• Apply technical expertise to strategize for current/future technological developments and serve as point of contact for technical questions.
• Ensure ongoing compliance with regulatory requirements, evaluate controls to help mitigate negative outcomes through prevention, detection, and correction – SOX/PCI/GDPR/Export compliance etc., Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Honeywell, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing.
• Engage in cross-platform training & in bits and bytes sessions on technology trends, create opportunities for career growth, and train the resources across various technologies

Benefits

• In addition to a competitive salary, leading-edge work, and developing solutions side-by-side with dedicated experts in their fields, Honeywell employees are eligible for a comprehensive benefits package.
• This package includes employer-subsidized Medical, Dental, Vision, and Life Insurance; Short-Term and Long-Term Disability; 401(k) match, Flexible Spending Accounts, Health Savings Accounts, EAP, and Educational Assistance; Parental Leave, Paid Time Off (for vacation, personal business, sick time, and parental leave), and 12 Paid Holidays.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level