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.