PostgreSQL Database Architect - Military Veterans
at General Dynamics
Responsibilities for this Position
Location: USA MO Arnold
Full Part/Time: Full time
Job Req: RQ190664
Type of Requisition:
Regular
Clearance Level Must Currently Possess:
Top Secret/SCI
Clearance Level Must Be Able to Obtain:
Top Secret SCI + Polygraph
Public Trust/Other Required:
None
Job Family:
Database Analysis/Design
Job Qualifications:
Skills:
Kubernetes, pgAdmin, PostgreSQL
Certifications:
None
Experience:
5 + years of related experience
US Citizenship Required:
Yes
Job Description:
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.
At GDIT, people are our differentiator. As a PostgreSQL Database Architect you will help ensure today is safe and tomorrow is smarter. Our work depends on PostgreSQL Database Architect joining our team to support our intelligence customer in Arnold, MO.
HOW A POSTGRESQL DATABASE ARCHITECT WILL MAKE AN IMPACT
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.
SPECIFIC DUTIES AND RESPONSIBILITIES:
- 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
WHAT YOU'LL NEED TO SUCCEED:
EDUCATION:
Bachelor's Degree in Computer Science, Engineering or a related technical discipline, or the equivalent combination of education, technical training, or work/military experience.
QUALIFICATIONS:
5+ years of related database architecture & administration experience
Required Skills:
- Strong understanding of PostgreSQL internals, architecture and best practices.
- Familiarity with popular PostgresSQL 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
Desired
- 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
Location: Customer Site
US Citizenship Required
GDIT IS YOUR PLACE:
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
Rest and recharge with paid vacation and holidays
#RoverGSS
The likely salary range for this position is $111,897 - $151,389. This is not, however, a guarantee of compensation or salary. Rather, salary will be set based on experience, geographic location and possibly contractual requirements and could fall outside of this range.
Scheduled Weekly Hours:
40
Travel Required:
None
Telecommuting Options:
Onsite
Work Location:
USA MO Arnold
Additional Work Locations:
Total Rewards at GDIT:
Our benefits package for all US-based employees includes a variety of medical plan options, some with Health Savings Accounts, dental plan options, a vision plan, and a 401(k) plan offering the ability to contribute both pre and post-tax dollars up to the IRS annual limits and receive a company match. To encourage work/life balance, GDIT offers employees full flex work weeks where possible and a variety of paid time off plans, including vacation, sick and personal time, holidays, paid parental, military, bereavement and jury duty leave. To ensure our employees are able to protect their income, other offerings such as short and long-term disability benefits, life, accidental death and dismemberment, personal accident, critical illness and business travel and accident insurance are provided or available. We regularly review our Total Rewards package to ensure our offerings are competitive and reflect what our employees have told us they value most.
We are GDIT. 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. Together with our clients, we strive to create a safer, smarter world by harnessing the power of deep expertise and advanced technology.
We connect people with the most impactful client missions, creating an unparalleled work experience that allows them to see their impact every day. We create opportunities for our people to lead and learn simultaneously. From securing our nation's most sensitive systems, to enabling digital transformation and cloud adoption, our people are the ones who make change real.
GDIT is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other protected class.
PI255665318
Arnold, MO
General Dynamics is a global aerospace and defense company.
Our portfolio spans the realm of the world's most technologically advanced business jets, wheeled combat vehicles, command and control systems and nuclear submarines. We offer these through our five business groups: Aerospace, Combat Systems, Information Technology, Mission Systems and Marine Systems.
General Dynamics employs thousands of people across the globe, with locations in more than 45 countries. We rely on the skills of our employees and their knowledge of customer requirements to deliver best-in-class products and services.
Who We Are Looking For
General Dynamics is seeking military veterans and military spouses across the country who bring a deeply rooted skillset that includes team-oriented approaches to problem-solving, demonstrations of leadership and an overall commitment to the mission of the organization. We recognize the knowledge and skills gained during your military experience are invaluable to the success of a team. We’re proud of the thousands of veterans and military professionals who have chosen to apply their leadership, teamwork and problem-solving skills to a career at General Dynamics and to continue supporting the mission of those serving today.
Should I Apply?
At General Dynamics, our employees are the heart of our company. We rely on their dedication to excellence and their intimate knowledge of customer requirements to meet the needs of customers around the globe, day in and day out. Our employees' unique blend of skill, innovation and agility drives our continued success, and we take our responsibility to them seriously. If you are a military veteran or military spouse ready to advance your career, view our available career opportunities to the right for more information and to apply today!
What Happens After I Apply?
Once you click ‘Apply Now’ on a General Dynamics posting, you will be re-directed to fill out an application on General Dynamics career page. In order to be considered for next steps, please complete the application on General Dynamics career page and make sure you have an updated resume uploaded to your RecruitMilitary profile. Once General Dynamics reviews your resume and profile, a recruiter will reach out to provide you with more information and to schedule you for an interview.
How to Win An Interview
1. Review the job description for the specific position you are applying for.
2. Review the company website. Know their mission and values. What do they do? What are their products?
3. Prepare a few questions to ask on your interview.
4. Prepare to discuss your military or civilian background and how it relates to the position.
5. Check out the RecruitMilitary Resources tab for resume guidance, interview prep and more!