Jobs Career Advice Signup
X

Send this job to a friend

X

Did you notice an error or suspect this job is scam? Tell us.

  • Posted: Jan 14, 2020
    Deadline: Not specified
    • @gmail.com
    • @yahoo.com
    • @outlook.com
  • Alexander Forbes is a leading provider of financial, risk and insurance and multi-manager investment solutions internationally. The primary operations are based in South Africa and the United Kingdom. A significant network of subsidiaries and partners ensures we provide an outstanding level of service to our customers internationally. Alexander Forbes’...
    Read more about this company

    MS SQL Development DBA

    Introduction
    The Microsoft (MS) SQL Development Database Administrator (Dev DBA) is responsible for providing technical support for application development teams, focusing on tasks related to building an effective, usable MS SQL database environment to support the design and maintenance of applications.

    Minimum Requirements
    Education and Experience

    • Grade 12
    • B-Degree/Diploma in Information Technology or equivalent
    • Minimum of 10 years’ experience within the financial services industry
    • 2 or more years in a similar role
    • IT Operational experience would be advantageous

    Knowledge And Skills

    • SQL Server 2012-2016 Installations and Management
    • SSRS Reports Design and Management
    • SSIS Design and Management
    • Working with SSIS Catalog
    • T-SQL Scripting
    • Logical and physical database design.
    • SQL Server AlwaysOn
    • Windows Server Clustering
    • Working Knowledge of Visual Studio and Azure DevOps

    Job Specification...
    Key performance areas
    SQL Server Administration
    Implementation
    The Dev DBA is responsible for:

    • Installations of SQL servers in the Development and QA environments according to the set standards
    • Ensuring SQL servers have the latest security patches installed.
    • Configure SQL servers for optimal availability and performance.

    Standards and documentation
    The Dev DBA is required to contribute to:

    • Contributing to the setting of AF SQL standards in the environment
    • Updating the relevant documentation
    • Ensuring these standards are adhered to when deploying all servers
    • Adding and updating the SQL knowledge base with work arounds and solutions regarding SQL Servers

    Performance
    The Dev DBA is responsible for:

    • Ensuring the SQL servers are configured for optimal performance
    • Working with server support teams to ensure the servers are configured for optimal performance and have minimal downtime.
    • Working with server support teams to ensure the servers are maintained for optimal performance. This would include disk capacity, memory and CPU
    • Monitor and ensure SQL maintenance is performed regularly to optimize performance

    Security
    The Dev DBA is responsible for:

    • Applying and adhering the AF SQL security standards defined by the AF Security and Compliance team and the SQL Architect
    • SQL Server security must be regularly reviewed to ensure standards are maintained
    • SQL DBA is granted full privileges to the environment and must treat this privilege responsibly and with discretion.

    SQL REPORTs ADMINSTRATION
    The following section details the responsibilities of the DBA with regards to the SQL Reporting Services in the Alexander Forbes Environment
    Implementation
    The Dev DBA is responsible for:

    • Implementation of SQL Reports to the environment standards
    • Maintaining the folder structure within the report server to ensure the data is secure.
    • Setup report schedules and ensure there are limited reports running at the same time.
    • Apply shared schedules to multiple report schedules that occur at the same time.

    Support
    The DBA is required to:

    • Apply deployment of SQL reports according to standards
    • Troubleshoot reports errors in the production and staging environments
    • Have a working knowledge of the components of a SQL Report
    • Have knowledge of creating and designing reports to assist with troubleshooting or issues

    SQL integration Services
    The following section details the responsibilities of the DBA with regards to the SQL Integration Services (SSIS) in the Alexander Forbes Environment
    design and Implementation
    The Dev DBA is responsible for:

    Design and implementation of SQL SSIS packages to the environment standards

    Support
    The Dev DBA is required to:

    • Deployment of SQL SSIS packages according to standards
    • Troubleshoot SSIS errors in the development and QA environments
    • Have a working knowledge of the components of a SQL SSIS package
    • Have knowledge of creating and designing SSIS packages to assist with troubleshooting or issues

    SQL Analysis Services
    The following section details the responsibilities of the DBA with regards to the SQL Analysis Services (SSAS) in the Alexander Forbes Environment
    Implementation
    The Dev DBA is responsible for:

    • Implementation of SQL SSAS databases to the environment standards
    • Maintaining the security within the SSAS server to ensure the data is secure.
    • Setup scheduled jobs to run the backups of the databases to ensure recoverability

    Support
    The Dev DBA is required to:

    • Deployment of SQL SSAS databases according to standards
    • Troubleshoot SSAS errors in the development and QA environments
    • Have a basic working knowledge of the components of a SQL SSAS databases.

    Full backups
    It is the responsibility of the Dev DBA to:

    • Ensure all databases in the environment have a daily full backup run successfully
    • If the database utilizes a differential backup strategy the full backup should occur at least once a week.
    • The DBA must troubleshoot any issues that may occur with backups.
    • The backups require ad-hoc restore tests to ensure the backups are valid
    • Please note: If you do not receive feedback within 2weeks please consider application unsuccessful

    Method of Application

    Interested and qualified? Go to Alexander Forbes on www.linkedin.com to applyInterested and qualified candidates should apply using the Apply Now button below.
  • MYJOBMAG.CO.ZA
  • Send your application

Never miss a job with our real-time & personalized job service
Subscribe Now
Back To Home

Career Advice

View All Career Advice

Subscribe to Job Alert

 

Join over 182 happy subscribers

 
 
 
Send your application through

Yahoomail Gmail Hotmail