Job Title: Database Engineer Expert
Job Description:
We are seeking a Database Engineer Expert to join our dynamic team. The ideal candidate will possess extensive experience in database design, develop, maintain scalable database architecture, and ETL processes. This role requires a proactive individual who can manage and optimize our database systems, design and implement ETL processes, and ensure data integrity and performance.
Key Responsibilities:
- Database Architecture & Design: Design, develop, and maintain scalable database architectures, ensuring high performance, reliability, and availability.
- Database Administration: Manage, monitor, and optimize database performance, including regular tuning, backup/recovery strategies, and capacity planning.
- Data Modeling: Work closely with software engineers to design and implement efficient database schemas for new and existing applications.
- Query Optimization: Analyze and optimize complex SQL queries to ensure maximum efficiency and performance.
- Database Security: Implement and maintain security protocols, ensuring databases are secure against unauthorized access and vulnerabilities.
- Automation: Develop and implement automation scripts and tools for database management, deployments, and monitoring.
- Database Migration: Lead and execute database migrations, upgrades, and consolidations, ensuring minimal downtime and data integrity.
- Collaboration: Work with cross-functional teams, including software developers, DevOps engineers, and business analysts, to support their database needs and ensure alignment with business objectives.
- Disaster Recovery: Develop and maintain disaster recovery plans, ensuring regular testing and validation of backup and restore processes.
- Documentation: Create and maintain detailed database design documentation, best practices, and operational procedures.
- ETL Development:
- Design, develop, and optimize ETL processes to extract, transform, and load data from various sources into data warehouses.
- Analysts to understand data requirements and translate them into robust ETL workflows.
- Ensure data integrity, quality, and consistency across different data sources and destinations.
- Implement best practices for ETL process design, development, and deployment.
Key Qualifications:
- Education: Bachelors degree in Computer Science, Information Technology, or a related field.
- Experience:
- 5+ years of hands-on experience in database development, administration, and architecture.
- Extensive experience with multiple database platforms such as PostgreSQL, MySQL, Oracle, SQL Server, and NoSQL databases.
- Expertise in database clustering, replication, sharding, and partitioning.
- Proven experience in optimizing complex queries and resolving performance bottlenecks.
- Skills:
- Strong proficiency in SQL, PL/SQL, and scripting languages (e.g., Python, Bash).
- Expertise in database design principles, normalization, and indexing.
- Hands-on experience with cloud databases (AWS RDS, Azure SQL, Google Cloud SQL) is a plus.
- Proficiency in database monitoring tools (e.g., Nagios, Zabbix, Prometheus, Grafana) and backup solutions.
- Strong understanding of database security practices, data encryption, and GDPR compliance.
- Excellent troubleshooting and problem-solving skills with a focus on root-cause analysis.
Preferred Skills:
- Knowledge of ETL tools (e.g., Apache Airflow) or willingness to learn.
If you're interested, please DM or send your CV/Resume to my email: [Confidential Information]
