Database Developer/API Developer

Key Responsibilities

Database Engineering Responsibilities:

• Design, develop, and optimize complex Oracle and PostgreSQL database structures, schemas, views, stored procedures, and functions.
• Develop and maintain PL/SQL packages, triggers, and performance-optimized routines.
• Lead data modeling, query optimization, and database performance tuning across multiple environments.
• Support database migration efforts, including Oracle-to-PostgreSQL transitions and AWS Aurora PostgreSQL.
• Oversee database reliability, scalability, security, and high-availability configurations.

MongoDB / NoSQL Database Administration (DBA) Responsibilities

• Support integration and management of MongoDB databases in hybrid data architectures.
• Assist in modeling and maintaining document-based datasets for applications requiring NoSQL solutions.

API Development Responsibilities

• Develop and maintain RESTful APIs to support data services and backend integrations.
• Implement API endpoints using Python and the Django REST Framework.
• Collaborate with application teams to integrate APIs with UI and workflow components.
• Contribute to API documentation, versioning, testing, and performance improvements.

General Responsibilities

• Automate database and API operational tasks where possible.
• Participate in disaster recovery planning, backups, and failover testing.
• Troubleshoot and resolve complex database or API-related issues.