POSTGRESQL DATABASE ARCHITECT WITH SECURITY CLEARANCE
General Dynamics Information Technology
Arnold MO 63010 US
REQ#: RQ182211 Public Trust: None Requisition Type: Regular Your Impact Own your opportunity to serve as a critical component of our nation's safety and security. Make an impact by using your expertise to protect our country from threats. 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 Work Requirements .cls-1{fill:none;stroke:#5b6670;stroke-miterlimit:10;stroke-width:2px} Years of Experience 5 + years of related experience * may vary based on technical training, certification(s), or degree .cls-2{fill:none;stroke:#5b6670;stroke-miterlimit:10;stroke-width:2px} Certification Travel Required None .cls-3{fill:none;stroke:#5d666f;stroke-miterlimit:10} Citizenship U.S. Citizenship Required Salary and Benefit Information 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. View information about benefits and our total rewards program. About Our Work 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. 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.
* 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 Work Requirements .cls-1{fill:none;stroke:#5b6670;stroke-miterlimit:10;stroke-width:2px} Years of Experience 5 + years of related experience * may vary based on technical training, certification(s), or degree .cls-2{fill:none;stroke:#5b6670;stroke-miterlimit:10;stroke-width:2px} Certification Travel Required None .cls-3{fill:none;stroke:#5d666f;stroke-miterlimit:10} Citizenship U.S. Citizenship Required Salary and Benefit Information 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. View information about benefits and our total rewards program. About Our Work 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. 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.