Senior Database Administrator at Sage

Job Description    

The Database Administrator is responsible for the overall management of Data resources including but not limited to:

•  Data Policies, procedure & standards
•  Data conflict resolution
•  Data analysis, modelling data requirements, business rules, design and administration tasks,
• Whilst work closely with IT project and development managers, programmers, architects and test engineers.

The Database Administrator will assume ownership in the design, development and delivery of high quality products and/or systems and services that exceed customers’ and business expectations and will proactively share their own knowledge for specific technical solutions and business processes in their area of responsibility.
Key Responsibilities    

• Performance, integrity and security of databases in Microsoft SQL Server , Microsoft SQL AZURE Servers
•  ensure data remains consistent and clearly defined across the database servers
•  users access data concurrently, in a form that suits their needs
•  there is provision for data security and recovery control (ensuring all data is retrievable in an emergency).
•  establish the needs of users and monitoring user access and security
•  monitor performance and manage parameters in order to provide fast responses to front-end users
•  map out the conceptual design for a planned databases
•  consider both back-end organisation of data and front-end accessibility for end-users
•  refine the logical design so that it can be translated into a specific data model
•  continuous refinement of the physical design to meet system storage requirements
•  install and test new versions of the database management system (DBMS)
•  maintain data standards, including adherence to the Data Protection Act
•  write database documentation, including data standards, procedures and definitions for the data dictionary (metadata)
•  develop, manage and test back-up and recovery plans
•  ensure that storage and archiving procedures are functioning correctly
•  carry out capacity planning
•  communicate regularly with technical, applications and operational staff to ensure database integrity and security (LSM & Security Champions)
•  commission and install new applications and customise existing applications in order to make them fit for purpose
•  manage the security and disaster recovery aspects of a database.
•  Advise Management on Long Term Capacity plans and Growth
•  Analyse Impact of Database Changes to the Business
•  Audit Database Access and Requests

Skills, know-how and experience:
Must have:

•  Ability to interpret and/or gather user requirements and translate these into technical specifications and/or code
•  SQL Availability Groups
•  Query Store
•  problem-solving and good analytical skills
•  communication, teamwork and negotiation skills
•  familiarity with the main data manipulation languages and the principles of database design
•  the ability to work to tight deadlines under pressure
•  good organisational skills
•  flexibility and adaptability
•  the ability to create and maintain strong working relationships with colleagues and customers
•  business awareness and understanding of business requirements of IT
•  an understanding of information legislation, such as the Data Protection Act.
•  Be an active and enthusiastic team player
•  The ability to self-train on new technologies
•  Strong oral and written communications skills
•  Ability to collect requirements from business people

Preferred:

•  Innovative and creative thinking
•  a willingness to keep up to date with developments in new technology
•  a commitment to continuing professional development (CPD)
•  High numerical reasoning and logic ability with good problem solving skills
•  Team-oriented individual who effectively collaborates with various roles involved in the software delivery process.