SQL Database Specialist at Alexander Forbes

Purpose of the Job:

• To implement, configure, maintain and perform critical SQL Server RDBMS systems to ensure the availability and consistent performance of various corporate applications; and ensure technical support for the database environment that includes the overseeing of the deployment & organization of databases and assessment & implementation of new technologies to ensure that data is secure and data access is controlled

Overview:

Education

• Matric – Essential
• Bachelor’s Degree (3 years - 360 credits) - Relevant Degree/ Certification in Computer Programming(SharePoint/End User) – Essential

Experience required

• First Line Support – Minimum 3 years required
• Microsoft SQL Administration Certification - Minimum 1 year required
• System Administrator – Minimum 1 year required
• Azure Cloud Certification – Minimum 1 year required

Key responsibilities

Internal processes

To develop Software Solutions that includes the following activities:

• Apply knowledge of industry trends and developments to improve service to clients;
• Successfully interpret design documentation and build the software solution according to the specified requirement;
• Develop and test technical solutions using the development tools applicable to the team;
• Apply software engineering best practices gained through formal education, policies and work experience, during development of software solutions; and
• Review developed solutions and provide constructive feedback for improvements
• Evidence (Outcomes): Software Solutions that will promote business performance

Implementation

• Ensuring all deployments of databases are implemented according to AF SQL standards and processes.
• Have a basic understanding of database components to facilitate troubleshooting of issues.
• The DBA is responsible for all production and staging database deployments.
• The DBA is responsible for ensuring the environment has sufficient capacity when deploying a database

  Performance

• Evidence (Outcomes): The database is configured and maintained for optimal performance
• Ensuring all database indexes are optimized and maintained
• Troubleshoot database performance issues

Security. The DBA is responsible to ensure:

All failed logins are attended to in the call logging process

• Evidence (Outcomes): All security access is applied according to AF Standards and processes
• All exceptions to the security requirements are discussed and agreed with the SQL Architect.
• SQL logins passwords are maintained and changed annually.
• The Windows accounts passwords are stored in the SQL password repository
• Maintenance:
• Evidence (Outcomes):
• Ensuring the database maintenance is performed weekly and attend to any issues.
• The maintenance of the database space requirements

Support

• Evidence (Outcomes): Have a good understanding of database structure components to facilitate troubleshooting of issues
• Have a basic understanding of how to optimize a database through indexing, table and file structure

Competencies

Business skills

• Adaptability and Flexibility
• Project Management
• Business relations
• Decision Making and Judgement
• Process Management

Functional skills

• Accountability and Dependability
• Planning and Organizing
• Problem Solving
• Attention to detail
• Effective prioritisation
• Customer Focus

Leadership skills

• Change Management
• Coaching and Mentoring
• Driving Performance
• Interpersonal Skills
• Motivating and Inspiring

People skills

• Collaboration and Partnering
• Effective Communication
• Team Effectiveness
• Developing Others
• Empowering Others

Core competencies

• Change ability
• Customer Agility
• Business transformation thinking
• Creative and Innovative Thinking
• Initiative
• Learning Agility