SQL Database Administrator

Recruiter:

TransEra Solutions

Job Ref:

JHB000047/TD

Date posted:

Wednesday, September 4, 2024

Location:

Johannesburg, South Africa

SUMMARY:
SQL DATABASE ADMINISTRATOR | JOHANNESBURG
R700,000 CTC PER ANNUM

Our client – is a leading full-service commercial Bank, is looking for SQL Database Administrator to join their team. The company operates across ten African countries, the UAE and UK, with representative offices in China, India and Lebanon. They’re evolving to redefine the power of relationship.

JOB MISSION:

The Database Administrator will be responsible for the design, implementation, support, and maintenance of all MSSQL databases supporting applications in the bank. The incumbent will assist stakeholders and technical teams with projects, ad-hoc task, and investigations of database related matters on MSSQL and other RDBMS platforms as well as unstructured database platforms. The individual must adhere to related procedures to include organizational standards and policies.

REPORTS TO:
Manager: IT Systems

YOUR ‘DAY TO DAY’

Database Infrastructure:

Install, configure, and manage SQL Server instances across multiple environments
Upgrading and migrating database instances
Configuring and managing database clusters and high availability solutions (AOAG)
Perform database capacity planning and forecasting

Database Security:

Manage database security and permissions (Users, roles etc)
Install patches

Database Performance and Maintenance:

Monitor and optimize SQL Server performance
Perform regular database maintenance (tuning, index rebuilding, updating statistics etc)
Configure proactive monitoring and alerting

Database Backup and Recovery:

Configure, manage, and test backup and recovery strategies
Ensuring that all technical documentation is regularly updated, and new procedures are properly documented

Support Regular, Ad-hoc and Project work:

Database refreshes, data fixes and schema updates
Involved in designing technical specifications for new system implementations and system changes

Business Planning and Decision Making:

Provides input for short-term and long-term operational planning in respect of existing and emerging technology

Policies and Procedures:

DB Policies and procedures
Patch/security update as per agreed business OLA
Daily/Weekly and Monthly Reporting
Logging and resolving Helpdesk calls as per agreed business OLA
Database monitoring and fine tuning
Licensing management

Contacts and Business Relationships:
Internal:

All departments

External:

BankServ
Alliance Partners

IMPACT ON BUSINESS RESULTS:
The role has a direct impact on business results as it be involvement designing, prioritizing business solutions, coordinating development efforts and managing solutions life-cycle across the organization

FIGURES AFFECTED BY THE ROLE (KPI’S):
Quantitative

User stories
Business Requirements
Roadmaps

Qualitative

Architecture artefacts
Solution Designs architecture

MINIMUM ROLE REQUIREMENTS:

Degree or technical diploma in Computer Science or related field
Proven, demonstrable knowledge in managing MS SQL Databases Knowledge in Oracle, MySQL and other RDBMS is desirable
Strong knowledge of SQL and an understanding of T-SQL
Working knowledge of Windows Server platforms
Problem solving and troubleshooting skills
Minimum of 3 years’ MS SQL experience

SKILLS/ SPECIALIZED KNOW HOW:

Install, Setup, Configure and Support of the following solutions:

Microsoft SQL Standard and Enterprise
Working knowledge of SQL replication and high availability solutions
Keep up to date with developments in databases and data industry
Planning and organising
Accountable and responsible
Ability to self-train and develop
Ability to work independently and as a team

POSITION INFO:
SQL DATABASE ADMINISTRATOR | JOHANNESBURG
R700,000 CTC PER ANNUM

Our client – is a leading full-service commercial Bank, is looking for SQL Database Administrator to join their team. The company operates across ten African countries, the UAE and UK, with representative offices in China, India and Lebanon. They’re evolving to redefine the power of relationship.

JOB MISSION:

The Database Administrator will be responsible for the design, implementation, support, and maintenance of all MSSQL databases supporting applications in the bank. The incumbent will assist stakeholders and technical teams with projects, ad-hoc task, and investigations of database related matters on MSSQL and other RDBMS platforms as well as unstructured database platforms. The individual must adhere to related procedures to include organizational standards and policies.

REPORTS TO:
Manager: IT Systems

YOUR ‘DAY TO DAY’

Database Infrastructure:

Install, configure, and manage SQL Server instances across multiple environments
Upgrading and migrating database instances
Configuring and managing database clusters and high availability solutions (AOAG)
Perform database capacity planning and forecasting

Database Security:

Manage database security and permissions (Users, roles etc)
Install patches

Database Performance and Maintenance:

Monitor and optimize SQL Server performance
Perform regular database maintenance (tuning, index rebuilding, updating statistics etc)
Configure proactive monitoring and alerting

Database Backup and Recovery:

Configure, manage, and test backup and recovery strategies
Ensuring that all technical documentation is regularly updated, and new procedures are properly documented

Support Regular, Ad-hoc and Project work:

Database refreshes, data fixes and schema updates
Involved in designing technical specifications for new system implementations and system changes

Business Planning and Decision Making:

Provides input for short-term and long-term operational planning in respect of existing and emerging technology

Policies and Procedures:

DB Policies and procedures
Patch/security update as per agreed business OLA
Daily/Weekly and Monthly Reporting
Logging and resolving Helpdesk calls as per agreed business OLA
Database monitoring and fine tuning
Licensing management

Contacts and Business Relationships:
Internal:

All departments

External:

BankServ
Alliance Partners

User stories
Business Requirements
Roadmaps

Qualitative

Architecture artefacts
Solution Designs architecture

MINIMUM ROLE REQUIREMENTS:

Degree or technical diploma in Computer Science or related field
Proven, demonstrable knowledge in managing MS SQL Databases Knowledge in Oracle, MySQL and other RDBMS is desirable
Strong knowledge of SQL and an understanding of T-SQL
Working knowledge of Windows Server platforms
Problem solving and troubleshooting skills
Minimum of 3 years’ MS SQL experience

SKILLS/ SPECIALIZED KNOW HOW:

Install, Setup, Configure and Support of the following solutions:

Microsoft SQL Standard and Enterprise
Working knowledge of SQL replication and high availability solutions
Keep up to date with developments in databases and data industry
Planning and organising
Accountable and responsible
Ability to self-train and develop
Ability to work independently and as a team

NB! This job is now closed. You can apply for other jobs by uploading your CV.

Similar jobs you might be interested in:

SQL Database Administrator Specialist
Location: Johannesburg
Salary: 70000.00 Monthly
Are you an experienced sql database administrator Specialist eager to advance your career with a premier database management firm? Our client, a top-tier company, in Johannesburg North, is seeking a dedicated professional to join their team and oversee the management and optimization of their sql database systems.
7 days ago

Senior SQL Database Administrator
Location: Johannesburg
Salary: R300 Hourly
Senior sql database administratorJohannesburg, HoughtonContractHybrid
75 days ago

SQL Database Administrator
Location: Johannesburg
Salary:
Are you a sql DBA who is looking to join a company that thrives on brilliance? Then look no further ...
17 days ago

SQL Developer / Database Developer (scripting, integration)
Location: Johannesburg
Salary: R 20 000
sql Developer / database Developer (scripting, integration)JHB, In OfficeWe are looking for a highly skilled sql Developer and Integration Specialist to join our dynamic team. This role combines expertise in sql development, database management, system integration, and automation. The ideal candidate will have strong sql development experience, Python scripting skills, and the ability to integrate...
Today

Microsoft SQL Database and Windows Specialist - Contract - Onsite
Location: Johannesburg
Salary: R500 - 565 per hour
Microsoft sql database and Windows Specialist - Contract - Onsite
48 days ago

Database Administrator
Location: Johannesburg
Salary: 50000.00 Monthly
Are you an experienced database administrator with a passion for ensuring optimal database performance and security? Our client, a premier payment solutions company, based in Bryanston, is looking for a motivated database administrator to join their innovative team.
7 days ago

Database Administrator
Location: Johannesburg
Salary: R600 000 per annum
Oversee the design, implementation, and maintenance of database systems, ensuring data integrity, availability, and performance
13 days ago

Field Service Engineer - Software Services
Location: Johannesburg
Salary: Monthly
We are seeking a highly skilled Field Service Engineer specialising in software to join our client’s team assisting and supporting our client’s automotive division. The successful candidate will be responsible for integrating new software solutions into existing technical customer environments, providing technical support, and ensuring seamless software operation. This role requires ex...
17 days ago

Field Service Engineer
Location: Johannesburg
Salary:
We are looking for a Field Service Engineer. We have a permanent role in Jet Park.
17 days ago

DevOps Engineer X2
Location: Gauteng
Salary: Market related
DevOps Engineer (2 positions available) 6 months contract opportunity 5 to 7 years of related
25 days ago