JOB SUMMARY
- Build and maintain scalable and reliable database architectures that meet business needs.
- Ensure databases achieve high performance and availability through regular optimization and monitoring.
- Implement robust data security measures to safeguard sensitive information and ensure compliance with regulations.
- Enhance operational efficiency by automating repetitive database tasks and processes.
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 and oversee Database maintenance, security, health check and server troubleshooting activities
- Prepare Incident Root Cause Analysis report for the any critical incidents relating to Database platform
- 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 platform.
- Recommend and propose process improvement 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
- Stay up-to-date with the latest technologies, trends, and best practices in API development and related fields.
- Performs other related duties as assigned.
EDUCATION & EXPERIENCE
- 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.
SKILLS & ABILITIES
- Ability to work independently as well as part of a team, with strong communication and collaboration skills.
- Takes initiative to improve current state of things and adaptable to embrace new changes.
- Prior work experience in retail industry is an added advantage.
- Excellent verbal and written communications skills in English.
- Experience with cloud database solutions such as AWS RDS/Redshift, or Azure SQL Database.
- Knowledge of NoSQL databases like MongoDB, Cassandra, or DynamoDB.
- Familiarity with scripting languages (e.g., Python, Shell scripting) for automation.
- Experience with database monitoring tools and performance tuning.
- Certification in database technologies (e.., Oracle Certified Professional, Microsoft Certified: Azure Database Administrator).