Data Architect

Job Description

Primary Responsibilities:

• This role provides leadership in coordinating and reviewing the business process analyses, needs assessment, and preliminary cost/benefit analyses to align information technology solutions with the enterprise business initiatives.
• Coordinate with technical leads in the System Architect team with container orchestration, cloud solutions and services in a hybrid cloud environment.
• Create and maintain high performance, scalable, and stable data architectures for OIS
• Lead the organization’s data management, security, and migration initiatives while providing direction for a team of data engineers and database administrators.
• Examine the organization’s current data management systems and identify opportunities to enhance performance and prepare for growth.
• Work with System Architect team and assist in development of policies for standardizing systems, development tools and security practices.
• Design and implement data warehouse and storage strategy.
• Design and implement the data extraction, data load, and database synchronization routines and functions ETL.
• Analyze and make recommendations for improvements to existing software regarding database performance, stability, usability and scalability.
• Define and implement database security, audit, and resource allocation policies and procedures.
• Design and implement viable database backup, recovery, and high availability strategies and mechanisms.
• Monitor and optimize database instance using database administration tools, SQL scripts, and database utilities
• Provide guidance and support for data encryption at rest and in transit
• Design, model, document, and guide the logical and conceptual relationship of data and database changes for complex applications.
• Identify requirements, research options, design and implement solutions at a leadership level for the OIS Next Generation application and database.
• Perform technical planning, system integration, verification and validation, cost and risk assessments.
• Identify, research, design, develop, and promote solutions that enhance the modern development environment

Minimum Qualifications

• Must have DOD Top Secret level clearance to start (fully adjudicated T5 background check); Proof of U.S. Citizenship required only for Federal Clearance Requirement
• Certification Requirements: Directive 8570.1/8140 – IAT II:
  • Baseline Certification: Security+
  • Computing Environment Certification: AWS Certified Cloud Practitioner, Data Engineer, Solutions Architect or similar equivalent Cloud environment certification (if not in hand, must be obtained within 3 months of on-boarding)
• BA/BS or equivalent experience and 8+ years of prior relevant experience (or master’s with 6+ years or prior relevant experience), at least 3 years of concentrated hands on experience as Data Engineer or Data Architect within similiar tech stack
• Expert level knowledge of all aspects of SQL
• Extensive experience in container orchestration
• Extensive experience in database design and development
• Extensive experience with data modeling, schema design, and database optimization.
• Extensive experience in configuring and managing Oracle database
• Experience in migration from on-prem data center to public cloud (AWS, Azure)
• Experience in decomposition of Oracle PL/SQL stored procedures and triggers to migrate to Amazon Aurora DB, Postgres, or MySQL
• Experience with ETL/ELT pipeline design feeding data warehouse ingestion at scale
• Familiarity with data retention policies, TTL management, and tiered storage strategies
• Understanding of data warehouse monitoring — query performance tracking, storage growth, and resource utilization
• Strong understanding of dimensional modeling, data partitioning strategies, and query optimization for high-volume analytical workloads
• Experience designing and managing large-scale analytical data warehouses, preferably using ClickHouse or comparable columnar/OLAP databases (e.g., Redshift, BigQuery, Snowflake)
• Excellent communication and written skills
• Must be a self-starter, strong leader, and have the ability to work independently with little supervision.

Are you interested in this position?
Apply by clicking on the “Apply Now” button below!
#GraphicDesignJobsOnline
#WebDesignRemoteJobs
#FreelanceGraphicDesigner
#WorkFromHomeDesignJobs
#OnlineWebDesignWork
#RemoteDesignOpportunities
#HireGraphicDesigners
#DigitalDesignCareers
# Dynamicbrand guru