[Hiring] Data Architect @Program Management Solutions LLC

Role Description

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

• Designs, develops, secures, and improves Oracle-based relational and multidimensional data environments.
• Uses Oracle SQL and PL/SQL to support efficient database management and automation.
• Applies strong performance tuning, backup and recovery, security, and high-availability practices to protect data integrity and service continuity.
• Defines, designs, develops, and maintains relational and multidimensional Oracle database structures supporting enterprise applications, data warehouses, and data marts.
• Develops and optimizes Oracle SQL and PL/SQL queries, procedures, functions, packages, triggers, and automation scripts for efficient database management and repeatable operations.
• Reviews schemas, indexes, execution plans, queries, and database workloads; identifies bottlenecks and implements performance-tuning improvements.
• Develops and maintains data acquisition, integration, migration, archival, backup, recovery, and continuity strategies in coordination with database administrators and technical teams.
• Applies database security practices, including access controls, least privilege, secure coding, auditing, and protection of sensitive information to preserve confidentiality and data integrity.
• Supports high availability, production readiness, monitoring, troubleshooting, standards, metadata, documentation, and continuous improvement across test and production environments.

Qualifications

• 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

Requirements

• 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.
• 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.