Database Administrator - Cheltenham, United Kingdom - Ultra Electronics

Ultra Electronics
Ultra Electronics
Verified Company
Cheltenham, United Kingdom

3 weeks ago

Tom O´Connor

Posted by:

Tom O´Connor

beBee Recruiter
Description
Ultra PCS Is in the process of consolidating SQL and Oracle databases. Part of the job role will be migration of datasets between different datacentres and standardising various SQL/Oracle Versions. Migration process will require updating the databases backup and recovery process and updating the SQL/Oracle disaster recovery plan. Updating permission sets and verifying required access based on the IT requirements.


Ultra PCS have recently moved to a new Business Intelligence architecture, utilising SQL Server and SSIS to build a ground-up Data Warehouse, and PowerBI to consistently deliver quality data to our internal customers.

One of the key aspects of this role will be to administer our Data Warehouse, ensuring it consistently performs, whilst working to improve and streamline data extraction and transformation procedures.


Wherever possible, we will consider a variety of working options to suit your lifestyle, whether that be hybrid home/office working, flexible working and part or full time employment.

It's the 'innovating' and 'empowering' values that we ASPIRE to be.

We welcome the challenge to work in new ways and have trust in you when getting the job done because we recognise, our business is our people.


Key Responsibilities:

  • To manage SQL Server databases, monitoring the system's health and performance.
  • To manage data extraction and ETL schedules.
  • To manage data security and server access.
  • To utilise tools such as partitioning, indexing, and parallelisation, to improve the performance of PCS's data warehouse.
  • To ensure the robustness of our data pipelines by monitoring and improving data extraction procedures.
  • To manage the transition of data between Development, Test and Production environments.
  • Work closely with data analysts, datasource system developers, and endusers, to ensure solutions created meet business requirements and are delivered in a timely manner.
  • Ensure development of database architecture, and data pipelines, are documented in line with PCS policies.

Qualifications & Skills Required:

  • Expert knowledge of SQL and SQL Server Management Studio (SSMS).
  • Strong knowledge of SQL Server Integration Services (SSIS).
  • Familiarity with Oracle databases, PL/SQL, and IFS ERP.
  • 5+ years of working as a DBA, or a related field (desired).
  • Has the ability to selfmanage.
  • Enjoys working at speed, when necessary, but also able to plan and consider options.

Security Clearance:

Benefits:


Every employee is critical to our success and as such we offer a range of flexible employee benefits along with career development opportunities.

- Flexible working within core working hours

  • Early Finish on a Friday 25 days holiday with the option to buy/sell 5 days plus bank holidays. 4 times your annual salary in life assurance
  • Flexible benefits package (benefits such as, new car scheme, retail vouchers, gym discounts, health screening and more)
  • Pension Scheme
  • Less than 5 years' service up to 5.5% employer contributions, 5 years' service + up to 7.5% employer contributions.
  • Sports and Social club
  • Supportive and friendly working environment with regular team events
Here at Ultra we are an equal opportunity employer and value diversity and inclusivity.

Underpinned by our values, behaviours and policies, we want you to feel empowered to be the best version of yourself.

We also believe that people from different backgrounds and cultures will increase our diversity of thinking, ensuring we successfully deliver to our customers.


We therefore do not discriminate on the basis of race, religion, colour, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.

We also support requests for flexible working arrangements wherever possible.
More jobs from Ultra Electronics
See all jobs of Ultra Electronics