{"schemaVersion":"jobsearcher.job.v1","id":"f409fa88acfd4cef20949eee","url":"https://jobsearcher.com/jobs/f409fa88acfd4cef20949eee","canonicalUrl":"https://jobsearcher.com/jobs/f409fa88acfd4cef20949eee","title":"PostgreSQL Database Architect","description":"Job Description\n\nWhat You Will Be Doing:\nManaging the functionality and efficiency of a group of servers running on one or more operating systems.\nMaintaining database integrity and security, configuring role-based access control (RBAC), and setting up administrative accounts.\nSetting up administrator and service accounts.\nMaintaining documentation for configurations, standards, and procedures.\nInteracting with users and evaluating vendor products.\nDeveloping and monitoring policies and standards for allocation related to the use of computing resources.\nDeveloping and implementing testing strategies and documenting results.\nProviding advice on performance tuning and training to end-users.\nMaintaining current knowledge of relevant technologies as assigned.\nEvaluating open-source or vendor tools and participating in database migration/special modernization projects.\nCollaborating with developers on schema design, query optimization, and stored procedures.\nPlanning and executing database upgrades, patching, and migrations.\nEnsuring compliance with industry standards and regulatory requirements.\n\n,\nRequired Skills\n\nMust Have:\nMUST HAVE a Current and Active Top Secret SCI with Polygraph, as the customer is NOT sponsoring clearances.\nBachelor’s Degree in a Computer Science or related technical discipline, or the equivalent combination of education, technical certifications or training, or work experience.\n5 + years of related database analysis and/or administration experience.\nPostgreSQL experience.\nCompTIA Security+ or equivalent.\nExperience in PostgreSQL administration/tuning; including knowledge and implementation of database high-availability solutions and performance tuning.\nExperience in monitoring, creating, and managing PostgreSQL server agent alerts.\nExperience with Database backup, restore, migration, and Database snapshot technologies/strategies.\nKnowledge on how to build/maintain efficient database table structures for both transactional and warehouse data.\nMigration experience with Oracle, MySQL, and PostgresSQL.\n\n,\nDesired Skills\n\nNice to Have:\nOracle database administration.\n\n,\nAdditional Details\n\nCompensation & 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.\n\nU.S. citizenship and the ability to obtain or maintain a security clearance may be required for certain positions.\n\nCrimson 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.\n,\nAbout Crimson Phoenix\nCrimson Phoenix provides state of the art Information Technology & Intelligence solutions for the Federal Civilian Sector, Department of Defense, and Intelligence Community. We specialize in Web Development, Graphic Design, Software Engineering, System Engineering, Training, Intelligence Analysis, Data Science, and Instructional Systems Design.","company":"Crimson Phoenix","rawCompany":"crimson phoenix","city":"Fairfax","state":"VA","isRemote":false,"isActive":false,"createdAt":"2026-08-05T00:14:26.854Z","occupations":[{"code":"15-1242.00","title":"Database Administrators","slug":"database-administrators"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"541519","title":"Other Computer Related Services","slug":"other-computer-related-services"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"PostgreSQL Database Architect","description":"Job Description\n\nWhat You Will Be Doing:\nManaging the functionality and efficiency of a group of servers running on one or more operating systems.\nMaintaining database integrity and security, configuring role-based access control (RBAC), and setting up administrative accounts.\nSetting up administrator and service accounts.\nMaintaining documentation for configurations, standards, and procedures.\nInteracting with users and evaluating vendor products.\nDeveloping and monitoring policies and standards for allocation related to the use of computing resources.\nDeveloping and implementing testing strategies and documenting results.\nProviding advice on performance tuning and training to end-users.\nMaintaining current knowledge of relevant technologies as assigned.\nEvaluating open-source or vendor tools and participating in database migration/special modernization projects.\nCollaborating with developers on schema design, query optimization, and stored procedures.\nPlanning and executing database upgrades, patching, and migrations.\nEnsuring compliance with industry standards and regulatory requirements.\n\n,\nRequired Skills\n\nMust Have:\nMUST HAVE a Current and Active Top Secret SCI with Polygraph, as the customer is NOT sponsoring clearances.\nBachelor’s Degree in a Computer Science or related technical discipline, or the equivalent combination of education, technical certifications or training, or work experience.\n5 + years of related database analysis and/or administration experience.\nPostgreSQL experience.\nCompTIA Security+ or equivalent.\nExperience in PostgreSQL administration/tuning; including knowledge and implementation of database high-availability solutions and performance tuning.\nExperience in monitoring, creating, and managing PostgreSQL server agent alerts.\nExperience with Database backup, restore, migration, and Database snapshot technologies/strategies.\nKnowledge on how to build/maintain efficient database table structures for both transactional and warehouse data.\nMigration experience with Oracle, MySQL, and PostgresSQL.\n\n,\nDesired Skills\n\nNice to Have:\nOracle database administration.\n\n,\nAdditional Details\n\nCompensation & 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.\n\nU.S. citizenship and the ability to obtain or maintain a security clearance may be required for certain positions.\n\nCrimson 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.\n,\nAbout Crimson Phoenix\nCrimson Phoenix provides state of the art Information Technology & Intelligence solutions for the Federal Civilian Sector, Department of Defense, and Intelligence Community. We specialize in Web Development, Graphic Design, Software Engineering, System Engineering, Training, Intelligence Analysis, Data Science, and Instructional Systems Design.","datePosted":"2026-08-05T00:14:26.854Z","dateModified":"2026-08-05T00:14:26.854Z","hiringOrganization":{"@type":"Organization","name":"Crimson Phoenix","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Fairfax","addressRegion":"VA","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"f409fa88acfd4cef20949eee"},"url":"https://jobsearcher.com/jobs/f409fa88acfd4cef20949eee"}}