I ensure that: • data remains consistent across the database • data is clearly defined • users access data concurrently, in a form that suits their needs • there is provision for data security and recovery control (ensuring all data is retrievable in an emergency).
I need to: • establish the needs of users and monitor user access and security • monitor performance and manage parameters in order to provide fast responses to front-end users • map out the conceptual design for a planned database • consider both back-end organisation of data and front-end accessibility for end-users • refine the logical design so that it can be translated into a specific data model • further refining the physical design to meet system storage requirements • install and test new versions of the database management system (DBMS) • maintain data standards, including adherence to the Data Protection Act • write database documentation, including data standards, procedures and definitions for the data dictionary (metadata) • control access permissions and privileges • develop, manage and test back-up and recovery plans • ensure that storage and archiving procedures are functioning correctly • carry out capacity planning • work closely with IT project managers, database programmers and multimedia programmers • communicate regularly with technical, applications and operational staff to ensure database integrity and security • commission and install new applications and customise existing applications in order to make them fit for purpose • manage the security and disaster recovery aspects of a database.
CapgeminiFebruary 2019 - November 2019
Transact-SQL, SQL, Python, Microsoft SQL Server, Debian, Database Administration, C/C++
As Pentalog’s Talent Sourcing branch, SkillValue relies on a pool of 400,000+ Tech & Marketing Specialists – including 15,000+ Freelancers, a comprehensive catalog of IT assessments, available projects and job opportunities. Our SkillValue consultants are always ready and willing to help you boost your career.
Stay in the know with Pentalog tech & business updates
WHAT WE'RE ABOUT
Pentalog is a digital services platform dedicated to helping companies access world-class software engineering and product talent. With a global workforce spanning more than 16 locations, our staffing solutions and digital services power client success.