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.