Pearson
Job title:
Senior Database Developer
Company
Pearson
Job description
Role: Senior Database Developer (full or part time: at least 60% FTE)Division: Assessment & Qualifications DeliveryLocation: Bangalore or Chennai, India; Manchester, Oxford or Rotherham, UKGrade: C2About Pearson: At Pearson we ‘add life to a lifetime of learning’ so everyone can realise the life they imagine. We do this by creating vibrant and enriching learning experiences designed for real-life impact. Our Purpose | Add Life to a Lifetime of Learning. Pearson was founded in 1844 and has been built on our ability to grow with and adapt to a constantly evolving market. Our 20,000+ employees are dedicated to creating the high-quality, digital-first, accessible and sustainable resources for lifelong learning.About UK Assessment & Qualifications: We are responsible for the delivery of nearly 4 million examination results per annum, including A-Level, GCSE, BTEC and T-levels for students in UK and International centres. Our in-house systems process every learner from registration to marking and certification, in a highly regulated business. We currently operate a hybrid estate of predominantly bespoke systems, with an ongoing strategic transformation programme to migrate from on-prem to cloud based, cost effective, scalable, and resilient services.About the JobThe position is for a Senior Database Developer, who has experience working with large data focused projects, and whose responsibility is around the transformation of data from legacy systems to modern cloud microservice based applications, along with working towards better methods of exploiting this data in terms of analytics and reporting.Currently we are in the middle of a large programme to transform a legacy estate to AWS, and therefore there is a large amount of data hosted in platforms such as Oracle and SQL server that needs to be linked in with new microservices, using CDC technology, along with making this and new microservice mastered data available for both end user reporting and downstream consumption of other data platforms.This role involves working with business SME’s, product owners, architects, and developers, hence excellent communication and analysis skills are required. There will also be attendance to various senior stakeholder meetings to explain project progress, design ideas and decisions etc, so good communication & planning skills are essential, with the ability to put things into non-technical terms for the wider audience.About YouThis would suit someone with a background in complex data transformation projects, from legacy to cloud preferably, and who is looking to work on fast moving projects and contribute to design decisions. A proven track record in delivering projects is an advantage.Key Skills & ExperienceProficiency in one or more database systems such as Amazon Aurora MySQL, PostgreSQL, Microsoft SQL Server, Oracle, DynamoDB, etc.Expert level hands-on experience in designing, developing, and maintaining complex SQL queries, stored procedures to support various business applications.Design, implement, and maintain scalable and high-performance database solutions.Experience with data modelling tools and implementation of database schemas, ensuring optimal performance, data integrity, and scalability.Perform advanced performance tuning and optimization of database systems.Implement and maintain database monitoring solutions to proactively identify and address potential issues.Proven experience of implementing different indexing strategies to improve query performance.Develop scripts and automation tools to streamline database management tasks.Familiarity with version control systems for database schema changes (e.g., Git).Knowledge of AWS DMS, Lambda, S3, Step Functions, CloudWatch, Redshift, Glue, Event Bridge.Change Data Capture understanding.CI/CD – Pipeline setup and repository (Bitbucket) knowledge.Automated testing design and setup.Experience with large-scale data environments.Data Warehousing concepts, design and loading strategies.Experience with Integration / Ingestions of data sources into a Data Lake / Data Platforms.Excellent organisational skills, proactive, self-starter with a curious approach to data and its value.Microservice architecture understanding.AWS SNS\SQS pub/sub/queue concepts.JIRA – Kanban Boards, agile methodology.Working with product management, product owners, data architects, business stakeholders.Excellent Communication & Planning.Desirable Skills & ExperiencePython – Script writingJenkins\Terraform – Infrastructure as codeJob Location and HoursThe role is aligned to our Bangalore or Chennai offices in India, working a 45 hour week, or our Manchester, Rotherham, or Oxford offices in the UK, working a 37.5 hour week. Our Rotherham office is located at Junction 1 of the M18.All our roles are hybrid working; our current policy requires our team to visit their base office no more than once a week, and with the possibility of occasional business travel to other Pearson sites. Candidates must be a suitable commute from their base office as our office presence policy may change to require more frequent presence in 2024.For this role there is a requirement to provide occasional out of hours support during business critical periods.What to expect from PearsonDid you know Pearson is one of the 10 most innovative education companies of 2022?At Pearson, we add life to a lifetime of learning so everyone can realize the life they imagine. We do this by creating vibrant and enriching learning experiences designed for real-life impact. We are on a journey to be 100 percent digital to meet the changing needs of the global population by developing a new strategy with ambitious targets. To deliver on our strategic vision, we have five business divisions that are the foundation for the long-term growth of the company: Assessment & Qualifications, Virtual Learning, English Language Learning, Workforce Skills and Higher Education. Alongside these, we have our corporate divisions: Digital & Technology, Finance, Global Corporate Marketing & Communications, Human Resources, Legal, Strategy and Direct to Consumer. Learn more at We are Pearson.We value the power of an inclusive culture and also a strong sense of belonging. We promote a culture where differences are embraced, opportunities are accessible, consideration and respect are the norm and all individuals are supported in reaching their full potential. Through our talent, we believe that diversity, equity and inclusion make us a more innovative and vibrant place to work. People are at the center, and we are committed to building a workplace where talent can learn, grow and thrive.Pearson is an Affirmative Action and Equal Opportunity Employer and a member of E-Verify. We want a team that represents a variety of backgrounds, perspectives and skills. The more inclusive we are, the better our work will be. All employment decisions are based on qualifications, merit and business need. All qualified applicants will receive consideration for employment without regard to race, ethnicity, color, religion, sex, sexual orientation, gender identity, gender expression, age, national origin, protected veteran status, disability status or any other group protected by law. We strive for a workforce that reflects the diversity of our communities.To learn more about Pearson’s commitment to a diverse and inclusive workforce, navigate to: Diversity, Equity & Inclusion at Pearson.If you are an individual with a disability and are unable or limited in your ability to use or access our career site as a result of your disability, you may request reasonable accommodations by emailing [email protected].Note that the information you provide will stay confidential and will be stored securely. It will not be seen by those involved in making decisions as part of the recruitment process.Job: TECHNOLOGYOrganization: Assessment & QualificationsSchedule: FULL_TIMEReq ID: 14659
Expected salary
Location
Oxford
Job date
Wed, 13 Mar 2024 08:36:44 GMT
To help us track our recruitment effort, please indicate in your email/cover letter where (jobsnear.org) you saw this job posting.