Your responsibility as a database administrator (DBA) will be the performance, integrity and security of a database. You’ll be involved in the planning and development of the database, as well as in troubleshooting any issues on behalf of the users.
You’ll 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).
Responsibilities
As a database administrator, you’ll need to:
- Install and maintain the performance, integrity and security of database servers
- Develop processes for optimizing database security
- Set and maintain database standards, including adherence to the Data Protection Act
- Manage database access
- Performance tuning of database systems
- Install, upgrade, and manage database applications
- Diagnose and troubleshoot database errors
- Recommend and implement emerging database technologies
- Create and manage database reports, visualizations, and dashboards
- Create automation for repeating database tasks
- Be available for on-call support as needed
- monitor performance and manage parameters in order to provide fast responses to front-end users
- develop, manage and test back-up and recovery plans
- ensure that storage and archiving procedures are functioning correctly
- 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
- manage the security and disaster recovery aspects of a database
Qualifications/Skills:
You will need to show:
- excellent problem-solving and analytical skills
- good communication, teamwork and negotiation skills
- familiarity with the main data manipulation languages and the principles of database design
- the ability to work to tight deadlines under pressure
- good organisational skills
- flexibility and adaptability
- the ability to create and maintain strong working relationships with colleagues and customers
- business awareness and understanding of business requirements of IT
- a willingness to keep up to date with developments in new technology
- a commitment to continuing professional development
- an understanding of information legislation, such as the Data Protection Act
- Strong command of SQL and SQL server tools
- Advanced knowledge of database security, backup and recovery, and performance monitoring standards
- Understanding of relational and dimensional data modelling
- PowerShell and Unix shell scripting skills
- Familiarity with SSAS, SSIS, SSRS
- Strong mathematical and statistical knowledge
- Excellent written and verbal communication skills
- Impeccable attention to detail
Education and Experience Requirements
- Bachelor’s degree in computer science or a related field
- 5+ years of experience in database administration, information technology, database architecture, or a related field
- Experience with Linux and Windows Server environments
- Extensive experience with database technologies (MySQL, MS SQL, PostgreSQL Oracle, MongoDB)
Entry without a degree possible for those with good all-round IT skills.
Send us your CV along with your motivational letter to hr@daytonatec.com.
