Database & API Developer

We are seeking an experienced Database & API Developer to design, develop, and optimize data-driven and API-driven solutions supporting mission-critical business applications. The role includes analyzing existing systems—core data sources, billing modules, and API-based procedures—and extending PL/SQL logic built on the billing platform to deliver new functionality.
The developer will extract and analyze data from core systems, interpret high-level business requirements, and translate them into database extensions or API-related tasks, planning and tracking activities in Jira according to the delivery roadmap. The role also involves identifying and documenting database-side requirements for integrations with external and internal platforms (mobile applications, web portals, backend systems), designing and delivering the required APIs, and coordinating implementation with technical teams.

Additionally, the developer is expected to maintain thorough, clear, and up-to-date technical documentation, ensuring transparency, traceability, and efficient long-term maintenance. The ideal candidate demonstrates strong SQL/PL/SQL expertise, solid understanding of API design and lifecycle management, and the ability to work effectively in a fast-paced Agile environment.

Basic Requirements
Ability to analyze existing database structures, stored procedures, and API specifications.
Capability to read, debug, and extend SQL/PLSQL code, as well as update API definitions, policies, and configurations.
Strong discipline in version control for both database and API assets.
Habit of writing clean, self-documented code with meaningful comments and clear naming conventions.
Willingness to prepare and maintain technical documentation for both database components and APIs.
Familiarity with Agile methodologies (Scrum/Kanban) and collaborative team environments.

Key Responsibilities

Database Responsibilities
Design, develop, and maintain Oracle database objects (tables, views, indexes, partitions, materialized views).
Write efficient and optimized SQL/PL/SQL code (procedures, functions, packages, triggers).
Develop and maintain automated processes using Oracle Scheduled Jobs (DBMS_SCHEDULER / DBMS_JOB).
Implement and support Oracle Advanced Queue (AQ) for asynchronous workflows.
Monitor and optimize database performance; tune complex SQL queries and PL/SQL logic.
Ensure database security, integrity, and compliance with internal development standards.
Participate in code reviews and contribute to continuous improvement of database practices.

API Responsibilities
Manage and maintain the API Catalog, including registration, publishing, versioning, and lifecycle updates.
Design, document, and support APIs via HTTP services and WebSockets.
Configure routing and load balancing according to architectural guidelines.
Implement authentication and authorization mechanisms (tokens, keys, RBAC) and ensure data masking where needed.
Apply throttling, rate limiting, and circuit breaker policies to prevent overload and mitigate risks.
Collect, analyze, and interpret API performance metrics (latency, throughput, error rates).
Monitor API behavior and troubleshoot issues related to performance, routing, security, and compatibility.
Maintain backward compatibility and manage API deprecation strategies.
Produce and maintain API documentation (technical specifications, error models, integration guides).

Required Skills & Qualifications
Strong hands-on experience with SQL and PL/SQL development.
Practical experience with Oracle Scheduled Jobs (DBMS_SCHEDULER / DBMS_JOB).
Working knowledge of Oracle Advanced Queue (AQ).
Experience with Oracle 11g/12c/19c or later.
Solid understanding of relational database concepts and performance tuning.
Strong analytical skills to translate business requirements into technical solutions.
Experience with API design, lifecycle management, and performance considerations.

Understanding of key API concepts:
REST architecture and HTTP methods
JSON/XML data formats
Routing, throttling, rate limiting
Authentication and authorization mechanisms
Experience with version control systems (Git, GitLab).
Strong problem-solving skills and attention to detail.

Preferred Qualifications
Experience with API monitoring, logging, and performance analytics.
Familiarity with API gateways and API policy configuration (authentication policies, throttling, quotas).
Experience with CI/CD pipelines or automated deployment processes.
Exposure to integration platforms or message-driven architectures.
Summary

This role is essential for expanding our internal capabilities in database development and API integration, enabling scalable, secure, and high-quality solutions across the organization. The Database & API Developer will contribute directly to key projects, integrations, and system enhancements that support business continuity and innovation.