- Analyze current database systems (relational and non-relational) to identify performance inefficiencies and opportunities for optimization.
- Assist in database re-architecture projects, focusing on schema design, query performance, and indexing improvements.
- Support efforts to migrate databases to cloud platforms (AWS, Azure, Google Cloud) while ensuring data accuracy and minimal downtime.
- Optimize database performance by improving query execution times and indexing strategies.
- Collaborate with cross-functional teams, including software engineering and DevOps, to ensure database alignment with overall system architecture.
- Assist in implementing strategies to ensure scalability, high availability, and disaster recovery.
- Document database architecture changes, including schema updates, indexing plans, and performance tuning techniques.
- Stay updated on emerging database technologies and recommend improvements to the existing database infrastructure.
Qualifications and Skills:
- Bachelor s degree in Computer Science, Information Systems, or a related field.
- 2-4 years of experience in database management, design, or administration.
- Hands-on experience with Oracle DB and familiarity with Qlik for data analytics and visualization.
- Experience with relational databases (e.g., MySQL, PostgreSQL, Oracle) and non-relational databases (e.g., MongoDB).
- Basic experience with cloud platforms (AWS, Azure, Google Cloud) and database migration.
- Understanding of query optimization, indexing, and database performance tuning techniques.
- Familiarity with data security and privacy standards.
- Strong problem-solving and team collaboration skills.
