2

Remote Postgresql Jobs in Rochester, NY (NOW HIRING)

AI Data Architect

Rochester, NY · On-site +1

$150K - $200K/yr

This can be a remote opportunity, with 2 weeks of travel into Rochester, NY per quarter What You'll ... SQL and NoSQL on AWS - Aurora PostgreSQL, RDS PostgreSQL, DocumentDB, DynamoDB - including schema ...

AI Data Architect

Rochester, NY · Remote

$150K - $200K/yr

This can be a remote opportunity, with 2 weeks of travel into Rochester, NY per quarter What You'll ... SQL and NoSQL on AWS -- Aurora PostgreSQL, RDS PostgreSQL, DocumentDB, DynamoDB -- including schema ...

Remote Postgresql information

See Rochester, NY salary details

$82.4K

$125.3K

$168.7K

How much do remote postgresql jobs pay per year?

As of Aug 16, 2026, the average yearly pay for remote postgresql in Rochester, NY is $125,338.00, according to ZipRecruiter salary data. Most workers in this role earn between $107,500.00 and $141,600.00 per year, depending on experience, location, and employer.

What is a remote PostgreSQL?

A Remote PostgreSQL job involves managing, optimizing, and maintaining PostgreSQL databases while working from a remote location. Responsibilities typically include database design, performance tuning, query optimization, and troubleshooting issues. Professionals in this role may work as database administrators (DBAs), developers, or data engineers, depending on the organization’s needs. Strong SQL skills, experience with cloud-hosted databases, and knowledge of backup and security best practices are essential for success in this role.

What are the key skills and qualifications needed to thrive in the remote PostgreSQL position, and why are they important?

To thrive as a Remote PostgreSQL professional, you need a strong command of database administration, SQL programming, and performance tuning, typically backed by experience with PostgreSQL databases and a relevant technical degree. Familiarity with tools such as pgAdmin, backup utilities, cloud platforms (like AWS or Azure), and certifications such as PostgreSQL Certified Associate are often beneficial. Strong problem-solving skills, effective communication, and self-motivation are important soft skills for remote collaboration and troubleshooting. These capabilities ensure efficient database management, seamless remote support, and successful teamwork in distributed environments.

What are the typical daily responsibilities of a remote PostgreSQL professional?

As a Remote PostgreSQL professional, your daily tasks often include monitoring database performance, implementing backup and recovery procedures, troubleshooting issues, and optimizing queries for efficiency. You may also participate in database design, support application developers with SQL tuning, and apply necessary security updates to ensure data integrity. Collaboration with cross-functional teams is common, usually through virtual meetings and shared documentation platforms. Staying organized and responsive is key, as you’ll be addressing urgent issues while also planning for long-term improvements.

What are the most commonly searched types of Postgresql jobs in Rochester, NY?

The most popular types of Postgresql jobs in Rochester, NY are:

What are popular job titles related to Remote Postgresql jobs in Rochester, NY?

For Remote Postgresql jobs in Rochester, NY, the most frequently searched job titles are:

What job categories do people searching Remote Postgresql jobs in Rochester, NY look for?

The top searched job categories for Remote Postgresql jobs in Rochester, NY are:

What cities near Rochester, NY are hiring for Remote Postgresql jobs?

Cities near Rochester, NY with the most Remote Postgresql job openings:

Infographic showing various Remote Postgresql job openings in Rochester, NY as of August 2026, with employment types broken down into 83% Full Time, 6% Part Time, and 11% Contract. Highlights an 81% Physical, 3% Hybrid, and 16% Remote job distribution, with an average salary of $125,338 per year, or $60.3 per hour.

AI Data Architect

Innovative Solutions

Rochester, NY • On-site, Remote

$150K - $200K/yr

Full-time

Re-posted 20 days ago


Job description

As a Data/AI Architect, you'll design and build data-driven cloud architectures on AWS - from S3 data lakes and Glue ETL pipelines to data warehouses and RAG-powered AI systems. You'll own the full data stack across a variety of industries and projects: one engagement you're designing a Redshift data warehouse with medallion architecture processing 31M transactions/month, the next you're building a Bedrock Knowledge Base with OpenSearch vector search. Real ownership, real variety.
Location: This can be a remote opportunity, with 2 weeks of travel into Rochester, NY per quarter
What You'll Do:
  • Design and build S3 data lakes with multi-zone organization, partitioning strategies, lifecycle policies, and encryption
  • Implement medallion architecture (bronze/silver/gold) for data warehouses on Redshift, Snowflake, or Databricks
  • Build AWS Glue ETL pipelines (Python Shell and Spark) with incremental extraction, Data Catalog management, and optimized Parquet output
  • Design star/snowflake schemas, materialized views, and gold-layer models optimized for BI consumption (QuickSight, PowerBI)
  • Configure data warehouse platforms - Redshift with Zero-ETL from Aurora, Snowflake with Snowpipe, Databricks with Delta Lake and Auto Loader
  • Design RAG systems using Bedrock Knowledge Base with OpenSearch Serverless vector search and Titan Embeddings
  • Architect document AI pipelines using Textract, Comprehend, and Bedrock for entity extraction
  • Design SageMaker ML pipelines for training, Model Registry, and inference
  • Lead data discovery sessions with client stakeholders and present architecture recommendations to technical and business audiences
  • Mentor delivery team members on data architecture patterns and AWS data services
  • Contribute to R&D projects evaluating emerging AWS data and AI capabilities

Required Skills:
  • 5+ years professional IT experience, 2+ years professional AWS experience
  • At least one AWS Professional-level certification (Solutions Architect Professional or Data Engineer Specialty preferred)
  • Python for data pipelines (Glue jobs, Lambda, SageMaker scripts) and PySpark for Glue Spark jobs
  • SQL and NoSQL on AWS - Aurora PostgreSQL, RDS PostgreSQL, DocumentDB, DynamoDB - including schema design and query optimization
  • Data modeling - conceptual, logical, and physical models for AWS data platforms; normalized silver-layer schemas, denormalized star/snowflake gold-layer schemas, data dictionaries
  • Dimensional modeling and medallion architecture (bronze/silver/gold) on Redshift, Snowflake, or Databricks, including materialized views and incremental refresh patterns
  • AWS Glue ETL (Python Shell and Spark), Glue Data Catalog, and crawlers
  • S3 data lake architecture with partitioning, lifecycle policies, and encryptions

Preferred:
  • RAG systems with Bedrock Knowledge Base and OpenSearch Serverless vector search
  • Amazon SageMaker for ML training, Model Registry, and inference
  • AWS HealthLake, FHIR R4 transformation, and HIPAA-compliant data pipelines
  • Document AI with Amazon Textract and Comprehend
  • Amazon Athena, QuickSight, or PowerBI integration
  • Terraform or CloudFormation for data infrastructure as code
  • Step Functions, EventBridge, and Lambda for event-driven pipeline orchestration

$150,000 - $200,000 a year
The salary range provided is a general guideline. When extending an offer, Innovative considers factors including, but not limited to, the responsibilities of the specific role, market conditions, geographic location, as well as the candidate's professional experience, key skills, and education/training.
We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.