PostgreSQL Database Analyst with Security Clearance

B/CORE; Springfield (VA); On-site; USD 122,000 - 135,000; Full time

Benefits offered by this job

Health/Dental/Vision

401(k) match

Paid Time Off

STD/LTD/Life Insurance

Stipends

Referral Bonuses

Equal opportunity employer

Job summary

Bcore seeks a PostgreSQL Database Analyst to support NGA missions from Springfield, VA (or Arnold/ St. Louis, MO). Active TS clearance with SCI eligibility and CI poly is required. You’ll design, deploy, and manage SQL infrastructure, work with developers on schema, and drive modernization projects.

Responsibilities include server management, RBAC, backups, upgrades, migrations, and on-call support. 5+ years’ DB experience and a BS in CS are expected; Oracle 19c experience is a plus.

Qualifications

• Active TS clearance with SCI eligibility and CI poly.
• 5+ years of database analysis/administration experience.

Responsibilities

• Analyze, design, develop, implement, and support SQL infrastructure deployment and management.
• Manage functionality and efficiency of servers across one or more OSes.
• Configure RBAC, admin/service accounts, and maintain documentation.
• Plan upgrades, patches, migrations, and testing strategies.
• Collaborate with developers on schema design and query optimization.
• Evaluate vendor tools and perform database migrations.
• Ensure compliance with industry standards and participate in on-call rotations.

Skills

PostgreSQL

Oracle

DB tuning

Backup/Recovery

Database security

Performance monitoring

Education

Bachelor's degree in Computer Science or related field

Tools

PostgreSQL

Oracle 19c

Job description

Database Analyst Springfield, VA OR Arnold, MO OR St. Louis, MO Active TS (SCI eligibility) clearance and eligibility to obtain a CI poly 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's mission as a Database Analyst.

Responsibilities

What you get to do every day: As a PostgreSQL Database Analyst you will analyze, design, develop, implement, and support SQL infrastructure deployment and management. You will work under limited supervision and perform additional duties as assigned to include, but not limited to:

• Manages the functionality and efficiency of a group of servers running on one or more operating systems.
• Maintains the integrity and security, configures role-base access control (RBAC), and sets up administrative accounts
• Sets up administrator and service accounts.
• Maintain documentation for configurations, standards, and procedures.
• Interacts with users and evaluates vendor products.
• Develops and monitors policies and standards for allocation related to the use of computing resources.
• Develops and implements testing strategies and document results.
• Provides advice on performance tuning and training to end-users.
• Evaluates open-source or vendor tools and participates in database migration/special modernization projects.
• Collaborate with developers on schema design, query optimization, and stored procedures.
• Plan and execute database upgrades, patching, and migrations.
• Ensure compliance with industry standards and regulatory requirements.
• Participate in on-call rotations for after-hours support.

Qualifications

Clearance Required: Active TS clearance (with SCI Eligibility) and eligibility to obtain CI Poly.

Education/Experience

• Requires Bachelor's degree in Computer Science or related technical discipline, or the equivalent combination of education, technical certifications or training, or work experience
• 5+ years of of related database analysis and/or administration experience

Required Skills

• PostgreSQL experience required. Oracle database administration a plus.
• CompTIA Security+ or equivalent recommended
• Experience in PostgreSQL administration/tuning including knowledge and implementation of database high-availability solutions
• Experience in monitoring, creating, and managing PostgreSQL server agent alerts
• Experience with Database backup, restore, migration, and Database snapshot technologies/strategies
• Knowledge on how to build/maintain efficient database table structures for both transactional and warehouse data
• Knowledge of Oracle 19c administration and performance tuning
• Migration experience with Oracle, MySQL, and PostgreSQL

What is ideal?

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
• The expected salary range within the Washington, DC metropolitan area is: $122,000-$135,000. Final compensation is unique to each individual and will be determined based on factors such as experience, education, geographic location, and contractual requirements. This is not a guarantee.
• Benefits include Health/Dental/Vision, 401(k) match, Paid Time Off, STD/LTD/Life Insurance/Voluntary Life Insurance, Stipends, Referral Bonuses, and more.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.