Database Developer/API Developer

Plateau Software Inc•Fairfax, VA

10d

About The Position

Plateau GRP is seeking a highly skilled Database (DB) Developer with strong expertise in Oracle, PostgreSQL, PL/SQL, and database architecture, combined with API development experience using REST services and the Python Django REST Framework. This role focuses primarily on database engineering, performance tuning, data design, and migration activities, while also supporting API development needs to integrate database services with application layers.

Requirements

At least six (6) years of hands-on Oracle and PostgreSQL database development and administration experience.
Expert-level skills in PL/SQL, SQL optimization, data modeling, and performance tuning.
Experience with PostgreSQL in AWS Aurora environments.
At least three (3) years of hands-on experience developing and maintaining APIs to enable and support data services and backend integrations.
Hands-on experience developing REST APIs.
Hands-on experience working with Python and the Django REST Framework.
Ability to obtain and maintain any required government security clearance (this requires US Citizenship)

Nice To Haves

Experience with MongoDB or other NoSQL technologies.
Experience applying DevSecOps practices and working with CI/CD pipelines.

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.
Support integration and management of MongoDB databases in hybrid data architectures.
Assist in modeling and maintaining document-based datasets for applications requiring NoSQL solutions.
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.
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.