Copper River Technologies logo
Copper River Technologies

Federally recognized, Alaskan Tribal-Owned, 8(a) Certified IT cyber defense solutions & service provider.

RICE Object Developer, Oracle Database Administrator

Database AdministratorDatabase AdministratorFull TimeRemoteSeniorTeam 11-50H1B No SponsorCompany SiteLinkedIn

Location

United States

Posted

2 days ago

Salary

0

Seniority

Senior

Bachelor Degree3 yrs expEnglishCyber SecurityOracleSQL

Job Description

RICE Object Developer, Oracle Database Administrator

Copper River Technologies

• 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.

Job 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!

Related Categories

Related Job Pages

More Database Administrator Jobs

3Cloud logo

Database Administrator - Cloud Platform / Infrastructure

3Cloud

Delivering the ultimate Microsoft Azure experience.

Full TimeRemoteTeam 501-1,000H1B No Sponsor

Role Description 3Cloud is looking for an experienced Database Administrator who is comfortable managing multiple deadlines and varied customer requests. A strong OS background is preferred due to the many migration assessments and implementations required by the position. Experience with Azure is a must, along with flexible and creative analytical skills to fit the solution to the customer needs. - Work as a DBA for multiple customers, helping with Database Migrations, High Availability and Disaster Recovery solutions, SQL and Windows Clustering solutions, Monitoring, Backup/Recovery solutions, and Performance Tuning including remediation on performance blockers. - Manage multiple long-term database (Azure data services) projects at the same time. - Able to scope, plan, implement, and document and/or present a solution to the customer. - Provide cost effective Azure platforms to meet customer requirements. - Be able to work with Development, Test, and Production environments to support customer requirements at each level of work. - Assist with Security definitions and roles for various users in the environments and support Azure Infrastructure team in provisioning data services in Azure cloud. - Manage client expectations with regards to scope, cost, and timeline. - Author high quality project documentation and other project artifacts, including written case studies detailing use cases and project specifics. - Be an effective technical mentor to more junior level teammates. - Deliver complex projects on-time and within budget, proactively identifying and mitigating gaps and risks. - Expand your knowledge in multiple tools and technologies. - Foster a problem-solving culture that resolves issues through collaboration and partnerships with other parts of the organization. - Support internal 3Cloud objectives that help advance data services design and techniques. - Support the Sales Team on Presales efforts to define scope estimates for most projects when bandwidth allows. Qualifications - Bachelor’s degree in computer, engineering, data science or a related field; or equivalent work experience. - Has the ability to work both strategically and tactically in different customer environments. - Must be EXTREMELY detail oriented and self-directed. - Must be able to produce high-quality documentation for both internal and external distribution. - Must have multiple years working with a major RDBMS (Oracle/SQL Server) – preference given to deep experience with Microsoft products. - Should have done a few databases migration from different cloud platform/or on-prem to Azure. - Moderate experience with OS clustering concepts and technologies. - Understanding of security roles and how to implement database security. - Advanced level experience at the implementation and appropriate use of the following HA/DR technologies: Always On AG, Replication, Log shipping, Mirroring. - Advanced level experience with database objects/stored procedures. - Advanced level experience with performance tuning, monitoring, and troubleshooting. - Have a strong understanding of Cloud Infrastructure solutions and the delivery/execution of how they are implemented using IaC (Bicep or Terraform). - Drive to maintain knowledge of the latest technologies and how they may impact existing 3Cloud offerings. - Understanding of cloud ecosystem and leading-edge cloud emerging technologies. - Performance analysis, troubleshooting and remediation techniques. - Strong analytical problem-solving ability. - Strong presentation, written and verbal communication skills. - Self-starter with the ability to work independently or as part of a virtual project team. Requirements - You have over 2 years of experience in the following: - Designing and implementing logical and physical data models for cloud and hybrid data warehouse environments. - Implementing data architectures to support a variety of data formats and structures including structured, semi-structured and unstructured data. - Implementing multiple full life-cycle data warehouses. - Understanding of data architectures required to support data integration processing. - Data modeling technologies such as ER/Studio, ER/Win or similar. - Microsoft Azure Data Platform services including Azure Data Lake Store, Azure Storage, Azure Synapse, Azure Data Factory, Azure SQL database, Logic Apps, APIs. - Data profiling and creation of source to target mappings. - Ability to provision and configure Azure data service resources. Benefits - Full-time employment. - 📌 Remote in Philippines.

Philippines
Full TimeRemoteTeam 10,001+H1B No Sponsor

• Administer the Corrigo CMMS platform to ensure optimal system performance, data integrity, and adherence to operational standards through configuration management, system audits, and database maintenance protocols • Configure system settings including user access controls, property/asset hierarchies, work order scheduling processes, and system integrations to meet specific client requirements • Partner with client teams as the primary CMMS technical advisor and subject matter expert, processing data requests efficiently while maintaining accurate time tracking for reimbursable services • Develop reporting solutions and analytics that deliver performance insights, support account teams with complex data analysis, and maintain comprehensive database accuracy through regular validation • Analyze client change requests, provide impact assessments to support decision-making, and deliver system training and knowledge transfer to maximize platform adoption • Document and deploy configuration changes following change management protocols, explore innovative solutions within existing system capabilities, and implement process improvements based on industry best practices

Canada
$75K - $115K / year
Jahnel Group, an Inc. 5000 company logo

Database Administrator

Jahnel Group, an Inc. 5000 company

World Class Software Creators Ready To Hustle For You

Full TimeRemoteTeam 51-200Since 2010H1B No Sponsor

