Postgre SQL Database Administrator

MetaPhase; Washington (District of Columbia); On-site; USD 110,000 - 125,000; Full time

Benefits offered by this job

Generous PTO

Federal holidays

Parental leave

Comprehensive health coverage

401(k) with company match

Commuter benefits

Job summary

MetaPhase is seeking a Database Administrator (DBA) to support the U.S. Department of Homeland Security in its Financial Systems Modernization efforts.

You will secure and maintain enterprise databases across Oracle, Microsoft SQL Server, and PostgreSQL, with AWS-hosted environments and a focus on security per federal frameworks. You will design and optimize database solutions, oversee complex data migrations, and collaborate with security teams to ensure DHS enterprise architecture alignment.

Qualifications

• 3+ years leading data modeling, warehousing and migration projects.
• 4+ years of hands-on experience with AWS RDS.
• 3+ years with Oracle and/or Microsoft SQL Server.
• 2+ years of SQL development using WebADIs and APIs.
• Experience in enterprise data integration / ETL.
• Bash scripting; familiarity with Linux.
• SFTP / file transfer protocols.
• Familiarity with Apache Airflow / AWS Glue.

Responsibilities

• Design, implement, and secure database solutions in support of the FSM program.
• Oversee data warehousing, ETL, and migration activities from legacy financial systems.
• Participate in day-to-day operations of AWS-based relational database services (RDS), Oracle, SQL Server, and PostgreSQL environments.
• Ensure database security and compliance per FISMA/NIST standards.
• Utilize Informatica tools to support data integration, quality assurance, and migration tasks.
• Develop and optimize SQL queries, APIs, and WebADIs for performance.
• Implement backup, recovery, and high-availability strategies.
• Collaborate with security teams to align with enterprise policies.
• Monitor performance, troubleshoot issues, and mitigate data access risks.

Skills

Data modeling

Data warehousing

Data migration

SQL development

APIs

WebADIs

Bash scripting

Linux

SFTP

ETL

Apache Airflow

AWS Glue

Education

Bachelor’s degree in Information Systems, IT Management, or related field

Tools

AWS RDMS

Oracle

SQL Server

PostgreSQL

Job description

Description

At MetaPhase, we believe Quirky is Cool and being authentic is the only way to be! We take the work we do very seriously and do a lot of important mission-focused work for our clients. We are individuals with different passions and strengths who take as much joy in the work we do as from those we work with. Today, we have a team that is invested in creating new solutions that lean forward, challenge the status quo, but also reflect our intimate knowledge of our customers’ business. Over the years we have fostered a culture in which we are united by shared values - passion, solidarity, generosity, curiosity, and boldness and these come alive in the work we do and how we do it.

At MetaPhase, we believe Quirky is Cool and being authentic is the only way to be! We take the work we do very seriously and do a lot of important mission-focused work for our clients. We are individuals with different passions and strengths who take as much joy in the work we do as from those we work with. Today, we have a team that is invested in creating new solutions that lean forward, challenge the status quo, but also reflect our intimate knowledge of our customers’ business. Over the years we have fostered a culture in which we are united by shared values - passion, solidarity, generosity, curiosity, and boldness and these come alive in the work we do and how we do it.

Together, we know our people are our difference—for our clients and our colleagues.

Are you ready to:

• Work alongside a dedicated and diverse set of people to offer honest advice and practical guidance to our clients?
• Learn and grow by taking advantage of every opportunity available to you?
• Be the difference and make it happen?

MetaPhase is seeking a Database Administrator (DBA) to support the U.S. Department of Homeland Security (DHS) in its Financial Systems Modernization (FSM) efforts. This role is responsible for securing enterprise database systems across Oracle, Microsoft, and PostgreSQL platforms, ensuring performance, integrity, and compliance with DHS enterprise architecture standards. The DBA will play a role in supporting complex data migration, modeling, and integration activities using AWS-hosted environments, while embedding security best practices aligned to federal cybersecurity frameworks.

What You Will Be Doing:

• Design, implement, secure, and maintain robust database solutions in support of a FSM program.
• Oversee database architecture that supports complex data warehousing, ETL, and migration activities from legacy financial systems.
• participate in day-to-day operations of AWS-based relational database services (RDS), Oracle, Microsoft SQL Server, and PostgreSQL environments.
• Ensure database security and compliance in line with federal information security standards (FISMA, NIST 800-53).
• Leverage Informatica IICS, PowerCenter, and IDQ tools to support data integration, quality assurance, and migration tasks.
• Develop and optimize SQL queries, APIs, and WebADIs to enhance performance and streamline data access across platforms.
• Implement and monitor database backup, recovery, and high availability strategies.
• Collaborate with technical and security teams to ensure alignment with DHS' common operating environment and enterprise architecture policies.
• Monitor performance, troubleshoot issues, and proactively mitigate risks related to data access and integrity.
• Support audits and maintain compliance documentation for cybersecurity controls.

What We Need From You (Required):

• U.S. Citizenship required (NO EXCEPTIONS)
• 3+ years leading data modeling, warehousing, and migration activities
• 4+ years of hands-on experience with AWS RDMS
• 3+ years working with Oracle and/or Microsoft SQL Server
• 2+ years of SQL development experience using WebADIs and APIs
• Enterprise data integration / ETL
• Bash scripting (or equivalent)
• SQL (PostgreSQL / Oracle)
• Apache Airflow / AWS Glue (likely to be the new solution)
• Familiarity with Linux
• SFTP / file transfer protocols

Bonus Points (Desired):

• Familiarity with SAP S/4HANA data landscapes and integration patterns

Work Setup & Travel:

• Hybrid - Based in Washington, DC. Occasional travel may be required.

Clearance & Education:

• Must be able to obtain Public Trust
• Bachelor’s degree in Information Systems, IT Management, or related field

Benefits & Perks:

At MetaPhase, we care about your well-being and success. Our benefits include generous PTO, federal holidays, parental leave, and comprehensive health coverage (medical, dental, vision, life, and disability). We also offer a 401(k) with company match, FSA/HSA options, commuter benefits, and much more.

Compensation:

Compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range for this role in the U.S. is $110k - $125k.

About MetaPhase

MetaPhase is different with a purpose - demonstrating a new approach to the industry that puts employees and culture first! We continue to be recognized by industry as one of the fastest growing and most impactful consultancies in the nation, and are aggressively hiring to grow our team:

Best Places to Work

• Washington Post Top Workplaces - 2022, 2023
• Washington's Business Journal’s Best Places to Work - 2021, 2022
• Virginia Businesses Best Place to Work - 2021, 2022, 2023
• Northern Virginia Technology Council Top 100 Technology Firms - 2020

MetaPhase is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, national origin, disability or veteran status, or any other factors protected by federal, state, or local law.