MS SQL Development DBA at Alexander Forbes

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