PostgreSQL Database Architect

$111,897 - $151,389/Yr

General Dynamics - Arnold, MO

Full-time - Mid Level

Remote - Arnold, MO

10,001+ employees

Transportation Equipment Manufacturing

About the position

As a PostgreSQL Database Architect at GDIT, you will deliver insights to help clients turn data into actionable solutions, addressing big-data challenges and advancing their missions. This role involves working within a sophisticated enterprise environment, participating in SAFe and Scrum development teams, and developing custom solutions tailored to the customer's needs.

Responsibilities

• Research, design, develop, test, and modify PostgreSQL table architecture.
• Optimize queries, indexes, and configuration settings for high performance.
• Define and design scalable schemas that meet business requirements while ensuring performance and maintainability.
• Monitor existing database performance, identify architectural bottlenecks, and provide enhancements to increase performance.
• Architect a database structure supporting a globally distributed set of sites.
• Maintain documentation to support software development policies, standards, and procedures.
• Work under the guidance of the Scrum Master to produce accurate delivery estimates and manage the transition from analysis through to design and delivery.
• Provide progress updates to the Scrum Master and the team to manage delivery risks or concerns.
• Collaborate with the team to plan future sprints, define stories, and estimate efforts.
• Provide technical support and consultation for database-related questions.

Requirements

• Bachelor's Degree in Computer Science, Engineering, or a related technical discipline, or equivalent experience.
• 5+ years of related database architecture and 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 systems to inform databases (e.g., 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
• Paid vacation and holidays