We break down internal data silos that have different data structures, velocities and volumes, and enrich that data with external sources, creating a scalable Enterprise Data Platform that will arise as the single version of the truth, democratizing the data and fostering organizational changes towards a data-driven culture. Our Data Engineers combine data, business processes, and state-of-the-art IT tools and algorithms that enable businesses to engage in a deeper, interactive and more meaningful conversation with their data, using visual discovery techniques to reveal hidden patterns and trends and obtain relevant and useful business insights for decision-making purposes.
In our big data studio, we are all about the data. Our mission is to empower our clients with a competitive advantage by unlocking the true value of data to create meaningful, actionable and timely business insights.
DBA roles are increasingly identified by the databases, the processes they administer and the capabilities of the database management system (DBMS) in use.
Typical work activities
Typical responsibilities include some or all of the following:
- establishing the needs of users and monitoring user access and security;
- monitoring performance and managing parameters to provide fast query responses to front-end users;
- mapping out the conceptual design for a planned database in outline;
- considering both back-end organisation of data and front-end accessibility for end-users;
- refining the logical design so that it can be translated into a specific data model;
- further refining the physical design to meet system storage requirements;
- installing and testing new versions of the DBMS;
- maintaining data standards, including adherence to the Data Protection Act;
- writing database documentation, including data standards, procedures and definitions for the data dictionary (metadata);
- controlling access permissions and privileges;
- developing, managing and testing back-up and recovery plans;
- ensuring that storage, archiving, back-up and recovery procedures are functioning correctly;
- capacity planning;
- working closely with IT project managers, database programmers and multimedia programmers;
- communicating regularly with technical, applications and operational staff to ensure database integrity and security;
- commissioning and installing new applications and customizing existing applications in order to make them fit for purpose.
Because of the increasing levels of hacking and the sensitive nature of data stored, security and disaster recovery have become increasingly important aspects of the work.
We support Microsoft SQL Server (2000+). We have added support for SQL Server 2019 Beta Release