Position Summary
Designs, develops, secures, and improves Oracle-based relational and multidimensional data environments using Oracle SQL and PL/SQL, performance tuning, backup and recovery, security, and high-availability practices. Key Responsibilities
Define, design, develop, and maintain relational and multidimensional Oracle structures supporting enterprise applications, data warehouses, and data marts.
Develop and optimize Oracle SQL and PL/SQL queries, procedures, functions, packages, triggers, and automation scripts.
Review schemas, indexes, execution plans, queries, and workloads; identify bottlenecks and implement performance improvements.
Develop and maintain data acquisition, integration, migration, archival, backup, recovery, and continuity strategies.
Apply access controls, least privilege, secure coding, auditing, and protection of sensitive information.
Support high availability, production readiness, monitoring, troubleshooting, standards, metadata, documentation, and continuous improvement across test and production environments.
Required Skills
Oracle Database, SQL, and PL/SQL
Stored procedures, functions, packages, triggers, and automation
Relational and multidimensional data modeling
Query optimization, execution-plan analysis, indexing, and performance tuning
Backup, recovery, archival, migration, and continuity planning
High availability, monitoring, troubleshooting, and production support
Database security, access controls, least privilege, and auditing
Data warehousing, metadata, integration, and data marts
Education and Experience
At least 3 years of relevant experience with an Associate degree. Experience must include Oracle SQL and PL/SQL development, database design, automation, performance tuning, backup and recovery, security, high availability, data integration, and support of test or production database environments. Additional Requirements
Microsoft Excel and Microsoft Word proficiency.
Excellent verbal and written communication skills.
Potential overtime, weekend work, and travel; no on-call requirement.
No separately identified nice-to-have skills.
Numbers & Facts
Location
Washington, DC
Skills
Access Controlunmatched
Acquisition Integrationunmatched
Analysis Skillsunmatched
Auditingunmatched
Automationunmatched
Communication Skillsunmatched
Continuous Improvementunmatched
Data Martunmatched
Data Modelingunmatched
Data Recoveryunmatched
Data Warehousingunmatched
Data Warehousing Applicationsunmatched
DataArchitect Data Modeling Toolunmatched
Database Designunmatched
Documentationunmatched
Enterprise Applicationsunmatched
High Availabilityunmatched
Identify Issuesunmatched
Information/Data Security (InfoSec)unmatched
Metadataunmatched
Microsoft Excelunmatched
Microsoft Wordunmatched
On Callunmatched
Oracleunmatched
Oracle Databaseunmatched
Oracle PL-SQLunmatched
Performance Managementunmatched
Performance Tuning/Optimizationunmatched
Presentation/Verbal Skillsunmatched
Production Controlunmatched
Production Supportunmatched
Production Systemsunmatched
Query Optimizationunmatched
SQL (Structured Query Language)unmatched
Scripting (Scripting Languages)unmatched
Secure Codingunmatched
Software Administrationunmatched
Stored Proceduresunmatched
System Migrationunmatched
Testingunmatched
Writing Skillsunmatched
🎯
Be found by employers
5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.