PostgreSQL Database Architect NEW

$111,897 - $151,389/Yr

General Dynamics - Arnold, MO

Full-time - Mid Level

Arnold, MO

10,001+ employees

Transportation Equipment Manufacturing

About the position

As a PostgreSQL Database Architect at General Dynamics Information Technology (GDIT), you will play a crucial role in transforming data into actionable insights to support national safety and security. This position involves developing and deploying custom database solutions within a sophisticated enterprise environment, ensuring high performance and scalability while collaborating with cross-functional teams in a SAFe and Scrum framework.

Responsibilities

• Researches, designs, develops, tests, and/or modifies PostGresDB table architecture
• Optimizes queries, indexes, and configuration settings for high performance
• Defines and designs scalable schemas that meet business requirements while ensuring performance and maintainability
• Monitors existing database performance, identifies architectural bottlenecks, and provides enhancements to increase performance
• Architects a database structure supporting a globally distributed set of sites
• Maintains documentation to support software development policies, standards, and procedures
• Works under the guidance of the Scrum Master to produce accurate delivery estimates and manage the transition from analysis through to design and delivery
• Provides progress updates to Scrum Master and the team to ensure the management of any delivery risks or concerns
• Works with the team to plan future sprints, define stories, and estimate efforts
• Provides technical support and consultation for database questions

Requirements

• Bachelor's Degree in Computer Science, Engineering or a related technical discipline, or equivalent combination of education, technical training, or work/military experience
• 5+ years of related database architecture & administration experience
• Strong understanding of PostgreSQL internals, architecture and best practices
• Familiarity with popular PostgreSQL extensions such as PostGIS and monitoring tools like pgAdmin
• Experience with replication strategies to handle large datasets across multiple nodes
• Experience designing scalable schemas that meet business requirements while ensuring performance and maintainability
• Understanding of automatic and manual failover processes
• Familiarity with docker and orchestration tools (like Kubernetes)
• Experience with performance monitoring tools and techniques to track database health and troubleshoot performance issues
• Strong proficiency in SQL and PL/pgSQL
• Strong problem solving and troubleshooting skills
• Strong communication and interpersonal skills

Nice-to-haves

• Experience with Messaging to inform databases (ex. NATS/Pulsar)
• Experience with PostGIS
• Ability to perform capacity planning to analyze database usage and plan for future growth
• Familiarity with scripting languages (e.g. Bash, Python)
• Knowledge of database security principles and experience implementing security measures such as authentication and authorization

Benefits

• 401K with company match
• Comprehensive health and wellness packages
• Internal mobility team dedicated to helping you own your career
• Professional growth opportunities including paid education and certifications
• Cutting-edge technology you can learn from
• Paid vacation and holidays