To work within the DBA Team works with Development teams and other Infrastructure teams to deliver the Database infrastructure to support new and upgraded Services ensuring availability and capacity meet business requirements.
Reporting into the Head of Infrastructure Delivery, the Senior SQL Server Administrator will work within the IT Delivery area on multiple projects and be responsible for the successful implementation of the DBA work stream throughout the entire project life cycle. Additionally, the successful candidate will be expected to work alongside the Database Administration Team to manage and improve PayPoint's mission critical SQL Server database Services ensuring availability and capacity meet business requirements. This role includes the support, administration and improvement of the development and test SQL Server Services through to production deployment.
Strong SQL Server experience and knowledge is essential. Candidates must demonstrate experience of working with large, highly available databases that have high transaction rates. Candidates must also show experience with complex bespoke database design and administration.
Work with Project Managers to produce detailed project plans.
Identify and document Non-functional requirements and SLAs.
Produce high and low level Infrastructure designs in collaboration with other technical teams to meet the requirements of the project.
Consider the capacity implications of proposed developments, and specify amendments to ensure business needs are met.
Follow and enforce standards to ensure that solutions are Efficient, Flexible, Maintainable, Secure and that Data Integrity is maintained.
Provide expert knowledge to Development teams to ensure designs follow best practice and to help resolve complex issues.
Build database infrastructure components in Development, Test and Production environments.
Test database infrastructure components to prove they meet agreed requirements.
Support the testing of new software developments and ensure that the database components of the delivery match the original design.
Plan and implement the transition in to Production service, including knowledge transfer to support teams, ensuring that risk and service outages are minimised.
Provide Support during warranty periods for newly implemented services.
Administration of all Database and Biztalk Servers including
Effective and efficient maintenance & management to optimise performance.
Troubleshoot incidents. Experience with SQL Profiler and Windows Performance Monitor essential.
Provide On call support and be available for implementations outside of working hours.
Planning, testing and implementation of installations, patches and upgrades.
Define, maintain and test Disaster Recovery processes and procedures.
Ensuring backup and archiving processes are maintained to meet the agreed policy and recommending changes to the policy as circumstances require.
Ensure that SQL Server security and database activity monitoring is in line with PayPoint security policies.
Manage replication of data for MIS.
Represent the Database Management Team at meetings with other members of the IT Departments as well as internal business users and external suppliers and clients.
Produce cost effective options, recommendations and benefits cases to support expenditure requests and project initiation.
Coaching of members of the IT Operations and Development Departments to increase the level of SQL Server and Biztalk knowledge across the departments.
Contribute to the overall IT Strategy and Budget planning.
Develop new and existing policies and procedures to meet the continuing needs of the business.
QUALIFICATIONS AND EXPERIENCE REQUIREMENTS
SQL Server (2005 to 2012)
Always on Availability Groups and Database Mirroring
High level understanding of SAN technologies.
High Level understanding of VMWare virtualisation
Working knowledge of ITIL
Ability to review and analyse complex stored procedures.
Database Design & Development
Strong problem solving skills
SQL Server performance tuning and optimisation
Minimum 5 years SQL Server Experience
Basic knowledge of Windows Server 2008 to 2012 System Administration
2:1 Degree or higher
SQL Server 2014
SQL Server Replication, Security, Profiler
SSRS, SSIS, SSAS
Agile Methodologies - Scrum
Willingness to work outside of normal working hours, including weekends when required to minimise the business impact of system changes.
Live within 1 hour commute distance of Welwyn Garden City.
Hands on technical.
A well organised individual with potential and desire to drive this position forward in a fast moving dynamic environment.
Conscientious and meticulous with good attention to detail.
Excellent written and verbal communication skills as the role involves internal and sometimes external liaison.
Ability to produce clear documentation for both technical and non-technical audiences.
A team player, but capable of working on their own initiative.