Description:
We are seeking a highly skilled Database Engineer to manage, optimise, and maintain databases, ensuring high availability, security, and performance. The ideal candidate will be responsible for database optimisation, performance tuning, and troubleshooting complex database-related issues. This role requires deep expertise in database administration and optimisation strategies.
Key Responsibilities:
Database Engineering Responsibilities:
- Maintain, optimise, and monitor SQL databases (e.g., PostgreSQL, MySQL, SQL Server, Oracle).
- Implement performance tuning, indexing strategies, and query optimisation.
- Ensure database security, backup, and disaster recovery planning.
- Manage high availability (HA) and replication for critical systems.
- Troubleshoot and resolve complex database-related issues.
- Collaborate with DevOps and Engineering teams for cloud-based database solutions (AWS, Azure, GCP).
Strategic & Cross-Functional Collaboration:
- Work closely with Data Scientists, Developers, and Business Analysts to ensure smooth data access and utilisation.
- Implement best practices in data governance, security, and compliance.
- Provide expertise in troubleshooting critical issues as the last line of defense.
Required Skills & Qualifications:
- 5+ years of experience in a Database Engineering role (or similar).
- Strong expertise in SQL (writing complex queries, optimisation, indexing).
- Proficiency in database technologies (PostgreSQL, MySQL, Oracle, SQL Server).
- Experience with high availability (HA), replication, backup & disaster recovery strategies.
- Strong problem-solving skills and ability to optimise database performance.
- Familiarity with cloud database services (AWS RDS/Redshift, Azure SQL, Google BigQuery).
Bonus Points:
- Experience with Kafka, Snowflake, or NoSQL databases.
- Knowledge of CI/CD pipelines and DevOps for database deployments.
- Hands-on experience with containerisation (Docker, Kubernetes).
- Data modeling and experience with OLTP vs OLAP optimisation.
Requirements:
- Maintain, optimise, and monitor SQL databases (e.g., PostgreSQL, MySQL, SQL Server, Oracle).
- Implement performance tuning, indexing strategies, and query optimisation.
- Ensure database security, backup, and disaster recovery planning.
- Manage high availability (HA) and replication for critical systems.
- Troubleshoot and resolve complex database-related issues.
- Collaborate with DevOps and Engineering teams for cloud-based database solutions (AWS, Azure, GCP).
- Work closely with Data Scientists, Developers, and Business Analysts to ensure smooth data access and utilisation.
- Implement best practices in data governance, security, and compliance.
- Provide expertise in troubleshooting critical issues as the last line of defense.
- 5+ years of experience in a Database Engineering role (or similar).
- Strong expertise in SQL (writing complex queries, optimisation, indexing).
- Proficiency in database technologies (PostgreSQL, MySQL, Oracle, SQL Server).
- Experience with high availability (HA), replication, backup & disaster recovery strategies.
- Strong problem-solving skills and ability to optimise database performance.
- Familiarity with cloud database services (AWS RDS/Redshift, Azure SQL, Google BigQuery).
- Experience with Kafka, Snowflake, or NoSQL databases.
- Knowledge of CI/CD pipelines and DevOps for database deployments.
- Hands-on experience with containerisation (Docker, Kubernetes).
- Data modeling and experience with OLTP vs OLAP optimisation.
25 Feb 2025;
from:
careers24.com