Database Engineer

Responsibilities:

• Design, develop, and maintain database systems to ensure optimal performance, scalability, and reliability.
• Collaborate with cross-functional teams, including software developers, data scientists, and system administrators, to understand their requirements and provide appropriate database solutions.
• Develop database schemas, tables, and relationships based on business needs and best practices.
• Write and optimize complex SQL queries for data retrieval, manipulation, and analysis.
• Implement indexing strategies and query optimization techniques to improve database performance.
• Ensure data integrity and consistency by designing and implementing appropriate data validation and cleansing processes.
• Monitor and optimize database performance, including monitoring query execution, identifying and resolving performance bottlenecks, and optimizing database configurations.
• Implement and maintain database security measures to protect sensitive data.
• Develop and maintain database documentation, including data models, schema diagrams, and query performance analysis.
• Stay up to date with the latest trends and advancements in database technologies, SQL, and related tools.
• Collaborate with the operations team to plan and execute database backups, disaster recovery, and high availability strategies.
• Troubleshoot database issues, perform root cause analysis and implement corrective actions.
• Participate in database capacity planning and provide recommendations for hardware and infrastructure requirements.

Requirements:

• Bachelor’s degree in Computer Science, Information Systems, or a related field.
• Proven work experience as a Database Engineer or similar role.
• Strong proficiency in SQL and experience with relational database management systems (e.g., Oracle, MySQL, SQL Server, PostgreSQL).
• Knowledge of database design principles, normalization, and data modeling.
• Experience in performance tuning, query optimization, and troubleshooting database issues.
• Familiarity with database security and data protection best practices.
• Strong analytical and problem-solving skills.
• Excellent written and verbal communication skills.
• Ability to work collaboratively in a team environment.
• Knowledge of scripting languages (e.g., Python, Shell scripting) is a plus.
• Familiarity with non-relational databases (e.g., MongoDB, Cassandra) and big data technologies (e.g., Hadoop, Spark) is a plus.
• Relevant certifications (e.g., Oracle Certified Professional, Microsoft Certified: Azure Database Administrator Associate) are advantageous.

Tagged as: Database