Senior Oracle DB Engineer: Performance, HA & Integrations

Columbia Technology Partners, Inc; Annapolis, Northern (MD, KY); Hybrid; USD 140,000 - 190,000; Full time

Benefits offered by this job

Medical plans

Vision & Dental

401k retirement plan

Paid time off

Job summary

Columbia Technology Partners, Inc. is seeking a Senior Oracle Database Engineer to design, troubleshoot, and optimize enterprise Oracle database applications and data integrations.

The role focuses on hands-on SQL/PL/SQL development, production issue resolution, and data-flow maintenance using Oracle, NiFi, and AWS services. You will collaborate with developers, DBAs, infrastructure teams, and stakeholders to resolve complex production issues, support releases, and ensure data integrity across

Qualifications

• 10+ years of experience developing and supporting Oracle Database solutions, including advanced SQL and PL/SQL development.
• Bachelor's degree in Computer Science, Information Technology, or a related field; four years of additional experience may be substituted for a degree.
• Experience troubleshooting production issues, tuning database performance, and supporting high-volume data processing environments.
• Familiarity with enterprise integrations utilizing 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 efforts, data validation, operational requests, and issue resolution activities.
• Monitor, troubleshoot, and maintain enterprise data feeds and integrations involving Oracle databases, Apache NiFi, AWS services, APIs, file-based transfers, and dependent applications.
• Investigate failed data flows, perform root-cause analysis, reconcile source and target system discrepancies, and coordinate remediation efforts across technical teams.
• Tune SQL and PL/SQL workloads using execution-plan analysis, indexing strategies, partitioning, optimizer statistics, and Oracle performance diagnostic tools.
• Support production deployments, database releases, post-deployment validation activities, and operational readiness processes.
• Partner with Oracle DBAs to support RAC environments, backup and recovery operations, Data Guard configurations, security controls, monitoring activities, and incident response efforts.
• Create and maintain technical documentation, deployment procedures, troubleshooting guides, support runbooks, and operational process documentation.

Skills

Oracle SQL & PL/SQL development

Database performance tuning

Production issue resolution

Data integration & APIs

Cross-functional collaboration

Education

Bachelor's degree in Computer Science/IT or related field

Degree substitution: 4 years additional experience

Tools

Oracle RAC

RMAN

Data Guard

Oracle Enterprise Manager

Apache NiFi

AWS services

Job description

Columbia Technology Partners, Inc. is seeking a Senior Oracle Database Engineer to design, troubleshoot, and optimize enterprise Oracle database applications and data integrations.

The role focuses on hands-on SQL/PL/SQL development, production issue resolution, and data-flow maintenance using Oracle, NiFi, and AWS services. You will collaborate with developers, DBAs, infrastructure teams, and stakeholders to resolve complex production issues, support releases, and ensure data integrity across