• Investigate and resolve application and data-related support tickets. • Write, test, and execute SQL scripts to perform data updates, corrections, and maintenance activities. • Troubleshoot production and UAT issues by analyzing data, stored procedures, and application behavior. • Identify root causes of system issues and work with development teams to implement solutions. • Support reporting and operational data requests across multiple business functions. • Modify and maintain existing stored procedures, queries, and database processes. • Collaborate with developers, business analysts, and stakeholders to understand system workflows and business rules. • Participate in ongoing application support, maintenance, and enhancement initiatives.

New York
$65K - $75K / year

Microsoft Access Database Developer

Raye IT Consulting

Raye IT Consulting, LLC is a 8a certified minority woman-owned IT consulting and technology firm. Raye IT brings over 20 years experience in delivering mission-critical programs and support for the Federal Government and large agencies. We specialize in program and project management, capital planning and IT investment portfolio management, infrastructure support and application development deployment to include IT operations and maintenance. We deliver value through technical and managerial expertise – innovation, efficient processes, executable strategies, and methodologies that generate tangible and measurable results to our clients across the Federal, Civilian and DoD sectors.

Role Description Raye IT Consulting is seeking a Senior MS Access Database Developer to serve as the lead technical resource responsible for the maintenance, development, and optimization of a federal client's Financial Management Tool (FMT). - Lead development and ongoing maintenance of the MS Access front-end application, including forms for data entry and retrieval, queries for reporting and data updates, local reporting tables, and automation of recurring data processes. - Design and maintain the ODBC connectivity layer between the MS Access front end and the cloud-hosted MariaDB/MySQL backend, ensuring stable, performant communication between application tiers. - Develop and maintain queries, stored procedures, and data workflows that support budget formulation, spend approvals, funding allotments, vendor and contract management, inter- and intra-agency agreement tracking, and obligation of funds. - Perform bulk data loads and updates to maintain accurate financial data across multi-year budget cycles containing thousands of rows of plan data, contract records, agency agreements, and fund obligations. - Build, maintain, and refresh MS Excel-based reports using Pivot Tables connected via ODBC to MS Access front-end queries; ensure daily refresh of standard reports and develop new reports as requirements evolve. - Document all reporting processes, including data sources, query logic, refresh schedules, and output formats, to ensure continuity and auditability. - Manage version and environment control for the MS Access file, ensuring changes are tracked, tested, and deployed in a controlled manner across the user community. - Perform ongoing performance tuning, error resolution, and data integrity monitoring; respond to user-reported issues and proactively identify system anomalies. - Maintain role-based access management across the user base; ensure appropriate permissions are assigned, documented, and audited. - Store and distribute the MS Access file, Excel reports, and user documentation via a SharePoint site; maintain organized and accessible repositories for all tool-related materials. - Produce and maintain technical documentation for all forms, queries, tables, automation processes, and data management procedures. - Support requirements management by translating stakeholder needs into technical specifications and implementing changes in alignment with governance and budget timelines. - Conduct new technology research to identify opportunities to improve tool performance, scalability, or functionality within the federal IT environment. Qualifications - 8+ years of hands-on MS Access development experience, including forms, queries, macros, VBA automation, and table architecture in an Office 365 (64-bit) environment. - Demonstrated expertise with MariaDB or MySQL, including database design, query optimization, stored procedures, and ODBC integration with MS Access front-end applications. - Strong SQL skills; experience writing complex queries for reporting, data validation, and bulk data operations across large, multi-year datasets. - Experience building and maintaining MS Excel reporting solutions using Pivot Tables with live ODBC connections to database back-ends. - Proven ability to manage the full development lifecycle of a database application — from requirements gathering and design through testing, deployment, documentation, and ongoing support. - Experience supporting federal IT financial data systems, including budget execution, obligations tracking, inter-agency agreement management, or similar financial workflows. - Strong written communication skills; ability to produce clear technical documentation and present findings to both technical and non-technical federal stakeholders. - Experience with SharePoint as a document repository and file distribution platform. - U.S. Citizenship required; ability to obtain and maintain a federal Public Trust clearance and HSPD-12 credentials. - Ability to complete mandatory federal training requirements, including annual Information Security Awareness Training (ISAT). Requirements - Prior experience supporting the USDA FPAC Business Operations Branch (BOB) Financial Management Tool (BOB FMT) or equivalent federal agency financial management database system. - Familiarity with FPAC's multi-agency shared-cost IT budget model spanning FSA, NRCS, RMA, and FPAC-BC. - Experience integrating MS Access applications with AWS-hosted cloud databases using Oracle MySQL ODBC driver (v8.0.x or higher). - Knowledge of USDA IT security and privacy policies, including FISMA compliance, NIST SP 800-53, and federal system Authority to Operate (ATO) requirements as they apply to database development. - Experience with the USDA AgMAX capital planning tool and data loading processes for CPIC reporting. - Familiarity with federal IT financial terminology including obligations, accruals, commitments, spend plans, Working Capital Fund (WCF), and inter-agency agreement (IAA) structures. - Section 508 / WCAG 2.0 compliance awareness for database-integrated application development. - CompTIA Security+, Microsoft Certified: Data Analyst Associate, or equivalent certification. Benefits - 401(k) - 401(k) matching - Health Insurance - Dental Insurance - Disability Insurance - Flexible Spending Account (FSA) - Life Insurance - Paid Time Off Security Clearance Requirements Public Trust Schedule Monday - Friday (remote U.S. Based) - must be available during Kansas City core hours.

United States