Job Description
RESPONSIBILITIES- Develop, maintain, troubleshoot, and optimize complex Oracle SQL and PL/SQL solutions.
- Debug production database, application-processing, and data issues.
- Maintain PL/SQL packages, procedures, functions, triggers, batch jobs, and database interfaces.
- Create ad hoc SQL for investigations, reconciliation, validation, reporting, and operational support.
- Monitor and troubleshoot database-driven data feeds and system integrations.
- Analyze execution plans and tune SQL and PL/SQL workloads for performance and scalability.
- Support database deployments, production releases, incidents, and post-release validation.
- Partner with database, application, integration, and infrastructure teams on complex technical issues.
Role Requirements- 10+ years of enterprise Oracle Database experience.
- Advanced Oracle SQL and PL/SQL development expertise.
- Extensive experience debugging complex SQL and PL/SQL in production environments.
- Strong knowledge of packages, procedures, functions, triggers, views, dynamic SQL, and bulk processing.
- Strong SQL performance tuning and execution-plan analysis experience.
- Experience supporting high-volume data processing, ETL, batch processing, and data reconciliation.
- Experience troubleshooting data feeds and system integrations.
- Familiarity with Oracle diagnostic tools such as AWR, ASH, ADDM, SQL Trace, or TKPROF.
- Working knowledge of Oracle RAC, RMAN, Data Guard, security, storage, sessions, and locks.
- Active TS/SCI with Full Scope Polygraph required.
- Ability to work onsite in Annapolis, Maryland five days per week.
PREFERRED EXPERIENCE- Apache NiFi experience.
- AWS integration or endpoint experience.
- Oracle Exadata.
- Database Vault or Label Security.
- Large-scale database migration experience.
Numbers & Facts
| Location | Annapolis, MD |
| Salary | $90 |
Skills
Amazon Web Services (AWS)unmatched
Analysis Skillsunmatched
Apacheunmatched
Application Integrationunmatched
Data Processingunmatched
Database Extract Transform and Load (ETL)unmatched
Database Programmingunmatched
Database Technologyunmatched
Database Triggersunmatched
Debugging Skillsunmatched
Full Scope Polygraphunmatched
Identify Issuesunmatched
Information/Data Security (InfoSec)unmatched
Operational Supportunmatched
Oracleunmatched
Oracle Databaseunmatched
Oracle PL-SQLunmatched
Oracle RAC (Real Application Clusters)unmatched
Performance Tuning/Optimizationunmatched
Production Systemsunmatched
RMANunmatched
Reconciliationunmatched
SQL (Structured Query Language)unmatched
Sensitive Compartmented Information (SCI)unmatched
System Integration (SI)unmatched
Top Secret Clearanceunmatched
Level up your application
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.
Free resume templatesImprove your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.
Free resume builder