PostgreSQL DB Developer
Apptad Inc
Key Responsibilities
- Database Modernization & Migration: Lead heterogeneous data migrations from legacy enterprise databases to AWS-managed targets using AWS Schema Conversion Tool (SCT) and AWS Database Migration Service (DMS) .
- PostgreSQL Architecture: Design, implement, and manage highly scalable Postgres Architecture in AWS , focusing heavily on modern serverless deployment options (such as Amazon Aurora PostgreSQL Serverless v2).
- DBA & Performance Tuning: Execute core database administration duties, query optimization, indexing strategies, connection pooling configurations (e.g., PgBouncer), and latency reduction for high-volume transactions.
- ETL & Data Pipeline Design: Build, scale, and maintain efficient ETL workflows structured around medallion architecture (Bronze, Silver, and Gold tiers) for streamlined analytics and reporting.
- Infrastructure as Code (IaC): Write and maintain Terraform configurations to automate the provisioning, scaling, and management of AWS cloud and database resources.
Required Skills & Qualifications
- Deep practical experience with AWS SCT and AWS DMS for handling schema translations, data mapping, initial full-loads, and ongoing CDC (Change Data Capture) replication.
- PostgreSQL DBA Expertise: Comprehensive database administration skills on PostgreSQL , specializing in performance tuning, resource monitoring, and deadlock/lock conflict troubleshooting.
- AWS & Serverless Expertise: Strong architectural background in AWS cloud services, specifically relational database design and serverless configurations.
- Heterogeneous Migration Experience: Proven track record of executing complex data migrations across different legacy database platforms onto cloud-native PostgreSQL.
- Data Engineering & ETL: Solid foundational knowledge of ETL concepts combined with practical experience implementing medallion architecture for modern data lakes and warehouses.
- Automation: Hands-on proficiency with Terraform to manage AWS resources securely and repeatably
Vacancy posted 2 days ago
Similar jobs that could be interesting for youBased on the PostgreSQL DB Developer in Boston, MA vacancy
- ...enterprise databases to AWS-managed targets using AWS Schema Conversion Tool (SCT) and AWS Database Migration Service (DMS) . PostgreSQL Architecture: Design, implement, and manage highly scalable Postgres Architecture in AWS , focusing heavily on modern...Postgresql
Apptad Inc
Boston, MA1 day ago - ...We are looking for a seasoned, hands-on C++ Developer for an upcoming project with a company in... ...development experience ~ Experience with PostgreSQL and/or MongoDB Good to Have ~ Experience with Versant DB (Object-Oriented Database) $000,000 – $...PostgresqlH1bLocal areaRemote work
ZealHire Inc.
Boston, MA2 days ago $112k - $200k
...with relational and/or NoSQL databases (e.g., SQL Server, PostgreSQL, Cosmos DB).Strong understanding of software engineering fundamentals:... ...consulting).Relevant Azure certifications (e.g., AZ-204 Azure Developer Associate, AZ-305 Azure Solutions Architect Expert).Other...PostgresqlFull timeSidley Austin
Boston, MA2 days ago- ...looking for a Database Software Engineering Developer reporting directly to Vice President. You... ...in Oracle RDBMS, PL/SQL, AWS RDS, PostgreSQL, RedshiftDeploy high performing, quality/... ....Hands on expertise in Data Modeling and DB design with strong skills in performance...PostgresqlFull timeTemporary workWork at officeMonday to FridayFlexible hours
State Street Bank
Boston, MA1 day ago - ...by mapping source data to ontology models.Develop data mapping and transformation workflows... ...4j, Amazon NeptuneRelational databases: PostgreSQL, MySQL, SQL ServerVector stores: Pinecone... ...Kubernetes, HelmCloud: AWS Neptune, Azure Cosmos DB, GCPMessaging: Kafka, RabbitMQVersion...PostgresqlFull timeWork experience placementLive inWork at officeLocal area
Accenture
Boston, MA2 days ago - ...Oracle GoldenGate Data Engineer is responsible for designing, developing, and maintaining real-time data replication solutions using Oracle... ....Integrate OGG with Oracle Database (12c, 19c, 21c), PostgreSQL, Snowflake, AWS RDS, and other cloud-based platforms.Support heterogeneous...Postgresql
SRI Tech
Boston, MA4 days ago - ...across Engineer and Lead levels, Open Positions : 30 Full Stack Developers & 20 Lead Full Stack DevelopersLocation: Madison, NJ/... ...System design and distributed systems knowledge.Experience with PostgreSQL, MySQL, Aurora, RDS, MongoDB, DynamoDB, Redis.AWS experience (...Postgresql
HAN Staffing
Boston, MA2 days ago - ...streaming & messaging (Kafka / Azure Event Hubs)API design (REST and messaging contracts, schema & versioning)Relational data modeling (PostgreSQL)Cloud Native Services - ideally AzureExperience in the investment/financial services space needed - portfolio Accounting, trading...PostgresqlWork at office
The Ceres Group
Boston, MA1 day ago $124.7k - $168.8k
...transaction logs, replication mechanisms, query optimization) across PostgreSQL, Oracle, SQL Server, MySQL, or DB2 to diagnose and resolve... ...and strive to assign projects that help our team members develop your engineering expertise so you feel empowered to take on more...PostgresqlFlexible hoursAmazonWebServices
Boston, MA3 days ago- ...enterprise software. You'll leverage technologies including Azure, Kubernetes, Docker, TeamCity, DigitalOcean, Prometheus, Grafana, PostgreSQL, and automation tools to build scalable environments, improve deployment processes, and support mission-critical applications....PostgresqlFull time
Motion Recruitment
Boston, MA11 hours ago $170k - $235k
...the development team, the engineer will lead many aspects of developing our AI engineering systems; as well as provide thought leadership... ...and the Kubernetes platform.Proficiency with MySQL, PostgreSQL, or equivalent RDBMSExperience with NoSQL/NewSQL databases.Proficiency...PostgresqlContext Labs
Cambridge, MA4 days ago$105k - $133k
...applications from Microsoft SQL Server to strategic platforms such as PostgreSQL and Amazon Aurora PostgreSQL. The Senior Database Engineer... ...root cause analysis, and implementing corrective actions.· Develop and maintain automation and Infrastructure as Code (IaC) for...PostgresqlFull timeWork at officeLocal areaVisa sponsorshipFlexible hoursZelis
Boston, MA2 days ago$95k - $165k
...The Business and Client Technologies team are responsible for developing technology solutions supporting Arrowstreet Capital’s Marketing... ...to relational databases such as SQL Server, PostgreSQL, or MySQLExperience using Git or similar source code management...PostgresqlFull timeLocal areaArrowstreet Capital
Boston, MA4 days ago$125k - $175k
...Engineer II, you will build on WHOOP’s generative AI capabilities to develop and maintain exciting, member-facing features that drive... ...infrastructure and toolsLeverage Java, Kafka, AWS, and PostgreSQL to deliver scalable and reliable software solutions and featuresConsistently...PostgresqlFull timeWork at officeRelocationWHOOP
Boston, MA2 days ago$125k - $175k
...Infrastructure team (focused on scalability, reliability, and developer enablement). Either way, you’ll have the opportunity to shape... ...RabbitMQ).Familiarity with database design and management (e.g., PostgreSQL, MySQL, or NoSQL databases).Understanding of cloud...PostgresqlFull timeWork at officeWorldwideRelocationWHOOP
Boston, MA4 days ago- ...design experience Strong experience with Node.js, TypeScript, PostgreSQL, database design, and backend scalable solutions Strong experience... ..., versioning, and multi-tenant capabilities Design and develop scalable backend systems and customer-facing platform features...PostgresqlFull time
Motion Recruitment
Boston, MA4 days ago $96.75k - $148.35k
...PathAI, we are constantly evaluating our tech stack and our current tools consist of::PythonVue.jsDjango + DRFDockerAWS: EKS, S3, RDS/PostgreSQL, SQS, MSK/KafkaThe Opportunity:Solve interesting problems with code. Build new features for internal and external users, and...PostgresqlRelocation packagePathAI
Boston, MA1 day ago- ...systems.Experience with writing production code in Python.Advanced knowledge of Kubernetes, Docker, and an OO Language along with AWS, PostgreSQL, Helm, Terraform, Python 3, Grafana.Proficient in leveraging modern LLM tools to accelerate development workflows and enhance...Postgresql
Air space Intelligence
Boston, MA4 days ago - ...from end to end Design and build scalable backend architecture, APIs, data models, and shared services Develop and optimize high-throughput Node.js services, PostgreSQL queries, APIs, queues, and background processes Communicate with product, engineering leadership, and...PostgresqlFull time
Motion Recruitment
Boston, MA12 hours ago $148k - $222k
...empower creators to own their own destiny.Why You Should Join the Developer Infrastructure Team Our core focus is empowering engineers to... ..., Kubernetes, Terraform, Helm, Buildkite, PantsData: MySQL, PostgreSQL, Redis, KafkaAI Tools: Claude, Cursor, Copilot, or internal AI...PostgresqlKlaviyo
Boston, MA11 hours ago$70 - $85 per hour
...support large-scale financial solutions. They are looking for a senior automation engineer with strong experience in Python, Pytest, PostgreSQL, ETL testing, CI/CD pipelines, and automated test development to improve data quality and reliability across critical systems....PostgresqlFull timeContract workTemporary workFlexible hours3 days per weekMotion Recruitment
Boston, MA2 days ago- ..., development, debugging and performance tuning.About the job:Develop modern enterprise-level applications in the cloud.Lead & mentor... ...tuning.Experience with relational databases (Oracle, PostgreSQL, MySQL) and ORM frameworks such as Hibernate/JPA.Familiarity with...PostgresqlLocal areaRemote workVisa sponsorshipWork visaShift work
Liberty Mutual
Boston, MA2 days ago $139k - $176.7k
...Microsoft SQL Server and expanding strategic platforms including PostgreSQL and Amazon Aurora PostgreSQL. The Sr Manager will coordinate... ...the transition.Key Responsibilities:Lead, coach, and develop a distributed team of Database Engineers across onshore and offshore...PostgresqlFull timeWork at officeLocal areaVisa sponsorshipFlexible hoursZelis
Boston, MA2 days ago$100k - $300k
...as a discipline: You have designed and evolved a relational schema that many teams depended on, and carried out the migrations. PostgreSQL experience preferredFull-stack fluency: TypeScript and React on the front end, Python or TypeScript services on the back end, and...PostgresqlFull timeLive inShift workTutor Intelligence
Watertown, MA4 days ago$93.9k - $153.6k
...experienced engineers, contributing to meaningful features while developing strong production engineering skills through mentorship and... ...Experience with relational and/or NoSQL databases (e.g., SQL Server, PostgreSQL).Experience with version control (Git) and Agile development...PostgresqlFull timeInternshipSidley Austin
Boston, MA4 days ago- ...tooling: Apache Spark, Airflow, dbt, or equivalentSolid understanding of data modeling, SQL, and working with large-scale databases (PostgreSQL, MSSQL, or similar)Strong grasp of software engineering fundamentals: CI/CD, DevOps, testing, and system designFamiliarity with...PostgresqlWork at officeFlexible hours
Verisk Analytics
Boston, MA11 hours ago $130k - $140k
...financial opportunity should be more personalized and fair. We develop innovative technologies that provide underserved and... ...engineering workDeep technical fluency with relational databases (PostgreSQL, AWS RDS), cloud infrastructure (AWS), container management (ECS...PostgresqlFull timeLendbuzz
Boston, MA2 days ago$170k - $185k
...financial opportunity should be more personalized and fair. We develop innovative technologies that provide underserved and... ...The ideal candidate will possess strong expertise in Python, PostgreSQL and system design, with a proven ability to architect efficient...PostgresqlFull timeLendbuzz
Boston, MA4 days ago$127.5k - $195.5k
...PathAI, we are constantly evaluating our tech stack and our current tools consist of:PythonVue.jsDjango + DRFDockerAWS: EKS, S3, RDS/PostgreSQL, SQS, MSK/KafkaThe OpportunityWe’re looking for a Fullstack Senior Software Engineer to join our team. You will help solve...PostgresqlLocal areaRelocation packagePathAI
Boston, MA1 day ago- ...platforms within the post-trade processing lifecycle.You will design, develop, and optimize scalable database and application solutions that... ..., and optimize enterprise database solutions using Oracle and PostgreSQL. Build and support high-volume OLTP systems that process large...PostgresqlRemote workFlexible hours
DTCC- The Depository Trust & Clearing Corporation
Boston, MA11 hours ago
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to PostgreSQL DB Developer. Be the first to apply!
Related searches