Senior Database Administrator

4 days ago


Shanghai, Shanghai, China iHerb Full time
About the Role

iHerb's Data Platform department is responsible for developing and enhancing database infrastructure to support the growth of the business and to promote highly available, stable and secure database systems.

Job Summary

The Senior Database Administrator will contribute to the overall engineering, design, build and high-level support of all existing and new Microsoft SQL Server systems (SQL 2016 higher), mongoDB systems, DynamoDB as well as several other data stores owned by the data platform team.

Key Responsibilities
  • Ensure the availability and performance of all iHerb databases.
  • Work to ensure that the proper resources are allocated to the databases, and to ensure high resilience and performance.
  • Proactively monitor the database systems to ensure secure services with minimum downtime.
  • Provide trend analysis to the management team to enable them to make informed decisions regarding resource management.
  • Troubleshoot and problem-solve SQL development issues.
  • Assist developers to optimize, tune and enhance database queries.
  • Improve and maintain all databases, to include rollout and upgrades.
  • Implement and release database changes according to agreed timescales and costs.
  • Propose and implement database architectural changes to make database infrastructure highly scalable and optimized.
  • Take on technical leadership responsibilities of database projects across various teams in the organization.
  • Mentor developers on data modeling best practices and enable them to come up with an optimized data model.
