Logo of Huzzle

Home

Matches

Explore

Manage

PostgreSQL Database Architect

image

General Dynamics Information Technology

Aug 4, 2024

  • Job
    Full-time
    Senior (5-8 years)
  • Arnold
  • Quick Apply

AI generated summary

  • You must have a Top Secret/SCI clearance, 5+ years of experience, strong PostgreSQL skills, schema design, performance tuning, Docker/Kubernetes familiarity, and proficiency in SQL and scripting languages.
  • You will design and optimize PostgreSQL databases, enhance performance, support Scrum teams, document processes, and provide technical consultation while managing project deliverables.

Requirements

  • - Top Secret/SCI clearance level must currently possess
  • - Top Secret SCI + Polygraph clearance level must be able to obtain
  • - 5 + years of related experience
  • - US Citizenship Required
  • - Bachelor's Degree in Computer Science, Engineering or a related technical discipline, or the equivalent combination of education, technical training, or work/military 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
  • - 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

Responsibilities

  • Deliver insights to help our clients turn data into action as a PostgreSQL Database Architect at GDIT. Your work will provide transformative solutions to our clients’ big-data obstacles and help advance the mission. Here, you can make a meaningful impact on our clients’ mission and on your career.
  • This position supports the Geospatial Services & Solutions business area to provide high-quality, cost-effective solutions to the customer. As part of the GSS Team the Database Architect's expertise is needed to support a sophisticated enterprise environment.
  • The Database Architect is an active participant in SAFe and Scrum development teams and meetings. The Database Architect will be responsible for developing and deploying custom solutions to the customer's enterprise environment.
  • Researches, designs, develops, tests, and/or modifies PostGresDB table architecture
  • Ability to optimize queries, indexes, and configuration settings for high performance
  • Defining designing scalable schemas that meet business requirements while ensuring performance and maintainability
  • Monitoring existing database performance, identifying architectural bottlenecks and providing architectural 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

FAQs

What is the job title for this position?

The job title for this position is PostgreSQL Database Architect.

What level of security clearance is required for this role?

A Top Secret/SCI clearance is currently required, and the candidate must be able to obtain a Top Secret SCI + Polygraph clearance.

How many years of experience are required for this position?

A minimum of 5 years of related database architecture and administration experience is required.

What specific skills are necessary for this role?

Required skills include proficiency in Kubernetes, pgAdmin, and PostgreSQL, as well as strong problem-solving and troubleshooting skills.

Is US citizenship required for this position?

Yes, US citizenship is required.

Where is this job located?

The job is located at the customer site in Arnold, MO.

What educational background is needed for this position?

A Bachelor's Degree in Computer Science, Engineering, or a related technical discipline is required, or an equivalent combination of education and experience.

Are there any specific duties for the PostgreSQL Database Architect role?

Yes, specific duties include researching and designing PostgreSQL table architecture, optimizing queries and index settings, monitoring database performance, and providing technical support and consultation for database questions.

What benefits are offered to employees?

Benefits include a 401K with company match, comprehensive health and wellness packages, paid education and certifications, and paid vacation and holidays, among others.

Is telecommuting an option for this position?

No, this position requires onsite work.

What is the salary range for this position?

The likely salary range for this position is between $111,897 and $151,389, based on experience, geographic location, and contractual requirements.

image

General Dynamics Information Technology

Art of the possible.

Technology
Industry
10,001+
Employees
1962
Founded Year

Mission & Purpose

GDIT is a global technology and professional services company that delivers consulting, technology and mission services to every major agency across the U.S. government, defense and intelligence community. Our 30,000 experts extract the power of technology to create immediate value and deliver solutions at the edge of innovation. We operate across 30 countries worldwide, offering leading capabilities in digital modernization, AI/ML, Cloud, Cyber and application development. GDIT is part of General Dynamics, a global aerospace and defense company. We have shared our clients’ sense of purpose for over half a century and have a have a unique understanding of their missions, complex environments, and a rapidly changing world. Together with our clients, we strive to create a safer, smarter world by harnessing the power of deep expertise and advanced technology.