Database Administrator

Overview:
**Role**:Database Administrator

**Location**: Oxford, Harwell

**Role ID**: 2023-1972

Our vision is to create a safe and sustainable world.

**Working with Ricardo**

You will be warmly welcomed into our workplace where every voice matters. We are diverse thinkers and doers, coming together to create a culture of inclusion. We will support you to find your place.

We will encourage you to use your passion and expertise to make a positive impact through the projects you work on. Your knowledge and desire to bring about change will be invaluable in helping deliver innovative solutions that support communities across the globe in becoming safer and more sustainable.

**Work life balance**

We offer flexible approaches to work, whether that is working from home, being in the office, or as a hybrid worker. We're happy to discuss flexible working arrangements. Wellbeing is at the core to our culture, allowing employees to flourish and to achieve their full potential.

We are currently looking for a Database Administrator to join our Digital Service team.

At Ricardo we help Governments and businesses across the world address environmental challenges through our world leading consultancy expertise and innovative technical solutions. We combine energy and climate change, air quality, resource efficiency, sustainable transport and chemical risk expertise with our strong IT capability. We’ve got some ambitious growth plans and we’re looking for a talented SQL DBA with SQL development skills to join our team.

**Key Responsibilities**
- To be responsible for the delivery and support of robust and efficient database systems.
- Manage and perform full system implementations.
- Monitor systems to make sure they run efficiently.
- Develop database documentation.
- Working with development teams to formulate/ architect database solutions.

**Skills and Behaviours**

**(Essential)**
- SQL Server (from 2019 to latest version)
- MS SQL design, deploy and manage
- MS SQL clustering, design and deploy
- MS SQL reporting, analysis, integration, deploy and manage
- Database design, development and ETL technologies.
- Knowledge and commercial experience of Data Warehousing.
- Excellent Transact SQL skills.
- Adept at developing and refactoring stored procedures.
- Exposure to Microsoft SQL clustering and replication management.
- Experience developing SSIS packages.
- Have detailed knowledge of server architecture.
- Strong commercial experience with XML.

**(Desired)**
- Working knowledge of C#,.NET.
- Trained and practiced in MS Windows Clustering.
- Trained and practiced in MS Windows NLB.
- Knowledge of iSCSI storage.
- Working knowledge of MS Dynamics and Agresso Financial Software.
- Working knowledge of MySQL would be useful but not essential.
- Working knowledge of MySQL clustering would be useful but not essential.
- Mentoring and leadership experience would be a distinct advantage.

**Benefits**

We want you to know how much you are valued. Your remuneration and benefits package will reflect that. You will receive a range of benefits which include support for your physical and mental health.

Our core benefits include 25 days' annual leave, plus 8 flexible bank holidays, a competitive company pension scheme, life assurance and professional subscriptions reimbursement. We also offer a wide range of flexible benefits to suit your lifestyle.

**Next steps