ZipRecruiter
Senior Software Engineer - Database Runtime Performance Optimization
ZipRecruiter, Los Angeles, California, United States, 90079
Job DescriptionJob Description
StubHub is on a mission to redefine the live event experience on a global scale. Whether someone is looking to attend their first event or their hundredth, we're here to delight them all the way from the moment they start looking for a ticket until they step through the gate. The same goes for our sellers. From fans selling a single ticket to the promoters of a worldwide stadium tour, we want StubHub to be the safest, most convenient way to offer a ticket to the millions of fans who browse our platform around the world.
StubHub is on a mission to redefine the live event experience on a global scale. Whether someone is looking to attend their first event or their hundredth, we're here to delight them all the way from the moment they start looking for a ticket until they step through the gate. The same goes for our sellers. From fans selling a single ticket to the promoters of a worldwide stadium tour, we want StubHub to be the safest, most convenient way to offer a ticket to the millions of fans who browse our platform around the world.We are looking for an experienced Senior Software Engineer who specializes in optimizing MS SQL Server performance. The ideal candidate will have a deep understanding of SQL Server workload optimization, excellent skills in programming like C++, C#, and Java, and a proven track record in migrating massive workloads across databases. Experience in developing SQL Server engine components is a plus. This is a hybrid work opportunity located in either New York, NY or Los Angeles, CA.
Key Responsibilities:
Programming Skills:
Proficiency in one or more of the following : C++, C#, Java. Ability to write high-performance and maintainable code.
Database Performance Optimization:
Analyze, optimize, and enhance SQL Server workloads to ensure optimal performance and efficiency. Address complex performance issues and implement solutions to improve database responsiveness.
Query Optimization:
Utilize advanced techniques to optimize SQL queries, including index tuning, query plan analysis, and performance troubleshooting.
MS SQL Server Internals:
Leverage in-depth knowledge of MS SQL Server internals to understand and resolve performance bottlenecks and inefficiencies.
Workload Migration : Lead and manage the migration of large-scale workloads across different databases or environments, ensuring data integrity and minimal downtime.
Collaborative Development:
Work closely with cross-functional teams, including developers, architects, and system administrators, to address performance issues and implement improvements.
What You'll Be Doing:
Database Workload Optimization:
Optimize database workloads across hundreds of services and databases to ensure high performance and efficiency. Identify and address performance issues in a large-scale environment.
Services Optimization:
Design and implement changes to existing services or develop new microservices aimed at optimizing database workloads. Ensure that these modifications contribute to improved performance, scalability, and reliability of the overall system.
Data Management Solutions:
Design and develop data management solutions that will be applied across hundreds of services. Focus on improving performance, reducing costs, and increasing engineering agility.
Framework Development:
Develop frameworks and tools to identify performance bottlenecks and optimize SQL Server queries. Collaborate with multiple teams to implement and standardize best practices for performance enhancement.
What We Offer:
Accelerated Growth Environment:
Immerse yourself in an environment designed for swift skill and knowledge enhancement, where you have the autonomy to lead experiments and tests on a massive scale.
Top Tier Compensation Package:
Enjoy a rewarding compensation package that includes enticing stock incentives, aligning with our commitment to recognizing and valuing your contributions.
Flexible Time Off:
Embrace a healthy work-life balance with unlimited Flex Time Off, providing you the flexibility to manage your schedule and recharge as needed.
Comprehensive Benefits Package:
Prioritize your well-being with a comprehensive benefits package, featuring 401k, and premium Health, Vision, and Dental Insurance options.
Team-Building Events:
Engage in vibrant team events that foster camaraderie and collaboration, creating an atmosphere where your professional and personal growth are celebrated.
The anticipated gross base pay range is below for this role. Actual compensation will vary depending on factors such as a candidate's qualifications, skills, experience, and competencies. Base annual salary is one component of StubHub's total compensation and competitive benefits package, which includes equity, 401(k), paid time off, paid parental leave, and comprehensive health benefits.
Salary Range$200,000—$275,000 USD About Us StubHub is the world's leading marketplace to buy and sell tickets to any live event, anywhere. Through StubHub in North America and viagogo, our international platform, we service customers in 195 countries in 33 and 49 available currencies. With more than 300 million tickets available annually on our platform to events around the world -- from sports to music, comedy to dance, festivals to theater -- StubHub offers the safest, most convenient way to buy or sell tickets to the most memorable live experiences. Come join our team for a front-row seat to the action. For California : California Job Applicant Privacy Notice found here We are an equal opportunity employer and value on our team. We do not discriminate on the basis of , , , , , , , , , veteran status, or any other legally protected status.
StubHub is on a mission to redefine the live event experience on a global scale. Whether someone is looking to attend their first event or their hundredth, we're here to delight them all the way from the moment they start looking for a ticket until they step through the gate. The same goes for our sellers. From fans selling a single ticket to the promoters of a worldwide stadium tour, we want StubHub to be the safest, most convenient way to offer a ticket to the millions of fans who browse our platform around the world.
StubHub is on a mission to redefine the live event experience on a global scale. Whether someone is looking to attend their first event or their hundredth, we're here to delight them all the way from the moment they start looking for a ticket until they step through the gate. The same goes for our sellers. From fans selling a single ticket to the promoters of a worldwide stadium tour, we want StubHub to be the safest, most convenient way to offer a ticket to the millions of fans who browse our platform around the world.We are looking for an experienced Senior Software Engineer who specializes in optimizing MS SQL Server performance. The ideal candidate will have a deep understanding of SQL Server workload optimization, excellent skills in programming like C++, C#, and Java, and a proven track record in migrating massive workloads across databases. Experience in developing SQL Server engine components is a plus. This is a hybrid work opportunity located in either New York, NY or Los Angeles, CA.
Key Responsibilities:
Programming Skills:
Proficiency in one or more of the following : C++, C#, Java. Ability to write high-performance and maintainable code.
Database Performance Optimization:
Analyze, optimize, and enhance SQL Server workloads to ensure optimal performance and efficiency. Address complex performance issues and implement solutions to improve database responsiveness.
Query Optimization:
Utilize advanced techniques to optimize SQL queries, including index tuning, query plan analysis, and performance troubleshooting.
MS SQL Server Internals:
Leverage in-depth knowledge of MS SQL Server internals to understand and resolve performance bottlenecks and inefficiencies.
Workload Migration : Lead and manage the migration of large-scale workloads across different databases or environments, ensuring data integrity and minimal downtime.
Collaborative Development:
Work closely with cross-functional teams, including developers, architects, and system administrators, to address performance issues and implement improvements.
What You'll Be Doing:
Database Workload Optimization:
Optimize database workloads across hundreds of services and databases to ensure high performance and efficiency. Identify and address performance issues in a large-scale environment.
Services Optimization:
Design and implement changes to existing services or develop new microservices aimed at optimizing database workloads. Ensure that these modifications contribute to improved performance, scalability, and reliability of the overall system.
Data Management Solutions:
Design and develop data management solutions that will be applied across hundreds of services. Focus on improving performance, reducing costs, and increasing engineering agility.
Framework Development:
Develop frameworks and tools to identify performance bottlenecks and optimize SQL Server queries. Collaborate with multiple teams to implement and standardize best practices for performance enhancement.
What We Offer:
Accelerated Growth Environment:
Immerse yourself in an environment designed for swift skill and knowledge enhancement, where you have the autonomy to lead experiments and tests on a massive scale.
Top Tier Compensation Package:
Enjoy a rewarding compensation package that includes enticing stock incentives, aligning with our commitment to recognizing and valuing your contributions.
Flexible Time Off:
Embrace a healthy work-life balance with unlimited Flex Time Off, providing you the flexibility to manage your schedule and recharge as needed.
Comprehensive Benefits Package:
Prioritize your well-being with a comprehensive benefits package, featuring 401k, and premium Health, Vision, and Dental Insurance options.
Team-Building Events:
Engage in vibrant team events that foster camaraderie and collaboration, creating an atmosphere where your professional and personal growth are celebrated.
The anticipated gross base pay range is below for this role. Actual compensation will vary depending on factors such as a candidate's qualifications, skills, experience, and competencies. Base annual salary is one component of StubHub's total compensation and competitive benefits package, which includes equity, 401(k), paid time off, paid parental leave, and comprehensive health benefits.
Salary Range$200,000—$275,000 USD About Us StubHub is the world's leading marketplace to buy and sell tickets to any live event, anywhere. Through StubHub in North America and viagogo, our international platform, we service customers in 195 countries in 33 and 49 available currencies. With more than 300 million tickets available annually on our platform to events around the world -- from sports to music, comedy to dance, festivals to theater -- StubHub offers the safest, most convenient way to buy or sell tickets to the most memorable live experiences. Come join our team for a front-row seat to the action. For California : California Job Applicant Privacy Notice found here We are an equal opportunity employer and value on our team. We do not discriminate on the basis of , , , , , , , , , veteran status, or any other legally protected status.