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
