We are seeking a lead snowflake dba who will play a critical role in building and maintaining office depot’s data warehouse database using snowflake.
Perform administrative tasks like but not limited to, ddl creation, user creation, account level parameter changes etc within snowflake database.
Responsible to integrate snowflake database with saml or openid provider for authentication
Create snowflake utilization and capacity plan for general housekeeping as well as for peak period.
Understand snowflake best practices & considerations for managing load operations and performance which will aid in creating right size snowflake warehouses.
Implement data masking policies to protect pii/pci data.
Create and manage multiple accounts across the organization.
Practical knowledge of time travel & cloning
Be able to design and develop secure access to objects in snowflake with role-based access control (rbac)
Able to provide recommendation on snowflake best practices for management, monitoring, and optimization
Good understanding of data replication for data sharing across accounts and for failover scenarios
Practical knowledge on how to share data securely both within and outside your organization
Hands on experience with shell scripting and python.
Diagnose database problems and implement solutions.
Experience working with snowflake support for raising tickets and triaging outages
Be able to review ddls and apply standards.
Good understanding of snowflake odbc, jdbc drivers as well as snowsql in terms of usage as well as troubleshooting any issues.
Experience with development tools like jenkins/ansible to create ci/cd
Ability to maintain and follow a run book with has documentation related all the tasks as well as database standards
Provide technical leadership, mentoring to team in india
L3 on-call support on rotational basis
Bachelor’s degree or 8-10 years of experience working in the field of it, specifically as database administrator
2+ years experience as snowflake dbaThis should a complete hands-on experience.
Snow pro core certification preferred
Operating systems: windows, unix, linux,
Database systems: teradata, snowflake, ms-sql, oracle,
Automation: ansible, jenkins, python
Cloud: aws, azure
Defect tracking tools: jira
Able to successfully manage multiple projects simultaneously
Adept in both agile and waterfall methodologies
Ability to communicate with all levels throughout the organization (peers, junior associates, upper management)
Collaborative, innovative, detail oriented, willingness to accept change, self-learner
Fair chance ordinance
We will consider for employment qualified applicants with arrest and conviction records city & county of san francisco fair chance ordinance