Performance Engineer (MS SQL Database)
Remote
Salary range is: $160,000 - $180,000
About Centric Software:
Centric Software stands at the forefront of innovation, delivering cutting-edge PLM solutions tailored specifically for the retail, fashion, footwear, luxury, and consumer goods industries. Our enterprise software applications are designed to meet the unique challenges of the fast-moving consumer goods market, empowering businesses to manage, optimize, and execute their critical processes with ease.
From concept to production, our software solutions streamline the journey of bringing products to life. We support our customers in effectively managing materials, sourcing, quality, and pricing, ensuring every step leads to a successful final catalog. With Centric Software, businesses can navigate the complexities of product development with confidence and agility. www.centricsoftware.com
Job Summary
We are seeking a Performance Engineer with strong expertise in MS SQL Server database troubleshooting to join our team. In this role, you will be responsible for optimizing the performance, scalability, and reliability of our application and underlying database. You will identify and resolve database-related performance issues, working closely with developers, DBAs, and infrastructure teams to ensure optimal system performance under varying load conditions.
The ideal candidate will have deep knowledge of database internals (e.g., SQL tuning, indexing, query optimization), and the ability to diagnose complex database issues. Your role will be essential in enhancing overall system efficiency and ensuring the best possible performance for our applications.
Key Responsibilities:
- Analyze and optimize the performance of SQL database to improve efficiency and scalability.
- Troubleshoot and resolve database performance issues, including slow queries, resource contention, deadlocks, and indexing problems.
- Use profiling and monitoring tools to identify and resolve database bottlenecks, resource utilization issues, and latency.
- Conduct root cause analysis for database performance degradation and implement corrective actions.
- Work with development teams to identify code optimizations and database changes that improve system performance.
- Stay up to date with emerging trends in database technologies, performance testing tools, and best practices.
- Write monitoring and data extraction tools in Java, Python, or Unix Shell is a plus.
Required Qualifications:
- Bachelor’s degree in Computer Science, Software Engineering or Information Technology
- Proven experience as a Database administrator.
- Experience as a Performance Engineer or a similar role with a focus on database performance is a plus.
- Strong expertise in database troubleshooting and performance tuning.
- Deep understanding of database internals, including indexing, caching, query execution plans, and storage engines.
- Strong analytical and problem-solving skills, with the ability to troubleshoot complex performance issues.
- Familiarity with database management systems (e.g., MySQL, PostgreSQL, Oracle, SQL Server, MongoDB).
- Excellent communication and collaboration skills, with the ability to work effectively across cross-functional teams.
- Familiarity with AWS, Azure, and Google Cloud.
Centric Software provides equal employment opportunities to all qualified applicants without regard to race, sex, sexual orientation, gender identity, national origin, color, age, religion, protected veteran or disability status or genetic information.
What We Do
Centric Software® is the innovator behind the #1 Product Lifecycle Management (PLM) platform, Centric PLM™, that is blazing the trail for brands, manufacturers and retailers across all segments of the consumer goods industry. Headquartered in Silicon Valley, Centric Software has shattered the mold to create state-of-the-art digital solutions to satisfy the needs of every player in the market, large and small, and supports their mission to develop high-quality, sustainable products that are on time and on trend.
- Centric PLM delivers enterprise-class merchandise planning, product development, sourcing, quality and product portfolio optimization innovations specifically for fast-moving consumer industries. Centric PLM streamlines the product development process from concept to retail.
- Centric Planning provides best-in-class data and visually driven financial, merchandise and assortment planning as well as store and vendor forecasting to maximize margins and for seamless and fast, pre and in-season execution.
- Centric Visual Boards improves collaboration and decision-making of merchandising and buying teams through intuitive digital boards, driving innovation and decreasing time to market.
All Centric solutions are market-driven, ensuring they meet the needs of customers. These innovations include the first ever PLM mobile apps, 3D CAD connectors, sustainability integrations, and more. Centric Software has the highest user adoption rates in the industry and proudly maintains a 99% customer retention rate due to its seamless implementation methodology which ensures that 100% of its customers go live. Centric Software is proud to provide the best solution, backed by the best team to service the best customers.
Centric Software is a subsidiary of Dassault Systèmes (Euronext Paris: #13065, DSY.PA). For more information, please visit www.centricsoftware.com.