Data Architect II

Job DescriptionJob Description Data Architect II 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.