RICE Object Developer, Oracle Database Administrator

This is a fully remote position, open to applicants in United States.

📋 Description

• Maintain, update, and enhance the application code, software, and release documentation of legacy systems.

• Develop and modify RICE objects to facilitate system updates, enhancements, interfaces, reports, and fixes.

• Address Discrepancy Reports (DRs) and System Change Requests (SCRs) to enhance system performance and functionality.

• Provide Technical Solutions and Rough Order of Magnitude (ROM) estimates for system modifications.

• Conduct and support Critical Design Reviews (CDR), Preliminary Design Reviews (PDR), and Test Readiness Reviews (TRR).

• Monitor application logs, identify system issues, and carry out ongoing reviews to ensure system stability.

• Assist with the integration of system changes supplied by external organizations.

• Ensure adherence to security protocols, configuration management, and best practices in software development.

• Collaborate effectively with business analysts, testers, system administrators, cybersecurity personnel, and government stakeholders.

• Provide necessary technical documentation, user guides, training materials, and end-user support.

• Develop, maintain, and optimize Oracle database objects such as tables, views, indexes, stored procedures, packages, triggers, and PL/SQL code.

• Design and maintain both logical and physical data models that support application enhancements and business requirements.

• Configure, administer, and maintain Oracle database environments for development, testing, staging, and production systems.

• Monitor database performance and perform tuning activities to enhance system efficiency and reliability.

• Analyze and resolve database bottlenecks, locking issues, deadlocks, and performance degradation.

• Develop and implement indexing strategies, query optimization techniques, and improvements for database performance.

• Assist with database upgrades, patching, configuration management, and software installations.

• Coordinate and support database backup, recovery, and disaster recovery operations.

• Manage database imports, exports, migrations, and data transformation tasks.

• Ensure database integrity, availability, and security in compliance with government standards.

• Implement and maintain database security measures, user account management, role-based access controls, and auditing processes.

• Support interface development and integration activities involving Oracle databases and external systems.

⛳️ Requirements

• Security Clearance or the ability to obtain and maintain necessary government security credentials.

• Bachelor’s degree in Computer Science, Computer Information Systems, Information Technology, Software Engineering, Management Information Systems, or a related technical field.

• An equivalent combination of education, technical certifications, and relevant experience may be considered.

• Security + certification or an equivalent is required.

• Over 3 years of experience in software development, particularly in Oracle application development and RICE object development.

• Strong expertise in Oracle PL/SQL, Forms, Reports, Workflow, Packages, Procedures, and Triggers.

• Experience in designing, developing, testing, and implementing Reports, Interfaces, Conversions, and Extensions (RICE).

• Solid understanding of Oracle relational database architecture and administration.

• Experience in developing and maintaining logical and physical data models.

• Proficient in SQL, PL/SQL, and database scripting.

• Experience with Oracle Database versions 12c, 19c, or newer.

• Experience supporting multiple software releases annually, including testing, deployment, and sustainment activities.

• Familiarity with database performance tuning, query optimization, indexing strategies, and execution plan analysis.

• Experience with database import/export processes, data migration, and change management activities.

• Knowledge of Oracle backup and recovery methodologies, including RMAN and Oracle Data Guard.

• Experience with Oracle Enterprise Manager (OEM) and database monitoring tools.

• Strong understanding of software versioning, configuration management, and release management processes.

• Knowledge of solutions integration methodologies and system interfaces.

• Experience implementing database security controls, user administration, and role-based access management.

• Strong analytical, troubleshooting, and problem-solving abilities.

• Excellent written, verbal, and interpersonal communication skills.

🏝️ Benefits

• Comprehensive medical, dental, and vision coverage.

• Flexible Spending Account for healthcare and dependent care.

• Health Savings Account associated with a high deductible medical plan.

• Retirement 401(k) plan with employer matching.

• Open leave policy along with paid holidays.

• Additional perks including tuition reimbursement, transportation expense account, employee assistance program, and more!