Manchester - Hybrid
Department:
The DBA team are a core part of Cox Automotive Produce and Technology Group (CAPTG), with most key business data stored in SQL, as well as Postgres, MongoDB and DynamoDB. The team will be looking after the delivery and support of products through their lifecycle, ensuring delivery of the business strategy and ensuring high standards are maintained.
Role:
As a CAPTG Database Administrator, you will play a crucial role in ensuring integrity, availability and security of our databases. You will be responsible for the design, implementation, maintenance, and performance tuning of our database systems. Out of core hours work should be expected in this role to support deployments, maintenance or priority issue resolution.
The successful candidate will collaborate with cross-functional teams to support our mission-critical applications and delivery product initiatives. You will also be involved in a program of DBA specific work provided by your line manager, releasing into production via a stringent change process.
Installation, maintaining, and technical support of high-profile business critical database system(s) and other data related vendor products.
Perform regular database monitoring, tuning, and optimisation for optimal performance.
Management and documentation of synchronisation of data across database systems.
Give feedback on new database systems on areas such as design and security. Then support in the data migrations and reduction of redundant data.
Ensure HADR procedures are defined, documented, and tested.
Supporting in maintenance of Database documentation and data categorisation.
Troubleshoot and act as a liaison between vendor and user, achieving a timely resolution to related problems.
Assist in the release of database changes either manually or via DevOps.
Stay updated on emerging database technologies and best practices.
Skills & Experience:
Experience of working with SQL in all forms on Premise and in Azure.
Strong knowledge of SQL across the editions.
Ability to perform all common Database Administration tasks including performing database backups and recovery, management, security, etc.
Ability to take functional and nonfunctional requirements and realise them into a suitable database structure.
Ability to perform Database and Index designing and tuning.
Ability to create, maintain and troubleshoot Data Factory pipelines.
Understanding of performance tuning and query optimisation.
Experience of HADR strategies, supporting in configuration and implementation.
Experience and understanding deploying and maintaining reporting services.
Troubleshooting various database issues and T-SQL queries.
Ability to deliver and perform under pressure and to tight deadlines.
High degree of self-management in areas such as documentation.
Experience of working within engineering teams.
Ability to conveying the status of the project / programme / issue to line manager.
Interest in upskilling in other technologies to deliver desired outcome.
Implement documented system designs where databases are required as well as maintaining legacy documentation.
Experience in Aurora and DynamoDB and/or MySQL would be an advantage.
STRICTLY NO AGENCIES PLEASE
We work with a carefully selected set of recruitment agencies and we're not looking to add to our PSL.
We do not accept unsolicited agency CV's sent to the recruitment team or directly to the hiring manager. We will not be responsible for any fees related to unsolicited CV's.
#INDTR