Senior SQL Developer

Cogent People

. Build, tune, and operate database processing supporting a mission-critical, data-centric financial system for the Federal Government in the healthcare domain .

Posted 10/13/2026full-timeColumbia • Maryland • United StatesSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in Oracle SQL and PL/SQL for developing and maintaining database applications, with a strong focus on data validation, reporting, and performance tuning in a healthcare or financial context. Proficient in automating data processes and ensuring compliance with federal security standards.

Highest-signal resume keywords

Oracle SQLPL/SQL DevelopmentData ValidationPerformance TuningHealthcare EDI Interchange

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Oracle PL/SQL PackagesQuery Performance TuningXML ParsingData Warehouse DevelopmentLinux Shell ScriptingPython for Data AutomationAgile MethodologiesCI/CD PracticesData Processing AutomationDatabase Application Support

Soft Skills

Strong Communication SkillsMentoring Junior DevelopersExplaining Data Findings

Tools & Technologies

IBM Workload SchedulerControl-MAutosysGit Version ControlAWS Oracle RDSAWS S3

Certifications & Qualifications

Public Trust Clearance

Industry Keywords

Healthcare DomainFinancial Transaction ProcessingRegulatory ReportingFederal Security ControlsEDI Standards

Tech Stack

Tools & technologies

AWSCloudLinuxOraclePythonShell ScriptingSQL

About the role

Key responsibilities & impact

Build, tune, and operate database processing supporting a mission-critical, data-centric financial system for the Federal Government in the healthcare domain
Own and execute recurring data validation and reporting processes, delivering accurate results on schedule
Design, write, and maintain Oracle PL/SQL packages and procedures
Ingest and validate large XML and EDI files
Load staging and fact tables
Produce outbound data files and reconcile results across interfacing systems
Turn ad-hoc client data requests into correct, documented query results and extracts
Explain data findings and discrepancies
Tune queries against very large partitioned tables
Diagnose and recover failed batch jobs
Replace manual spreadsheet-based steps with automated, repeatable processes
Take changes through formal release processes with testing, security review, and approval gates
Support changes in production
Document developed processes and systems
Mentor junior developers
Contribute to modernization of reporting workloads onto modern cloud data platforms

Requirements

What you’ll need

Bachelor’s degree in computer science, information systems, or related field (or equivalent experience)
6+ years of hands-on experience developing and supporting production Oracle database applications
At least 3 years in a data warehouse, financial transaction processing, or regulatory reporting context
Expert Oracle SQL and PL/SQL, including packages, procedures, cursors, collections, BULK COLLECT/FORALL, dynamic SQL, exception handling, and job/error instrumentation
Query performance tuning, including execution plans, indexing strategy, and partitioned large tables
Experience with datasets in the hundreds of millions of rows
XML parsing and loading using XMLTYPE/XMLTABLE
Experience with delimited and fixed-width formats, SQL*Loader, and external tables
Working knowledge of healthcare or financial EDI interchange, including X12 834, 810, 820, 835, 824, or comparable
Enterprise batch scheduling with IBM Workload Scheduler/TWS, Control-M, Autosys, or similar
Linux shell scripting
Python for data automation and report generation
Git-based version control
AWS familiarity, particularly Oracle RDS and S3
Experience with agile methodologies, including SAFe and Scrum
Working knowledge of DevSecOps practices, CI/CD, formal release management, and change control with documented test evidence
Ability to handle sensitive healthcare and financial data under federal security controls
Strong written and verbal communication skills
Ability to explain data discrepancies to non-technical business leads and government stakeholders
Candidates must have lived in the U.S. for at least 3 of the past 5 years
Must be authorized to work in the U.S. (Citizen, Permanent Resident, or EAD)
Public Trust Clearance or ability to obtain

Benefits

Comp & perks

Health, Dental, and Vision Insurance: Comprehensive coverage
401(k) Plan: Matching contributions
Life Insurance & Disability Coverage: Company-paid life, short-term, and long-term disability insurance
Paid Time Off: 3 weeks of PTO annually, plus 10 holidays
Career development opportunities
Supportive, inclusive culture
Competitive salaries