Database Architect II - Postgres with Security Clearance - Alpha Omega Integration LLC
Vienna, VA 22180
About the Job
Job Title: Database Architect II - Postgres
Clearance Required: Public Trust - Federal Client requires US Citizenship
Work Location: Remote, Arlington, VA Alpha Omega is seeking a qualified Database Architect II - Postgres for a remote position on a Federal program in Arlington, Virginia. Key Responsibilities: * Responsible for designing, creating, and managing large-scale databases used to store and organize vast amounts of digital information. Possess expertise in database technologies, data modeling, and information management. They work closely with organizations to understand their data requirements, ensuring that databases are structured efficiently, securely, and in a way that facilitates optimal performance.
* As a PostgreSQL architect you will be responsible for designing, implementing, and managing the infrastructure and database systems using PostgreSQL.
* Participate in daily stand-ups, bi-weekly sprint planning, and sprint retrospectives for the team
* Participate in root cause analysis and blameless post-mortems
* Provide competent leadership and highly specialized/technical guidance to complex Database Administration challenges.
* Has detailed specialized experience in recent or rare technologies.
* Simultaneously plan, manage, and provide technical oversight for other database administrators.
* Work in cross functional domain of data analyst and database administrator.
* Supports users by resolving problems with application databases.
* Provide direction to junior Database Administrators.
* Coordinate with the Program Manager and Assistant Program Manager to ensure problem resolution and customer satisfaction.
* Provide expert support for production application databases with respect to availability, reliability, and integrity.
* Work with application developers and their logical data models, create physical application database designs which conform to industry standards (e.g., data normalization), optimize performance and efficiently utilize disk space, size tables and indexes for production implementation based on projected row counts provided by applications.
* Create complex new databases and application database objects (e.g., tables, indexes, procedures), and as requirements change, update data structures/objects in existing databases.
* Coordinate production database deployment including tasks to promote database objects between environments (e.g., test to production) in support of application requirements.
* Provide technical leadership to Application developers in database capabilities and features, build efficient queries, database design, application database Problem resolution, and the use of database utilities.
* Determine and implement appropriate application database backup and recovery strategies, including decisions regarding frequency of backup and procedures for recovering application database Changes.
* Perform production database recovery when necessary. Required Qualifications: Education: * Bachelor's degree or higher in Computer Science, Information Technology, or equivalent field
Experience/Skills: * Federal Client requires US Citizenship.
* At least 5 years' experience architecting PostgreSQL
* Advanced knowledge of networking concepts, object-oriented technology, data warehousing, and relational database engines (e.g., Oracle, SQL Server).
* Advanced proficiency in analytical, project planning, negotiating, interpersonal, and communication skills (written and oral).
* Excellent Oral and Written communication skills
* Knowledge in implementing and managing DevOps tools such as GitHub ES,
* Experience in React.js and its core principles such as React patterns, state management libraries (such as Flux or Redux), Props drilling, data sharing among React components
* Knowledge in Azure cloud monitoring tools, application performance monitoring tools, and operational dash-boarding
* Experience with Azure solutions such as App Services, App Insights, Storage Accounts, Resource Groups, and monitoring tools, etc.
* Ensure SLA's & operational KPI's are met, working as necessary with internal and external support functions when major incidents occur.
Preferred Qualifications: * Worked in an agile environment as part of an agile product team
Salary and Benefit Information: The likely salary range for this position is $88,501 - $110,000. This is not, however, a guarantee of compensation or salary. There are multiple factors that are considered in determining final pay for a position, including, but not limited to, relevant work experience, skills, certifications and competencies that align to the specified role, education and certifications as well as contract provisions regarding labor categories that are specific to the position and could fall outside of this range. Application Deadline: August 20, 2025 Joining the Alpha Omega team entitles you to participate in all retirement benefits, plans of deferred compensation, health and insurance benefits, and other such benefits as set forth in the company's policy and benefits manuals. See below, to name a few: * PTO including paid parental, military, and bereavement leave
* Eleven (11) paid Federal holidays, five of which are floating holidays (as designated by the company's holiday schedule each year)
* Health and Dental Insurance (including 100% employer paid premiums for employee coverage under the HDHP health plan)
* Life Insurance, STD/LTD term disability coverage, with employer paid premiums
* 401 (k) plan with a match that is 100% vested after you complete two years of service
* FSA/DFSA/HSA flexible benefit plans
* Annual Tuition & Professional Development Reimbursement benefit
We regularly review our Total Rewards package to ensure our offerings are competitive and reflect what our employees have told us they value most. Culture and Values: Guided by our core values-Harmony, Engagement, Accountability, Resourcefulness, and Tenacity (HEART)- we foster a culture of innovation, collaboration, and continuous learning and are committed to delivering high-impact solutions. We recognize and reward hard work. Through our H.E.A.R.T. Awards Program, colleagues and managers can recognize each other for actions that exemplify these values. Recognized employees receive a detailed nomination highlighting their contributions, which is shared with their manager. Each quarter, select nominees have the opportunity to receive a monetary bonus as an extra thank-you for their impact. Our Company: Alpha Omega is an award-winning Federal IT solutions provider dedicated to delivering mission-enabling technology and strategic solutions across the National Security, Federal Financial, Healthcare, and Space & Science domains. Since our founding in 2016, we have grown to over 800 employees nationwide with $230m in revenue. With the January 2025 acquisitions of SeKON and Macro Solutions, we have expanded our capabilities to further support our customers in digital modernization, artificial intelligence, and cybersecurity. We are committed to supporting our agency partners as they transform their operations, delivering on our purpose to ensure the safety, security, and well-being of future generations: * National Security - Supporting agencies such as the Department of Homeland Security (DHS) and the Department of State. * Federal Financial - We bring deep expertise in enterprise financial systems, supporting agencies like the Securities and Exchange Commission (SEC) and the Federal Deposit Insurance Corporation (FDIC). * Healthcare - Our Health IT capabilities, enhance health outcomes for the warfighter via the Defense Health Agency (DHA) and support public health initiatives at the Centers for Disease Control and Prevention (CDC), National Institutes of Health (NIH), and the Substance Abuse and Mental Health Services Administration (SAMHSA). * Space & Science - We leverage technology to advance agricultural sustainability, secure our nation's food supply, and prepare for natural disasters, working with the National Oceanic and Atmospheric Administration (NOAA) and the United States Department of Agriculture (USDA). Through strategic partnerships, intellectual property, and relentless drive for innovation, Alpha Omega is shaping the future of government technology. We are proud to be a Virginia Best Places to Work 8 times, an Inc. 5000 honoree 7 times, and a Washington Post Top Workplaces 4 times. Join us in driving transformation that secures the nation's future. Alpha Omega Integration, LLC (Alpha Omega) is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other protected class.
Clearance Required: Public Trust - Federal Client requires US Citizenship
Work Location: Remote, Arlington, VA Alpha Omega is seeking a qualified Database Architect II - Postgres for a remote position on a Federal program in Arlington, Virginia. Key Responsibilities: * Responsible for designing, creating, and managing large-scale databases used to store and organize vast amounts of digital information. Possess expertise in database technologies, data modeling, and information management. They work closely with organizations to understand their data requirements, ensuring that databases are structured efficiently, securely, and in a way that facilitates optimal performance.
* As a PostgreSQL architect you will be responsible for designing, implementing, and managing the infrastructure and database systems using PostgreSQL.
* Participate in daily stand-ups, bi-weekly sprint planning, and sprint retrospectives for the team
* Participate in root cause analysis and blameless post-mortems
* Provide competent leadership and highly specialized/technical guidance to complex Database Administration challenges.
* Has detailed specialized experience in recent or rare technologies.
* Simultaneously plan, manage, and provide technical oversight for other database administrators.
* Work in cross functional domain of data analyst and database administrator.
* Supports users by resolving problems with application databases.
* Provide direction to junior Database Administrators.
* Coordinate with the Program Manager and Assistant Program Manager to ensure problem resolution and customer satisfaction.
* Provide expert support for production application databases with respect to availability, reliability, and integrity.
* Work with application developers and their logical data models, create physical application database designs which conform to industry standards (e.g., data normalization), optimize performance and efficiently utilize disk space, size tables and indexes for production implementation based on projected row counts provided by applications.
* Create complex new databases and application database objects (e.g., tables, indexes, procedures), and as requirements change, update data structures/objects in existing databases.
* Coordinate production database deployment including tasks to promote database objects between environments (e.g., test to production) in support of application requirements.
* Provide technical leadership to Application developers in database capabilities and features, build efficient queries, database design, application database Problem resolution, and the use of database utilities.
* Determine and implement appropriate application database backup and recovery strategies, including decisions regarding frequency of backup and procedures for recovering application database Changes.
* Perform production database recovery when necessary. Required Qualifications: Education: * Bachelor's degree or higher in Computer Science, Information Technology, or equivalent field
Experience/Skills: * Federal Client requires US Citizenship.
* At least 5 years' experience architecting PostgreSQL
* Advanced knowledge of networking concepts, object-oriented technology, data warehousing, and relational database engines (e.g., Oracle, SQL Server).
* Advanced proficiency in analytical, project planning, negotiating, interpersonal, and communication skills (written and oral).
* Excellent Oral and Written communication skills
* Knowledge in implementing and managing DevOps tools such as GitHub ES,
* Experience in React.js and its core principles such as React patterns, state management libraries (such as Flux or Redux), Props drilling, data sharing among React components
* Knowledge in Azure cloud monitoring tools, application performance monitoring tools, and operational dash-boarding
* Experience with Azure solutions such as App Services, App Insights, Storage Accounts, Resource Groups, and monitoring tools, etc.
* Ensure SLA's & operational KPI's are met, working as necessary with internal and external support functions when major incidents occur.
Preferred Qualifications: * Worked in an agile environment as part of an agile product team
Salary and Benefit Information: The likely salary range for this position is $88,501 - $110,000. This is not, however, a guarantee of compensation or salary. There are multiple factors that are considered in determining final pay for a position, including, but not limited to, relevant work experience, skills, certifications and competencies that align to the specified role, education and certifications as well as contract provisions regarding labor categories that are specific to the position and could fall outside of this range. Application Deadline: August 20, 2025 Joining the Alpha Omega team entitles you to participate in all retirement benefits, plans of deferred compensation, health and insurance benefits, and other such benefits as set forth in the company's policy and benefits manuals. See below, to name a few: * PTO including paid parental, military, and bereavement leave
* Eleven (11) paid Federal holidays, five of which are floating holidays (as designated by the company's holiday schedule each year)
* Health and Dental Insurance (including 100% employer paid premiums for employee coverage under the HDHP health plan)
* Life Insurance, STD/LTD term disability coverage, with employer paid premiums
* 401 (k) plan with a match that is 100% vested after you complete two years of service
* FSA/DFSA/HSA flexible benefit plans
* Annual Tuition & Professional Development Reimbursement benefit
We regularly review our Total Rewards package to ensure our offerings are competitive and reflect what our employees have told us they value most. Culture and Values: Guided by our core values-Harmony, Engagement, Accountability, Resourcefulness, and Tenacity (HEART)- we foster a culture of innovation, collaboration, and continuous learning and are committed to delivering high-impact solutions. We recognize and reward hard work. Through our H.E.A.R.T. Awards Program, colleagues and managers can recognize each other for actions that exemplify these values. Recognized employees receive a detailed nomination highlighting their contributions, which is shared with their manager. Each quarter, select nominees have the opportunity to receive a monetary bonus as an extra thank-you for their impact. Our Company: Alpha Omega is an award-winning Federal IT solutions provider dedicated to delivering mission-enabling technology and strategic solutions across the National Security, Federal Financial, Healthcare, and Space & Science domains. Since our founding in 2016, we have grown to over 800 employees nationwide with $230m in revenue. With the January 2025 acquisitions of SeKON and Macro Solutions, we have expanded our capabilities to further support our customers in digital modernization, artificial intelligence, and cybersecurity. We are committed to supporting our agency partners as they transform their operations, delivering on our purpose to ensure the safety, security, and well-being of future generations: * National Security - Supporting agencies such as the Department of Homeland Security (DHS) and the Department of State. * Federal Financial - We bring deep expertise in enterprise financial systems, supporting agencies like the Securities and Exchange Commission (SEC) and the Federal Deposit Insurance Corporation (FDIC). * Healthcare - Our Health IT capabilities, enhance health outcomes for the warfighter via the Defense Health Agency (DHA) and support public health initiatives at the Centers for Disease Control and Prevention (CDC), National Institutes of Health (NIH), and the Substance Abuse and Mental Health Services Administration (SAMHSA). * Space & Science - We leverage technology to advance agricultural sustainability, secure our nation's food supply, and prepare for natural disasters, working with the National Oceanic and Atmospheric Administration (NOAA) and the United States Department of Agriculture (USDA). Through strategic partnerships, intellectual property, and relentless drive for innovation, Alpha Omega is shaping the future of government technology. We are proud to be a Virginia Best Places to Work 8 times, an Inc. 5000 honoree 7 times, and a Washington Post Top Workplaces 4 times. Join us in driving transformation that secures the nation's future. Alpha Omega Integration, LLC (Alpha Omega) is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other protected class.
Source : Alpha Omega Integration LLC