PostgreSQL Database Architect

D2 Technical Services
Springfield, VA, United States
24 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Compensation
$130,000.0 - $140,000.0
Working hours
Regular working hours

Tech stack

CompTIA Security+ Databases Database Analysis PostgreSQL MySQL Open Source Technology Oracle Databases Oracle (Applications) Performance Tuning Query Optimization Role-Based Access Control SQL Stored Procedures
+4 more
Strategies of Testing Database Migration Information Technology Database Backup

Job description

D2 has an immediate need for a PostgreSQL Database Architect to analyze, design, develop, implement, and support database infrastructure deployment and management., * 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, administers, and services 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
  • Maintains current knowledge of relevant technologies as assigned
  • Evaluates open-source or vendor tools and participates in database migration/special modernization projects
  • Collaborates with developers on schema design, query optimization, and stored procedures
  • Plans and executes database upgrades, patching, and migrations
  • Ensures compliance with industry standards and regulatory requirements

Requirements

  • 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 related database analysis and/or administration experience
  • PostgreSQL experience required. Oracle database administration is 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 Oracle, MySQL, and PostgreSQL,
  • TS/SCI clearance

Bonus Points For:

  • CompTIA Security+ or equivalent

Benefits & conditions

  • Compensation is unique to each candidate and relative to the skills and experience they bring to the position. The salary range for this position is typically $130 - $140k. This does not guarantee a specific salary as compensation is based upon multiple factors such as education, experience, certifications, and other requirements, and may fall outside of the above-stated range.
  • Highlights of our benefits include Health/Dental/Vision, 401(k) match, Accrued PTO, STD/LTD/Life Insurance, Referral Bonuses, professional development reimbursement, and more!

About the company

D2 Technical Services is committed to a merit-based recruitment process and encourages applications from all qualified individuals. As a Veteran-Owned Small Business, we particularly welcome applications from veterans who have the requisite skills and experience. Job applicants that are interested in one of our openings and may require a reasonable accommodation to participate in the job application or interview process, should contact us to request an accommodation.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.clearancejobs.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

1:32 min

Live migration to PostgreSQL for relational analytics features

Josip Stuhli Josip Stuhli · WWC 2023

1:25 min

Advantages of migrating search infrastructure to PostgreSQL

Dharin Shah Dharin Shah · WWC 2025

2:18 min

Scaling MySQL databases for massive user growth

Johannes Nicolai Johannes Nicolai +1 · LIVE

3:04 min

Database evolution and the funding behind vector databases

Erik Bamberg · LIVE

2:09 min

Setting up Konveyor AI and PostgreSQL locally

Daniel Oh Daniel Oh · WWC 2024

1:54 min

Provisioning databases automatically via Dev Services

Alex Soto Alex Soto · WWC 2022

Videos

See all

Related articles

See all