Posted:
9/20/2024, 7:55:30 AM
Location(s):
California, United States
Experience Level(s):
Junior ⋅ Mid Level
Field(s):
IT & Security
Workplace Type:
Remote
TechStyleOS is currently looking for a Database Engineer II
How Do You Fit In?
We are looking for an experienced Database Engineer II to join our dynamic team. The ideal candidate will have a deep understanding of database architecture, design, and implementation, with a focus on performance, scalability, and data integrity. This role will involve working closely with cross-functional teams to ensure the development and maintenance of robust, scalable database systems to meet business needs. As a Database Engineer II, you will join a tight knit group of key contributors who are actively working together to achieve aggressive goals and meet timelines to drive the business forward.
This position will report to the Manager, Database Engineering
Responsibilities:
Collaborate with stakeholders to understand business requirements and provide effective, data-driven solutions to meet their needs.
Design and develop scalable, efficient database structures that align with project goals and business requirements.
Write, modify, and optimize complex SQL queries, stored procedures, and triggers to support internally hosted applications and ensure optimal performance.
Conduct comprehensive code reviews to enforce database engineering best practices, maintain high code quality, and ensure maintainability.
Manage code deployments to production systems, ensuring stability and minimizing downtime.
Proactively monitor and troubleshoot system issues such as blocking, deadlocks, and inefficient execution plans.
Analyze and refactor existing SQL code to enhance performance, scalability, and reliability.
Maintain regular communication with technical, application, and operational teams to develop new tools, features, and systems that support business growth.
Collaborate closely with software developers, analysts, and database administrators to ensure that database operations are efficient and aligned with business goals.
Assist in data integration across multiple systems and build robust data pipelines using ETL processes and cloud technologies like Kafka or AWS.
Stay current with emerging trends, tools, and technologies in database management, cloud computing, and data storage to drive innovation within the team.
Provide on-call production support on a rotating basis to ensure the availability, reliability, and performance of critical database systems.
Required Skills:
Bachelor’s degree in computer science, Engineering, or a related field (master’s degree is a plus).
3+ years of experience in T-SQL programming and database systems.
3+ years of hands-on experience with SQL Server 2018 or later.
Proven track record working with high-traffic, production-level SQL Server environments.
Strong expertise in writing and optimizing complex SQL queries and stored procedures.
Experience in performing code reviews and ensuring adherence to best practices.
Excellent communication and presentation skills, with the ability to effectively convey complex data findings to non-technical stakeholders.
24x7 Production support experience supporting a high throughput Database.
Strong knowledge of normalization and denormalization strategies, and the ability to apply them as needed.
Proven ability to design, implement, and maintain data workflows and scheduled jobs.
Solid understanding of N-tier architectures, with experience in troubleshooting complex systems.
Pluses:
Experience in database engineering on cloud platforms such as Elastic Search, Kafka, Redis, AWS etc.
In-depth understanding of SQL Server internals, including performance tuning and optimization strategies.
Previous experience in e-commerce, retail, or internet industries.
What we offer:
401K match
Annual Bonus Plan
Competitive Salary and Equity Structure
Discretionary PTO
Health & Wellness Benefits
Learning & Development opportunities
And more!
Where we are:
This role is fully remote
Our headquarters are based in our El Segundo, CA
#CR-LI1
About TechStyleOS
TechStyleOS is the globally integrated Operations and Services provider behind some of the fastest growing online fashion brands in history, including Fabletics, Savage X Fenty, JustFab, ShoeDazzle, and FabKids. With capabilities spanning technology, data science, supply chain management, fulfillment, customer service, and more, we help brands launch, scale and grow—across product categories and geographically. From predictive analytics to data-driven marketing and attribution, our unique approach is powered by our proprietary, end-to-end tech platform that enables the brands we serve to deliver a level of personalization, value, and satisfaction that are unrivaled in the fashion industry.
Fabletics, Inc. is an equal opportunity employer. We recruit, employ, compensate, develop, and promote regardless of race, national origin, religion, sex, sexual orientation, gender identity, age, disability, genetic information, veteran status, and other protected status as required by applicable. At Fabletics, Inc., we champion a vibrant workplace culture that thrives on diversity law and do not tolerate discrimination or harassment. We are one team from many backgrounds, innovating through diversity of individuals, who are driven by passion for creating an inclusive space for all. Fabletics, Inc. will continue to champion a workplace culture that prizes diversity and inclusivity.
We encourage you to apply regardless of meeting all qualifications and/or requirements.
Website: https://thesummitatfritzfarm.com/
Headquarter Location: Lexington, Kentucky, United States
Employee Count: 11-50
IPO Status: Private
Industries: Agriculture ⋅ Retail ⋅ Shopping