Senior Database Developer (MS SQL)

Posted 4 Days Ago
Mumbai, Maharashtra
Mid level
Business Intelligence
The Role
As a Senior Database Developer at YouGov Sport, you will be responsible for designing, developing, and maintaining MS SQL Server databases, optimizing their performance and scalability. Key tasks include creating SQL database solutions, performing ETL processes, and collaborating with application developers to enhance research data accessibility through a proprietary dashboard.
Summary Generated by Built In

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. 
    Company Description and Culture 

     

    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

    Top Skills

    SQL
    The Company
    HQ: Toronto, Ontario
    3,758 Employees
    On-site Workplace
    Year Founded: 2000

    What We Do

    YouGov is an international online research data and analytics technology group. Our mission is to offer unparalleled insight into what the world thinks.

    With operations in the UK, the Americas, Europe, the Middle East, India and Asia Pacific, we have one of the world's largest research networks.

    At the core of our platform is an ever-growing source of connected consumer intelligence that has developed daily over our 20 years of operation. We call it living data. All of our products and services draw upon this detailed understanding of our 26+ million registered panel members in over 55 markets to deliver accurate, actionable consumer insights.

    Our innovative solutions help the world’s most recognised brands, media owners and agencies to explore, plan, activate and track better marketing activities:

    Explore
    Actionable answers from your audience - from syndicated data and in-depth custom research to quick surveys and polls.

    Plan
    Unlock the most complete view of your audience, with over a million profiling points.

    Activate
    Supercharge campaigns with precision targeting and unmissable advertising.

    Track
    Continuously monitor what the world thinks about brands, campaigns and your competition, with daily updates.

    As innovators and pioneers of online market research, we have a strong reputation as a trusted source of accurate data and insights. Testament to this, YouGov data is regularly referenced by the global press, and we are the most quoted market research source in the world (Meltwater 2022).

    Similar Jobs

    Deutsche Bank Logo Deutsche Bank

    Database Lead Engineer, AVP

    Fintech • Financial Services
    Magarpatta, Hadapsar, Pune, Maharashtra, IND
    68787 Employees

    Broadridge Logo Broadridge

    Database Developer

    Fintech • Financial Services
    Andheri East, Mumbai Suburban, Maharashtra, IND
    14000 Employees

    PTC Logo PTC

    Technical Lead

    Information Technology • Internet of Things • Software • Virtual Reality
    Industrial Estate, Kharadi, Pune, Maharashtra, IND
    7347 Employees
    Mumbai, Maharashtra, IND
    2115 Employees

    Similar Companies Hiring

    SAG LLC Thumbnail
    Virtual Reality • Generative AI • Business Intelligence • Big Data Analytics • App development • Analytics • Agriculture
    Minot, ND
    4 Employees
    Halter Thumbnail
    Software • Machine Learning • Internet of Things • Hardware • Greentech • Business Intelligence • Agriculture
    Auckland City, NZ
    150 Employees
    Energy CX Thumbnail
    Utilities • Professional Services • Greentech • Financial Services • Energy • Consulting • Business Intelligence
    Chicago, IL
    55 Employees

    Sign up now Access later

    Create Free Account

    Please log in or sign up to report this job.

    Create Free Account