PostgreSQL Database Administrator

Niyam IT

PostgreSQL Database Administrator managing database solutions in a federal environment for Niyam. Collaborating with multiple teams to ensure database efficiency and integrity for operational success.

Posted 5/2/2026full-timeAshburn • Virginia • 🇺🇸 United StatesSeniorLeadWebsite

Tech Stack

Tools & technologies

AWSCloudETLInformaticaOraclePostgres

About the role

Key responsibilities & impact

Build ERD, physical and logical data models.
Follow and establish DB standards.
Understand PostgreSQL architecture.
Upgrade PostgreSQL Databases.
Support the Functional Business, Application Development, and Security Technical Teams to provide O&M and Release Management support for landscape components.
Integrate and support cloud RDS Databases providing high availability backup.
Participate in the design activities consistent with enterprise standards and Agency priorities for continuous improvement (e.g.: Robotics Process Automation, Automated Testing, etc.) to deliver value-added solutions.
Participate proof of concept in new technologies.
Design, develop and implement approaches for historical data retention and archival storage backup and recovery solutions.
Work in a collaborative team environment with other operational (e.g. OS, DBA, network, security, etc.) team members to troubleshoot and optimize performance.
Write triggers and functions to support ETL.
Migrate data across heterogenous Databases.
Work on AWS services specifically AWS DMS, RDS, Lambda, S3.
Work on performance insight AWS service.
Work with Informatica ETL tool.

Requirements

What you’ll need

US Citizenship with ability to obtain a Public Trust.
Bachelor’s degree in Computer Science, Software Engineering, Information Management Systems or a related discipline (equivalent professional experience may be considered in lieu of degree).
At least seven (7) years of technical experience.
Five (5)+ years of experience as Database Administrator and Developer in PostgreSQL and Oracle environments.
At least (2) Two years of AWS DMS service experience.
Familiarity with RDS upgrades.
Experience working on AWS performance insight.
Strong analytical and problem-solving skills to provide expertise to support application team.
Strong written communication skills to document implemented solutions or workarounds.
Good understanding of physical and logical data modeling.
Capable of working in a team environment and collaborating with other teams like platform support, developers, production support etc..
Experience utilizing performance monitoring tools to work with application developers to identify and correct inefficient database operations.
Database Migration experience strongly preferred, especially Oracle to PostgreSQL.
AWS RDS experience especially Aurora.
Experience working with AWS services such as S3 AND Lambda.
Strong programming background for writing triggers, functions and procedures.
Must be available for Production on-call support.

Benefits

Comp & perks

Flexible Work Hours : Life doesn’t always fit into a 9-to-5 schedule. We offer flexibility to help you manage your work-life balance effectively.
Remote Work : Niyam understands the value of flexibility. We offer remote work.
Career Growth : Niyam is not just a job; it’s a career journey. We provide a supportive environment for your professional development and offer fully paid opportunities for training and advancement within the company.
Great People : Our people are the blueprint of who Niyam is to the industry and community.
Great Environment : Niyam fosters a great environment where innovation, collaboration, and personal growth thrive.
Diversity & Inclusion : We believe in the strength of diverse perspectives. Your unique ideas are welcomed and celebrated every day at Niyam.

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

PostgreSQLOracleETLdata modelingdata migrationRobotics Process AutomationAutomated Testingbackup and recovery solutionstriggersfunctions

Soft Skills

analytical skillsproblem-solving skillswritten communicationteam collaboration

Certifications

Bachelor’s degree in Computer ScienceBachelor’s degree in Software EngineeringBachelor’s degree in Information Management Systems