Performance Engineer (MS SQL Database)

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.