PostgreSQL Database Analyst

Springfield, VA, US • Posted 15 hours ago • Updated 2 hours ago
Full Time
On-site
USD $125,800.00 - 170,200.00 per year
Fitment

Dice Job Match Score™

⭐ Evaluating experience...

Job Details

Skills

  • Servers
  • Operating Systems
  • Access Control
  • RBAC
  • Documentation
  • Testing
  • Open Source
  • Database Migration
  • Query Optimization
  • Stored Procedures
  • Regulatory Compliance
  • Computer Science
  • Training
  • Database Analysis
  • Security+
  • High Availability
  • Management
  • PostgreSQL
  • Backup
  • Recovery
  • Database
  • Warehouse
  • Performance Tuning
  • Migration
  • Oracle
  • MySQL
  • Oracle Database Administration
  • Insurance
  • Professional Development
  • Security Clearance
  • Law

Summary

Job Description

What You Will Be Doing:

  • Managing the functionality and efficiency of a group of servers running on one or more operating systems.
  • Maintaining database integrity and security, configuring role-based access control (RBAC), and setting up administrative accounts.
  • Setting up administrator and service accounts.
  • Maintaining documentation for configurations, standards, and procedures.
  • Interacting with users and evaluating vendor products.
  • Developing and monitoring policies and standards for allocation related to the use of computing resources.
  • Developing and implementing testing strategies and documenting results.
  • Providing advice on performance tuning and training to end-users.
  • Maintaining current knowledge of relevant technologies as assigned.
  • Evaluating open-source or vendor tools and participating in database migration/special modernization projects.
  • Collaborating with developers on schema design, query optimization, and stored procedures.
  • Planning and executing database upgrades, patching, and migrations.
  • Ensuring compliance with industry standards and regulatory requirements.
  • Participating in on-call rotations for after-hours support.

Required Skills

Must Have:

  • MUST HAVE a Current and Active Top Secret SCI with Polygraph, as the customer is NOT sponsoring clearances.
  • 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.
  • CompTIA Security+ or equivalent.
  • 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 PostgresSQL.

Desired Skills

Nice to Have:

  • Oracle database administration.

Additional Details

Compensation & Benefits: This position has an anticipated salary range of $125,800 - $170,200 per year. Actual compensation will be determined based on factors including experience, qualifications, skills, education, certifications, and business needs. Crimson Phoenix offers a comprehensive benefits package, including medical, dental, and vision insurance, a 401(k) with company match, generous paid time off, company-paid life and disability insurance, tuition reimbursement, professional development opportunities, employee recognition programs, and additional wellness and work-life benefits.

U.S. citizenship and the ability to obtain or maintain a security clearance may be required for certain positions.

Crimson Phoenix is an Equal Opportunity Employer. We make employment decisions without regard to race, color, religion, sex, national origin, age, disability, veteran status, or any other status protected by applicable law. Crimson Phoenix participates in E-Verify.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10441024
  • Position Id: 4009b338297ad68319518a18cfed9c52
  • Posted 15 hours ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Springfield, Virginia

Today

Full-time

USD 112,840.00 - 142,600.00 per year

Springfield, Virginia

Today

Full-time

USD 125,800.00 - 170,200.00 per year

Springfield, Virginia

Today

Full-time

Springfield, Virginia

Today

Full-time

USD 122,000.00 - 135,000.00 per year

Search all similar jobs