Postgre SQL Database Administrator
Summary
Maintains and secures enterprise PostgreSQL, Oracle, and SQL Server databases for a DHS financial modernization program, including AWS RDS operations, ETL pipelines, and federal compliance.
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?
- 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.
- 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)
- 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
- Hybrid - Based in Washington, DC. Occasional travel may be required.
- Must be able to obtain Public Trust
- Bachelor’s degree in Information Systems, IT Management, or related field
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 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
- 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
#dice
#LI-Hybrid