Concept Plus, LLC
Posted 4 days agoVerified live 2d ago
Oracle Developer (CEMS)
Brief overview
Remote
UndergradOr in progress
2+ yrsMinimum
Clearance requiredU.S. government
Oracle PL/SQLOracle Database ReplicationAWSOracle Cloud Infrastructure (OCI)AgileDevSecOpsAWS Cloud OneAWS GovCloud
About the company
Concept Plus, LLCconceptplus.com
Concept Plus is a technology services company offering deep technical expertise, an experienced team, and a dedication to maximizing business productivity.
Job description
Summary
Concept Plus is a mission-focused technology solutions provider that delivers technology solutions for federal agencies. The Oracle Developer will support CEMS database sustainment, develop and maintain Oracle PL/SQL components, and build web services APIs and interfaces. The role also involves database optimization, integration, troubleshooting, deployment support, documentation, and collaboration with technical teams.
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 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
Skills
- 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
- Strong interpersonal and communications skills
- AGILE Environment experience, DevSecOps
- Have AWS Cloud One or AWS Gov Cloud experience
Qualifications
Must Haves
- 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
Nice to Haves
- Strong interpersonal and communications skills
- AGILE Environment experience, DevSecOps
- Have AWS Cloud One or AWS Gov Cloud experience
Benefits
- Comprehensive health, dental, and vision insurance
- Paid life insurance
- Paid time off
- 11 paid holidays
- Performance bonuses
- Tuition reimbursement
- Unlimited training
- A collaborative, flexible, and innovative environment
