Sr. Engineer / Engineer – Database Administrator
Department : Database Administration
Qualification : -
PURPOSE OF THE JOB
A Database Administrator is responsible for the performance, integrity and security of a database. Also involved in the planning and development of the database as well as troubleshooting any issues on behalf of the users
- Create ways to store, organize, and present data.
- Work with businesses and managers to identify user needs.
- Administer a variety of database systems including Microsoft SQL Server, Filemaker Pro, and others.
- Maintain and administer Web server and middleware tools.
- Set up new computer databases.
- Integrate old systems data with new system.
- Test and coordinate modifications.
- Assume the technical lead for SQL Server and online database projects.
- Create high-level reporting systems.
- Maintaining data standards, including adherence to the Data Protection Act
- Writing database documentation, including data standards, procedures and definitions for the data dictionary (metadata)
- 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;
- Ensuring that storage and archiving procedures are functioning correctly
- Assist in capacity planning, space management and data maintenance activities for database system.
- Perform database recovery and backup tasks on daily and weekly basis.
- Resolve any database issues in accurate and timely fashion.
- Monitor databases regularly to check for any errors such as existing locks and failed updates.
- Troubleshoot and correct issues as they arise.
- Ensure system is running smoothly.
- Add new users to the system as needed.
- Plan and coordinate security measures alongside network administrators.
- Enhance or build database designs.
TECHNICAL / FUNCTIONAL SKILLS REQUIRED
Understanding of structured query language (SQL), Knowledge of 'relational database management systems' (RDBMS), 'object oriented database management systems' (OODBMS) and XML database management systems, Experience with database software/web applications, Up-to-date knowledge of technology and the Data Protection Act
SOFT SKILLS REQUIRED:
Database Performance Tuning, Database Security, Promoting Process Improvement, Problem Solving, Presenting Technical Information, Quality Focus, Database Management, Data Maintenance, Operating Systems, Attention to Detail, Information Security Policies