PostgreSQL DBA - Onsite

The Dignify Solutions, LLC; Jersey City (NJ); On-site; USD 90,000 - 120,000; Full time

Job summary

A leading IT services company is seeking an experienced Database Administrator to manage and optimize PostgreSQL and Aurora DB systems. The ideal candidate should have over 8 years in database administration and strong expertise in data warehousing, ETL processes, and AWS managed services. This full-time role is in Jersey City, focusing on enterprise data systems within the Banking and Financial Services domain.

Qualifications

• 8+ years of experience in PostgreSQL / Aurora DB SQL Database Administration.
• 5+ years in enterprise data systems, preferably in Banking and Financial Services.
• Strong knowledge of data warehousing and ETL processes.

Responsibilities

• Plan and manage capacity of database management systems.
• Design, develop, and test data warehouse systems.
• Administer MySQL, PostgreSQL, and Aurora databases, optimizing performance.

Skills

PostgreSQL database management

Data warehousing

Automation with Terraform

AWS services (RDS, DMS, KMS, Lambda, EKS)

Analytical and problem-solving skills

Communication skills

Job description

Overview

Database Administrator with 8+ years of experience in PostgreSQL / Aurora DB SQL Database Administration. Location and posting specifics have been omitted. The role emphasizes enterprise data systems, data warehousing, cloud services, and automation.

Responsibilities

• Plan and manage capacity of database management systems.
• Design, develop, and test data warehouse systems.
• Apply strong analytical and problem-solving skills to database challenges.
• Maintain strong knowledge of data warehousing and ETL processes.
• Utilize AWS managed services (RDS, DMS, KMS, Lambda, EKS) for database operations.
• Administer MySQL, PostgreSQL, and Aurora databases; manage multi-tenant Aurora MySQL environments; optimize performance and scalability.
• Automate infrastructure and deployments using Terraform.
• Leverage IT Service Management tools (e.g., ServiceNow/Remedy) where applicable.
• Collaborate within enterprise data systems environments, preferably in Banking and Financial Services domains.
• Demonstrate efficient written and verbal communication; strong organizational and leadership skills.

Qualifications

• 8+ years of experience in PostgreSQL / Aurora DB SQL Database Administration.
• 5+ years of experience working with enterprise data systems; Banking and Financial Services domain preferred.
• Strong knowledge of data warehousing, ETL, and data warehouse design, development, and testing.
• Extensive knowledge of AWS managed services (RDS, DMS, KMS, Lambda, EKS).
• Experience with MySQL/PostgreSQL/Aurora; multi-tenant Aurora MySQL experience.
• Experience in automation leveraging Terraform.
• Knowledge of multi-tenant cloud environments is a plus.
• Proficient understanding of IT Service Management tools like ServiceNow/Remedy.
• Excellent communication skills and strong organizational and leadership abilities.

Seniority level

• Mid-Senior level

Employment type

• Full-time

Job function

• Other

Industry

• IT Services and IT Consulting