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
