PP0413 - SQL Database Specialist - Alexander Forbes Limited - Sandton

Designation: PP0413 - SQL Database Specialist Category: Technology - OF6302 Posted by: Alexander Forbes Posted on: 13 Mar 2024 Closing date: 27 Mar 2024 Location: Sandton 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: 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 All failed logins are attended to in the call logging process 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 " data-auto-id"3590" data-css"report_field_detail" data-label-for"" data-label-required"False"> 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: 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 All failed logins are attended to in the call logging process 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 Apply Now

Share this job with someone you think should apply!

Facebook

PP0413 - SQL Database Specialist - Sandton

Related Jobs

Sql Database Administrator Johannesburg - Johannesburg

SQL Database Administrator - Johannesburg

SQL Developer - Johannesburg

Sql Developer Johannesburg North - North Johannesburg

Database Administrator - Midrand

Want to do another search?