Job title – Database Administrator
Job Description
The Role:
YouGov Sports is looking for a talented and proven Database Administrator with experience of database structure design and extensive knowledge of the T-SQL. The ideal candidate will have expertise in MS SQL Server and a proven track record of optimizing the performance of particularly with complex datasets. A minimum of 5 years’ experience administering SQL Server Database Systems is a must, with specific knowledge of SQL Server 2019. 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. Using your expertise in database builds, migrations and upgrades, you will be responsible for enhancing the performance of this dashboard and other YouGov Sport systems.
Overall role objectives:
- Take ownership and responsibility for the maintenance and development of the YouGov Sport database
- As a Database Administrator, you will be responsible for developing, constructing, testing, and maintaining architectures, such as databases and large-scale processing systems
Key responsibilities:
- Design, implement, and maintain database solutions using MS SQL Server, ensuring scalability, reliability, and performance.
- Collaborate with cross-functional teams to gather requirements and design data models that meet business objectives.
- Optimize database performance through indexing, query optimization, and other performance tuning techniques, especially for complex data sets.
- Develop and maintain data migration strategies for moving data between environments.
- Build data pipelines and ETL processes to extract, transform, and load data from various sources into databases or data warehouses.
- Ensure data integrity and security by implementing access controls, encryption, and other security measures.
- Provide guidance and support to developers in writing efficient SQL queries and accessing database resources.
- Monitor database performance and troubleshoot issues as they arise, working with IT operations teams to resolve problems.
- Stay up-to-date with emerging technologies and trends in database management and data engineering.
Qualifications
- Bachelor’s degree in computer science, Information Technology, or a related field.
- Proven 4+ years’ experience as a Data base administrator or similar role, with a focus on MS SQL Server.
- Strong SQL programming skills, with the ability to write complex queries and stored procedures.
- 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 modeling.
- Experience with ETL (Extract, Transform, Load) processes and data pipeline development.
- Experience with database administration tasks such as backup and recovery, security management, and monitoring.
- Excellent problem-solving skills and attention to detail.
- Strong communication and collaboration skills, with the ability to work effectively in a team environment.
- Experience working in an Agile development environment is a plus.
- Relevant certifications such as Microsoft Certified: Azure Data Engineer Associate or similar are advantageous.
- Experienced in alternate open-source technology is a plus.
Shift - Monday to Friday (11:00 am to 8:00 pm IST)
Benefits -
- LinkedIn Learning
- Mental Health First Aiders
- Headspace App
- Annual Leave – 20 Days
- Birthday Leave – An additional day holiday on your Birthday
- Sick & Casual Leave – 12 Sick leave and 8 Casual Leave
- Maternity Leave
- Paternity Leave
- Private Medical Insurance
- Life Insurance
- Sodexo Meal Pass
- Leave & Travel allowance (LTA)
- Provident Fund
- Night Shift Transportation facility
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 24 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
