Department: Service Operations

Location: Pune, India

Description

ParentPay Group is Europe's leading software product company and the UK's largest education technology business. We are on a mission to bring next-generation innovation to positively impact on the lives of millions of parents, teachers, and students every day in over 49 countries.

Our market leading products use cutting edge cloud-based technology to streamline school processes, including secure web and mobile apps that enable secure online payments for school items such as meals, trips, clubs and uniform, improve parental engagement, simplify meal management and - through our product SIMS - collect and manage a database of student information and core school operations.

ParentPay Group's new offices in Pune are a fantastic tech hub for those looking to boost their careers in software product development.

Our bright team FastTrack their career with international exposure and ways of working based on agile development best practices from globally renowned technology consultancies.

We're now hiring an experienced DBA to join our team, based in Pune.

Reporting to the Infrastructure Engineering Manager, in a newly formed SME team, you'll provide the Group Service Operations team with support and expertise on all aspects of the databases and applications.

You will proactively identify opportunities to improve our service to our customer base, so that SLA's are exceeded and customer feedback is consistently high.

Key Responsibilities

Your responsibilities will include:

maintaining a high level of Database and Application availability and performance.
Creating and optimising SQL queries and stored procedures
Proactively monitoring SQL databases
Undertaking capacity planning to ensure that there is adequate capacity within the system
Providing support to both internal teams and external customers, assisting with queries and related data quality and application problems.
Supporting SQL Server instances through complete lifecycles (build, maintain, update migrate)
Collaborating with the Dev team to identify and eliminate issues that impact performance
Identifying opportunities to introduce new tools and methodologies which help to optimise overall efficiencies, where appropriate.

Skills, Knowledge and Expertise

Technical skills:

Strong hands-on experience (5+ years) writing, reviewing and optimising SQL Server/ T-SQL queries in an enterprise environment.
Proven ability to analyse and improve query performance using execution plans, indexing strategies and query refactoring.
Experience of maintaining stored procedures, views, functions and triggers.
Ability to troubleshoot and resolve database performance and reliability issues
Demonstrated understanding of infrastructure (compute, storage, networks)
Exposure to backup, recovery and data consistency practices
Exposure to Azure public or private cloud infrastructure and private data centres

Behavioural skills:

Clear and concise communication skills, both written and verbal
Strong collaboration skills - ability to work closely with Dev teams, wider internal and external stakeholders
Proactive problem-solver who takes ownership of issues through to resolution
Ability to prioritise and manage competing requests in a fast-paced environment
Adaptable and willing to learn, with a continuous improvement mindset

Senior Database Developer