Compuways's Blog

Next Generation IT Recruitment

Johannesburg: CRM Database Support Specialist

Job Purpose

Technical project and production support (application and database) for company’s 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 and/or 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 and/or 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

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 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
  • 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 Challenge(S):

  • Maintaining a constructive and beneficial working relationship with Heads of Divisions and Line Management.
  • General maturity of IT Governance, ITIL and Compliance Frameworks within ABC
  • Undocumented governance and compliance requirements in African countries
  • Culture change to effect IT governance and compliance within ABC
  • Effective and efficient communication to various risk and compliance committees demands much time and effort.
  • Lack of robust GRC systems throughout the Group

To apply for this position, plse click here:

Advertisements

Filed under: Database Administrators, , , , , , ,

Johannesburg: SQL Developer and Data Analyst

Experience And Skill Required

Experience

A Formal Qualification or Certification in Information Technology, with at least 2 to 3 years experience in database development and data modeling. A minimum 2 to 3 years experience in Microsoft SQL Server development including TSQL,SSIS and Reporting Services optional and preferably in the Financial Services Industry. Experience in.Net development or SharePoint a bonus.

Skills Required

  1. Good knowledge of Microsoft TSQL including stored procedures, triggers, indexing and remote data access
  1. Good understanding of Relational Database design principles
  1. Good understanding of mechanisms of ETL, data import and export including SSIS, Linked Servers and XML
  1. Ability to complete required documentation including Technical Requirements, Change Requests, ERD, DFD.
  1. Ability to communicate with both technical and non-technical people verbally and in writing

Key Responsiblies & Daily Duties

Key Responsibilities

  • Maintain existing and develop new ETLs
  • Assist in optimizing performance of databases
  • Assist in ongoing documentation of organizational data dictionary, data flows
  • Assist with data purification and enrichment exercises
  • Assist with development of reports, queries and extracts for use by business

Daily Duties

  • Monitor, support and maintain existing bespoke databases and ETLs
  • Develop new ETLs and data repositories
  • Monitor network, application and security logs

 Apply for this job by clicking here:

 

 

Filed under: IT / LAN Administrators or Technicians, , , , ,

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 606 other followers