[Hiring] RICE Object Developer, Oracle Database Administrator at Copper River Technologies

As a Federally Recognized Alaskan Tribal 8(a) Certified Entity, Copper River Technologies understands that our Federal clients’ mission success is dependent upon creating a robust, high-performance IT infrastructure. For this reason, we are dedicated to delivering the technical products and expertise that help our clients solve critical cybersecurity, network infrastructure, mobility and cloud challenges. We believe that delivering exceptional products and services through cost effective platforms gives our clients more time to focus on what matters to them most- driving the innovation and performance they need to reduce cost and maximize their ROI.

📋 Description

• Maintain, update, and enhance legacy system application code, software, and release documentation. • Develop and modify RICE objects to implement system updates, enhancements, interfaces, reports, and fixes. • Resolve Discrepancy Reports (DRs) and System Change Requests (SCRs) to improve system performance and functionality. • Deliver 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 perform ongoing reviews to ensure system stability. • Support the integration of system changes provided by external organizations. • Ensure compliance with security, configuration management, and software development best practices. • Work collaboratively with business analysts, testers, system administrators, cybersecurity personnel, and government stakeholders. • Provide technical documentation, user guides, training materials, and end-user support as required. • Develop, maintain, and optimize Oracle database objects including tables, views, indexes, stored procedures, packages, triggers, and PL/SQL code. • Design and maintain logical and physical data models supporting application enhancements and business requirements. • Configure, administer, and maintain Oracle database environments supporting development, test, staging, and production systems. • Monitor database performance and conduct tuning activities to optimize system efficiency and reliability. • Analyze and resolve database bottlenecks, locking issues, deadlocks, and performance degradation. • Develop and implement indexing strategies, query optimization techniques, and database performance improvements. • Support database upgrades, patching, configuration management, and software installations. • Coordinate and support database backup, recovery, and disaster recovery activities. • Manage database imports, exports, migrations, and data transformation efforts. • Maintain database integrity, availability, and security in accordance with government requirements. • Implement and maintain database security controls, user account administration, role-based access controls, and auditing mechanisms. • Support interface development and integration activities involving Oracle databases and external systems.

🎯 Requirements

• Security Clearance or ability to obtain and maintain required government security credentials • Bachelor’s degree in Computer Science, Computer Information Systems, Information Technology, Software Engineering, Management Information Systems, or related technical discipline • Equivalent combination of education, technical certifications, and relevant experience may be considered • Security + certification or equivalent required • 3+ years of software development experience with a focus on Oracle application development and RICE object development • Strong proficiency in Oracle PL/SQL, Forms, Reports, Workflow, Packages, Procedures, and Triggers • Experience designing, developing, testing, and implementing Reports, Interfaces, Conversions, and Extensions (RICE) • Strong understanding of Oracle relational database architecture and administration • Experience developing and maintaining logical and physical data models • Proficiency in SQL, PL/SQL, and database scripting • Experience with Oracle Database 12c, 19c, or newer versions • Experience supporting multiple software releases annually, including testing, deployment, and sustainment activities • Experience 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 controls • Strong analytical, troubleshooting, and problem-solving skills • Excellent written, verbal, and interpersonal communication skills.

🏖️ Benefits

• Comprehensive medical, dental, and vision coverage • Flexible Spending Account – healthcare and dependent care • Health Savings Account – high deductible medical plan • Retirement 401(k) with employer match • Open leave policy and paid holidays • Additional benefits including tuition reimbursement, transportation expense account, employee assistance program, and more!