Database manager

Salary: Competitive

Hours: Full time

Location: Aztec Centre, Aztec West, Bristol

 

About Carterwood

Carterwood are disrupting the health & social care sector!

We offer expert opinion based upon market leading data, to enable our clients to make the most informed decisions – and 2019 has already been an extraordinary year for us, and our clients. In March, we released our new subscription based online market analysis tool, which is already changing the way that the elderly specialist care and older people’s housing markets are being managed.

We are a unique blend of data experts with chartered surveyors, we own a lot of exciting data and we play with a lot more. Most importantly, we use our data and our data insight to help guide the market, which feels great! The introduction of our new product provides a rare opportunity for our team to guide and grow a product start up, with the security, experience and knowledge of a company whose brand has been respected by the industry for over a decade.

Carterwood are proud to have picked up many awards over the years. These not only reflect what we do, but how we do it. Recognised for our bespoke, personal and specialist service, Carterwood was awarded the prestigious ‘Property consultants of the year – property services’ HealthInvestor Award 2019, and honoured as one of the ‘Best places to work in property’, at the national Property Week awards in both 2018 and 2019, not to mention being shortlisted for the EG Awards this year in the Employer and Alternative sector categories.

As well as establishing long-term partnerships with our clients, we work with and support several industry partners, to share our knowledge and forge new relationships. These include Care England, the National Care Forum, ARCO and Housing LIN.

 

What the role will include

Carterwood’s database manager will design and develop complex data structures, data models and processes to support our data warehouse and its related systems. They will develop new features in our already established warehouse, which holds data from multiple real-time and static proprietary, commercial and open source datasets. Specifically, the database architect will work closely with our remotely located software development team and our analyst team to design, improve and document the future of our backend data storage and processing solutions.

 

The responsibilities of the database architect may include:

  • Maintaining our AWS-hosted PostgreSQL databases to meet the current needs of our growing technology function.
  • Advising and implementing on the future direction of our data management and data product strategies.
  • Accessing and extracting information from our externally maintained MSSQL and MySQL databases.
  • Managing the interfaces between the data warehouse, business and connected systems, e.g. our in-house updaters, CRMs and client facing systems.
  • Working with our software development team to ensure that each data feed is configured and tuned for optimal performance to all output platforms.
  • Working with cross functional teams (i.e. software, advisory, agency and analytics) to gather and understand business requirements.
  • Maintaining and enhancing existing data warehouse functionality and capabilities.
  • Monitoring and managing background processes to ensure continuity of service.
  • Sourcing complex data structures, and designing and managing their input into our database.
  • Undertaking specific projects, e.g. building dashboards and bespoke products for customers.
  • Developing the database skills of our extended team.
  • Be the primary administrator for infrastructure systems such as AWS, local servers and similar.
  • Other similar and reasonable roles.

 

Essential competencies

  • Knowledge of RDBMS, specifically data warehouse design/architecture.
  • Ability to perform key DBA functions on PostgreSQL and SQL Server.
  • Working knowledge of performance tuning, index maintenance and active monitoring.
  • Experience in writing high performance queries and stored procedures.
  • Experience in deploying database changes/migrations.
  • Good documentation skills – experience in developing entity-relationship and schema diagrams.
  • Exposure to Cloud infrastructure, specifically AWS (RDS).
  • Fluency in English.
  • 2+ years’ experience with degree in related subject, or 3+ years’ experience otherwise. The experience referred to must include all of the following: (1) designing database schemas; (2) performing database optimisations using PostgreSQL and/or Microsoft SQL Server; and (3) coding in a general-purpose programming language, such as Python or R.
  • Working practice of geodatabases.
  • Experience in working with programming languages (Python, R, Perl, Java, Bash, Powershell, for example) for general purpose programming, e.g. accessing APIs, automating processes, manipulating data and prediction.
  • Ability to write, present and explain complex concepts to non-technical people with a clear, transparent and open approach to communicating your ideas.
  • Knowledge/awareness of agile and SCRUM working practices.

 

Benefits

  • 25 days’ annual leave plus eight bank holidays
  • Birthday off work (discretionary)
  • Childcare vouchers
  • Free fruit at the office
  • Annual flu vaccination
  • Free eye tests
  • On-site parking
  • Discretionary bonus scheme
  • Flexible working policy
  • Summer and Christmas events
  • A commitment to wellness at work.

Carterwood awards

  • HealthInvestor Awards winner 2016, 2017 and 2019
  • Best Places to Work in Property winner 2018 and 2019
  • South Gloucestershire Happiest Workplace (Medium Business) winner 2018
  • Estates Gazette Awards finalist 2019 in two categories, employer and alternative sector
  • LaingBuisson Awards finalist 2017.

 

Why work for Carterwood?  This is what the team have to say…

  • “Carterwood provides an excellent career pathway for everyone, no matter how junior or senior.”
  • “Everyone is treated with respect and there is a genuine interest in what we do and say.”
  • “Really inclusive and energetic environment to work in, where everyone is valued.”
  • “The organisation cares about the quality of its advice and client care.”

 

Why use Carterwood?  This is what our clients have to say…

  • “We have always found Carterwood to be knowledgeable about the Healthcare Industry and they work hard for their clients. They are pragmatic in their approach and are genuinely good to work with.”
  • “Carterwood have certainly made a significant impression on the care sector in a very short space of time. Their work is at the heart of this, of course, but the principals have also made it their mission to be supportive to the sector generally and this has certainly not gone unnoticed.”
  • “We have worked with Carterwood since they set up. We have always found them straightforward in their approach and are very aware that it is their delivery which matters. We have found them to be committed, focussed and consistent.”

 

How to apply

If you are interested in applying for this position, please send a CV and covering letter to joinus@carterwood.co.uk quoting the reference DATABASE MANAGER.

Closing date for applications is Monday 18 November 2019.

First interviews will take place at our offices in Aztec West in Bristol on Thursday 28 November 2019; all candidates will be asked to take a technical test, which should last no more than 60 minutes.   Second interviews will be held on Tuesday 3 December 2019.

Due to the large volume of applications we receive, we are unable to respond to all candidates individually.  Only those candidates being invited to interview will be contacted.  If you do not hear back from us before Monday 4 November, then your application is not being progressed. We thank you for considering Carterwood as a future employer and wish you well in your job search.

Carterwood is committed to equality of opportunity in employment and welcomes applications from all suitably qualified candidates, irrespective of gender, marital or family status, religious belief, political opinion, disability, age, race, nationality or sexual orientation. All applications for employment will be considered on the basis of merit.

This job description should not be taken as constituting conditions of employment.

No agencies please.

Back to all jobs
By using this form you agree with the storage and handling of your data by this website.

Please be assured we never share your data without your permission. Please see our Privacy Policy for more information.