An investment back based in Sandton is looking for a SQL DBA with CRM support experience. 

Please send all CVs to keshia@esmartgroup.co.za 

PURPOSE OF THE JOB:

Technical project and production support (application and database) for  Microsoft Dynamics CRM implementations

The SQL database support functions include, design, implementation and management of SQL Server 2008 databases which includes Analysis Services

Perform database Extract Transform and Load (ETL) functions using Microsoft SQL Integration Services

Perform database performance tuning and query optimisation

Perform ad hoc data mining activities and other campaign analytics   

Communicate with internal users or external clients in order to gather reporting requirements

Work closely with the CRM application development and system integration teams

Maintain and create web-based reporting using Excel dashboards and Microsoft reporting services

Use Visual Source Safe allowing versioning of source code

Perform new CRM installations and/or new software releases using Windows Active Directory and SQL database clustering  

 

REQUIREMENTS:

General Database Administration (DBA) with skills in Transact SQL development

Excellent knowledge of Microsoft Windows, Active Directory and related systems

Excellent knowledge of Microsoft SQL Server 2008:

Transact SQL

Stored Procedures and functions

Triggers

Database Performance tuning

Query optimisation

Knowledge and experience with Very Large Databases (VLDB’s), or large data warehouses

Knowledge of object-oriented software design concepts and the full system development life cycle (SDLC) would be a plus

Experience with Microsoft SQL Server 2008 Applications:

Configuration Tools

Performance Tools

Integration Services (SSIS)

Analysis Services (SSASA)

Reporting Services (SSRS)

Experience using Microsoft SQL Server Management Studio

Experience using Microsoft Visual Studio.Net

Experience using Microsoft Visual Source Safe

Additional requirements:

Self motivated with good people and communication skills

High attention to detail

Innovative and results driven

Strong team orientation

EXPERIENCE

Minimum 8 years database development experience in Microsoft SQL Server 200/2005/2008

Industry experience includes Campaign Management and Credit and Risk reporting in the financial services industry

Systems integration experience with Oracle Flexcube (FCC), IBM MQ Series and Tieto (Card Management System) web services

QUALIFICATIONS

Suitable tertiary or computer science degree (Minimum 3 years) or the relevant certification in IT related field