Data Architect II

• Posted 6 days ago • Updated 4 hours ago
Full Time
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • Scripting
  • Database Administration
  • Data Acquisition
  • Collaboration
  • Data Integrity
  • Documentation
  • Continuous Improvement
  • Database Design
  • Data Integration
  • Database
  • Oracle
  • SQL
  • PL/SQL
  • Data Modeling
  • Query Optimization
  • Performance Tuning
  • Backup
  • Recovery
  • Migration
  • High Availability
  • Production Support
  • Database Security
  • Access Control
  • Auditing
  • Data Warehouse
  • Meta-data Management
  • Data Marts
  • Microsoft Word
  • Microsoft Excel
  • Communication
  • Artificial Intelligence
  • Biometrics
  • Spectrum
  • Business Process

Summary

Design, develop, secure, and improve Oracle-based relational and multidimensional data environments. The Data Architect II uses Oracle SQL and PL/SQL to support efficient database management and automation and applies strong performance tuning, backup and recovery, security, and high-availability practices to protect data integrity and service continuity.

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
Requirements
  • ship
  • 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

About Us
For more than 20 years, NewGen Technologies has solved our clients' toughest IT challenges with integrity, security, and outstanding service by delivering both technology and talent. We have helped secure borders, have used artificial intelligence (AI) to fight terror, aided the identification of criminals, and have helped to prevent crime through the introduction of biometrics. Our team of Highly Cleared Specialists have hard-to-find skills and expertise in a wide spectrum of technologies to provide solutions that transform business processes and solve problems of national significance. #CJ
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10153280
  • Position Id: c2ee8ef1c751054126ad27a0d90edd3d
  • Posted 6 days ago
Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Spring, Texas

•

Today

Full-time

Hybrid in Washington, District of Columbia

•

Yesterday

Easy Apply

Contract

Depends on Experience

Spring, Texas

•

Today

Full-time

Savannah, Georgia

•

Today

Full-time

Search all similar jobs