Senior PostgreSQL Database Engineer
About The Position
Bcore is hiring a Senior PostgreSQL Database Engineer to support the NGA customer mission. The role combines hands-on PostgreSQL administration with database engineering and architecture. The engineer will serve as the team’s primary database subject matter expert, partnering with software developers and systems engineers to maintain reliable operations and improve database performance, design, security, and maintainability. The environment uses PostgreSQL for transactional and analytical workloads and OpenShift for application deployment. The position involves independently troubleshooting operational issues and recommending and implementing improvements to database design, deployment, monitoring, and maintenance. The role is based in Springfield, Virginia, or St. Louis, Missouri, and requires an active TS clearance with SCI eligibility and eligibility to obtain a CI polygraph.
Requirements
- Active TS clearance with SCI eligibility and eligibility to obtain a CI polygraph.
- Bachelor’s degree in Computer Science, Information Technology, or a related technical discipline, or equivalent education, training, certifications, and experience.
- At least 5 years of experience in database administration, database engineering, database architecture, or a related technical discipline.
- Hands-on experience administering and supporting PostgreSQL databases.
- Experience with relational database design, data modeling, SQL, schema development, indexing, and query optimization.
- Experience troubleshooting database issues and managing database users, roles, permissions, and configurations.
- Experience with database backups, restores, upgrades, and routine maintenance.
- Working knowledge of database high availability, replication, and disaster recovery concepts.
- Ability to collaborate with developers and infrastructure engineers to resolve technical issues and improve system performance.
- Strong analytical, troubleshooting, documentation, and communication skills.
Nice To Haves
- CompTIA+ certification is preferred.
- Experience supporting PostgreSQL in OpenShift, Kubernetes, containerized, or Linux-based environments.
- Experience with PostgreSQL replication, failover, connection pooling, or high-availability technologies.
- Experience with database monitoring, logging, alerting, and performance diagnostics.
- Experience supporting transactional and analytical data workloads.
- Experience with database automation, scripting, infrastructure as code, or repeatable deployment practices.
- Experience planning and executing database migrations, upgrades, and modernization initiatives.
- Familiarity with database security practices in regulated or classified environments.
- Experience with Oracle database administration or Oracle-to-PostgreSQL migration.
- Intelligence Community experience.
Responsibilities
- Administer PostgreSQL database configuration, user accounts, roles, permissions, routine maintenance, patching, upgrades, and operational troubleshooting.
- Design and improve database architectures, schemas, data models, indexing strategies, and data access patterns.
- Analyze SQL queries and execution plans, identify performance bottlenecks, and improve queries, indexes, configuration, and resource utilization.
- Support PostgreSQL deployment, connectivity, configuration, monitoring, and operational integration with OpenShift-based systems.
- Implement and maintain backup and restore procedures, validate recovery processes, and support high availability, replication, and disaster recovery capabilities.
- Configure and maintain database monitoring, logging, alerting, capacity tracking, and operational reporting.
- Advise software developers on schema design, SQL development, transaction management, data access patterns, and database integration.
- Identify and implement improvements to database performance, reliability, scalability, and maintainability; evaluate appropriate tools and approaches.
- Plan and execute database upgrades, migrations, configuration changes, and modernization efforts while minimizing risk and service disruption.
- Document database architecture, configurations, security controls, operational procedures, and engineering practices.
- Maintain database security through access controls, least-privilege permissions, auditing, and practices aligned with customer and system requirements.
- Provide technical guidance as the primary database resource for the engineering team, supporting troubleshooting and database design and operations decisions.
Benefits
- Health, dental, and vision coverage.
- 401(k).
- Paid time off.
- Short-term disability, long-term disability, and life insurance, including voluntary life insurance.
- Stipends.
- Employee referral bonuses.
- Service anniversaries and spot awards.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
