Database Administrator
Role details
Job location
Tech stack
Job description
We are seeking a highly skilled and detail-oriented Database Administrator to manage and optimise our organisation's database systems. The successful candidate will be responsible for ensuring the high availability, security, and performance of our databases, supporting various applications and data-driven processes. This role offers an excellent opportunity to work with a diverse range of database technologies within a dynamic environment., * Design, implement, and maintain robust database architectures ensuring optimal performance and scalability.
- Monitor database health and perform regular performance tuning to enhance efficiency.
- Manage database security, including user access controls and data protection measures.
- Develop and implement backup, recovery, and disaster recovery plans to safeguard organisational data.
- Perform database migrations, upgrades, and patching with minimal downtime.
- Write and optimise complex SQL queries, stored procedures, triggers, and functions using PL/SQL and T-SQL.
- Automate routine tasks using Bash (Unix shell) scripting and Shell scripting techniques on Linux environments.
- Collaborate with development teams to support application integration using SSIS, Oracle, MySQL, Microsoft SQL Server, and other database platforms.
- Ensure high availability through replication, clustering, or other clustering solutions.
- Document database configurations, procedures, and policies for compliance and audit purposes.
Requirements
Do you have experience in UNIX?, * Proven experience in Database Administration across multiple platforms including Oracle, Microsoft SQL Server, MySQL, and Linux-based systems.
- Strong knowledge of database design principles and best practices for performance optimisation.
- Hands-on experience with high availability solutions such as clustering or replication setups.
- Proficiency in writing complex SQL queries along with PL/SQL or T-SQL scripting.
- Experience with performance tuning techniques to optimise query execution times and overall system responsiveness.
- Familiarity with SSIS for data integration tasks is desirable.
- Ability to perform shell scripting using Bash on Unix/Linux systems for automation purposes.
- Prior involvement in managing large-scale databases in a production environment is preferred. This role is ideal for a dedicated professional eager to contribute to organisational success through expert database management while continuously developing their skills within a supportive team environment.