Database Engineer

Database Engineer

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.