Company Description: IMCS Group is one of the fastest growing MWBE (Minority Woman Owned Enterprise) staffing firms in the U.S. We focus on bringing a Diversity Recruitment approach to Fortune 500 companies within North America and EMEA region contingent labor programs. IMCS Group excels in providing top talent in IT, Healthcare, Engineering, Finance, Light Industrial, Contact Center, and Clerical. We have offices in the US, Canada, Mexico, and India in which we can provide support to our clients.
Description: Job title -PostgreSQL Database Administrator
Work location - - Irvine, CA or San Antonio, TX
Is it Hybrid, onsite or remote position - Onsite
Please confirm if the candidate can work from any *** DC office No,
Tentative Start date - Immediate
Contract duration 12 Months
Vendor rate *** USD/ Hr
Minimum years of experience needed in the required skills- 10 yrs of experience
Minimum over all work experience required -10 yrs of experience
Any certification required Good to have. PostgreSQL Certified Professional (or equivalent), AWS Certified Solutions Architect Associate/Professional
Mandatory skills required -PostgreSQL Database, on-prem (SQL/Oracle) databases to AWS Cloud Environment (PostgreSQL). AWS services, Terraform
Complete job description - PostgreSQL DBA Job Description
We are seeking a highly skilled and experienced PostgreSQL Database Administrator (DBA) with strong expertise in AWS. The candidate will be responsible for the day-to-day management of PostgreSQL databases and will lead efforts to migrate and optimize our database infrastructure in the AWS cloud. This role requires deep knowledge of PostgreSQL database administration and AWS services, particularly related to database migration, performance tuning, and high availability.
Key Responsibilities
Lead and execute migration of on-prem (SQL/Oracle) databases to AWS Cloud Environment (PostgreSQL).
Administration of Postgres DB on AWS.
Remediate code from SQL/Oracle to PostgreSQL.
Install, configure, and manage PostgreSQL databases across various versions.
Optimize database performance and ensure high availability and scalability.
Design and implement backup and recovery strategies using native database tools and AWS services.
Manage PostgreSQL replication (streaming replication, logical replication) and high availability setups.
Implement and maintain PostgreSQL security policies, roles, and privileges.
Monitor database health and performance using tools like pgAdmin, AWS CloudWatch, and other monitoring solutions.
Perform regular database maintenance tasks including vacuuming, indexing, and query optimization.
Configure and manage PostgreSQL on AWS
Extensive experience in terraform
Utilize AWS services such as S3, IAM, CloudWatch, and DMS for database operations and migration.
Design and implement disaster recovery strategies, including Multi-AZ deployments and failover configurations.
Collaborate with development and infrastructure teams to support application requirements.
Document database environments, configurations, and procedures.
Certifications (Preferred but not mandatory)
PostgreSQL Certified Professional (or equivalent)
AWS Certified Solutions Architect Associate/Professional
Interview mode - In person/Virtual - Virtual
How many rounds of interview - 2
Custom Fields:
Name: Intake Call Requested
Value: true
Name: Intake Call Completed
Value: true
EEOC Disclaimer: IMCS Group is an equal opportunity employer and makes employment decisions without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran status, disability status, age, or any other status protected by law. IMCS Group is committed to maintaining an inclusive workforce, where employees are hired, retained, compensated, and promoted based on their contributions to our Company.