PostgreSQL Database Architect

D2 Technical Services
Springfield, United States of America
3 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 140K

Job location

Springfield, United States of America

Tech stack

CompTIA Security+
Databases
Database Analysis
PostgreSQL
MySQL
Open Source Technology
Oracle
Oracle Applications
Performance Tuning
Query Optimization
Role-Based Access Control
SQL Stored Procedures
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