PostgreSQL Database Analyst

Bridge Core (BCore)

$80K — $110K *
Information Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • Active TS clearance with SCI eligibility required; CI Poly eligibility preferred.
  • Bachelor's degree in Computer Science or related field, or equivalent experience and training.
  • Minimum of 5 years of database analysis and administration experience.
  • Proven PostgreSQL experience, with Oracle database skills as a plus.
  • Knowledge of CompTIA Security+ or equivalent is recommended.

Responsibilities

  • Manage functionality and efficiency of database servers across operating systems.
  • Ensure integrity and security of the database with role-based access control and account setup.
  • Maintain comprehensive documentation of configurations and procedures.
  • Evaluate vendor products and interact with users for feedback.
  • Develop policies for computing resource allocation and monitor their compliance.
  • Execute testing strategies and document results effectively.
  • Collaborate with developers for schema design and query optimization.

Benefits

  • Recognition for achievements through awards and bonuses.
  • Join a team of experienced IT professionals in the Intelligence community.
  • Health, Dental, and Vision insurance provided.
  • 401(k) match to support your retirement planning.
  • Universal Leave, along with STD/LTD and Life Insurance options.
Full Job Description
Overview
PostgreSQL Database Analyst Springfield, VA OR Arnold, MO OR St. Louis, MO

Active TS (SCI eligibility) clearance and eligibility to obtain a CI poly

Do you want to join a team that is building tailored technical solutions to modernize our government27s mission and our client27s business? Do you have a desire to change how people work? Are you interested in helping to protect our nation27s cyber interests? Join our growing team supporting the NGA customer missions as a PostgreSQL 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 standardsand 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 Bachelor27s 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
  • You27ll 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, 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.

Similar Jobs

More Jobs at Bridge Core (BCore)

More Information Technology Jobs

Find similar PostgreSQL Database Analyst jobs: