Job Summary
Responsible for designing, maintaining, and optimizing reliable database systems to support business operations. The role focuses on database performance, availability, security, and automation while ensuring data is properly managed and protected.
Job Responsibilities
- Provide technical support on multiple Database platforms, maintain the operations and management for Oracle (Primary), MS SQL (Primary) and PostgreSQL (Secondary) databases.
- Work with a diverse team of skilled Data Analytics & Application Developer professionals.
- Provide work guidance and mentoring to subordinates and junior resources.
- Technical assessment, migration or upgrade of Oracle, Microsoft SQL Server and PostgreSQL databases.
- Ensure day-to-day operations of Database maintenance, patching, hardening and service requests.
- Perform recovery of Database-related issues.
- Participate in and oversee Database maintenance, security, health check and server troubleshooting activities.
- Prepare Incident Root Cause Analysis reports for any critical incidents relating to Database platforms.
- Ensure proper planning and execution of Disaster Recovery support and Database maintenance activities.
- Prepare and submit required weekly and monthly reports regarding database capacity, issues and risks.
- Attend to regulatory and internal audit requirements (audit artefacts preparation) and work towards remediating audit findings relating to Database platforms.
- Recommend and propose process improvements to improve team productivity and efficiency.
- Implement and manage the operational aspects of cloud-native and hybrid data platform solutions built on Microsoft SQL Server or PostgreSQL.
- 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.
- Develop code to interact with databases and other data sources to retrieve and manipulate data needed for API functionality.
- Write clean, maintainable, and efficient code. Conduct thorough testing of APIs to identify and fix bugs, performance bottlenecks, and other issues.
- Create clear and comprehensive technical documentation for APIs, including usage instructions, endpoints, request/response formats, and authentication methods.
- Manage API versioning and handle backward compatibility while making updates or improvements.
- Monitor API usage, performance metrics, and error logs. Respond promptly to incidents and troubleshoot issues as they arise.
- Stay up-to-date with the latest technologies, trends, and best practices in API development and related fields.
- Perform other related duties as assigned.