Senior Oracle DB Engineer: SQL/PLSQL, RAC & Data Guard

Columbia Technology Partners

Maryland

On-site

USD 120,000 - 180,000

Full time

2 days ago

Be an early applicant

Application generator

Stand out for this role — generate a tailored resume and cover letter in about a minute.

Get past ATS filters

Job summary

Columbia Technology Partners is seeking a Senior Oracle Database Engineer to support the development, troubleshooting, optimization, and sustainment of enterprise-scale Oracle database applications and data integration solutions.

The role focuses on hands-on SQL/PL/SQL development, production issue resolution, script remediation, and data integration maintenance across Oracle, NiFi, and AWS ecosystems. Collaboration with DBAs, developers, and stakeholders is essential.

Qualifications

10+ years of experience developing and supporting Oracle DB solutions, including advanced SQL and PL/SQL.
Experience troubleshooting production issues, tuning database performance, and supporting high-volume data processing environments.
Familiarity with enterprise integrations using Apache NiFi, AWS services, APIs, and file-based data exchanges.
Working knowledge of Oracle RAC, RMAN, Data Guard, database security, and software release management practices.

Responsibilities

Debug, analyze, and resolve complex Oracle SQL, PL/SQL, data-processing, and production-support issues across development, test, and production environments.
Review, refactor, optimize, and maintain SQL and PL/SQL code, including packages, procedures, functions, triggers, batch jobs, and database interfaces.
Develop ad hoc queries and scripts to support investigations, reporting, reconciliation, data validation, and issue resolution activities.
Monitor, troubleshoot, and maintain enterprise data feeds and integrations involving Oracle databases, NiFi, AWS services, APIs, and file-based transfers.
Investigate failed data flows, perform root-cause analysis, reconcile source and target system discrepancies, and coordinate remediation across technical teams.
Tune SQL and PL/SQL workloads using execution-plan analysis, indexing strategies, partitioning, optimizer statistics, and diagnostic tools.
Support production deployments, database releases, post-deployment validation activities, and operational readiness processes.
Collaborate with Oracle DBAs to support RAC environments, backup/recovery operations, Data Guard configurations, security controls, monitoring, and incident response.
Create and maintain technical documentation, deployment procedures, troubleshooting guides, runbooks, and operational process documentation.