Oracle Developer (CEMS)

Concept Plus; United States; Remote; USD 90,000 - 120,000; Full time

Benefits offered by this job

Health insurance

Paid time off

Bonuses

Tuition reimbursement

Job summary

Concept Plus is seeking an Oracle Developer to sustain CEMS database support and develop Web Services APIs for CEMS interfaces from its Fairfax, VA office. The role involves designing and optimizing PL/SQL packages, procedures, and queries, while ensuring secure, reliable, and scalable code across environments.

You will collaborate with application teams, perform data migrations and ETL tasks, and participate in code reviews.

Qualifications

• Requires US Citizenship with active Secret Clearance.
• BA/BS preferred, can be replaced by additional experience.
• 2+ years of experience with Oracle PL/SQL.
• Experience with Oracle database replication.
• Knowledge of AWS and/or OCI technologies and utilities.

Responsibilities

• Design, develop, and optimize PL/SQL packages, procedures, functions, triggers, and queries to support application features and business workflows.
• Analyze existing database code and processes to identify performance bottlenecks and implement tuning improvements.
• Collaborate with application developers, business analysts, and data teams to translate requirements into efficient database solutions.
• Develop and maintain complex SQL queries, stored procedures, and database scripts for reporting, integration, and data processing needs.
• Ensure database code follows best practices for security, reliability, reusability, and performance.
• Work with relational database structures, implementing changes, updates, and schema modifications as required.
• Perform troubleshooting, debugging, and root cause analysis on PL/SQL components and database issues.
• Support deployment activities by preparing scripts and validating results.
• Create and maintain documentation for database structures, stored procedures, data flows, and development standards.
• Participate in code reviews and provide guidance on PL/SQL and database standards.
• Assist with data migration, ETL processes, and integration tasks between internal and external systems.
• Monitor database performance and collaborate with DBAs to optimize queries, indexes, and storage.

Skills

Oracle PL/SQL

Performance Tuning

SQL Queries

AWS / OCI

Clearance

Communication

Education

BA/BS in CS or related field

Tools

Oracle Database

ETL Tools

Job description

company

About Concept Plus

Concept Plus is a mission-focused technology solutions provider that transforms IT concepts into impactful solutions for federal agencies. Headquartered in Fairfax, VA, we bring the agility, responsiveness, and customer intimacy of a small business combined with the quality and infrastructure of a larger firm.

Recognized as an award-winning Oracle partner, we have delivered innovative solutions across Defense, Intelligence, Civilian, Health IT, and Tribal sectors. Our highly certified experts build systems that drive efficiency, accelerate modernization, and ensure mission outcomes with certainty.

We offer competitive pay, comprehensive health, dental, and vision insurance, paid life insurance, paid time off, 11 paid holidays, performance bonuses, tuition reimbursement, unlimited training, and the opportunity to thrive in a collaborative, flexible, and innovative environment.

For more information, visit www.conceptplus.com .

role

About the role

Concept Plus is seeking a Oracle Developer to perform sustainment tasks for CEMS database support and APIs/Interfaces. Develops and maintains CEMS Web Services APIs for existing and future CEMS interface.

What you'll do

• Design, develop, and optimize PL/SQL packages, procedures, functions, triggers, and queries to support application features and business workflows.
• Analyze existing database code and processes to identify performance bottlenecks and implement tuning improvements.
• Collaborate with application developers, business analysts, and data teams to understand requirements and translate them into efficient database solutions.
• Develop and maintain complex SQL queries, stored procedures, and database scripts for reporting, integration, and data processing needs.
• Ensure database code follows best practices for security, reliability, reusability, and performance.
• Work with relational database structures, implementing changes, updates, and schema modifications as required.
• Perform troubleshooting, debugging, and root cause analysis on PL/SQL components and database-related issues.
• Support deployment activities by preparing scripts, validating execution results, and ensuring smooth transitions between environments.
• Create and maintain documentation for database structures, stored procedures, data flows, and development standards.
• Participate in code reviews and provide technical guidance on PL/SQL and database development standards.
• Assist with data migration, ETL processes, and integration tasks between internal and external systems.
• Monitor database performance and collaborate with DBAs to optimize queries, indexes, and storage strategies.

Required Qualifications

• US Citizen with active Secret Clearance
• BA/BS preferrable, can be replaced by additional experience
• 2+ years of experience with Oracle PL/SQL
• Experience with Oracle database replication
• Knowledge of AWS and/or OCI related technologies and utilities

Preferred Qualifications

• Strong interpersonal and communications skills.
• AGILE Environment experience, DevSecOps
• Have AWS Cloud One or AWS Gov Cloud experience.

Concept Plus is an Equal Opportunity Employer. As such, we will give your application full consideration without regard to your race, color, religion, sex, age, national origin, disability, veteran status, sexual orientation, gender identity, or any other classification protected by federal, state, or local law.