Data Architect - Hybrid

**** Webcam interview; *** Long term project ***Linkedin Must*** Hybrid - Washington, DC / College Park, GA / Fort Worth, TX / Des Moines, WA and telework.

Job Description

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.