Senior Database Architect, London

Company:
Ascential
Brand:
Ascential Technology
Job function:
IT/Technology
Job type:
Perm Full Time
Location:
London, UK
Salary:
£ 0 - 0
Job ref:
JA-55
Close date:
20 September 2017
The Role

On a day-to-day basis, the role holder will be responsible for leading technically for all DB server designs implemented within our Production Environment ensuring built to vendor best practices, security and high availability at all times. Owning and contibuting to the success of Ascential’s infrastructure projects and overall architecture. Also, the role holder will provide 4th line engineering assistance to escalated problems and major incidents, occaisonally providing out of hours cover (which is paid in addition to the role holders salary)
 
The ideal candidate is an experienced Senior DBA / Architect with extensive experience in designing, and implimenting highly available enterprise using both Microsoft SQL and MySQL solutions for multi-national fast paced businesses.
 
Proven extensive working knowledge of Microsoft SQL 2012, 2014 and 2016, Microsoft Always on clusters (Supporting MS SQL High Availability) MySQL 5.7.x, MySQL High Availability.
 
Proven working knowledge of supporting DB’s in a fully virtualised environment (VMware Vsphere 5.x and 6.x), Windows Server (2008 R2 - 2012) The candidate will be to demonstrate they are capable of designing building, configuring, deploying, optimising and performance tuning MS SQL and MySQL systems to recognised manufacturer best practise, utilising their wealth of experience and recognised training and certifications.

The Person
  • A multi skilled Senior DB / Architect
  • Always leads as a subject matter expert to more junior DBA’s within the team, sharing knowledge and experience to ensure they follow best practice design and deployments
  • Able to demonstrate flexibility, adaptability, motivation, as well as excellent problem solving
  • Able to demonstrate being a strong team player at all times while also being able to work unsupervised
  • Excellent Database server design skills, coupled with an ability to articulate and document design to a high standard following best practice methodologies
  • Offers and welcomes constructive feedback at all times
  • Is able to fully document both high level and low level designs to a high standard and hand over deployed systems to a support group, before moving on to the next project
  • Is never defeatist, complacent or deflated
Qualifications / Training:
  • Current MCSA, MCSE and MySQL Database Adminsitration
  • ITIL V3 foundation (minimum)
 
Work Experience:
  • Advanced and extensive MS SQL, MySQL Server DBA experience
  • Extensive knowledge and experience with different HA/DR technologies – clustering, AlwaysOn
  • Design, implementation & administration of MS SQL Server 2012, 2014 and 2016 multi node, multisite, MySQL clustering
  • Knowledge and experience with core features and services – database engine, analysis services, reporting services, integration services
  • Knowledge and experience of linked servers, and other methods of inter server/database communications
  • Understanding of server and database security, triggers and stored procedures
  • Experience with SSIS package administration, SSRS report administration
  • T-SQL experience
  • Manage production, QA and development database environments
  • Create detailed procedure documentation including diagrams of database infrastructure
  • Manage multiple databases and assist in capacity planning
  • Use of tools such as SQL Profiler for database tuning. Generate traces, execution plans, identify performance issues, deadlocks/contention and resolve them
  • Develop strategies and implement solutions for managing back-ups, restoration and replication.
  • Innovative approach to work, constantly looking for upgrading the system to more efficient and effective new technologies
  • Experience of cloud based database technology/hosting (e.g. Azure SQL Database/AWS RDS)
  • Knowledge and experience of replication technologies 

Additional Skills
  • Understanding of a variety of Monitoring tools
  • Strong understanding of enterprise database architecture solution

Personal characteristics
  • Strong customer facing skills
  • Able to work to tight time-scales and agile enough to successfully deliver concurrent projects.
  • Strong team player
  • Clear communication skills at all times, able to articulate technical concepts to non technical people and ability to present
  • Can do attitude
 
Additional responsibilities
  • Troubleshooting, analysis and solution of specific Database issues including the generation of accurate requirement specifications and scopes
  • Used to working as part of a project team as a Senior DBA
  • Assessment of business requirements and recommendation/development of viable and long-term solutions.
  • Able to run a proof of concept and prove project objectives in a lab environment
  • Identifying and advising on all Database matters that could have an effect on the operations of the business
  • Liaising with other technology teams throughout business fostering and building relationships
  • The role holder will be required (and remunerated) to be on call occasionally outside of sociable hours, including evenings, weekends and national holidays