About the Role
Our client, a growing e-commerce company, is seeking a meticulous and experienced Database Administrator (DBA) to join their IT department in **Paarl, Western Cape**. This hybrid role is essential for maintaining the performance, integrity, and security of our critical databases. You will be responsible for installation, configuration, patching, upgrading, monitoring, and tuning of database systems to ensure optimal performance and availability. The ideal candidate will have a deep understanding of relational database management systems, strong troubleshooting skills, and a commitment to data security. Join a dynamic team that values data integrity and efficiency in **Paarl, Western Cape**.
Key Responsibilities
- Install, configure, and upgrade database software and related products.
- Monitor database performance, identify and resolve performance bottlenecks.
- Implement and manage database security, including user access control and data encryption.
- Develop and implement backup and recovery strategies to ensure data integrity and availability.
- Perform regular database maintenance tasks, including patching and applying updates.
- Design and implement database schemas, tables, and other database objects.
- Write and optimize complex SQL queries and stored procedures.
- Troubleshoot and resolve database-related issues in a timely manner.
- Collaborate with developers and system administrators to ensure database efficiency and reliability.
- Develop and maintain database documentation.
- Participate in capacity planning and performance tuning initiatives.
- Ensure compliance with data governance policies and regulations.
Requirements
- Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent work experience.
- Minimum of 3 years of experience as a Database Administrator.
- Proven experience with major RDBMS such as SQL Server, Oracle, MySQL, or PostgreSQL.
- Strong knowledge of database architecture, design, and implementation.
- Proficiency in SQL, including query optimization and stored procedure development.
- Experience with database backup, recovery, and disaster recovery strategies.
- Understanding of database security best practices.
- Familiarity with performance monitoring and tuning tools.
- Excellent troubleshooting and problem-solving skills.
- Strong communication and collaboration abilities.
- Experience with cloud database services (e.g., AWS RDS, Azure SQL Database) is a plus.
- Experience with NoSQL databases is also a plus.
Benefits
- Our client offers a competitive salary, comprehensive medical and pension benefits, and opportunities for professional growth and training.
- This hybrid role offers a good balance between office-based collaboration and remote flexibility.