PostgreSQL DBA at C Mack Solutions LLC

, Virginia, United States -

Full Time

Start Date

Immediate

Expiry Date

23 Jul, 26

Salary

0.0

Posted On

24 Apr, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

PostgreSQL, AWS, ETL, Database Administration, Oracle, AWS DMS, RDS, Informatica, Data Modeling, Performance Tuning, SQL, AWS Lambda, S3, Release Management, Agile

Industry

IT Services and IT Consulting

Description

Description C. Mack Solutions is seeking a PostgreSQL DBA with strong ETL and AWS Experience to join our team and support a complex program to provide Agile development and operations and maintenance for critical systems on a mission-critical program for the Federal Government.The ability to be adaptable and to work constructively with a technically diverse and geographically separated team is crucial. You should have worked in PostgreSQL DBA experience, ETL tool to understand concepts and supported RDS in AWS environment. Responsibilities: 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 You must live within the DC, MD, VA area. U.S. Citizenship is required. Candidate must be able to obtain CBP Public Trust clearance. College degree (B.S.) in Computer Science, Software Engineering, Information Management Systems or a related discipline 7-10 years of technical experience A minimum of 5 years of experience as Database Administrator and Developer in PostgreSQL and Oracle environment A minimum of 2 years of AWS DMS service experience Must be familiar with RDS upgrades Must have worked 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 modelling 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

Responsibilities

The PostgreSQL DBA will manage and maintain mission-critical database systems, including performing upgrades, migrations, and performance optimization. They will collaborate with cross-functional teams to support cloud-based RDS environments and implement data retention and archival solutions.