Senior Oracle DB Engineer: Performance & Data Integration

Columbia Technology Partners, Inc; Annapolis (MD); On-site; USD 120,000 - 190,000; Full time

Benefits offered by this job

Medical plans

Vision & Dental

401(k) with company contribution

PTO & leave

Career growth learning budget

Life and AD&D / disability

Profit sharing bonus

Referral bonus

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.

This role is heavily focused on hands-on Oracle SQL and PL/SQL development, production issue resolution, script remediation, ad-hoc data analysis, and the maintenance of critical data feeds and integration endpoints.

Qualifications

• 10+ years of experience developing and supporting Oracle Database solutions with 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 environments.
• Review, refactor, optimize, and maintain SQL/PL/SQL code, including packages, procedures, functions, triggers, and interfaces.
• Develop ad hoc queries and scripts to support investigations, reporting, reconciliation, and data validation.
• Monitor, troubleshoot, and maintain enterprise data feeds and integrations involving Oracle databases, NiFi, AWS, APIs, and file transfers.
• Tune SQL/PL/SQL workloads using execution plans, indexing, partitioning, and diagnostic tools.
• Support production deployments, database releases, post-deployment validation, and operation readiness.

Skills

Oracle SQL

PL/SQL

Troubleshooting

Performance tuning

Data integration

AWS

NiFi

Education

Bachelor's degree in Computer Science/Information Technology or related field

Tools

Oracle RAC

RMAN

Data Guard

Oracle Exadata

Oracle Enterprise Manager

AWR

ASH

TKPROF

Job description

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.

This role is heavily focused on hands-on Oracle SQL and PL/SQL development, production issue resolution, script remediation, ad-hoc data analysis, and the maintenance of critical data feeds and integration endpoints.