Job Location: Mumbai/ Navi Mumbai/ Bangalore
Here’s a summary of the role:
YouGov Sport has developed a proprietary web-based dashboard to allow our clients access to in-depth, comprehensive research data, enabling them to carry out instant, ad-hoc analysis of key metrics relating to their effectiveness across multiple media channels.
YouGov Sport are looking for a talented and proven Senior SQL Database Developer with experience of database structure design and extensive knowledge of T-SQL. You will also bring your expertise in database developments, builds, migrations and upgrades to enhance the performance of our dashboard and other YouGov Sport systems.
The ideal candidate will have expertise in MS SQL Server and a proven track record of developing and optimizing the performance of particularly complex datasets. A minimum of 4 years’ experience developing SQL Server Database Systems is a must, with specific knowledge of SQL Server 2019.
Here’s a breakdown of what you’ll do (not all of it, just the important stuff):
- Take ownership and responsibility for the maintenance and development of the YouGov Sport databases
- Focus on developing, constructing, testing, and maintaining architectures, such as databases and large-scale processing systems
- Design, develop, implement, and maintain database solutions using MS SQL Server, ensuring scalability, reliability, performance and security.
- Develop SQL DB objects as per the design and defined standards.
- Maintain/ write SQL database schemas and scripts, including views, stored procedures, dynamic queries and triggers.
- Extract, transform, and load (ETL) data from multiple databases to support reference data enhancements and new functionalities.
- Optimize database performance through indexing, query optimization, and other performance tuning techniques, especially for complex data sets.
- Independently analyse, solve, and correct issues in real time, providing problem resolution end-to-end.
- Perform scheduled maintenance and support release deployment activities after hours.
- Provide support, guidance and collaborate with Application Developers to implement database design & solution.
- Stay up to date with emerging technologies and trends in database management and data engineering.
- Provide support for critical production systems.
- Monitor database performance and troubleshoot issues as they arise, working with IT operations teams to resolve problems.
- Collaborate with system DBAs to help implement database changes, upgrades, and migrations.
These are the essentials you’ll need to get an interview:
- Bachelor’s degree in Computer Science, Information Technology, or other related field.
- Proven experience as a Database Developer or similar role, with a focus on MS SQL Server.
- Strong SQL programming skills, with the ability to write complex queries, stored procedures, Functions, Views.
- Experience optimizing the performance of web-based applications, including identifying and resolving performance bottlenecks, particularly with complex data sets.
- Familiarity with database design principles, including normalization, indexing, and data modelling.
Here are some nice to haves:
- Experience working in an Agile development environment
- Relevant certifications such as Microsoft Certified: Azure Data Engineer Associate or similar
- Experienced in alternate open-source technology
- Basic programming knowledge on any NoSQL database
These are the behaviours you'll need to thrive in this role:
- Excellent problem-solving skills and attention to detail.
- Strong communication and collaboration skills, with the ability to work effectively in a team environment.
YouGov is a global online research company, offering insight into what the world thinks.
We speak daily to our panel of over 27 million registered members to understand opinion and behaviors around the world. We have a strong reputation as a source of accurate data and we’re trusted by the world’s biggest brands to get it right, making us the most quoted market research source in the world.
Why join YouGov?
Join our global team to help us achieve our social mission: to make millions of people’s opinions heard for the benefit of our local, national, and international communities.
Understanding diversity of opinion requires diversity of background. Although our global panel of millions of people worldwide powers our research, our biggest asset is our people. If our research is to be truly representative of what the world thinks, we need people from all walks of life to be part of the team to bring their perspective to the work we do.
Life at YouGov
We are driven by a set of shared values. We are fast, fearless, and innovative. We work diligently to get it right. We are guided by accuracy, ethics, and proven methodologies. We respect and trust each other, bringing these values into everything that we do.
We strive to provide YouGovers with best-in-class benefits to support their physical, financial, and emotional wellbeing. We want our employees to have a sense of belonging and uniqueness in a supportive workplace, so they can bring their full selves to work.
Equal Opportunity Employer
As an Equal Opportunity Employer, qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, gender identity or expression, and sexual orientation), parental status, national origin, marital status, age, disability, genetic information, HIV status, political affiliation, socioeconomic background, veteran status or any other characteristic protected by law or in line with our responsibilities as a fair and ethic employer. All employment decisions are made based on occupational qualifications, merit, and business need.
Data Privacy
To find out how we collect and use your personal data when you apply for a role at YouGov, please read our privacy notice at https://jobs.yougov.com/privacy
