Oracle Database Engineer
Red Arch Solutions2 months ago
Fort Meade, MD, USASenior
Base Salary
$190k - $220k/yr
Responsibilities
- Debug and resolve complex SQL, PL/SQL, data, and production-processing issues.
- Review, rewrite, refactor, and optimize SQL and PL/SQL scripts, packages, procedures, functions, triggers, and batch jobs.
- Develop ad hoc queries and operational scripts for investigations, reporting, reconciliation, data correction, validation, and issue resolution.
- Monitor, troubleshoot, and maintain data feeds involving Oracle, Apache NiFi, AWS endpoints, APIs, files, and connected applications.
- Investigate failed or incomplete data flows and coordinate resolution across database, integration, application, and infrastructure teams.
- Perform data validation, reconciliation, and root-cause analysis across source and target systems.
- Support application releases, database deployments, production incidents, recovery activities, and post-deployment validation.
- Tune SQL and PL/SQL workloads for performance, scalability, and reliability.
- Partner with Oracle DBAs on RAC, recovery, Data Guard, security, performance, configuration, and environment issues.
- Create and maintain technical documentation, deployment instructions, troubleshooting guides, support procedures, and operational runbooks.
Requirements
- 10+ years of experience developing and supporting enterprise solutions using Oracle Database.
- Advanced expertise in Oracle SQL and PL/SQL, including packages, procedures, functions, triggers, views, materialized views, dynamic SQL, collections, bulk processing, exception handling, and database APIs.
- Extensive experience debugging and troubleshooting complex SQL and PL/SQL code across development, test, and production environments.
- Strong experience with data feeds, system integrations, Apache NiFi data flows, AWS services and endpoints, APIs, file-based transfers, batch interfaces, and dependent applications.
- Strong knowledge of SQL and PL/SQL performance tuning, execution-plan analysis, optimizer statistics, indexing, partitioning, query optimization, locking, concurrency, and wait-event analysis.
- Experience with AWR, ASH, ADDM, SQL Trace, TKPROF, and Oracle Enterprise Manager Cloud Control.
- Experience supporting high-volume processing, batch jobs, ETL workflows, data conversion, data migration, and reconciliation processes.
- Working knowledge of database application design, data modeling, schema development, database object management, source control, code review, release documentation, rollback planning, and repeatable database deployments.
- Oracle database administration experience with Oracle RAC, RMAN backup and recovery, Oracle Data Guard, database security, roles, privileges, auditing, tablespaces, storage, sessions, locks, monitoring, and recovery procedures.
- Bachelor's degree in Computer Science, Information Technology, or a related field, or an equivalent combination of education and professional experience.
- Active CompTIA Security+ certification.
- TS/SCI with polygraph is required.
- Experience with Oracle Exadata, Database Vault, Label Security, and large-scale data migration is highly desirable.
Benefits
- 100% paid employee healthcare premiums and CareFirst Advantage benefits.
- HaloScripts concierge prescription medication service.
- Generous paid time off and 11 paid federal holidays.
- 401(k) contribution with a 6% match vested on day one, plus up to 4% profit-sharing contribution.
- Annualized bonus compensation and spot bonuses.
- Tuition reimbursement, a 529 College Savings Plan, and a college loan repayment program.
- Generous referral bonuses.
About Red Arch Solutions
Red Arch Solutions is an IT and engineering services firm that builds software, cloud, cyber, data, and systems solutions for U.S. intelligence and national security customers. It operates as a government contractor, delivering mission systems integration, zero-trust architectures, and AI/ML-enabled analytics. Founded in 2004 and headquartered in Columbia, Maryland, the company is privately held and focuses on programs within the federal intelligence community.