PostgreSQL Database Architect

D2 Consulting; St. Louis (MO); On-site; USD 125,000 - 135,000; Full time

Benefits offered by this job

Health/Dental/Vision

401(k) match

Accrued PTO

STD/LTD/Life Insurance

Referral Bonuses

Professional development reimbursement

Job summary

D2 Consulting seeks a PostgreSQL Database Architect in St. Louis, MO to analyze, design, implement, and support database infrastructure. The role emphasizes high-availability, security, and scalable data solutions for mission-critical applications.

The ideal candidate has a BS in CS or related field, 5+ years of PostgreSQL administration and tuning, experience with backups, migrations, RBAC, and an active TS/SCI clearance. On-site work with competitive compensation and benefits awaits.

Qualifications

• Bachelor’s degree or equivalent in CS or related field.
• 5+ years of database analysis/administration experience.
• Strong PostgreSQL experience and tuning.
• Backups, migrations, and snapshot technologies knowledge.
• Experience building efficient transactional and warehouse schemas.
• RBAC and security practices knowledge.
• Migration experience: Oracle, MySQL, PostgreSQL.
• Active TS/SCI clearance required.

Responsibilities

• Manage group of servers running on one or more operating systems.
• Maintain database integrity, RBAC, and admin accounts.
• Set up, administer, and service accounts.
• Maintain configuration docs and procedures.
• Collaborate with developers on schema design, queries, and stored procedures.
• Plan upgrades, patching, migrations.
• Ensure compliance with standards and regulations.
• Provide performance tuning advice and training to end-users.

Skills

PostgreSQL administration

Database tuning

High-availability databases

RBAC and security

Migration experience (Oracle/MySQL)/PG

Education

Bachelor’s degree in Computer Science or related

Tools

Oracle DB

MySQL

PostgreSQL

Job description

ACTIVE TS/SCI SECURITY CLEARANCE REQUIRED

D2 has an immediate need for a PostgreSQL Database Architect to analyze, design, develop, implement, and support database infrastructure deployment and management.

Responsibilities

• 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

What We're Looking For

Required

• 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

What to Expect Day-to-Day

You’ll work with moderate autonomy — trusted to manage your workload and make good technical decisions without someone looking over your shoulder. You’ll collaborate with developers and infrastructure teams, advise end-users on best practices, and participate in an on-call rotation for after-hours support. The work is varied, the problems are real, and the mission is meaningful.

Additional Information

• All your information will be kept confidential according to EEO guidelines.
• 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 $125 - $135k. 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!

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.