PostgreSQL DBA

C Mack Solutions LLC

11h • Remote

About The Position

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.

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

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level