Under general supervision, the Database Administrator will be responsible for the installation, configuration, upgrade, administration, monitoring and maintenance of databases in the company. The role includes the development and design of database strategies, system monitoring and improving database performance and capacity, and planning for future expansion requirements. They may also plan, co-ordinate and implement security measures to safeguard the database.
Installing and upgrading the database server and application tools
Allocating system storage and planning future storage requirements for the database system
Modifying the database structure, as necessary, from information given by application developers verbally
Developing database queries for applications and programs as needed
Diagnosing database problems and coming up with resolutions
Enrolling users and maintaining system security
Ensuring compliance with database vendor license agreement
Controlling and monitoring user access to the database
Monitoring and optimizing the performance of the database
Planning for backup and recovery of database information
Maintaining archived data
Backing up and restoring databases
Contacting database vendor for technical support
Generating various reports by querying from database as per need.
The duties and responsibilities described above may provide only a partial description of this position. This is not an exhaustive list of all aspects of the job. Other duties and responsibilities not outlined in this document may be added as necessary or desirable, with or without notice.
Knowledge, Skills and Abilities:
Strong knowledge of SQL and experience with Microsoft SQL Server
Strong knowledge of relational databases
Strong knowledge of T-SQL and database programming
Full understanding of database transactions and how they work.
Experience in optimizing query plans
Experience in database security
Experience in working with SQL profiler
Experience in working with high traffic databases
Experience in setting up and managing fail-over clusters
Experience in developing and managing SSIS packages
Experience in database mirroring and replications
Generally, requires a minimum of two (2) to five (5) years of experience with the Microsoft SQL Server. Experience in working with NOSQL databases would be an advantage.
Bachelor’s Degree in Computer Science preferred.
At iHerb we strive for innovation, targeted at delivering a customer-centric experience while transforming the online shopping experience. We change direction and define ourselves in the idea that individually we are incredible but united our growth is infinite and paramount to our success. iHerb strives to be the global industry leader!
iHerb is an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status. iHerb provides equal employment opportunities to all applicants for employment and prohibits discrimination and harassment.