Database Engineer

We are seeking a skilled and proactive Database Engineer with 2-3 years of hands-on experience in MySQL and PostgreSQL databases. The successful candidate will play a key role in the development, optimization, and maintenance of our database systems, ensuring reliability, performance, and scalability. If you are passionate about databases and eager to work with cutting-edge technologies, we want to hear from you!

Responsibilities:

• Database Management: Design, implement, and maintain MySQL and PostgreSQL databases, ensuring high availability, reliability, and data integrity.
• Performance Optimization: Monitor database performance, analyze query execution plans, and tune queries to improve performance. Implement indexing strategies and other optimization techniques.
• Backup & Recovery: Design and implement backup and recovery strategies to ensure data availability and business continuity.
• Database Design: Assist in creating efficient database schemas, including normalization, to support application and reporting needs.
• SQL Development: Write efficient, optimized SQL queries, stored procedures, and functions for both MySQL and PostgreSQL databases.
• Database Migration: Assist with data migration tasks, including version upgrades and migrations between MySQL and PostgreSQL.
• Automation & Scripting: Write scripts to automate routine database tasks, such as backups, monitoring, and maintenance.
• Monitoring & Troubleshooting: Regularly monitor database health, resolve performance issues, and troubleshoot complex database problems as they arise.
• Collaboration: Work closely with development teams to ensure optimal database performance for applications and provide database-related support for development projects.
• Security: Implement and enforce database security practices, including user management and access control, to ensure the protection of sensitive data.
• Documentation: Maintain clear and concise documentation on database architectures, procedures, and troubleshooting steps.
• Compliance: Ensure compliance with data protection regulations (e.g., GDPR) and best practices in database management.

Skills & Qualifications:

• 2-3 years of experience as a Database Engineer or Database Administrator working with MySQL and PostgreSQL.
• Proficiency in SQL, with strong experience in writing complex queries, stored procedures, and functions.
• Hands-on experience in performance tuning, including query optimization, indexing, and improving database performance.
• Experience in database backup, recovery, and disaster recovery strategies.
• Familiarity with database design principles such as normalization, schema design, and data modeling.
• Experience with data migration between different database platforms, particularly MySQL and PostgreSQL.
• Knowledge of database security best practices, including user access control and encryption.
• Familiarity with Linux/Unix-based environments (for PostgreSQL) is a plus.
• Experience with cloud database platforms (e.g., AWS RDS, Azure Database for PostgreSQL/MySQL) is a plus.
• Strong troubleshooting and problem-solving skills, especially in a database-centric environment.
• Familiarity with monitoring tools like Prometheus, Grafana, or similar tools for database health monitoring.
• Knowledge of ETL processes and data integration is a plus.

Preferred Qualifications:

• Bachelors degree in Computer Science, Information Technology, or a related field.
• Certification in MySQL or PostgreSQL is a plus.
• Familiarity with containerization and orchestration tools like Docker and Kubernetes is a plus.
• Exposure to NoSQL databases (e.g., MongoDB, Cassandra) is a plus.