Oracle Developer (CEMS) - Secret Clearance

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

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.