Database Administrator
Engineering | Palo Alto, United States

The Work:

  • Extend and improve Nest’s Business Data Warehouse to support a rapidly expanding supply chain and ever increasing demands for information from data hungry business users.
  • Institute best practices for design and rollout of data views for use within and outside the company
  • Develop, manage and improve our existing ETL processes and data services
  • Manage the implementation of  new EDI connections as we onboard new major customers and vendors with our 3rd party EDI partner
  • Manage customizations and add-ons for our NetSuite ERP instance
  • SQL Server Database Administration
  • Be the primary liaison between the business operations team and IT Support

Preferred Skills and Experience:

  • Experience supporting e-commerce infrastructures and external fulfillment partners
  • Experience with manufacturing data integration and logistics management
  • Experience with integrating corporate systems with SalesForce and NetSuite
  • Strong Database Administration skills and a full understanding of best practices for SQL Server and MySQL
  • Ability to audit and improve database security
  • Ensure internal and offsite backups are processing correctly
  • Proven experience with scaling and reliability of DB services
  • Experienced with data architecture and design and normalization techniques
  • Manage and monitor scheduled tasks and agent jobs
  • Extensive experience with SQL Server Development Studio to create and modify SSIS packages
  • Solid scripting abilities, especially SQL , XML ETL and able to manage or modify configurations
  • Especially related to integrating Netsuite with other 3rd party services
  • Experience with EDI, especially transaction sets related to purchase and selling of physical goods and Partner Activity Reporting.