Lead Cloud PostgreSQL Database Administrator

Location: Springfield, VA

Clearance Required: Active TS (SCI eligibility) clearance and eligibility to obtain a CI poly is required upon application for initial consideration **We are not able to upgrade or sponsor clearances**

At Bcore, our strength comes from how we deliver impact to the mission. Whether it's architecting critical IT solutions, producing actionable intelligence, or developing cutting edge technology, we succeed because of the expertise, collaboration, and agility of our teams. Our Mission Services division combines enterprise IT, cloud solutions, DevSecOps, systems engineering, software development, and operational support. Bcore accelerates decisive advantage for warfighters and intelligence professionals by fusing human insight, rapid-fire engineering, precision-measured outcomes, and relentless grit into mission-ready solutions.

Do you want to join a team that is building tailored technical solutions to modernize our government's mission and our client's business? Do you have a desire to change how people work? Are you interested in helping to protect our nation's cyber interests? Join our growing team supporting the NGA customer missions as a Lead Cloud PostgreSQL Database Administrator *contingent upon award*

Responsibilities

What you get to do every day:

• Lead enterprise-level PostgreSQL database administration across AWS cloud infrastructure supporting mission-critical applications and services.
• Architect and implement robust, scalable database solutions using Amazon Aurora and RDS, incorporating best practices for high availability, disaster recovery, and performance optimization.
• Design and deploy advanced database architectures including read replicas, replication strategies, and distributed sharding solutions to meet complex scalability requirements.
• Provide technical leadership and subject matter expertise on database performance tuning, query optimization, and infrastructure capacity planning for large-scale data workloads.
• Engineer automated solutions for database migrations, ETL pipelines, and bulk loading operations while ensuring data integrity and minimal downtime.
• Mentor database team members and provide guidance on PostgreSQL best practices, troubleshooting methodologies, and emerging cloud database technologies.
• Collaborate with development teams to design optimal database schemas, implement row-level security, and develop efficient stored procedures and triggers.

Qualifications

Clearance Required: Active TS clearance (with SCI Eligibility) and eligibility to obtain CI Poly **We are not able to upgrade or sponsor clearances**

Education/Experience:

• Bachelor's Degree or equivalent combination of education, technical training, or work/military experience
• 8+ years of experience in database administration with at least 5 years focused on PostgreSQL in production environments

Required Skills:

• Hands-on experience with Amazon Aurora or PostgreSQL RDS, including configuration, monitoring, and optimization in AWS cloud environments
• Deep expertise in PostgreSQL versions 14, 15, 16, or 17, including advanced features such as partitioning ( pg_partman ), indexing strategies, and performance tuning (ANALYZE, VACUUM, autovacuum optimization)
• Strong understanding of AWS networking concepts as they relate to database connectivity, security groups, and VPC configurations
• Demonstrated ability to design relational database schemas following normalization principles and performance best practices
• Proficiency with Linux command line
• Familiarity with pgAdmin4 and psql for database management and scripting
• Independent worker with excellent communication skills and ability to translate technical concepts for non-technical stakeholders

Preferred Skills:

• Experience implementing and managing connection pooling solutions for high-concurrency applications
• Experience implementing row-level security and advanced PostgreSQL security features
• Advanced SQL proficiency , including complex queries with CTEs, window functions, and query performance tuning and optimization
• Experience with scripting for database automation and ETL processes
• Proficiency with Docker containerization and CI/CD tools (Gitlab, ArgoCD )
• Background in technical operations at DOD agencies working on-site in secure spaces
• CompTIA Security+ certification

What is ideal?

• Experience with PostGIS for geospatial data management
• Experience designing and implementing database replication, read replicas, and distributed database architectures (sharding)
• Proven track record with database migration tools such as Liquibase, Flyway, or golang-migrate in production environments
• Solid experience with infrastructure as code tools (AWS CDK/CloudFormation, or Terraform) for database infrastructure automation
• Experience with Kubernetes for database deployments
• Intelligence Community Experience preferred

What you can expect from us

• Recognizing great achievements do not go unnoticed by bcore through service anniversaries, spot awards, and employee referral bonuses
• You'll join a growing organization of passionate, top-shelf, IT engineering professionals with extensive experience in actively developing the technology revolution in the Intelligence community
• Highlights of our benefits include Health/Dental/Vision, 401(k) match and potential Profit Sharing, Universal Leave, STD/LTD/Life Insurance/Voluntary Life Insurance, Stipends, Referral Bonuses, and more!
• Compensation is unique to each candidate and compensation packages are based on education, experience, and other requirements.

BCore is proud to be an equal opportunity workplace. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, sexual orientation or any other characteristic protected by law.