Senior Oracle Database Engineer (Development & Administration)

Columbia Technology Partners; Maryland; On-site; USD 150,000 - 190,000; Full time

Job summary

Columbia Technology Partners in Maryland is seeking a Senior Oracle Database Engineer to develop, troubleshoot, optimize, and sustain enterprise Oracle database solutions. The role centers on hands-on SQL/PLSQL, production issue resolution, script remediation, ad hoc data analysis, and maintaining data feeds and integrations with Oracle, NiFi, AWS, APIs, and file interfaces.

Ideal candidates bring 10+ years of Oracle experience, strong performance tuning, and familiarity with RAC, RMAN, and Data

Qualifications

• The candidate has 10+ years of Oracle database experience with strong SQL/PLSQL development.
• Bachelor’s degree required; additional experience can substitute for a degree.
• Experience with high-availability, security, and release management practices.

Responsibilities

• Debug, analyze, and resolve complex Oracle SQL/PLSQL issues across environments.
• Review, refactor, optimize, and maintain SQL code and interfaces.
• Develop ad hoc queries for investigations, data validation, and reporting.
• Monitor and maintain enterprise data feeds and integrations (NiFi, AWS, APIs).
• Coordinate remediation across technical teams and perform root-cause analysis.
• Tune workloads using execution plans, indexing, partitioning, and tools.
• Support deployments, post-deployment validation, and operational readiness.
• Collaborate with Oracle DBAs on RAC, backup/recovery, Data Guard, and security.

Skills

Oracle SQL

PL/SQL development

Production issue resolution

Performance tuning

Data integration

Apache NiFi

AWS services

Scripting

Education

Bachelor's degree in Computer Science or related field

Tools

Oracle RAC

RMAN

Data Guard

Oracle Exadata

Job description

Description Columba 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. The ideal candidate combines deep Oracle development expertise with strong database troubleshooting and performance tuning experience, along with working knowledge of Oracle administration technologies that support high-availability production environments. In this role, you will work closely with developers, DBAs, infrastructure teams, application owners, and business stakeholders to resolve complex production issues, optimize database performance, support application releases, and maintain data integrations leveraging Oracle, Apache NiFi, AWS services, APIs, and file-based interfaces.

Key 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.

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.

Desired Skills

• Experience with Oracle Exadata, Database Vault, Oracle Label Security, or other advanced Oracle technologies.
• Experience supporting large-scale data migration, conversion, or reconciliation efforts.
• Familiarity with Oracle performance and diagnostic tools, including AWR, ASH, ADDM, TKPROF, and Oracle Enterprise Manager.
• Understanding of database design, data modeling, and scalable application architecture.
• Strong analytical, troubleshooting, communication, and cross-functional collaboration skills.

Requirements

• U.S. Citizenship is required for all applicants. CTP is an equal opportunity employer and abides by applicable employment laws and regulations. All applicants and employees are subject to random drug testing in accordance with Executive Order 12564. Employment is contingent upon successful completion of a security background investigation and polygraph.
• Certification Requirements:
  • DOD 8570 Certification

This position requires an active Security Clearance with appropriate Polygraph.

About Us

Founded in 2007, Columbia Technology Partners is a Service-Disabled Veteran Owned Small Business with a specialization in technology and management consulting committed to solving intricate and sensitive technology issues facing corporations and federal agencies. Since its inception, CTP has been instrumental in the technical design, engineering development, operational deployment, and support of key systems. With a proven track record in information security, project management, systems/network engineering, security risk management, vulnerability assessments, and mobile security implementation; our employees have the experience, expertise, and innovative thinking our customers need for results that exceed expectations. CTP staff have worked closely with both government engineers and management to gather mission requirements, develop the architecture to deliver the needed functionality and assess tools available to meet or exceed the needs of the mission.

At Columbia Technology Partners (CTP), we are united in being the best that we can be as individuals, but our core belief is that we can be better together. Together we will take on each mission with an execution process that authentically represents who we are. Our success relies on our team values, the foundation we built around them, and the Partners we become along the way. Thats why our pay is competitive, our missions are critical, and our benefits represent what matters most to CTP: Our People.

Salary Range Transparency

• Salary: $150000.00 - $190000.00 per year

CTP was voted one of the top 25 best places to work in Baltimore by Baltimore Magazine.