Database Administrator
5 months ago
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 Architect
1 month ago
Shanghai, Shanghai, China iHerb Full timeiHerb Data Platform Job DescriptioniHerb'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...
-
Senior Database Architect
4 weeks ago
Shanghai, Shanghai, China iHerb Full timeiHerb's Data Platform DepartmentIs 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 successful candidate will contribute to the overall engineering, design, build and high level support of...
-
Sales Administrator
4 weeks ago
Shanghai, Shanghai, China Atlas Copco Full timeAdministrative Support RoleAs a Sales Administrator at Atlas Copco, you will provide administrative support to the sales team by ensuring efficient and accurate order management. Your duties will include preparing, booking, and maintaining orders, as well as updating and managing the SAP/C4C database.Key ResponsibilitiesPrepare, book, and maintain orders in...
-
Offshore Database Specialist in China
2 weeks ago
Shanghai, Shanghai, China SBM Offshore Full timeOverviewSBM Offshore is seeking a highly skilled ECOM Database Assistant to join our team in China. As an integral part of our operations, you will play a critical role in ensuring the accuracy and efficiency of our database.About the RoleThe successful candidate will be responsible for preparing engineering lists for tags population in ECOM, allocating ITRs...
-
Sales Administration Specialist
1 month ago
Shanghai, Shanghai, China Atlas Copco Full timeAbout the RoleWe are seeking a highly organized and detail-focused individual to join our sales team as an Administrative Support Specialist. In this role, you will be responsible for providing administrative support to the sales team by efficiently and accurately managing orders, updating and maintaining SAP/C4C database, and handling claims and customer...
-
Administrative Coordinator
4 weeks ago
Shanghai, Shanghai, China MMR Research Full timeJob Summary: MMR Research is seeking a detail-oriented and organized Office Administrator and Project Assistant to join our team.Key Responsibilities:As an Office Administrator and Project Assistant, you will be the first point of contact for our company, managing the front desk, handling administrative tasks, and providing support to the team.Reception...
-
Administrative Support Associate
4 weeks ago
Shanghai, Shanghai, China Roche Full timeThe PositionKey Responsibilities:Provides skilled administrative support to senior management and teams, ensuring seamless day-to-day operations and strategic initiatives.Executes research and data analysis tasks, identifying trends and insights to inform business decisions.Develops and maintains databases, reports, and presentations to communicate key...
-
Administrative Support Specialist
1 month ago
Shanghai, Shanghai, China Atlas Copco Full timeAdministrative Support RoleWe are seeking a highly skilled and experienced Administrative Support Specialist to join our team at Atlas Copco. The successful candidate will provide efficient and professional administrative support to all staff members, ensuring a secure, friendly, and efficient working environment.Key ResponsibilitiesProvide administrative...
-
Product Safety Administrator
2 weeks ago
Shanghai, Shanghai, China Huntsman Full timeJob SummaryHuntsman's Polyurethanes division is currently seeking an experienced Team Assistant, Product Safety & Regulatory Compliance. This role provides administrative support to the PSRC team, CoE EHS APAC team, and CoE Process Safety APAC team.About the RoleThe successful candidate will be responsible for travel arrangements, budget updates, managing...
-
Marketing and Administrative Assistant
2 weeks ago
Shanghai, Shanghai, China Mapletree Full timeJob TitleMarketing and Administrative AssistantAbout the RoleWe are seeking a highly organized and detail-oriented Marketing and Administrative Assistant to provide support to our leasing teams in Shanghai.This is an excellent opportunity for a recent graduate or someone looking to gain experience in a dynamic and fast-paced environment.Key...
-
Administration Specialist
6 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
2 weeks ago
Shanghai, Shanghai, China MMR Research Full timeWe are seeking a highly organized and detail-oriented Administrative Support Specialist 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.Job DescriptionAs an Administrative Support Specialist, you will be...
-
Office Administrator and Project Coordinator
1 month ago
Shanghai, Shanghai, China MMR Research Full timeJob Title: Office Administrator and Project AssistantJob Summary:We are seeking a highly organized and detail-oriented Office Administrator and Project Assistant to join our team at MMR Research. As the first point of contact for our company, you will be responsible for managing the front desk, handling administrative tasks, and providing support to the...
-
Commercial and Administrative Support Specialist
1 month ago
Shanghai, Shanghai, China Huntsman Full timeJob SummaryThe Commercial and Administration Officer will provide administrative support to the APAC Commercial team and associates in Shanghai Campus.Key Responsibilities• Maintain C4C database and train Asia C4C users• Govern C4C data/report quality• Support Sales Director and Commercial team in organizing regular commercial activities• Provide...
-
Shanghai, Shanghai, China Hyatt Corporation Full timeJob SummaryWe are seeking an Administrative Support Specialist to provide exceptional support to our F&B division.About the RoleThis is a full-time position responsible for providing administrative support to ensure seamless operations in our F&B division. As an Administrative Support Specialist, you will be responsible for managing daily tasks, maintaining...
-
Administrative Coordinator
2 weeks ago
Shanghai, Shanghai, China Atlas Copco Full timeAt Atlas Copco, we're passionate about creating exceptional things. Our solutions are a key part of most industries, including electronics, medical research, renewable energy, food production, infrastructure, and many more. With our inclusive and caring environment, you get the support and inspiration you need to grow.As an Administrative Coordinator -...
-
Online Systems Administrator
6 months ago
Shanghai, China Ubisoft Full timeJob 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...
-
Shanghai, Shanghai, China SAP Full timeWe are seeking a highly skilled Global SAP Basis and System Administration Consultant to join our team. As a member of our CoE S/4HANA Migration team, you will play a critical role in helping SAP customers manage their maintenance events, such as transition to S/4HANA via system conversion, move to Hyperscaler, HANA migration, system release upgrade, and so...
-
Office Administrator and Project Assistant
5 months ago
Shanghai, China MMR Research Full time我们正在寻找一位敬业且注重细节的行政专员及项目助理加入我们充满活力的团队。这一角色对于维持我们办公室的平稳运营,以及确保我们的客户和访客得到专业和热情的体验来说,至关重要。职位描述:作为行政专员和项目助理,您将是我们公司的第一联系人。您将管...
-
Logistics Coordinator
3 weeks ago
Shanghai, Shanghai, China Mapletree Full timeThe Mapletree team is looking for a skilled Logistics Coordinator to join our Shanghai leasing team.Job OverviewAs a key member of our team, you will provide administrative support and ensure seamless operations in our office. This role requires strong organizational skills, attention to detail, and excellent communication abilities.ResponsibilitiesTranslate...