Oracle Database Engineer

Ft Meade, MD
Full Time
Database
Experienced
Red Arch Solutions is seeking a Senior Oracle Database Engineer with 10+ years of experience developing, troubleshooting, and supporting enterprise-scale Oracle database applications. This position is primarily focused on hands-on SQL and PL/SQL development, production debugging, script remediation, ad hoc data analysis, and the maintenance of data feeds and integration endpoints.
The ideal candidate has expertise in Oracle SQL and PL/SQL, along with complementary database administration skills that support effective production troubleshooting, performance tuning, deployment, recovery, and collaboration with DBA and infrastructure teams.

Basic Qualifications:
  • 10+ years of experience developing and supporting enterprise solutions using Oracle Database.
  • 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
  • Experience with Oracle Exadata, Database Vault, Label Security, and large-scale data migration is highly desirable.
  • Ability to work effectively with developers, database administrators, application owners, business analysts, infrastructure teams, and upstream and downstream integration partners.
  • Must be an independent, analytical, and detail-oriented contributor with strong written and verbal communication skills and the ability to manage production issues and competing priorities.
  • TS/SCI w/ polygraph required.

Required Skills:
  • 10+ years of experience developing and supporting enterprise solutions using Oracle Database, including Oracle 10g through current versions.
  • 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 in development, test, and production environments.
  • Demonstrated ability to:
    • Analyze existing database code and business logic.
    • Identify defects, data issues, and performance bottlenecks.
    • Rewrite, refactor, and optimize existing scripts.
    • Develop and maintain operational and production-support scripts.
    • Create ad hoc queries for data analysis, reporting, reconciliation, validation, and issue resolution.
  • Strong experience maintaining and supporting data feeds and system integrations, including:
    • Apache NiFi data flows and endpoints.
    • AWS services, interfaces, and endpoints.
    • APIs and service-based integrations.
    • File-based data transfers and batch interfaces.
    • Upstream and downstream application dependencies.
    • Data validation, reconciliation, exception handling, and feed monitoring.
  • Experience diagnosing data-feed and integration failures by tracing issues across database objects, PL/SQL processes, NiFi flows, AWS endpoints, files, APIs, and dependent systems.
  • Strong knowledge of SQL and PL/SQL performance tuning, including execution-plan analysis, optimizer statistics, indexing, partitioning, query optimization, locking, concurrency, and wait-event analysis.
  • Experience using Oracle diagnostic and performance tools such as AWR, ASH, ADDM, SQL Trace, TKPROF, and Oracle Enterprise Manager Cloud Control.
  • Experience supporting high-volume data processing, batch jobs, ETL workflows, data conversion, data migration, and data-reconciliation processes.
  • Working knowledge of database application design, data modeling, schema development, and database object management sufficient to maintain and enhance scalable, reliable database solutions.
  • Experience deploying SQL, PL/SQL, schema, and configuration changes through structured development, testing, validation, and production-release processes.
  • Familiarity with source control, code review, release documentation, rollback planning, and automated or repeatable database deployment practices.
  • Complementary Oracle database administration experience, including working knowledge of:
    • Oracle RAC.
    • RMAN backup and recovery.
    • Oracle Data Guard.
    • Database security, roles, privileges, and auditing.
    • Tablespaces, storage, sessions, locks, and database-object management.
    • Production monitoring, incident troubleshooting, and recovery procedures.
Primary Responsibilities:
  • Debug and resolve complex SQL, PL/SQL, data, and production-processing issues.
  • Review, rewrite, refactor, and optimize existing SQL and PL/SQL scripts.
  • Develop ad hoc queries and scripts to support investigations, reporting, reconciliation, data correction, and operational requests.
  • Maintain and enhance PL/SQL packages, procedures, functions, triggers, batch jobs, and database interfaces.
  • 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 and root-cause analysis to identify discrepancies between source and target systems.
  • Support application releases, database deployments, production incidents, and post-deployment validation.
  • Tune SQL and PL/SQL workloads to improve performance, scalability, and reliability.
  • Partner with Oracle DBAs on database configuration, RAC, recovery, Data Guard, security, performance, and environment-related issues.
  • Create and maintain technical documentation, support procedures, deployment instructions, troubleshooting guides, and operational runbooks.
Salary range for this position: $190,000-$220,000 #CJ

The Red Arch Solutions pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Determination of official compensation or salary relies on several factors including, but not limited to, level of position, job responsibilities, geographic location, scope of relevant work experience, educational background, certifications, contract-specific affordability, organizational requirements, alignment with local internal equity as well as alignment with market data.

Red Arch Solutions Benefits Snapshot:

  • 100% paid employee healthcare premiums. CareFirst Advantage Best in Class Benefits.
  • HaloScripts Concierge prescription medication service
  • Generous PTO.
  • 10 % 401K 6% match vested day one and up to 4% profit sharing contribution.
  • Annualized bonus compensation.
  • Spot bonuses for hard work.
  • Tuition reimbursement.
  • 529 College Saving Plan.
  • College Loan Pay Back Program.
  • 11 Paid Federal Holidays
  • Generous Referral Bonuses.

Red Arch Solutions provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.

Have more questions about Red Arch? Email us at Careers@RedArchSolutions.com

Share

Apply for this position

Required*
We've received your resume. Click here to update it.
Attach resume or Paste resume
Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

To comply with government Equal Employment Opportunity and/or Affirmative Action reporting regulations, we are requesting (but NOT requiring) that you enter this personal data. This information will not be used in connection with any employment decisions, and will be used solely as permitted by state and federal law. Your voluntary cooperation would be appreciated. Learn more.
Voluntary Self-Identification of Disability
Voluntary Self-Identification of Disability Form CC-305
OMB Control Number 1250-0005
Expires 07/31/2029
Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Please check one of the boxes below:

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.

You must enter your name and date
Human Check*