PostgreSQL Database Architect

$111,897 - $151,389/Yr

GD Information Technology, Inc. - Arnold, MO

posted about 1 month ago

Full-time - Mid Level
Remote - Arnold, MO
10,001+ employees

About the position

As a PostgreSQL Database Architect at GDIT, you will play a crucial role in delivering insights that help our clients transform data into actionable solutions. Your expertise will be instrumental in overcoming big-data challenges and advancing the mission of our clients. This position is based in Arnold, MO, where you will support our intelligence customer by providing high-quality, cost-effective solutions within the Geospatial Services & Solutions business area. Your work will not only impact the clients' missions but also contribute significantly to your career development. In this role, you will be an active participant in SAFe and Scrum development teams, collaborating closely with team members to ensure the successful delivery of projects. You will be responsible for researching, designing, developing, testing, and modifying PostgreSQL database architecture. This includes optimizing queries, indexes, and configuration settings to achieve high performance, as well as defining and designing scalable schemas that meet business requirements while ensuring performance and maintainability. You will monitor existing database performance, identify architectural bottlenecks, and provide enhancements to improve overall performance. Your responsibilities will also include maintaining documentation to support software development policies, standards, and procedures, and working under the guidance of the Scrum Master to produce accurate delivery estimates. You will provide progress updates to the Scrum Master and the team, manage delivery risks, and assist in planning future sprints by defining stories and estimating efforts. Additionally, you will offer technical support and consultation for database-related inquiries, ensuring that the team has the necessary resources to succeed.

Responsibilities

  • Research, design, develop, test, and modify PostgreSQL database 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 Scrum Master and the team to ensure the management of any delivery risks or concerns.
  • Work with the team to plan future sprints, define stories, and estimate efforts.
  • Provide 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 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 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
  • Cutting-edge technology you can learn from
  • Paid vacation and holidays
  • Paid parental leave
  • Paid military leave
  • Paid bereavement leave
  • Paid jury duty leave
  • Short and long-term disability benefits
  • Life, accidental death and dismemberment, personal accident, critical illness, and business travel and accident insurance.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service