Dice
Posted 2 days agoVerified live 1d ago
Data Architect II
Brief overview
Remote
UndergradOr in progress
3+ yrsMinimum
Clearance requiredU.S. government
Oracle DatabaseSQLPL/SQLDatabase DesignRelational and Multidimensional Data ModelingQuery Optimization and Performance TuningBackup and RecoveryHigh AvailabilityDatabase Security and Access ControlData IntegrationData Warehousing and Data MartsPublic Trust ClearanceWritten and Verbal Communication
About the company
Dicedice.com
Dice is the go-to career marketplace for tech professionals.
Job description
Summary
NewGen Technologies delivers secure IT solutions and technology talent to address complex client challenges. The Data Architect II designs, develops, secures, and improves Oracle-based relational and multidimensional data environments, while supporting database performance, integration, recovery, security, high availability, and production operations.
Responsibilities
- 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
Skills
- Able to obtain a Public Trust designation for access to sensitive, unclassified government information
- 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
- Oracle Database, SQL, and PL/SQL
- Store 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
- Skills in Microsoft Word and Excel
- Excellent written and verbal communication skills
Qualifications
Must Haves
- Able to obtain a Public Trust designation for access to sensitive, unclassified government information
- 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
- Oracle Database, SQL, and PL/SQL
- Store 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
- Skills in Microsoft Word and Excel
- Excellent written and verbal communication skills
