Lead Cloud PostgreSQL Database Administrator

OverviewLocation: Springfield, VAClearance 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 clearancesAt 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 awardResponsibilitiesWhat 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 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 designoptimaldatabase schemas, implement row-level security, and develop efficient stored procedures and triggers.QualificationsClearance Required: Active TS clearance (with SCI Eligibility) and eligibility to obtain CI Poly We are not able to upgrade or sponsor clearancesEducation/Experience:Bachelor's Degree or equivalent combination of education, technical training, or work/military experience8+ years of experience in database administration with at least 5 years focused on PostgreSQL in production environmentsRequired Skills:Hands-on experience with Amazon Aurora or PostgreSQL RDS, including configuration, monitoring, and optimization in AWS cloud environmentsDeep 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 configurationsDemonstrated ability to design relational database schemas following normalization principles and performance best practicesProficiency with Linux command lineFamiliarity with pgAdmin4 and psql for database management and scriptingIndependent worker with excellent communication skills and ability to translate technical concepts for non-technical stakeholdersPreferred Skills:Experience implementing and managing connection pooling solutions for high-concurrency applicationsExperience implementing row-level security and advanced PostgreSQL security featuresAdvanced SQL proficiency, including complex queries with CTEs, window functions, and query performance tuning and optimizationExperience with scripting for database automation and ETL processesProficiency with Docker containerization and CI/CD tools (Gitlab, ArgoCD)Background in technical operations at DOD agencies working on-site in secure spacesCompTIA Security+ certificationWhat is ideal?Experience with PostGIS for geospatial data managementExperience 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 environmentsSolid experience with infrastructure as code tools (AWS CDK/CloudFormation, or Terraform) for database infrastructure automationExperience with Kubernetes for database deploymentsIntelligence Community Experience preferredWhat you can expect from usRecognizing great achievements do not go unnoticed by bcore through service anniversaries, spot awards, and employee referral bonusesYou'll join a growing organization of passionate, top-shelf, IT engineering professionals with extensive experience in actively developing the technology revolution in the Intelligence communityHighlights 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.J-18808-Ljbffr