Join our Talent Network
Skip to main content

Overview

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. 

 

Core Responsibilities: 

  • 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 

 

Qualifications:  

  • Bachelor’s degree or 8-10 years of experience working in the field of IT, specifically as Database Administrator 

  • 2+ years experience as Snowflake DBA. This should a complete hands-on experience. 

  • Snow Pro Core Certification preferred 

 

Other Information:  

  

  • 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  

 

Read More Read Less

At Office Depot, we offer our benefits around the 5 facets of Total Well-Being: Physical, Emotional, Work-Life, Financial, and Community. Here’s a look into what we offer:

Physical:

  • Health Insurance
  • Wellness Fairs
  • Flu shots
  • Fitness & Nutrition Programs
  • Ergonomic Support
  • Return-to-Work Programs

Emotional:

  • Mental Health Benefits
  • Support Programs

Work-Life:

  • Location Events & Activities
  • Onboarding Plan & 'Buddy'
  • Recognition & Rewards Programs
  • Flexible Work Schedules
  • Paid Holidays
  • Paid Time Off

Financial:

  • Retirement Programs
  • 401(k) Match
  • FSA/HSA Pre-Tax Benefits
  • HSA Match
  • HRA Funding
  • Discounts/Perks
  • Life/Disability Plans

Community:

  • Charitable Giving
  • Volunteering & Mentorship

At Office Depot, we offer our benefits around the 5 facets of Total Well-Being: Physical, Emotional, Work-Life, Financial, and Community. Here’s a look into what we offer:

Emotional:

  • Employee Assistance Programs

Community:

  • Associate Resource Groups focused on Diversity and Inclusion

As the working world continues to evolve, so are we. Shifting from an office supplies retailer to a business services platform is not a simple task, nor is it one we take lightly. It requires the diverse talents and contributions from each and every associate – all driven by our 5C culture of Customer, Commitment, Change, Caring and Creativity. We’re working together to make a difference, challenge the status quo, and be the trusted experts that help our customers manage their businesses. We’ve got 40,000+ associates to date – and we’re always looking to add great talent to our team. The once-in-a-lifetime opportunity to help transform our company to fuel the businesses and communities around us is knocking. Start your #LifeAtDepot and discover how you can be a part of the transformation.

  • Description

    Overview

    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. 

     

    Core Responsibilities: 

    • 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 

     

    Qualifications:  

    • Bachelor’s degree or 8-10 years of experience working in the field of IT, specifically as Database Administrator 

    • 2+ years experience as Snowflake DBA. This should a complete hands-on experience. 

    • Snow Pro Core Certification preferred 

     

    Other Information:  

      

    • 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  

     

    Read More Read Less

  • Benefits

    At Office Depot, we offer our benefits around the 5 facets of Total Well-Being: Physical, Emotional, Work-Life, Financial, and Community. Here’s a look into what we offer:

    Physical:

    • Health Insurance
    • Wellness Fairs
    • Flu shots
    • Fitness & Nutrition Programs
    • Ergonomic Support
    • Return-to-Work Programs

    Emotional:

    • Mental Health Benefits
    • Support Programs

    Work-Life:

    • Location Events & Activities
    • Onboarding Plan & 'Buddy'
    • Recognition & Rewards Programs
    • Flexible Work Schedules
    • Paid Holidays
    • Paid Time Off

    Financial:

    • Retirement Programs
    • 401(k) Match
    • FSA/HSA Pre-Tax Benefits
    • HSA Match
    • HRA Funding
    • Discounts/Perks
    • Life/Disability Plans

    Community:

    • Charitable Giving
    • Volunteering & Mentorship
  • Benefits Part-Time

    At Office Depot, we offer our benefits around the 5 facets of Total Well-Being: Physical, Emotional, Work-Life, Financial, and Community. Here’s a look into what we offer:

    Emotional:

    • Employee Assistance Programs

    Community:

    • Associate Resource Groups focused on Diversity and Inclusion
  • About Us

    As the working world continues to evolve, so are we. Shifting from an office supplies retailer to a business services platform is not a simple task, nor is it one we take lightly. It requires the diverse talents and contributions from each and every associate – all driven by our 5C culture of Customer, Commitment, Change, Caring and Creativity. We’re working together to make a difference, challenge the status quo, and be the trusted experts that help our customers manage their businesses. We’ve got 40,000+ associates to date – and we’re always looking to add great talent to our team. The once-in-a-lifetime opportunity to help transform our company to fuel the businesses and communities around us is knocking. Start your #LifeAtDepot and discover how you can be a part of the transformation.

APPLY  
SHARE THIS JOB: share to e-mail

Similar Jobs

Sr. Manager SRE - Cloud & Kubernetes Services (Remote)

Information Technology
Boca Raton, FL, United States

Lead Cyber Security Engineer-Cloud Security- REMOTE

Information Technology
Boca Raton, FL, United States

Lead Cyber Security Engineer -Application Security- REMOTE

Information Technology
Boca Raton, FL, United States

Lead Software Development Engineer (Remote)

Information Technology
Boca Raton, FL, United States

Lead Mobile App Developer (Remote)

Information Technology
Boca Raton, FL, United States

Lead- Database Administrator -REMOTE

Information Technology
Boca Raton, FL, United States

Engineer, Lead Solution IT -REMOTE

Information Technology
Boca Raton, FL, United States

Developer, Lead

Information Technology
Boca Raton, FL, United States

Lead DBA (Remote)

Information Technology
Boca Raton, FL, United States

Lead Systems Engineer - Middleware (Remote)

Information Technology
Boca Raton, FL, United States

Software Engineer, Lead - IT - REMOTE

Information Technology
Boca Raton, FL, United States

Lead Data Engineer, ETL Data Warehouse (Remote)

Information Technology
Boca Raton, FL, United States

Sr. Business Intelligence Engineer (Remote)

Information Technology
Boca Raton, FL, United States

Lead Front End Software Development Engineer (Remote)

Information Technology
Boca Raton, FL, United States

Career Progression

  • 2014
    MERCHANDISING INTERN
  • 2015
    CATEGORY ASSISTANT
  • 2017
    SR. ASSOCIATE MERCHANT
  • 2020
    DIVISIONAL MERCHANDISING DIRECTOR

Associate Spotlight

Carlos Q
 

Carlos Quiros

Lead Functional Analyst, PMO

"I began my career as an intern in Property Accounting at Office Depot 12 years ago. Office Depot helped me leverage my academic background in Finance, leading me to tenures in General Accounting, Accounts Receivable, Financial Planning & Analysis. I was able to then pivot my career to the IT PMO, and more recently the EPMO. As a Lead Functional Analyst, I work to improve the financial visibility of projects to Project Managers and Leaders across the enterprise as well as to enable better decision making. I look forward to growing with Office Depot and contributing to a winning environment!"

Palm Beach County School District Electronic Device Drive

Office Depot Supports Komen South Florida Race for the Cure 2020 #DepotDifference

Browse Other Career Areas