Oracle Data Architect – Data Warehousing & Security

Program Management Solutions LLC; Washington (District of Columbia); On-site; USD 110,000 - 160,000; Full time

Job summary

Program Management Solutions LLC seeks an experienced Data Architect to design, develop, and secure Oracle-based data environments supporting enterprise applications and data warehouses. The role emphasizes SQL/PL/SQL development, performance tuning, and robust backup/recovery strategies.

You will implement data modeling, data integration, and high-availability practices while ensuring data security and governance across production environments.

Qualifications

• 3+ years of Oracle SQL/PL/SQL development experience.
• Experience with relational and multidimensional data modeling.
• Experience with data warehouses, data marts, and ETL/data integration workflows.

Responsibilities

• Define, design, develop, and maintain Oracle DB structures for enterprise apps, data warehouses, and data marts.
• Develop and optimize Oracle SQL/PL/SQL queries, procedures, functions, packages, triggers, and automation scripts.
• Review schemas, execution plans, indexes, queries, and workloads; implement performance tuning improvements.
• Develop and maintain data acquisition, integration, migration, archival, backup, recovery, and continuity strategies.

Skills

Oracle SQL

PL/SQL

Data modeling

Query optimization

Backup & recovery

Security & auditing

High availability

Education

Associate degree

Job description

Program Management Solutions LLC seeks an experienced Data Architect to design, develop, and secure Oracle-based data environments supporting enterprise applications and data warehouses. The role emphasizes SQL/PL/SQL development, performance tuning, and robust backup/recovery strategies.

You will implement data modeling, data integration, and high-availability practices while ensuring data security and governance across production environments.