Database Administrator

SUMMARY:
Our client is seeking a Database Administrator.  To implement, configure, maintain, and monitor the performance of the organization’s database systems, to ensure high availability and consistent performance of the organization’s services to the clients.

POSITION INFO:

Role Purpose Summary
To implement, configure, maintain, and monitor the performance of the organisation’s database systems, to ensure high availability and consistent performance of the organisation’s services to the clients.
To develop and maintain the organisation’s databases, including but not limited to the data warehouse, ensuring their operational readiness, i.e., security, health and performance, monitoring the execution of and executing data loads, and performing data modelling in support of the developers where required. The databases including but not limited to the data warehouse support the enterprise applications and must be capable of working independently and collaboratively.
 
Key Responsibilities
Database Administration
Manage databases environments through the product lifecycle, from development to decommissioning for mission-critical and other production systems.
Install the relevant, agreed database server versions 2012 and components as required.
Confirm and advise on database server requirements, i.e., hardware, OS, network protocols, etc.
 Database Development
Apply data modelling and database design techniques, i.e., logical, and physical modelling, making use of modelling tools, e.g., Visio, Erwin, etc., to ensure development and implementation support integration and performance expectations.
Create and maintain T-SQL code for database development.
Create and maintain Common Language Runtime (CLR) objects, i.e., Stored Procedures, Triggers, User defined functions, aggregates, and types.
Create and maintain SQL Server Integration Services (SSIS) packages for ETL development.
Create and maintain SQL Server Analysis Services (SSAS) code for code development.
Assist developers with complex query tuning and schema refinement
Compliance
Adhere to all IT policies, follow relevant pre-defined IT processes, and produce audit evidence.
Adhere to Change Management Process and produce required Change Management documentation prior to changes being released into production.
Cross Role Support
Serve as backup to the Help Desk Administration Role:
Assign calls to relevant technicians.
Assist with desktop support requests when required.
Ensure that documented desktop support processes are documented, updated and followed.

Qualifications
Tertiary qualification in Information Technology or relevant equivalent experience
Certified MCTS, MCITP, and/or MVP or relevant equivalent experience

Experience
Essential:
 3 - 5 years of MS SQL Server Administration experience required.
2 – 3 years of Desktop Support and Hardware Experience.

NB! This job is now closed. You can apply for other jobs by uploading your CV.