Database Administrator

2 months ago

Shanghai, China iHerb Full time
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.
Reporting to the Team Lead of Data Platform, the Sr. DBA 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. As a Senior team member, the successful candidate will need to work closely with our stakeholders and team members to develop consensus and find solutions to problems facing their business constituents.
The Sr. DBA II will work with IT development teams to assist in the implementation, development, deployment and administration of the databases that support the company's IT data integration initiatives. This candidate should be able to lead projects from inception to completion with little or no supervision.
Duties and Responsibilities
● Responsible for ensuring 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.
● Responsible for providing trend analysis to the management team to enable them to make
informed decisions regarding resource management.
● Responsible for troubleshooting and problem solving SQL development issues.
● Responsible for assisting developers to optimize, tune and enhance database queries
● Responsible for improvement and maintenance of all databases, to include rollout and upgrades.
● Responsible for implementation and release of database changes according to agreed timescales
and costs.
● Responsible for proposing and implementing 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
● Responsible for mentoring developers on data modeling best practices and enabling them to
come up with a optimized data model
● iHerb operates a 24x7 e-com platform. On-call / off-hours deployments and support will be
required.
Skills / Attributes Required
● 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 #LI-OJ1

  • Senior Database Administrator

    2 days ago

    Shanghai, Shanghai, China iHerb Full time

    About the RoleiHerb'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 SummaryThe Senior Database Administrator will contribute to the overall engineering, design, build and high-level support of all...

  • Database Administrator

    7 days ago

    Shanghai, China Cognizant Full time

    Job SummaryWe are seeking an experienced Infra. Architect with 8 to 10 years of experience to join our team. The ideal candidate will have extensive knowledge in Microsoft Sentinel Microsoft Defender for Servers Microsoft Defender for Cloud and other Azure security tools. This role will involve designing implementing and managing secure infrastructure...

  • Administration Specialist

    3 days ago

    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...

  • Administration Specialist

    3 months ago

    Shanghai, China Atlas Copco Full time

    .fit_to_content{width:%;height:auto}Our solutions are a key part of most industries - electronics, medical research, renewable energy, food production, infrastructure and many more. Working with us means working with the latest technologies and groundbreaking, sustainable innovations.Join us on our journey for a better tomorrow.Your RoleMissionTo provide...

  • Administrative Support Specialist

    3 days ago

    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...

  • Office Administrator and Project Coordinator

    3 days ago

    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...

  • Supply Chain Administrative Associate

    3 days ago

    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...

  • Online Systems Administrator

    3 months ago

    Shanghai, China Ubisoft Full time

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

  • DevOps Systems Administrator

    2 days ago

    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...

  • Administrative Coordinator

    3 days ago

    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...

  • MultiCloud Administrator

    3 months ago

    Shanghai, China Corning Full time

    Requisition Number: 63067 Corning is vital to progress – in the industries we help shape and in the world we share. We invent life-changing technologies using materials science. Our scientific and manufacturing expertise, boundless curiosity, and commitment to purposeful invention place us at the center of the way the world interacts, works, learns, and...

  • MultiCloud Administrator

    3 months ago

    Shanghai, China Corning Full time

    Requisition Number: 63067 Corning is vital to progress – in the industries we help shape and in the world we share.We invent life-changing technologies using materials science. Our scientific and manufacturing expertise, boundless curiosity, and commitment to purposeful invention place us at the center of the way the world interacts, works, learns, and...

  • MultiCloud Administrator

    3 months ago

    Shanghai, China Corning Full time

    Requisition Number: 63067   Corning is vital to progress – in the industries we help shape and in the world we share. We invent life-changing technologies using materials science. Our scientific and manufacturing expertise, boundless curiosity, and commitment to purposeful invention place us at the center of the way the world interacts,...

  • Office Administrator and Project Assistant

    3 months ago

    Shanghai, China MMR Research Full time

    我们正在寻找一位敬业且注重细节的行政专员及项目助理加入我们充满活力的团队。这一角色对于维持我们办公室的平稳运营，以及确保我们的客户和访客得到专业和热情的体验来说，至关重要。职位描述：作为行政专员和项目助理，您将是我们公司的第一联系人。您将管...

  • Clinical Research Coordinator

    1 day ago

    Shanghai, Shanghai, China PSI CRO Full time

    About the RoleWe are seeking a highly organized and detail-oriented Clinical Research Coordinator to join our team at PSI CRO. As a Clinical Research Coordinator, you will play a critical role in the success of our clinical research projects.Key ResponsibilitiesDatabase Management: Maintain accurate and up-to-date databases and tracking systems to ensure...

  • Research Coordinator, Office of Research

    2 months ago

    Shanghai, China NYU Shanghai Full time

    Position Summary The Research Coordinator will support the Office of Research’s research related functions and activities. S/he will be primarily responsible for supporting the administration of research grants, including pre-award and non-financial post-award support to faculty and investigators.  The main responsibilities include:  Provide...

  • Team assistant, Product Safety

    2 months ago

    Shanghai, China Huntsman Full time

    Description : Team assistant, Product Safety & Regulatory Compliance Huntsman’s Polyurethanes division is now looking for a Team assistant, Product Safety & Regulatory Compliance. This Team assistant is Responsible for the administrative support for Product Safety & Regulatory Compliance (PSRC) APAC team, CoE EHS APAC team and CoE Process Safety...

  • EHS Manager

    1 month ago

    SHANGHAI, China BASF SE Full time

    Main Tasks:1. Team member A-PMA EHS team 2. Coordinate the EHS community activitiesa) Support team leader to coordinate the EHS Community activitiesb) Share experience/best practices among Operation and Lab c) Maintain the networkingd) Participate EHS Council meetinge) Support team leader to prepare the monthly update on the statistics and activitiesf) Join...

  • Recruitment Sourcing Specialist-Intern

    1 week ago

    Shanghai, China Allegis Global Solutions Full time

    Job DescriptionOpportunity knocks only once with this rare opportunity with a high-end luxury retailer.  Don't miss this!The role of a Recruitment Sourcing Specialist Intern is to assist in all aspects of day to day life onsite, assist with recruitment drive events, and manage all administration tasks and where relevant (inclusive of Candidate Management...

  • AP Paralegal 律师助理

    2 months ago

    Shanghai, China Goodyear Full time

    Location: CN - Shanghai    Goodyear Talent Acquisition Representative: Amelia Li   Sponsorship Available:  NoRelocation Assistance Available: No  Responsibilities: - You need to support AP legal matters and handles administrative activities and reporting requirements at the AP regional level. This includes AP contracts preparation, routing...