1. Analyze requirements produce accurate unambiguous technical design specifications to the appropriate detail
2. Collaborate with cross functional squad members (product and tech teams) to help them understand and fully comply with data quality standards architectural guidelines and designs. 3. Recommend and implement emerging database technologies.
4. Set and maintain database standards. Develop processes for establishing and sustaining impeccable database security.
5. Install database servers maintain with constant upgrades (including security patches and hotfixes) and sustain the highest performance.
6. Establish the needs of users and monitor user access and security. Performance tuning of database systems.
7. Map out the conceptual design for a planned database.
8. Own and manage all changes to the data models. Create data models solution designs and data architecture documentation for complex information systems powering the EI product.
9. Install upgrade and manage database applications.
10. Diagnose and troubleshoot database errors.
11. Create and manage database reports visualizations and dashboards. Create automation for repeating database tasks.
12. Write database documentation including data standards procedures and definitions for the data dictionary (metadata). Ability to work independently with minimal supervision and assistance.
13. Plans designs develops integrates database scripts to consuming application components and helps to test software systems or applications for software enhancements and new products. Write debug and deploy scripts to production; deliver timely fixes in close collaboration with Developers and DevOps.
14. Deliver customer value in the form of highquality software components and services in adherence with policies on security performance longevity and integration testing.
15. Be well versed in the latest development methodologies like Agile Scrum DevOps and unit testing for database scripts during development.
16. Adhere to DOD (story definition of done) as part of the sprint including unit tests functional testing code reviews no regressions bug fixes documentation and adhere to best coding practices.
17. Perform peer code reviews in order to ensure quality standards
18. Master the domain knowledge in the area of assignment 19. Take ownership of what the team builds after the release; consider customer adoption as success criteria
20. Volunteer for work in the backlog and commit to quality delivery; Coordinate efforts across the team to ensure completion and effectiveness
21. Participate and contribute to scrum meetings i.e. daily standup sprint planning readouts and retrospectives
22. Work collaboratively across the Technology and Product organizations to ensure alignment towards business goals
23. Should understand fundamentals of iterative product development.
24. Should understand the value of commitments to delivery made by the development team
25. As a member of technical staff youll have the opportunity to grow as a database engineer in a culture of technical excellence high team performance and impeccable work ethics.
Requirements
1. 5 years of experience working with different databases like MySQL Postgres MongoDB Redis Elasticsearch Clickhouse etc.
2. Excellent problemsolving and analytical skills.
3. Familiarity with the main data manipulation languages and the principles of database design. Advanced knowledge of database structure and theory.
4. Ability to write and troubleshoot complex queries in various SQL and NoSQL databases.
5. Basic understanding of disaster recovery and database backup procedures.
6. Experience with building highquality software based upon architectural specifications.
7. Experience in NoSQL databases (e.g. MongoDB Cassandra)
8. Very comfortable using GIT version control tool (we use Bitbucket)
9. Familiarity with reporting tools.
We invite you to Do your Lifes Best work at Ei to make an impact that matters.
Join us to explore the infinite opportunities to Act Solve and Transform the education landscape.