Sun is looking for a Senior Microsoft SQL Server DBA for one of our customers based in South Africa

Job type: Contract

Location: Hybrid

Education and Experience 

? Grade 12 

? B-Degree/Diploma in Information Technology or equivalent 

? Minimum of 10 years’ experience within the financial services industry 

? 5 or more years in a similar role 

? IT Operational experience would be advantageous Knowledge and skills 

? SQL Server 2014-2019 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 Always On 

? Windows Server Clustering 

? Working Knowledge of Visual Studio and Azure DevOps Leadership Competencies 

? Practical Execution Management (Planning, Organising and Monitoring; Includes Project Management) 

? Group IT Approved Policies and Procedures 

? Online resources ? Peer networking 

? Training in line with approved budgets 

? Lead and drive the socialization of change impact across Group Technology. 

? Leadership - Internal processes and systems 

? Collaboration - Relating and networking with various stakeholders Functional Competencies 

? Presentation Skills 

? Time Management 

? Attention to Detail (Including Focus) 

? Anticipating, Creating and Managing Change (Tolerance of Ambiguity) 

? Holistic / Big Picture thinking 

? Innovation / Creativity 

? Problem Solving

? Assertiveness (Includes willingness to challenge and confront) 

? Ethical Behaviour/ Honesty/ Integrity/Transparency (Includes Modelling the Values) 

? Responsible and Accountable 

? Strong work ethic 

? Problem solver 

? Excellence Orientation 

? Flexibility / Adaptability 

? Objectivity 

? Personal Growth Orientation/ Motivation to Learn / Learning Agility 

? Resilience / Perseverance / Stress Management 

? Results & Solution Focused (Drive, Energy & Follow Through) 

? Rule Orientation 

? Self-Management (Planning, Prioritising & Time Management) 

? Ability to work and deliver under pressure 

? Visibility & Impact (Includes Confidence and Professionalism Presentation) 

? Strong written and verbal communication skills - a skilled communicator 

? Strong collaboration skills and a team player, with the ability to work independently

? Customer Service Orientation 

? Self-starter with the ability to work to unsupervised 

? professional, diplomatic and cordial 

? Influence, Persuasion and Negotiation (Includes Conflict Management) 

? Knowledge Sharing (includes Information Management) 

? Comfort with Diversity ? Organisational Awareness 

? Relationship Building (Includes Listening, Interpersonal Sensitivity, and ability to read and interact with people) 

? Building good working partnerships

SQL Server Administration Database Services Implementation The DBA is responsible for: 

? Ensuring all deployments of databases are implemented according to Customer SQL standards and processes. 

? Have a basic understanding of database components to facilitate troubleshooting of issues. 

? The DBA is responsible for all database deployments. 

? The DBA is responsible for ensuring the environment has sufficient capacity when deploying a database Performance 

The DBA is responsible for: 

? 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 security access is applied according to Customer Standards and processes Support 

The DBA is required to have: 

? Have a good understanding of database structure components to facilitate troubleshooting of issues 

? Have a understanding of how to optimize a database through indexing, table and file structure SQL REPORTS ADMINSTRATION Implementation 

The 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. 

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 Implementation 

The DBA is responsible for: 

? Implementation of SQL SSIS packages to the environment standards 

? Maintaining the folder structure within the SSIS server to ensure the data is secure. 

? Setup scheduled jobs to run the packages and ensure there is minimal conflict on the shared server Support 

The DBA is required to: 

? Deployment of SQL SSIS packages according to standards 

? Troubleshoot SSIS errors in the production and staging 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) 

The 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 DBA is required to: 

? Deployment of SSAS cubes according to standards ? Troubleshoot SSAS processing.

? Have a working knowledge of the components of SSAS Cubes. Backup and Recovery Understand MS SQL backup and recovery strategies.

Please share your profile at naidu@sunrisetechnosystems.co.za with below details

Current CTC or Rate per hour:

Expected CTC or Rate per hour:

Notice Period:

Regards

-Sun Team

Job Location:

Gauteng, South Africa

Address:

Company Industry:

ICT/Telecommunications

Company Type:

Direct Employer

Employment Status:

Contract Jobs

Experience Required:

3 - 5 years

Minimum Qualification Required:

Diploma

Monthly Salary Range:

More than 50000

Job Ref.:

JB16901

Job Role:

Unspecified

• Sql
• Server
• Micro
• Soft