Requirements
  • Masters in Computer Science or related field are desirable.
  • 8+ years of in-depth SQL Server Database architecture and administration experience.
  • 1+ years of experience on NoSQL technologies in MongoDB, DynamoDB, TimeScaleDB, etc.
  • Experience in designing highly scalable database architectures and data models.
  • Extensive experience in High availability designs, Business Continuity processes, and conducting Disaster Recovery exercises.
  • Experience of managing SQL server & mongoDB clusters.
  • Strong self-sufficiency and initiative working on Database projects.
  • Experience in mentoring team members.
  • Practical experience in monitoring and tuning databases.
  • Experience with T-SQL, SSIS, stored procedures, Javascript, JSon, Powershell, Shell scripting.
  • Strong knowledge of Multi-Instance implementations and methodologies.
  • Experience with database clustering, Availability Groups, Replication, Log Shipping and Change Data Capture.
  • Experience of managing SQL Server on AWS cloud platform.
  • Experience with CI/CD processes and scripting languages: Ansible, Terraforms, Jenkins.
  • Knowledge of Kafka or other streaming processes is desirable.
  • Technical certifications (AWS, SQL Server, MongoDB) are desirable.


  • Shanghai, Shanghai, China Bosch Full time

    Job Overview We are seeking a highly organized and proactive Senior Executive Administrator to support our leadership team at Bosch. The ideal candidate will possess exceptional administrative skills and a keen ability to manage multiple tasks efficiently. Key Responsibilities Oversee and coordinate the schedules, appointments, and travel logistics for...


  • Shanghai, Shanghai, China Bosch Full time

    Job Overview We are seeking a highly skilled Senior Executive Administrator to provide comprehensive support to our executive team at Bosch. The ideal candidate will be adept at managing complex schedules and facilitating seamless operations. Key Responsibilities Oversee and organize executives' calendars, appointments, and travel logistics. Plan and...


  • Shanghai, Shanghai, China Roche Full time

    Position Overview Key Responsibilities 1. Administrative Assistance Coordinate and manage travel arrangements, including itineraries, bookings, and reimbursements for both domestic and international trips. Facilitate visits from Global/Regional teams, organizing travel logistics, meetings, workshops, and related activities. Maintain and manage...


  • Shanghai, Shanghai, China Roche Full time

    Position Overview Key Responsibilities 1. Administrative Assistance Coordinate and manage travel arrangements, including itineraries, reservations, and reimbursements for both domestic and international trips. Facilitate visits from Global/Regional teams, organizing travel logistics, meetings, workshops, and related activities. Maintain...


  • Shanghai, Shanghai, China Atlas Copco Full time

    About the RoleWe are seeking a highly skilled and experienced Administration Specialist to join our team at Atlas Copco. As an Administration Specialist, you will play a critical role in providing efficient and professional administrative support to our staff members.Key ResponsibilitiesProvide administrative support to our Shanghai offices and other branch...


  • Shanghai, Shanghai, China MMR Research Full time

    Job Summary:We are seeking a highly organized and detail-oriented Office Administrator and Project Assistant to join our dynamic team at MMR Research. This role is integral to maintaining the smooth operations of our office and ensuring that our clients and visitors have a professional and welcoming experience.Key Responsibilities:Reception Duties:Greet and...


  • Shanghai, Shanghai, China Roche Full time

    Position Overview Key Responsibilities: Delivers comprehensive analytical and specialized administrative assistance to alleviate executives, administrative staff, and managerial personnel from intricate details and advanced administrative tasks. Conducts ongoing research and data analysis assignments. Evaluates challenges, determines...


  • Shanghai, Shanghai, China Ubisoft Full time

    Job DescriptionSummaryUbisoft is seeking an experienced Online Systems Administrator (DevOps) to join our IT Game Services team. The ITGS team is composed of Network professionals, Systems Administrators specialized in Microsoft, Linux products, software developers, and Network Architects. The team applies expertise to service Ubisoft game development to...


  • Shanghai, Shanghai, China NYU Shanghai Full time

    Job SummaryThis role is crucial to the success of the Computer Science, Data Science, and Engineering division at NYU Shanghai. The successful candidate will provide administrative support to advance the goals of the division and its affiliated research centers.Main ResponsibilitiesMeeting and Documentation Management:Write and distribute meeting minutes...


  • Shanghai, Shanghai, China NYU Shanghai Full time

    Position Overview This role is essential in providing comprehensive support to the Dean of Arts and Sciences, facilitating the smooth operation of the Dean's office while delivering a wide array of administrative assistance. The responsibilities encompass a variety of tasks, including schedule coordination, financial management, event planning, and...

  • Senior Data Manager

    4 days ago


    Shanghai, Shanghai, China PSI Full time

    Job OverviewThe Senior Data Manager will be responsible for overseeing all data management activities in large, complex studies at PSI.Key ResponsibilitiesProvide strategic oversight on all Data Management activities on large complex global studiesEstablish a communication line for clients/vendors for all data management aspects of clinical projects and...


  • Shanghai, Shanghai, China Tetra Pak Full time

    At Tetra Pak we commit to making food safe and available, everywhere; and we protect what's good – protecting food, protecting people, and protecting the planet. By doing so we touch millions of people's lives every day. And we need people like you to make it happen.We empower you to reach your potential with opportunities to make an impact to be proud of...


  • Shanghai, Shanghai, China Roche Full time

    Position Overview Key Responsibilities 1. Administrative Assistance Coordinate and manage travel arrangements, including itineraries, reservations, and reimbursements for both domestic and international trips. Facilitate visits from Global/Regional teams, organizing travel, meetings, workshops, and related activities. Oversee calendar...


  • Shanghai, Shanghai, China General Motors Full time

    Job SummaryWe are seeking a highly skilled Senior Analyst to join our Sales team at General Motors. As a Senior Analyst, you will play a critical role in driving business growth and improving sales performance.Key ResponsibilitiesDevelop and maintain advanced sales analytics models to identify trends and opportunities for growthCollaborate with...

  • PHE Order Engineer

    2 months ago


    Shanghai, Shanghai, China Tetra Pak Full time

    Job SummaryWe are looking for a expert who will overall responsible for BU BPU and Line order projects in all respects i.e. cost, time, quality and scope of obligations. To manage the project within the framework of the budget, time schedule, quality and scope, contributing to the overall sales result and customer satisfaction.What you will doDrive PHE order...


  • Shanghai, Shanghai, China Thermo Fisher Scientific Full time

    Position Overview:The Senior Operations Specialist plays a critical role in ensuring the smooth functioning of executive operations within Thermo Fisher Scientific. This position requires a proactive individual who can effectively manage various administrative responsibilities while maintaining a high level of professionalism.Key Responsibilities:Oversee and...


  • Shanghai, Shanghai, China Thermo Fisher Scientific Full time

    Position Overview: The Senior Operations Specialist will play a pivotal role in supporting executive functions within Thermo Fisher Scientific. This position requires a proactive individual who can effectively manage a variety of administrative tasks while ensuring seamless communication and organization. Key Responsibilities: Oversee and organize executive...


  • Shanghai, Shanghai, China SAP Full time

    Job Title: Senior Business Process ConsultantJob Summary:We are seeking a highly skilled Senior Business Process Consultant to join our team at SAP. As a Senior Business Process Consultant, you will be responsible for supporting SAP solutions deployment and collaborating with colleagues to ensure customer success in solution deployment projects or customer...


  • Shanghai, Shanghai, China Imperva Full time

    Job Summary:The Senior Sales Engineer will work alongside the Regional Sales Managers, as part of the Global Sales Team, to oversee the sales support of Imperva's Web Application and Database Security/Compliance products to existing and prospective customers with the assigned geographic region.Key Responsibilities:Participate in sales conference calls and...


  • Shanghai, Shanghai, China GLG Full time

    Job SummaryWe are seeking a highly skilled and experienced Senior Accountant to join our team at GLG. As a Senior Accountant, you will be responsible for maintaining internal controls, ensuring accurate and timely processing of cash receipts, and coordinating with sales professionals and clients to process billing documents and collect payments.Key...