Department Business & Technology
Employment Type Open-Ended
Minimum Experience Experienced
Database Administrator
The Database Administrator is responsible for the effective operations of the server and database infrastructure to ensure integrity and availability of data and systems are maintained. The DBA will also plays a major role in performance tuning for mission critical systems and enhancing the company’s disaster recovery capabilities.
Job Responsibilities:
- Installing and maintaining the performance of database servers.
- Developing processes for optimizing database security, management and maintenance.
- Mapping out the conceptual design for a planned database.
- Refining the logical design so that it can be translated into a specific data model
- Installing and testing new versions of the database management system (DBMS).
- Writing database documentation, including data standards, procedures and definitions for the data dictionary (metadata)
- Developing and maintaining documented backup, restoration and disaster recovery procedures for applications, server and database infrastructure, and conducting routine Disaster Recovery exercises on a regular basis.
- Carrying out capacity planning
- Administering applications and databases as assigned, through but not limited to the following:
- Liaising with relevant team members to understand how changes to be made in the database would affect the system operations.
- Establishing database configuration, or liaising with Contractor as required.
- Installing and configuring new application, database or web Servers.
- Preparing the schedule of tasks for database administration (e.g. back-up times, maintenance schedule, random security audits), as required by the type of system and level of usage etc.
- Performing data recovery routine, when required.
- Monitoring report generation to ensure efficient use of time and other resources.
- Assisting with monitoring and fine-tuning systems to achieve optimum performance levels
- Commissioning and installing new applications and customising existing applications in order to make them fit for purpose
- Ensuring that End-User/Team Members are given a basic introduction to the new hardware or software, upon installation, based on standard agreed with immediate supervisor or the provider’s guidelines
- Assisting with the planning and budgeting process of the department, as required.
- Writing and submitting for approval, justification for any purchase, modification or termination being recommended.
- Recommending and implementing emerging database technologies.
- Creating and managing database reports, visualizations, and dashboards.
- Creating automation for repeated database tasks.
- Providing on-call support as needed.
The ideal candidate will possess:
- BSc. in Computer Science / MIS / Data Science or any related field
- Minimum of five years’ experience in Information Technology, including database administration
- Strong command of SQL Server, Language and Data Tools (SSIS, SSRS etc.)
- One or combination of certifications or equivalent experience: MCSA: Windows Server 2008/2012, SQL Server 2008/2012
- Advanced knowledge of database security, backup and recovery, and performance monitoring standards
- Proven understanding of relational and dimensional data modeling
- PowerShell and Unix shell scripting skills
- Excellent written and verbal communication skills
- Impeccable attention to detail
- Familiarity with COBIT, ITIL standards and strong mathematical/statistical knowledge would be beneficial
Comments
Post a Comment
Got a question? Ask it here! Speak with our admin. Respectful language please.