Apply: Senior Database Architect, London
Reference:
JA-55
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
Company Background:
<p>Do We Inspire You? <br />As a business-to-business media company connecting leading professionals globally through insightful market-leading Exhibitions, vibrant Festivals, and precise Informational Services, we inspire people to join us from around the globe with our strong ethics, integrity and clear focus for the future. <br /> <br />Can You Inspire Us? <br />As an ever expanding global business, we thrive upon fresh talent, new ideas, and unique approaches to make our businesses and people flourish. With exciting opportunities in sales, marketing, recruitment, to name a few, we want you to try things differently, show us your creativity, and inspire us by being you. <br /> <br />So WhyNot Join Us and Discover What You Can Do? <br />With a choice of vibrant and prestigious brands, it is simple to begin a career to flourish. <br /> <br />How Do I Apply? <br />Click ‘Apply’ and attach a copy of your CV with a contact number, to kick start your career with us.</p>
Add your CV and application details
Apply with Dropbox
No CV attached... *
Upload CV
First name *
Last name *
Enter your email address *
Enter a contact number: *
80