Description Embark on an extraordinary journey with us at Innovative Skincare, home of the renowned iS CLINICAL cosmeceutical brand. We are not just about creating groundbreaking skincare products; we are about creating chemistry that extends beyond the lab - a dynamic synergy between our products and our people. At Innovative Skincare, we believe in a unique formula: the perfect blend of professional expertise and cultural harmony. This philosophy fuels our brand's continuous growth and empowers each member of our team. We are more than a company; we are a community bound by passion, dedication, and a deep love for what we do, crafting an atmosphere that is as vibrant and energizing as our products. Who we are: Discover a world where skincare innovation meets scientific excellence at Innovative Skincare, a globally acclaimed leader in high-performance cosmeceuticals. Our journey is rooted in the relentless pursuit of creating skincare products that are not only effective but transformative. At the heart of our brand is the iS CLINICAL line, renowned for its fusion of nature's finest ingredients with cutting-edge science. We are driven by a deep understanding of skin biology and a passion for unlocking the secrets of skin health and rejuvenation. Our ethos is built on the pillars of innovation, integrity, and excellence. Our team members at Innovative Skincare are part of a company that is shaping the future of skincare, where your work contributes to the well-being and confidence of people globally. Join us and be a part of this exciting alchemy where your talent meets our vision, creating a world of pure chemistry! About the role: The Databases Administrator (DBA) will assist with development and maintenance of SQL databases and development of business intelligence applications, your responsibility will include data modeling, performance, integrity and security of databases across our business applications, also troubleshooting user issues, user access data concurrently, and database backup/restore planning. This role is critical to ensuring the integrity, availability, and security of our data, and to supporting our advanced data analytics initiatives. The role will be reporting to Director of IT and will be on-site in Burbank, CA Duties/Responsibilities:
- Design, implement, and maintain robust database architectures that meet business requirements.
- Develop and implement processes for cleaning, organizing, and transforming data from various sources.
- Identify and rectify data quality issues, including duplicates, missing values, and inconsistencies.
- Install, configure, and maintain Microsoft SQL Server databases.
- Maintain database for e-commerce sites and partner with external teams and consultants on improvement projects in managing improvement projects.
- Support maintaining database for sales site environments in salesforce or similar and partner with external team and consultants in managing improvement projects.
- Ensure high availability, disaster recovery, and security of databases.
- Optimize database performance through regular monitoring, tuning, and maintenance activities.
- Manage database security, including user access and permissions.
- Develop and implement automated processes for data extraction, transformation, and loading (ETL).
- Create scripts and tools to automate routine database maintenance tasks.
- Continuously evaluate and improve database management processes to increase efficiency.
- Work closely with cross-functional teams, including Reporting, IT, Sales and Software development.
- Refine the logical design so that it can be translated into a specific data model.
- Maintain data standards, change objects database including adherence to the Data Protection Act and abide by IT policies of iS Clinical.
- Write database documentation, including data standards, procedures, and definitions when necessary.
- Other duties as assigned.
Required Skills/Abilities:
- Strong proficiency in SQL and experience with major database systems (e.g., SQL Server, MySQL, PostgreSQL, NoSQL).
- Proven experience as a Database Administrator with a focus on data cleanup, transformation, architecture, and automation.
- Experience with ETL tools and processes.
- Familiarity with machine learning concepts and tools is a plus (e.g., Python, R, TensorFlow, scikit-learn).
- Knowledge of data warehousing and big data technologies.
- Experience with cloud database solutions (e.g., AWS RDS, Azure SQL Databases) is a plus.
Education and Experience:
- Bachelor's degree in Computer Science, Computer Engineering, or Mathematics and minimum of 3 years of relevant experience.
- Certifications in database management or related technologies a plus.
Physical Requirements:
- Prolonged periods of sitting at a desk and working on a computer.
- Must be able to lift 15 pounds at times.
Our company is dedicated to providing equal employment opportunities and embraces diversity and inclusion in our workplace. All eligible candidates will be considered for employment without bias towards their race, ethnicity, religion, gender, gender identity or expression, sexual orientation, national origin, genetic information, disability, age, or veteran status. Following the Fair Chance Initiative for Hiring Ordinance, our hiring process is inclusive of candidates with criminal histories, ensuring fairness and equality in accordance with California's employment laws. Adhering to the requirements of California's law on salary transparency, the salary bracket for this role is set between $100,000 and $115,000 annually. The offered salary may be adjusted based on various factors such as the applicant's qualifications, skills, and professional experience. Benefits: Matching 401k, Life, Dental, Vision, Health, Paid Time Off