
Database Engineer
Salary undisclosed
Checking job availability...
Original
Simplified
JOB SUMMARY: - 1. Build and maintain scalable and reliable database architectures that meet business needs. 2. Ensure databases achieve high performance and availability through regular optimization and monitoring. 3. Implement robust data security measures to safeguard sensitive information and ensure compliance with regulations. 4. Enhance operational efficiency by automating repetitive database tasks and processes. JOB RESPONSIBILITIES: - 1. Provide technical support on multiple Database platforms, maintain the operations and management for Oracle (Primary), MS SQL (Primary) and PostgreSQL (Secondary) databases. 2. Work with a diverse team of skilled Data Analytics & Application Developer professionals 3. Provide work guidance and mentoring to subordinates and junior resources. 4. Technical assessment, migration or upgrade of Oracle, Microsoft SQL Server and PostgreSQL databases. 5. Ensure day to day operations of Database maintenance, patching, hardening and service requests 6. Perform recovery of Database related issues. 7. Participate and oversee Database maintenance, security, health check and server troubleshooting activities 8. Prepare Incident Root Cause Analysis report for the any critical incidents relating to Database platform 9. Ensure proper planning and execution of Disaster Recovery support and Database maintenance activities 10. Prepare and submit required weekly and monthly reports regarding database capacity, issues and risks 11. Attend to regulatory and internal audit requirements (audit artefacts preparation) and work towards remediating audit findings relating to Database platform. 12. Recommend and propose process improvement to improve team productivity and efficiency 13. Implement and manage the operational aspects of cloud-native and hybrid data platform solutions built on Microsoft SQL Server or PostgreSQL. 14. Design and implement RESTful Web APis, adhering to best practices and industry standards. Ensure the APis are secure, performant, and scalable to handle high traffic volumes. 15. Develop code to interact with databases and other data sources to retrieve and manipulate data needed for API functionality. 16. Write clean, maintainable, and efficient code. Conduct thorough testing of APis to identify and fix bugs, performance bottlenecks, and other issues. 17. Create clear and comprehensive technical documentation for APis, including usage instructions, endpoints, request/response formats, and authentication methods. 18. Manage API versioning and handle backward compatibility while making updates or improvements. 19. Monitor API usage, performance metrics, and error logs. Respond promptly to incidents and troubleshoot issues as they 20. Stay up-to-date with the latest technologies, trends, and best practices in API development and related fields. 21. Performs other related duties as assigned. JOB REQUIREMENT: - • Bachelor's degree in IT / Computer Science with at least 3 years of Oracle, Microsoft and/or PostgreSQL database administration experience. • Proven hands-on experience at least 1 years in developing ASP.NET Web APIs using C# and NET framework. • Experience with middleware, data model, ETL, API development, and system integrations. • Strong familiarity and experience with solution design and delivery using cloud platforms like AWS, Azure. • Experience to handle scalable projects with complex integration requirements, with the ability to architect or explain complex systems interactions including data flows, common interfaces, APis and other methods. • Ability to work independently as well as part of a team, with strong communication and collaboration skills. • Excellent verbal and written communications skills in English. • Takes initiative to improve current state of things and adaptable to embrace new changes. • Prior work experience in retail industry is an added advantage.