View Profile
Personal Profile
Career Summary
Job Skills
Software Skills
Business Skills

Match
History
Upload/Send CV

CRM Database Support Specialist

Position Details

Job ID:

3567

Last Updated (mm/dd/yyyy):

2013-10-23 01:07:03 PM

Position category:

Position Name:

CRM Database Support Specialist

Similar Experience:

48-54

Total Experience:

48-54

Project Location:

JHB

Job Type:

Permanent

Pay:

Rneg.

Academic Qualification/s:

Relevant

Industrial Qualification/s:

ETL SQL

Position Active:

No

Relocation Assistance:

No

Workpermit Assistance:

No


Job Description:
Untitled 1

Job Purpose

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

Dimensions

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

Principal Accountabilities

  • 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 andoror new software releases using Windows Active Directory and SQL database clustering

KEY PERFORMANCE AREAS

  • Work closely with the CRM application development and system integration teams

  • General Microsoft Dynamics CRM project implementations and production support

  • Design, develop and maintain the credit data marts

  • Data mining and data analytics for various marketing campaigns

  • Software patch management

  • Monitor, troubleshoot and optimise the performance of the Microsoft Dynamics CRM application and database

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

  • Maintain, gather business requirements and development new credit and CRM performance indicator reports

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

  • Perform new CRM installations andoror new software releases using Windows Active Directory and SQL database clustering

  • Upgrading of Microsoft Dynamics CRM application

Context

a Operating Environment

The incumbent works independently but is required to work within policies and procedures and guidance provided for by the Applications Manager.

b Framework & Boundaries

IT Policies and procedures

Project Governance methodologies

Change Management Processes

c Organisation

Relationships

c Other Contacts
IT department in all countries

External Vendors of CRM

Business Unit Heads

Knowledge and Experience

QUALIFICATIONS

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

EXPERIENCE

  • Minimum 8 years database development experience in Microsoft SQL Server 200or2005or2008

  • 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

  • General Database Administration DBA with skills in Transact SQL development

  • 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

KNOWLEDGE

  • 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

Additional requirements

    • Self motivated with good people and communication skills

    • High attention to detail

    • Innovative and results driven

    • Strong team orientation

Job ChallengeS

  • Maintaining a constructive and beneficial working relationship with Heads of Divisions and Line Management.

  • General maturity of IT Governance, ITIL and Compliance Frameworks within

  • Undocumented governance and compliance requirements in African countries

  • Culture change to effect IT governance and compliance within

  • Effective and efficient communication to various risk and compliance committees demands much time and effort.

  • Lack of robust GRC systems throughout the Group




Format: Skill Description (Rating 1-5,Experience in Months)
Rating: 1-Beginner, 2-Below Average, 3-Average, 4-Above Average, 5-Expert

Required Job Skills:

Required Software Skills:

Required Business Skills: