Senior Database Administrator (Oracle/SQL Server)GHSAJohannesburg, Gauteng, South AfricaIT Core ServicesOverview:
As part of an overall refresh of its underlying business processes and IT, Glencore is currently executing a number of projects that involve significant business and technological change.
These projects include a mixture of database technologies including Oracle, SQL Server, Sybase ASE, Sybase IQ, Azure SQL, and more.
We are seeking a highly skilled and experienced Database Administrator (DBA) specializing in Oracle and MS SQL Server to join our DBA team.
The ideal candidate will be responsible for the design, implementation, maintenance, and performance tuning of our databases, ensuring the availability, integrity, and security of our data.
This role requires strong analytical skills, excellent problem-solving abilities, and a deep understanding of database technologies.
KEY RESPONSIBILITIES: Install, configure, and upgrade Oracle and MS SQL Server databases.Identify and resolve database performance issues.Develop, manage, and test backup and recovery plans.Perform database tuning, indexing, and query optimisation where necessary.Ensure data integrity and security through implementation of best practises for database management.Develop and enforce policies and procedures for database management through the use of scripting and automation tools such as Ansible and GitHub.Maintain comprehensive documentation of database configuration, processes, and procedures.Manage and maintain database replication.Work with app teams to create, maintain, and optimise database queries and schemas.Occasional weekend work for major upgrades and patches.QUALIFICATION & SKILL REQUIREMENTS: Minimum Qualifications:
Tertiary Qualification in information science or computer science or a related field.
Work Experience: Essential: Expert level experience as an Oracle DBA, with extensive knowledge of SQL Server.Experience with database performance tuning and optimisation.Strong knowledge of database security practises, tools, and procedures.Proven experience in database installation, configuration, upgrading and patch management.Strong knowledge of SQL, PL/SQL, and other scripting languages such as bash/powershell.Experience with database replication.Strong analytical and problem-solving skills.Ability to work independently and as part of a team.Experience in the design and delivery of enterprise grade highly available solutions.Strong communication and documentation skills with the ability to convey technical issues to all levels.Builds and maintains strong relationships with leaders, customers, and team members.Desirable: Some knowledge of other common database and caching technologies, such as Sybase IQ/ASE, Rep Server, Azure SQL, CosmosDB, MongoDB, PostgreSQL, MySQL/MariaDB, Memcache, or Redis.Exposure to iterative/agile development methodologies and experience of enabling team delivery through technology.An appreciation for SRE and monitoring using tools such as ELK stack and Solarwinds.Skills: Oracle (Primary)SQL ServerSQL, PL/SQLPowerShell/BashQlik ReplicateDelphixAnsibleSolarwindsHow to apply:Start your application by clicking the "begin" button.
#J-18808-Ljbffr