PostgreSQL Database Architect

Crimson Phoenix

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

Qualifications

  • Current and Active Top Secret SCI with Polygraph required.
  • Bachelor's Degree in Computer Science or related technical discipline or equivalent experience.
  • 5+ years of database analysis and/or administration experience.
  • Proficient in PostgreSQL administration and tuning.
  • CompTIA Security+ certification or equivalent experience.
  • Experience in database migration from Oracle, MySQL, and PostgreSQL.

Responsibilities

  • Manage functionality and efficiency of server groups across operating systems.
  • Maintain database integrity and security; configure role-based access control.
  • Document configurations, standards, and procedures thoroughly.
  • Interact with users and evaluate vendor products for suitability.
  • Develop and monitor computing resource policies and standards.
  • Implement testing strategies and document results effectively.
  • Collaborate with developers on schema design and performance optimization.

Benefits

  • Comprehensive medical, dental, and vision insurance.
  • 401(k) with company match.
  • Generous paid time off policy.
  • Company-paid life and disability insurance.
  • Tuition reimbursement and professional development opportunities.
  • Employee recognition programs and wellness benefits.
Full Job Description
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.


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 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 PostgresSQL.


Desired Skills

Nice to Have:

  • Oracle database administration.


Additional Details

Compensation & Benefits: This position has an anticipated salary range of $112,840 - $142,600 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.

Similar Jobs

More Jobs at Crimson Phoenix

More Information Technology Jobs

Find similar PostgreSQL Database Architect jobs: