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.
