• Administer and maintain PostgreSQL databases, ensuring optimal performance, availability, and security across production and non-production environments • Design, implement, and manage database backup and disaster recovery strategies to minimize data loss and downtime • Monitor database performance metrics, identify bottlenecks, and implement optimization solutions including query tuning and index management • Manage user access controls, database permissions, and security protocols to protect sensitive retail and customer data • Troubleshoot and resolve database-related issues promptly, conducting root cause analysis and implementing preventive measures • Perform database migrations, upgrades, and patches with minimal impact to business operations • Collaborate with application development teams to support database design and troubleshoot application-level database issues • Implement and maintain high availability and replication solutions to ensure business continuity • Document database configurations, procedures, and runbooks to support operational efficiency and knowledge transfer • Stay current with PostgreSQL updates, security patches, and industry best practices

• Evaluate, curate, promote, and grow brands/products in assigned category. • Cultivate strong vendor partnerships for revenue and profit growth. • Source new suppliers and manage assortment relevant to category, trend, and team objectives. • Focus on assortment and product strategy complementary to iHerb overall Global strategy. • Identify and onboard regional brands, unlock logistical methods for global brand sourcing. • Work closely with the Global Director and team to ensure alignment on strategies. • Directly responsible for key metrics such as new brands, new products, pricing, gross margin, and promotions. • Understand supply chain complexities for proper and legal buying methods. • Partner with Compliance and Regulatory on catalog additions. • Negotiate with vendors for pricing, marketing budgets, and growth incentives. • Foster relationships with vendors for sales and product innovation. • Manage contracts, product evaluation, quality issues, and customer service questions. • Drive new product/brand onboarding and maintenance process. • Calculate, maintain and evaluate product pricing adjustments. • Coordinate with Inventory Management and Planning Team.

• Optimize existing Magento 2 installation • Provide regular and emergency support for break-fixes • Troubleshoot integration and performance issues • Design interfaces, themes, templates while following best practices and maintain world-class coding styles and standards • Anticipate the performance requirements and communicate with management on remediation plans to CTO/CIO • Develop new Magento modules and functionalities • Manage and upgrade Magento add-ons and conduct code reviews/scans • Establish DevOps pipelines, Release/Change management procedures, etc. • Develop testing scenarios including unit testing, integration testing and automate those • Work with UI/UX and graphic designers to implement front-end changes • Work with content writer to implement new contents • Implement additional components such as Elastic Search, Varnish, Redis, CDN, RabbitMQ, etc. • Manage SSL certificates, software accounts, keys, etc. • Rearchitect environment and provide vertical and horizontal scaling as demand grows • Fine-tune batch jobs (Crons) or Consumers • Migrate databases and data • Develop integrations for files, images, etc. • Manage stack components and upgrade them (Ubuntu, PHP, Percona, Nginx, Composer, Firewall, Redis, etc.) • Create plans for developing mobile experience, mobile apps or PWA front end environment • Maintain confidentiality about IP, methods, processes and data • Participate in conferences, webinars and provide presentations while socializing and partnering with startups • Install security patches and monitor web traffic brand and perform soft-sell while managing and improving brand reputation • Collaborate with other stakeholders such as content developer (copywriter), graphics and media designer, and management for consistent brand messaging and best customer experience

• Team Management: Lead and oversee a team of 5-7 customer service agents, providing guidance, support, and ongoing training to ensure optimal performance and team cohesion. • Operational Oversight: Standard Operating Procedures (SOPs) must be regularly reviewed and updated to maintain efficiency and align with company goals. • Ticket Review and Quality Assurance: Monitor and evaluate customer service tickets to ensure timely, accurate, and high-quality responses that meet our standards of excellence. • Performance Management: Hold agents accountable to established Key Performance Indicators (KPIs), offering constructive feedback and implementing improvement plans as necessary. • Brand Expertise: Leverage knowledge of subscription-based supplement brands to effectively address customer needs, streamline processes, and elevate service standards.