Data Architect

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

We are looking for an experienced Data Architect to join our growing team.

Job Description

Designs, develops, secures, and improves Oracle-based relational and multidimensional data environments. The Data Architect II uses Oracle SQL and PL/SQL to support efficient database management and automation and applies strong performance tuning, backup and recovery, security, and high-availability practices to protect data integrity and service continuity.

• Define, design, develop, and maintain relational and multidimensional Oracle database 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 for efficient database management and repeatable operations.
• Review schemas, indexes, execution plans, queries, and database workloads; identify bottlenecks and implement performance-tuning improvements.
• Develop and maintain data acquisition, integration, migration, archival, backup, recovery, and continuity strategies in coordination with database administrators and technical teams.
• Apply database security practices, including access controls, least privilege, secure coding, auditing, and protection of sensitive information to preserve confidentiality and data integrity.
• Support high availability, production readiness, monitoring, troubleshooting, standards, metadata, documentation, and continuous improvement across test and production environments.

Required Skills/Level of Experience:

• 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

At least 3 years of relevant experience with an Associate degree. Experience should 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.

PLEASE NOTE:

• Must be a U.S. citizen and reside in the United States.
• Must be able to obtain a public trust designation for access to sensitive, unclassified government information.