Senior Oracle Database Engineer (Development & Administration)

Columbia Technology Partners•Annapolis Junction, MD

18h

About The Position

Columbia Technology Partners is seeking a Senior Oracle Database Engineer to develop, troubleshoot, optimize, and sustain enterprise-scale Oracle database applications and data integration solutions. The position focuses 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 engineer works with developers, DBAs, infrastructure teams, application owners, and business stakeholders to resolve production issues, improve database performance, support application releases, and maintain integrations involving Oracle, Apache NiFi, AWS services, APIs, and file-based interfaces. The role also supports high-availability production environments in partnership with Oracle DBAs, including RAC environments, backup and recovery operations, Data Guard configurations, security controls, monitoring, and incident response. The position requires U.S. citizenship, an active security clearance with an appropriate polygraph, a DOD 8570 certification, and successful completion of a security background investigation and polygraph. Applicants and employees are subject to random drug testing in accordance with Executive Order 12564. Columbia Technology Partners is a Service-Disabled Veteran Owned Small Business founded in 2007, specializing in technology and management consulting for corporations and federal agencies. The company describes its culture as team-oriented and mission-focused, and offers competitive pay and benefits.

Requirements

At least 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, or four additional years of experience in place of a degree.
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.
U.S. citizenship.
DOD 8570 certification.
An active security clearance with an appropriate polygraph; employment is contingent on successful completion of a security background investigation and polygraph.

Nice To Haves

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.

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 for investigations, reporting, reconciliation, data validation, operational requests, and issue resolution.
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 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, and operational readiness processes.
Partner with Oracle DBAs to support RAC environments, backup and recovery operations, Data Guard configurations, security controls, monitoring, and incident response.
Create and maintain technical documentation, deployment procedures, troubleshooting guides, support runbooks, and operational process documentation.

Benefits

Three medical plans with in-network and out-of-network options.
Vision and dental coverage paid in full by CTP.
401(k) with a 6% company contribution.
Customizable paid time off and leave plans.
Jury duty, bereavement, and military leave.
Up to $10,000 for approved career-related learning, training, education, and/or tuition.
Life and AD&D insurance.
Short-term and long-term disability coverage.
End-of-year profit-sharing bonus.
Tiered referral bonus program, with bonuses ranging from $7,000 to $20,000 if a referral joins the team.