Database Architect

Peraton; United States; On-site; USD 104,000 - 166,000; Full time

Job summary

Peraton is looking for a Database Architect to support the Department of Homeland Security. Responsibilities include database design, installation, optimization, and interaction with government clients. Ideal candidates should have significant experience in database management and strong technical skills.

Qualifications

• Bachelors degree and 8 years of experience required.
• Minimum of 5 years of experience as a Database Architect/Engineer.
• Strong expertise in AWS Aurora PostgreSQL and Oracle database.

Responsibilities

• Install and configure new software and hardware.
• Design, develop, and maintain scalable database architectures.
• Administer and maintain AWS Aurora PostgreSQL and Oracle database environments.

Skills

AWS Aurora PostgreSQL

Oracle database management

ETL processes

Database architecture design

Database monitoring and alerting

Education

Bachelors degree

Tools

AWS GovCloud

Ansible

Gitlab

Jenkins

Job description

Join to apply for the Database Architect role at Peraton

1 week ago Be among the first 25 applicants

Join to apply for the Database Architect role at Peraton

About Peraton

Peraton is a next-generation national security company that drives missions of consequence spanning the globe and extending to the farthest reaches of the galaxy. As the world's leading mission capability integrator and transformative enterprise IT provider, we deliver trusted, highly differentiated solutions and technologies to protect our nation and allies. Peraton operates at the critical nexus between traditional and nontraditional threats across all domains: land, sea, space, air, and cyberspace. The company serves as a valued partner to essential government agencies and supports every branch of the U.S. armed forces. Each day, our employees do the can't be done by solving the most daunting challenges facing our customers. Visit peraton.com to learn how we're keeping people around the world safe and secure.

About Peraton

Peraton is a next-generation national security company that drives missions of consequence spanning the globe and extending to the farthest reaches of the galaxy. As the world's leading mission capability integrator and transformative enterprise IT provider, we deliver trusted, highly differentiated solutions and technologies to protect our nation and allies. Peraton operates at the critical nexus between traditional and nontraditional threats across all domains: land, sea, space, air, and cyberspace. The company serves as a valued partner to essential government agencies and supports every branch of the U.S. armed forces. Each day, our employees do the can't be done by solving the most daunting challenges facing our customers. Visit peraton.com to learn how we're keeping people around the world safe and secure.

Program Overview

Improve biometric services and access to expanded biometric data to enable DHS operational missions.

About The Role

Peraton is seeking a Database Architect to join our team of qualified, diverse individuals. The ideal candidate will become part of Peraton's Department of Homeland Security (DHS) Datacenter Consolidation and Cloud Optimization (DCCO) program providing database architecture support to the DHS Homeland Advanced Recognition Technology (HART) biometric system. The Database team maintains the HART Database by installing and configuring database, data migration, monitoring system performance, resolving customer tickets within JIRA and supporting system incident troubleshooting calls. Database members closely interact with the government customer to achieve system objectives, provide ticket updates, and system status updates. Database members are expected to be on-call for a week at a time approximately 6 - 9 times a year.

Day to Day Roles and Responsibilities:

• Be responsible for the installation and configuration of new software and hardware.
• Design, develop and maintain scalable database architectures
• Create and maintain Entity-Relationship Diagrams (ERDs)
• Develop and optimize ETL processes
• Implement partitioning strategies for optimal database performance
• Create and manage AWS-based data warehouse solutions
• Develop and enforce database standards and best practices
• Optimize query performance and database operations
• Provide technical guidance on database design to development teams
• Implement data security measures and compliance requirements
• Plan for necessary hardware or software upgrades to support system growth.
• Provide support with escalated help desk requests.
• Identify root cause and documenting troubleshooting steps to resolution.
• Work independently and in team settings to achieve key project/program objectives and deliverables.
• Administer and maintain AWS Aurora PostgreSQL and Oracle database environments.
• Design, implement, and optimize database schemas and query performance
• Execute data migration projects from Oracle to PostgreSQL
• Setup comprehensive database monitoring systems and alerting
• Manage database upgrades and version transitions
• Support operational maintenance tasks and troubleshooting
• Track and resolve database-related issues using Jira
• Perform regular database health checks and performance analysis
  
  

Qualifications

Basic Qualifications:

• Bachelors degree and 8 years of experience or a Masters degree and 6 years of experience or a High School Diploma and 12 years of experience.
• U.S. citizenship and the ability to obtain/maintain a U.S. government agency level clearance (the DHS EOD, which you must have prior to starting)
• Minimum of 5 years of experience as a Database Architect/Engineer
• Strong expertise in AWS Aurora PostgreSQL and Oracle database management
  
  

Desired Qualifications:

• Experience with AWS database services (RDS, Aurora, Redshift)
• Experience with monitoring tools like CloudWatch, Dynatrace, Grafana, or pgBadger
• Advanced SQL development skills
• Database modeling and normalization techniques
• Database performance tuning and query optimization techniques
• Understanding of high availability and disaster recovery strategies
• Knowledge of data governance and security best practices
• Experience with database high availability and disaster recovery strategies
• Experience with automation tools for database administration tasks
• Scripting skills in Python, Bash, or similar
• Strong O&M (Operations & Maintenance) background, including database upgrades
• Background in agile development environments
• Experience with JIRA Ticketing systems preferred
• Experience with DevOps and Agile methodologies
• Proficiency in AWS data warehouse solutions (Redshift, RDS)
• Experience designing and implementing data reporting solutions
• Proven experience with database design and Entity-Relationship Diagrams (ERD)
• Experience with ETL processes and data migration from Oracle to PostgreSQL
• Proficiency with PostgreSQL table partitioning techniques and optimization strategies
• Experience with Jira for project tracking and documentation
• Ability to set up comprehensive database monitoring solutions, writing custom monitoring queries and scripts
• Ability to write and optimize complex SQL queries
• Familiarity with Jira for issue tracking and project management
• Strong troubleshooting and problem-solving skills
  
  

Technologies

• AWS GovCloud (AWS Console)
• SNOW
• Ansible Automation Platform
• Aurora AWS (PostgreSQL) database, Redshift
• Gitlab and Jenkins pipeline
• CyberArk
• Splunk
  
  

SCA / Union / Intern Rate or Range

Details

Target Salary Range: $104,000 - $166,000. This represents the typical salary range for this position based on experience and other factors.

EEO:Equal opportunity employer, including disability and protected veterans, or other characteristics protected by law.

Seniority level

• Seniority level

  Not Applicable

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Civil Engineering

Referrals increase your chances of interviewing at Peraton by 2x

Sign in to set job alerts for “Database Architect” roles.

Remote Enterprise Data Warehouse Architect

United States $150,000.00-$170,000.00 1 day ago

Data Architect – Databricks, ADF in Property and Casualty domain exp and guidewire

Need Data Warehouse Architect 3 - Local to Richmond, VA

Georgia, United States $144,900.00-$144,900.00 1 week ago

California, United States $130,000.00-$145,000.00 1 week ago

United States $108,100.00-$180,600.00 1 week ago

United States $72,000.00-$148,500.00 6 days ago

Remote Enterprise Data Warehouse Architect

United States $130,000.00-$160,000.00 4 days ago

United States $143,700.00-$245,520.00 1 day ago

Greater Macon $144,900.00-$241,500.00 1 week ago

United States $140,000.00-$157,500.00 1 week ago

United States $120,000.00-$180,000.00 1 day ago

Scientific Data Architect/Senior Scientific Data Architect - Boston

United States $200,000.00-$225,000.00 3 weeks ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.