PostgreSQL Database Architect

General Dynamics

Confirmed live today High trust

Quick summary

Work type
On-site
Location
St. Louis, MOSpringfield, VA
Salary
$112,840–$142,600 / yr
Posted
100 days ago
Freshness
Confirmed live today

Market check

Salary context

Below market

How this pay compares to similar roles

Similar $198k
This role $128k
$98k $252k
below market most similar roles pay here above market

This role pays less than 97% of similar roles. Most pay $159,750–$235,750 — the blue band above. At the midpoint, this role pays about $128k versus about $198k for comparable roles.

Based on 240 similar postings.

Employer

About General Dynamics

General Dynamics is a global aerospace and defense company offering a broad portfolio of products and services in business aviation, ship construction, land combat vehicles, and information technology. It serves customers in the U.S. government, allied governments, and a diverse array of commercial markets.

General Dynamics currently has 1377 open roles on FindRole.

Listed pay typically runs $124,093–$150,385 across 1184 roles with salary data.

Most-posted roles

View all roles at General Dynamics

At a glance

TL;DR · PostgreSQL Database Architect

The PostgreSQL Database Architect joins the IT Infrastructure and Operations team to analyze, design, develop, implement, and support database infrastructure deployment and management. This role involves managing server functionality, maintaining database integrity and security through role-based access control, and developing testing strategies. The architect will collaborate with developers on schema design, query optimization, and stored procedures while executing upgrades, patching, and migrations. Key technical requirements include proficiency in PostgreSQL administration, MySQL, and Oracle Database, along with experience in high-availability solutions, performance tuning, and backup strategies. The position addresses big-data obstacles for an intelligence customer, requiring the candidate to build efficient table structures for both transactional and warehouse data while ensuring compliance with industry standards and regulatory requirements in a secure environment.

What you'll do

  • Analyze, design, develop, and implement database infrastructure deployment and management.
  • Maintain database integrity and security by configuring role-based access control and administrative accounts.
  • Plan and execute database upgrades, patching, and migrations from Oracle, MySQL, and PostgreSQL.
  • Collaborate with developers on schema design, query optimization, and stored procedures.
  • Develop and monitor policies for computing resource allocation and database performance tuning.
  • Create and manage PostgreSQL server agent alerts and backup/restore strategies.
  • Maintain documentation for configurations, standards, and procedures.
  • Evaluate open-source and vendor tools for database modernization projects.

What we're looking for

  • Must possess a Top Secret/SCI security clearance.
  • Must be a US Citizen.
  • Bachelor's degree in Computer Science or a related technical discipline, or an equivalent combination of education, certifications, and experience.
  • 5+ years of related database analysis and/or administration experience.
  • Proficiency in PostgreSQL administration, including high-availability solutions and performance tuning.
  • Experience with database backup, restore, migration, and snapshot technologies/strategies.
  • Experience with migration involving Oracle, MySQL, and PostgreSQL.
  • CompTIA Security+ or equivalent certification (preferred).

More like this

Similar roles

Postgres DBA

Cognizant

Charlotte, NC 8 days ago
PostgreSQL SQL Python Bash Shell Data Warehousing High Availability Replication Disaster Recovery Performance Tuning Capacity Planning Data Governance Cloud Migration Automation RCA SOPs

PostgreSQL Database Analyst

General Dynamics

Springfield, VA +2 125 days ago $125,800–$170,200
PostgreSQL Oracle Database MySQL Database Administration Query Optimization Stored Procedures RBAC high-availability Database Migration Performance Tuning Schema Design CompTIA Security+
5+ yrs exp

Senior PostgreSQL Database Admin

General Dynamics

Washington, DC 117 days ago $110,500–$149,500
PostgreSQL Database Administration High Availability Disaster Recovery Data Modeling Schema Design CI/CD DevSecOps Configuration Management Endpoint Management Query Optimization Backup and Recovery Security Best Practices
5+ yrs exp