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