PostgreSQL Database Architect

B CORE LLC
St. Louis, United States of America
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 139K

Job location

St. Louis, United States of America

Tech stack

Systems Engineering
CompTIA Security+
Databases
Database Analysis
IT Management
PostgreSQL
MySQL
Open Source Technology
Oracle
Oracle Applications
Performance Tuning
Query Optimization
Role-Based Access Control
Cloud Services
Software Engineering
SQL Stored Procedures
Strategies of Testing
Database Migration
Information Technology
Database Backup
Devsecops

Job description

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 as a PostgreSQL Database Architect, supporting the NGA customer mission.

What you get to do every day:

  • 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.
  • Manages the functionality and efficiency of a group of servers running on one or more operating systems.
  • Maintains database integrity and security, configures role-based access control (RBAC), and sets up administrative accounts.
  • Sets up administrator and service accounts.
  • Maintain documentation for configurations, standards, and procedures.
  • Maintains current knowledge of relevant technologies as assigned.
  • 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

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

Certification Required: CompTIA Security+ or equivalent recommended

Requirements

  • Requires Bachelor's degree in a Computer Science or related technical discipline, or the equivalent combination of education, technical certifications or training, or work experience
  • 5 + years of related database analysis and/or administration experience, * PostgreSQL experience required. Oracle database administration a plus.
  • Experience in PostgreSQL administration/tuning; including knowledge and implementation of database high-availability solutions and performance tuning
  • 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
  • Migration experience with PostgreSQL, Oracle and MySQL

What is ideal?

  • CompTIA Security+ or equivalent recommended.

  • Intelligence Community Experience preferred

  • 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

Benefits & conditions

  • The expected salary range within the Washington, DC metropolitan area is: $113,000-$139,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), Paid Time Off, STD/LTD/Life Insurance/Voluntary Life Insurance, Stipends, Referral Bonuses, and more.

Apply for this position