Milton Keynes, UK

Database Systems Administrator

Product development
Permanent

Objectives: Lead a team of DBA’s to manage database systems management for White Clarke Group's CALMS product suite. Working primarily on product development & maintenance activities, and project/client support as required.

Description of the role

  • Work with Business Analysts and Technical Leads on database design to meet technical and business requirements
  • Establish and maintain a set of database management policies & procedures
  • Design, build, configure databases on both Windows and UNIX servers
  • Co-ordinate database builds with other project build activities
  • Maintain and support existing databases including backup and restore
  • Design/create tables views and indexes to support application development activities
  • Review DB changes from developers and make sure they meet the standard
  • Optimize and performance tune database in line with project requirements
  • Maintain database security policies
  • Provide strategic direction for database environments to support future needs of the organization
  • Create and maintain data dictionary, scripting standards, architecture diagrams and configurations
  • Breadth in established and emerging data technologies
  • Ability to conceive and portray the big data picture

Requirements of the role

Essential
  • Database Administration skills for at least SQLServer and Oracle RDBMS
  • Ability to install, create, configure and size databases as per project requirements
  • Experience with performance analysis and tuning implementation
  • Scripting and DBA task automation skills
  • Database design experience
  • Ability to manage DDL and DML database upgrade and release management
  • Experience of using tools for managing database schema changes; i.e. Liquibase
  • Knowledge of Cloud Database; i.e. AWS RDS, AURORA
Desired
  • Basic knowledge of Java is desirable; i.e. able to read a stack trace, hibernate ORM
  • Familiar with Maven and Ant build tools
  • Familiar with the Liquibase database change management tool
  • UML design experience
  • Understanding of implementing ‘high availability’ solutions for SQLServer and/or Oracle
  • GIT experience and basic understanding of the GIT flow
  • Basic knowledge of DevOps methodology; i.e. CI/CD, Docker
Person Specification
  • Well-developed analytical capabilities
  • Ability to take ownership and be responsible for actions
  • Ability to communicate effectively (written and verbal)
  • Attention to detail, with ability to produce clear, concise documentation
  • Ability to work as part of a team
  • Self-motivated and able to work on own initiative
  • Professional image
  • Well-developed time management skills
  • Ability to be flexible with respect to working hours, according to operational requirements

White Clarke Group are committed to welcoming people with disabilities with respect to recruitment, employment, training, career development and career progression and welcomes and encourages applications from people with disabilities. Accommodations are available upon request for candidates taking part in all aspects of the selection process.

Benefits

  • Private medical healthcare on completion of probation period
  • Auto enrolment pension scheme
  • Childcare voucher scheme
  • Cycle to work scheme
  • Death in service benefit
  • Free onsite parking
  • Corporate gym membership options
  • Associate car purchasing discounts – available with selected manufacturers
  • 23 days holiday per year with the option to buy & sell 3 days
  • Additional holiday entitlement increases with length of service
  • Employee referral scheme
  • Assistance with eye tests
  • Professional Association subscriptions fee assistance
  • Social Committee – events throughout the year
  • Support with professional qualifications